diff options
| author | stuconnolly <stuart02@gmail.com> | 2012-09-09 01:26:21 +0000 |
|---|---|---|
| committer | stuconnolly <stuart02@gmail.com> | 2012-09-09 01:26:21 +0000 |
| commit | 3cce2b1a18eec301a2779806d8a01d50c360ef83 (patch) | |
| tree | 9ef0cd564672ea0ffedb2d93bd8c607fecc8fe38 /Frameworks/PostgresKit/Resources | |
| parent | 6ac4ca07b1b0d61d718e73e0ba35a579ccc162c7 (diff) | |
| download | sequelpro-3cce2b1a18eec301a2779806d8a01d50c360ef83.tar.gz sequelpro-3cce2b1a18eec301a2779806d8a01d50c360ef83.tar.bz2 sequelpro-3cce2b1a18eec301a2779806d8a01d50c360ef83.zip | |
Remember to truncate the test table.
Diffstat (limited to 'Frameworks/PostgresKit/Resources')
| -rw-r--r-- | Frameworks/PostgresKit/Resources/TestData.sql | 8 |
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; |