aboutsummaryrefslogtreecommitdiff
path: root/internal/dbstore/testdata/sql/table-exists.sql
diff options
context:
space:
mode:
authorPaul Duncan <pabs@pablotron.org>2022-02-04 18:52:04 -0500
committerPaul Duncan <pabs@pablotron.org>2022-02-04 18:52:04 -0500
commit2c10f51c09f56c19dfd1306340102963476bd03e (patch)
tree51e91c1ac6a6b406ca70aa8a864c79073e6cfaa1 /internal/dbstore/testdata/sql/table-exists.sql
parentdd04d8fa0d12afcbfe54b8ad273f55ad0750e553 (diff)
downloadcvez-2c10f51c09f56c19dfd1306340102963476bd03e.tar.bz2
cvez-2c10f51c09f56c19dfd1306340102963476bd03e.zip
re-add internal/dbstore
Diffstat (limited to 'internal/dbstore/testdata/sql/table-exists.sql')
-rw-r--r--internal/dbstore/testdata/sql/table-exists.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/internal/dbstore/testdata/sql/table-exists.sql b/internal/dbstore/testdata/sql/table-exists.sql
new file mode 100644
index 0000000..09d32a4
--- /dev/null
+++ b/internal/dbstore/testdata/sql/table-exists.sql
@@ -0,0 +1,6 @@
+SELECT EXISTS(
+ SELECT 1
+ FROM sqlite_schema
+ WHERE type = 'table'
+ AND name = ?
+)