diff options
| author | Paul Duncan <pabs@pablotron.org> | 2022-02-26 13:55:46 -0500 |
|---|---|---|
| committer | Paul Duncan <pabs@pablotron.org> | 2022-02-26 13:55:46 -0500 |
| commit | e2c77fc78be780d46c35584d5f33a771b14631fe (patch) | |
| tree | d4298d0d007b9ae2959c106033a778e75babab65 /dbstore | |
| parent | d5bd2d96cf58e997565aafab251a91714bc07a21 (diff) | |
| download | cvez-e2c77fc78be780d46c35584d5f33a771b14631fe.tar.bz2 cvez-e2c77fc78be780d46c35584d5f33a771b14631fe.zip | |
dbstore: add dbstore/sql/test/query{,row}
Diffstat (limited to 'dbstore')
| -rw-r--r-- | dbstore/sql/test/query/ids-arg-named.sql | 8 | ||||
| -rw-r--r-- | dbstore/sql/test/query/ids-arg-pos.sql | 8 | ||||
| -rw-r--r-- | dbstore/sql/test/query/ids.sql | 7 | ||||
| -rw-r--r-- | dbstore/sql/test/queryrow/ids-arg-named.sql | 8 | ||||
| -rw-r--r-- | dbstore/sql/test/queryrow/ids-arg-pos.sql | 8 | ||||
| -rw-r--r-- | dbstore/sql/test/queryrow/ids.sql | 7 |
6 files changed, 46 insertions, 0 deletions
diff --git a/dbstore/sql/test/query/ids-arg-named.sql b/dbstore/sql/test/query/ids-arg-named.sql new file mode 100644 index 0000000..984669d --- /dev/null +++ b/dbstore/sql/test/query/ids-arg-named.sql @@ -0,0 +1,8 @@ +WITH ids(id, sort) AS ( + VALUES ('foo', 1), ('bar', 2), ('baz', 3) +) + +SELECT id + FROM ids + WHERE id = :q + ORDER BY sort; diff --git a/dbstore/sql/test/query/ids-arg-pos.sql b/dbstore/sql/test/query/ids-arg-pos.sql new file mode 100644 index 0000000..a13888e --- /dev/null +++ b/dbstore/sql/test/query/ids-arg-pos.sql @@ -0,0 +1,8 @@ +WITH ids(id, sort) AS ( + VALUES ('foo', 1), ('bar', 2), ('baz', 3) +) + +SELECT id + FROM ids + WHERE id = ? + ORDER BY sort; diff --git a/dbstore/sql/test/query/ids.sql b/dbstore/sql/test/query/ids.sql new file mode 100644 index 0000000..ddc2bf2 --- /dev/null +++ b/dbstore/sql/test/query/ids.sql @@ -0,0 +1,7 @@ +WITH ids(id, sort) AS ( + VALUES ('foo', 1), ('bar', 2), ('baz', 3) +) + +SELECT id + FROM ids + ORDER BY sort; diff --git a/dbstore/sql/test/queryrow/ids-arg-named.sql b/dbstore/sql/test/queryrow/ids-arg-named.sql new file mode 100644 index 0000000..984669d --- /dev/null +++ b/dbstore/sql/test/queryrow/ids-arg-named.sql @@ -0,0 +1,8 @@ +WITH ids(id, sort) AS ( + VALUES ('foo', 1), ('bar', 2), ('baz', 3) +) + +SELECT id + FROM ids + WHERE id = :q + ORDER BY sort; diff --git a/dbstore/sql/test/queryrow/ids-arg-pos.sql b/dbstore/sql/test/queryrow/ids-arg-pos.sql new file mode 100644 index 0000000..a13888e --- /dev/null +++ b/dbstore/sql/test/queryrow/ids-arg-pos.sql @@ -0,0 +1,8 @@ +WITH ids(id, sort) AS ( + VALUES ('foo', 1), ('bar', 2), ('baz', 3) +) + +SELECT id + FROM ids + WHERE id = ? + ORDER BY sort; diff --git a/dbstore/sql/test/queryrow/ids.sql b/dbstore/sql/test/queryrow/ids.sql new file mode 100644 index 0000000..ddc2bf2 --- /dev/null +++ b/dbstore/sql/test/queryrow/ids.sql @@ -0,0 +1,7 @@ +WITH ids(id, sort) AS ( + VALUES ('foo', 1), ('bar', 2), ('baz', 3) +) + +SELECT id + FROM ids + ORDER BY sort; |