diff options
| -rw-r--r-- | Frameworks/PostgresKit/Makefile | 27 | ||||
| -rw-r--r-- | Frameworks/PostgresKit/Resources/TestData.sql | 59 |
2 files changed, 86 insertions, 0 deletions
diff --git a/Frameworks/PostgresKit/Makefile b/Frameworks/PostgresKit/Makefile new file mode 100644 index 00000000..8a01c273 --- /dev/null +++ b/Frameworks/PostgresKit/Makefile @@ -0,0 +1,27 @@ +# $Id$ + +CONFIG=Debug +OPTIONS= + +BUILD_CONFIG?=$(CONFIG) + +CP=ditto --rsrc +RM=rm + +.PHONY: postgreskit test clean clean-all latest + +querykit: + xcodebuild -project PostgresKit.xcodeproj -configuration "$(BUILD_CONFIG)" CFLAGS="$(SP_CFLAGS)" $(OPTIONS) build + +test: + xcodebuild -project PostgresKit.xcodeproj -configuration "$(BUILD_CONFIG)" CFLAGS="$(SP_CFLAGS)" -target Tests $(OPTIONS) build + +clean: + xcodebuild -project PostgresKit.xcodeproj -configuration "$(BUILD_CONFIG)" $(OPTIONS) -nodependencies clean + +clean-all: + xcodebuild -project PostgresKit.xcodeproj -configuration "$(BUILD_CONFIG)" $(OPTIONS) clean + +latest: + svn update + make postgreskit
\ No newline at end of file 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; |