aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorstuconnolly <stuart02@gmail.com>2012-09-09 01:26:21 +0000
committerstuconnolly <stuart02@gmail.com>2012-09-09 01:26:21 +0000
commit3cce2b1a18eec301a2779806d8a01d50c360ef83 (patch)
tree9ef0cd564672ea0ffedb2d93bd8c607fecc8fe38
parent6ac4ca07b1b0d61d718e73e0ba35a579ccc162c7 (diff)
downloadsequelpro-3cce2b1a18eec301a2779806d8a01d50c360ef83.tar.gz
sequelpro-3cce2b1a18eec301a2779806d8a01d50c360ef83.tar.bz2
sequelpro-3cce2b1a18eec301a2779806d8a01d50c360ef83.zip
Remember to truncate the test table.
-rw-r--r--Frameworks/PostgresKit/Resources/TestData.sql8
1 files changed, 5 insertions, 3 deletions
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;