From 3cf494c3896f903d9e0179c12897ffb6c7cbf4d5 Mon Sep 17 00:00:00 2001 From: Dan Goodliffe Date: Thu, 24 Sep 2015 03:03:25 +0100 Subject: MySQL mocking and tests from Project2 --- libmysqlpp/unittests/mysqlschema.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 libmysqlpp/unittests/mysqlschema.sql (limited to 'libmysqlpp/unittests/mysqlschema.sql') diff --git a/libmysqlpp/unittests/mysqlschema.sql b/libmysqlpp/unittests/mysqlschema.sql new file mode 100644 index 0000000..58724c8 --- /dev/null +++ b/libmysqlpp/unittests/mysqlschema.sql @@ -0,0 +1,14 @@ +CREATE TABLE test( + id int, + fl numeric(5,2), + string varchar(30), + boolean bool, + dt timestamp, + ts time); + +INSERT INTO test VALUES(4, 123.45, 'some text', true, '2015-04-27 23:06:03', '38:13:12'); + +CREATE TABLE bulktest( + intcol int, + stringcol varchar(3000)); + -- cgit v1.2.3