From f8317be5c2b2f6d31622d863a41646fa456afbbe Mon Sep 17 00:00:00 2001
From: Dan Goodliffe <dan@randomdan.homeip.net>
Date: Thu, 24 Sep 2015 03:02:07 +0100
Subject: PostgreSQL mocking and tests from Project2

---
 libpqpp/unittests/pqschema.sql | 37 +++++++++++++++++++++++++++++++++++++
 1 file changed, 37 insertions(+)
 create mode 100644 libpqpp/unittests/pqschema.sql

(limited to 'libpqpp/unittests/pqschema.sql')

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);
+
-- 
cgit v1.2.3