diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2021-08-05 23:30:09 +0100 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2021-08-05 23:30:09 +0100 |
| commit | fdc6de263a58480519d683e67bb3dfa262d9b230 (patch) | |
| tree | 1b2a5dbe54a02bacd008e38f2ef965ce40c9c8da /test/sql | |
| parent | Add base handlers for gtid/xid events (diff) | |
| download | mygrate-fdc6de263a58480519d683e67bb3dfa262d9b230.tar.bz2 mygrate-fdc6de263a58480519d683e67bb3dfa262d9b230.tar.xz mygrate-fdc6de263a58480519d683e67bb3dfa262d9b230.zip | |
Handle gtid and xid transaction events
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 = ? |