From 3cce2b1a18eec301a2779806d8a01d50c360ef83 Mon Sep 17 00:00:00 2001 From: stuconnolly Date: Sun, 9 Sep 2012 01:26:21 +0000 Subject: Remember to truncate the test table. --- Frameworks/PostgresKit/Resources/TestData.sql | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) (limited to 'Frameworks') diff --git a/Frameworks/PostgresKit/Resources/TestData.sql b/Frameworks/PostgresKit/Resources/TestData.sql index 036ce4f2..14849f77 100644 --- a/Frameworks/PostgresKit/Resources/TestData.sql +++ b/Frameworks/PostgresKit/Resources/TestData.sql @@ -29,6 +29,9 @@ CREATE TABLE IF NOT EXISTS data_types timestamptz_field TIMESTAMP WITH TIME ZONE NOT NULL ); +-- If the table existed, get rid of all it's data +TRUNCATE TABLE data_types; + INSERT INTO data_types ( int_field, smallint_field, @@ -41,7 +44,7 @@ INSERT INTO data_types ( timetz_field, timstamp_field, timestamptz_field) -SELECT +VALUES ( 12345, 2, TRUE, @@ -52,8 +55,7 @@ SELECT '02:02:02', '02:02:02 GMT', '08-04-1987 02:02:02', - '08-04-1987 02:02:02 GMT' -WHERE NOT EXISTS (SELECT 1 FROM data_types WHERE int_field = 12345); + '08-04-1987 02:02:02 GMT') COMMIT; -- cgit v1.2.3