#import #import "PGConnection.h" #import "PGConnectionFailedException.h" @interface Test: OFObject { PGConnection *connection; } @end OF_APPLICATION_DELEGATE(Test) @implementation Test - (void)applicationDidFinishLaunching { PGResult *result; connection = [[PGConnection alloc] init]; [connection setParameters: [OFDictionary dictionaryWithKeysAndObjects: @"user", @"js", @"dbname", @"js", nil]]; [connection connect]; [connection executeCommand: @"DROP TABLE IF EXISTS test"]; [connection executeCommand: @"CREATE TABLE test (" @" id integer," @" name varchar(255)," @" content text," @" success boolean" @")"]; [connection executeCommand: @"INSERT INTO test (id, name, content) " @"VALUES ($1, $2, $3)" parameters: @1, @"foo", @"Hallo Welt!", nil]; [connection executeCommand: @"INSERT INTO test (id, content, success) " @"VALUES ($1, $2, $3)" parameters: @2, @2, @YES, nil]; [connection insertRow: @{ @"content": @"Hallo!", @"name": @"foo" } intoTable: @"test"]; result = [connection executeCommand: @"SELECT * FROM test"]; of_log(@"%@", result); of_log(@"JSON: %@", [result JSONRepresentation]); result = [connection executeCommand: @"SELECT COUNT(*) FROM test"]; of_log(@"%@", result); [OFApplication terminate]; } @end