From d1f55e2626513dd8a77a6c6ad204f4ec843f2ad0 Mon Sep 17 00:00:00 2001
From: Paul Duncan <pabs@pablotron.org>
Date: Fri, 4 Feb 2022 18:38:48 -0500
Subject: mv internal/dbstore/testdata/sql internal/dbstore/sql

---
 internal/dbstore/testdata/sql/fill-fts.sql     | 10 ----
 internal/dbstore/testdata/sql/init.sql         | 73 --------------------------
 internal/dbstore/testdata/sql/insert-cpe.sql   |  1 -
 internal/dbstore/testdata/sql/insert-ref.sql   |  1 -
 internal/dbstore/testdata/sql/insert-title.sql |  1 -
 5 files changed, 86 deletions(-)
 delete mode 100644 internal/dbstore/testdata/sql/fill-fts.sql
 delete mode 100644 internal/dbstore/testdata/sql/init.sql
 delete mode 100644 internal/dbstore/testdata/sql/insert-cpe.sql
 delete mode 100644 internal/dbstore/testdata/sql/insert-ref.sql
 delete mode 100644 internal/dbstore/testdata/sql/insert-title.sql

(limited to 'internal/dbstore')

diff --git a/internal/dbstore/testdata/sql/fill-fts.sql b/internal/dbstore/testdata/sql/fill-fts.sql
deleted file mode 100644
index 5329ca7..0000000
--- a/internal/dbstore/testdata/sql/fill-fts.sql
+++ /dev/null
@@ -1,10 +0,0 @@
--- populate fts table
-INSERT INTO cpe_fts(rowid, title)
-  SELECT a.cpe_id,
-         COALESCE(b.val, '')
-
-    FROM cpes a
-    LEFT JOIN cpe_titles b
-      ON (b.cpe_id = a.cpe_id)
-
-   WHERE b.lang = 'en-US';
diff --git a/internal/dbstore/testdata/sql/init.sql b/internal/dbstore/testdata/sql/init.sql
deleted file mode 100644
index a08b2f8..0000000
--- a/internal/dbstore/testdata/sql/init.sql
+++ /dev/null
@@ -1,73 +0,0 @@
--- enable foreign keys
-PRAGMA foreign_keys = true;
-
--- create cpes table
-CREATE TABLE cpes (
-  cpe_id  INTEGER PRIMARY KEY,
-
-  -- cpe uri 
-  cpe_uri TEXT UNIQUE NOT NULL,
-
-  -- cpe 2.3 formatting string
-  cpe23   TEXT UNIQUE NOT NULL
-);
-
--- create titles table
-CREATE TABLE cpe_titles (
-  -- external CPE id
-  cpe_id  INT NOT NULL
-          REFERENCES cpes(cpe_id),
-
-  -- language code
-  lang    TEXT NOT NULL,
-
-  -- text value
-  val     TEXT NOT NULL,
-
-  UNIQUE (cpe_id, lang)
-);
-
--- create titles fts table
-CREATE VIRTUAL TABLE cpe_titles_fts USING fts5(title, tokenize = 'porter');
-
--- create titles insert trigger
-CREATE TRIGGER tr_cpe_titles_insert AFTER INSERT ON cpe_titles
-  FOR EACH ROW WHEN (NEW.lang = 'en-US') BEGIN
-    INSERT INTO cpe_titles_fts(rowid, title) VALUES (NEW.cpe_id, NEW.val);
-  END;
-
--- create titles delete trigger
-CREATE TRIGGER tr_cpe_titles_delete BEFORE DELETE ON cpe_titles
-  FOR EACH ROW WHEN (OLD.lang = 'en-US') BEGIN
-    DELETE FROM cpe_titles_fts WHERE rowid = OLD.cpe_id;
-  END;
-
--- create refs table
-CREATE TABLE cpe_refs (
-  -- external CPE id
-  cpe_id  INT NOT NULL
-          REFERENCES cpes(cpe_id),
-
-  -- url
-  href    TEXT NOT NULL,
-
-  -- text description
-  val     TEXT NOT NULL
-);
-
--- create refs fts
-CREATE VIRTUAL TABLE cpe_refs_fts USING fts5(cpe_id UNINDEXED, href, val);
-
--- create refs insert trigger
-CREATE TRIGGER tr_cpe_refs_insert AFTER INSERT ON cpe_refs
-  FOR EACH ROW BEGIN
-    INSERT INTO cpe_refs_fts(cpe_id, href, val) VALUES (NEW.cpe_id, NEW.href, NEW.val);
-  END;
-
--- create refs delete trigger
-CREATE TRIGGER tr_cpe_refs_delete BEFORE DELETE ON cpe_refs
-  FOR EACH ROW BEGIN
-    DELETE FROM cpe_refs_fts WHERE rowid = OLD.cpe_id;
-  END;
-
-PRAGMA user_version = 314159;
diff --git a/internal/dbstore/testdata/sql/insert-cpe.sql b/internal/dbstore/testdata/sql/insert-cpe.sql
deleted file mode 100644
index dca1c2b..0000000
--- a/internal/dbstore/testdata/sql/insert-cpe.sql
+++ /dev/null
@@ -1 +0,0 @@
-INSERT INTO cpes(cpe_uri, cpe23) VALUES (?, ?);
diff --git a/internal/dbstore/testdata/sql/insert-ref.sql b/internal/dbstore/testdata/sql/insert-ref.sql
deleted file mode 100644
index a39ab1c..0000000
--- a/internal/dbstore/testdata/sql/insert-ref.sql
+++ /dev/null
@@ -1 +0,0 @@
-INSERT INTO cpe_refs(cpe_id, href, val) VALUES (?, ?, ?);
diff --git a/internal/dbstore/testdata/sql/insert-title.sql b/internal/dbstore/testdata/sql/insert-title.sql
deleted file mode 100644
index 5045d95..0000000
--- a/internal/dbstore/testdata/sql/insert-title.sql
+++ /dev/null
@@ -1 +0,0 @@
-INSERT INTO cpe_titles(cpe_id, lang, val) VALUES (?, ?, ?);
-- 
cgit v1.2.3