diff options
Diffstat (limited to 'test/sql')
| -rw-r--r-- | test/sql/simpleCreate.sql | 5 | ||||
| -rw-r--r-- | test/sql/simpleDelete.sql | 2 | ||||
| -rw-r--r-- | test/sql/simpleDeleteSome.sql | 2 | ||||
| -rw-r--r-- | test/sql/simpleInsert.sql | 1 | ||||
| -rw-r--r-- | test/sql/simpleSelectAll.sql | 3 | ||||
| -rw-r--r-- | test/sql/simpleUpdate.sql | 1 | ||||
| -rw-r--r-- | test/sql/simpleUpdateAll.sql | 1 |
7 files changed, 15 insertions, 0 deletions
diff --git a/test/sql/simpleCreate.sql b/test/sql/simpleCreate.sql new file mode 100644 index 0000000..c2a89e9 --- /dev/null +++ b/test/sql/simpleCreate.sql @@ -0,0 +1,5 @@ +CREATE TABLE test( + id int auto_increment, + val varchar(20), + primary key(id) +) diff --git a/test/sql/simpleDelete.sql b/test/sql/simpleDelete.sql new file mode 100644 index 0000000..1c1bd85 --- /dev/null +++ b/test/sql/simpleDelete.sql @@ -0,0 +1,2 @@ +DELETE FROM test WHERE id = ? + diff --git a/test/sql/simpleDeleteSome.sql b/test/sql/simpleDeleteSome.sql new file mode 100644 index 0000000..ed69fa8 --- /dev/null +++ b/test/sql/simpleDeleteSome.sql @@ -0,0 +1,2 @@ +DELETE FROM test WHERE id < ? + diff --git a/test/sql/simpleInsert.sql b/test/sql/simpleInsert.sql new file mode 100644 index 0000000..f695332 --- /dev/null +++ b/test/sql/simpleInsert.sql @@ -0,0 +1 @@ +INSERT INTO test(val) VALUES(?) diff --git a/test/sql/simpleSelectAll.sql b/test/sql/simpleSelectAll.sql new file mode 100644 index 0000000..9fe07bc --- /dev/null +++ b/test/sql/simpleSelectAll.sql @@ -0,0 +1,3 @@ +SELECT id, val +FROM testout.test +ORDER BY id diff --git a/test/sql/simpleUpdate.sql b/test/sql/simpleUpdate.sql new file mode 100644 index 0000000..700f127 --- /dev/null +++ b/test/sql/simpleUpdate.sql @@ -0,0 +1 @@ +UPDATE test SET val = ? WHERE id = ? diff --git a/test/sql/simpleUpdateAll.sql b/test/sql/simpleUpdateAll.sql new file mode 100644 index 0000000..1ac2f13 --- /dev/null +++ b/test/sql/simpleUpdateAll.sql @@ -0,0 +1 @@ +UPDATE test SET val = ? |