aboutsummaryrefslogtreecommitdiffstats
path: root/Frameworks/PostgresKit/Resources/TestData.sql
diff options
context:
space:
mode:
Diffstat (limited to 'Frameworks/PostgresKit/Resources/TestData.sql')
-rw-r--r--Frameworks/PostgresKit/Resources/TestData.sql59
1 files changed, 59 insertions, 0 deletions
diff --git a/Frameworks/PostgresKit/Resources/TestData.sql b/Frameworks/PostgresKit/Resources/TestData.sql
new file mode 100644
index 00000000..1aea4908
--- /dev/null
+++ b/Frameworks/PostgresKit/Resources/TestData.sql
@@ -0,0 +1,59 @@
+-- $Id$
+--
+-- SQL script used by PostgresKit's integration tests.
+--
+-- For the tests to execute successfully this file should
+-- be run against a blank database called 'pgkit_test' and
+-- the user 'pgkit_test' with password 'pgkit' should exit:
+--
+-- CREATE DATABASE pgkit_test;
+-- CREATE USER pgkit_test WITH PASSWORD 'pgkit';
+
+BEGIN;
+
+SET datestyle = 'DMY';
+SET client_encoding = 'UNICODE';
+
+CREATE TABLE IF NOT EXISTS data_types
+(
+ int_field INT PRIMARY KEY NOT NULL,
+ smallint_field SMALLINT NOT NULL,
+ bool_field BOOL NOT NULL,
+ float_field REAL NOT NULL,
+ char_field CHAR(5) NOT NULL,
+ varchar_field VARCHAR(32) NOT NULL,
+ date_field DATE NOT NULL,
+ time_field TIME NOT NULL,
+ timetz_field TIME WITH TIME ZONE NOT NULL,
+ timstamp_field TIMESTAMP NOT NULL,
+ timestamptz_field TIMESTAMP WITH TIME ZONE NOT NULL
+);
+
+INSERT INTO data_types (
+ int_field,
+ smallint_field,
+ bool_field,
+ float_field,
+ char_field,
+ varchar_field,
+ date_field,
+ time_field,
+ timetz_field,
+ timstamp_field,
+ timestamptz_field)
+VALUES (
+ 12345,
+ 2,
+ TRUE,
+ 12345.678,
+ 'CHARV',
+ 'VARCHAR_VALUE',
+ '08-04-1987',
+ '02:02:02',
+ '02:02:02 GMT',
+ '08-04-1987 02:02:02',
+ '08-04-1987 02:02:02 GMT');
+
+COMMIT;
+
+ANALYZE data_types;