aboutsummaryrefslogtreecommitdiff
path: root/internal/dbstore/sql/table-exists.sql
diff options
context:
space:
mode:
authorPaul Duncan <pabs@pablotron.org>2022-02-05 02:34:41 -0500
committerPaul Duncan <pabs@pablotron.org>2022-02-05 02:34:41 -0500
commit425d2a2aa3e3d4ebb1cbf60982ef7a699dd79d97 (patch)
tree68cf04eaf99ae83f678399971a44458ad295d6fe /internal/dbstore/sql/table-exists.sql
parent4f21e2b639f7d66062f0340793626db962ebb9f6 (diff)
downloadcvez-425d2a2aa3e3d4ebb1cbf60982ef7a699dd79d97.tar.bz2
cvez-425d2a2aa3e3d4ebb1cbf60982ef7a699dd79d97.zip
internal/dbstore/sql: populate cpe search sql
Diffstat (limited to 'internal/dbstore/sql/table-exists.sql')
-rw-r--r--internal/dbstore/sql/table-exists.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/internal/dbstore/sql/table-exists.sql b/internal/dbstore/sql/table-exists.sql
new file mode 100644
index 0000000..09d32a4
--- /dev/null
+++ b/internal/dbstore/sql/table-exists.sql
@@ -0,0 +1,6 @@
+SELECT EXISTS(
+ SELECT 1
+ FROM sqlite_schema
+ WHERE type = 'table'
+ AND name = ?
+)