diff options
| author | stuconnolly <stuart02@gmail.com> | 2012-09-08 12:41:19 +0000 |
|---|---|---|
| committer | stuconnolly <stuart02@gmail.com> | 2012-09-08 12:41:19 +0000 |
| commit | 79a3dbd44f55340d2b6bd5f7e508341adaea1ad3 (patch) | |
| tree | 9913f11efa0246513dad0854e53d414c3062a585 /Frameworks/PostgresKit/Resources/TestData.sql | |
| parent | 9f9b1599232e2a93ee910b6a2888f911eedead70 (diff) | |
| download | sequelpro-79a3dbd44f55340d2b6bd5f7e508341adaea1ad3.tar.gz sequelpro-79a3dbd44f55340d2b6bd5f7e508341adaea1ad3.tar.bz2 sequelpro-79a3dbd44f55340d2b6bd5f7e508341adaea1ad3.zip | |
Add tests target and test script.
Diffstat (limited to 'Frameworks/PostgresKit/Resources/TestData.sql')
| -rw-r--r-- | Frameworks/PostgresKit/Resources/TestData.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/Frameworks/PostgresKit/Resources/TestData.sql b/Frameworks/PostgresKit/Resources/TestData.sql index 1aea4908..036ce4f2 100644 --- a/Frameworks/PostgresKit/Resources/TestData.sql +++ b/Frameworks/PostgresKit/Resources/TestData.sql @@ -41,7 +41,7 @@ INSERT INTO data_types ( timetz_field, timstamp_field, timestamptz_field) -VALUES ( +SELECT 12345, 2, TRUE, @@ -52,7 +52,8 @@ VALUES ( '02:02:02', '02:02:02 GMT', '08-04-1987 02:02:02', - '08-04-1987 02:02:02 GMT'); + '08-04-1987 02:02:02 GMT' +WHERE NOT EXISTS (SELECT 1 FROM data_types WHERE int_field = 12345); COMMIT; |