diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2015-09-24 03:02:07 +0100 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2015-09-24 03:06:06 +0100 |
| commit | 817e41ccb3102239c24af940f301a5335ddabeac (patch) | |
| tree | f93d51c06d3d244b5ddfd2c3b13f895a14c67e84 /libpqpp/unittests/pqschema.sql | |
| parent | Connector compatibility fix (diff) | |
| download | libdbpp-postgresql-817e41ccb3102239c24af940f301a5335ddabeac.tar.bz2 libdbpp-postgresql-817e41ccb3102239c24af940f301a5335ddabeac.tar.xz libdbpp-postgresql-817e41ccb3102239c24af940f301a5335ddabeac.zip | |
PostgreSQL mocking and tests from Project2
Diffstat (limited to 'libpqpp/unittests/pqschema.sql')
| -rw-r--r-- | libpqpp/unittests/pqschema.sql | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/libpqpp/unittests/pqschema.sql b/libpqpp/unittests/pqschema.sql new file mode 100644 index 0000000..80d9183 --- /dev/null +++ b/libpqpp/unittests/pqschema.sql @@ -0,0 +1,37 @@ +-- +-- pg_dump style comment +-- Table: test; owner: comment: ; +-- + +/* + This is + a + multiline comment */ + +CREATE TABLE test( + id int, + fl numeric(5,2), + string text, + boolean bool, + dt timestamp without time zone, + ts interval); + +INSERT INTO test VALUES(4, 123.45, 'some text with a ; in it and a '' too', true, '2015-04-27 23:06:03', '1 day 14:13:12'); + +CREATE TABLE test2( + path text not null); + +INSERT INTO test2 VALUES('$SCRIPTDIR/pqschema.sql'); + +CREATE FUNCTION event_tsvector() RETURNS int +LANGUAGE sql STABLE +AS $tag$ + SELECT max(id) + FROM test + WHERE string != 'complex '' string;'; +$tag$; + +CREATE TABLE bulktest( + id int, + string text); + |