function DriverPgsqlSetup($conn) { $sql = "DROP TABLE founding_fathers CASCADE"; DriverPgsqlExec($conn, $sql); $sql = ' CREATE TABLE founding_fathers ( "id" SERIAL, "first" varchar(50) NOT NULL default \'\', "last" varchar(50) NOT NULL default \'\', PRIMARY KEY (id))'; DriverPgsqlExec($conn, $sql); $sql = "DROP TABLE standard_types CASCADE"; DriverPgsqlExec($conn, $sql); $sql = ' CREATE TABLE standard_types ( "id" SERIAL, "type_smallint" smallint, "type_integer" integer, "type_boolean" bool, "type_char" char(30), "type_varchar" varchar(30), "type_clob" text, "type_float" float, "type_double" double precision, "type_decimal" decimal (30, 2), "type_timestamp" timestamp, "type_date" date, "type_time" time, "type_blob" text, PRIMARY KEY (id))'; DriverPgsqlExec($conn, $sql); DriverPgsqlExec($conn, 'TRUNCATE founding_fathers'); DriverPgsqlExec($conn, 'TRUNCATE standard_types'); $inserts = array("INSERT INTO founding_fathers(first, last) VALUES ('George', 'Washington');", "INSERT INTO founding_fathers(first, last) VALUES ('Alexander', 'Hamilton');", "INSERT INTO founding_fathers(first, last) VALUES ('Benjamin', 'Franklin');"); foreach ($inserts as $sql) { DriverPgsqlExec($conn, $sql); } }
protected function _execute($sql, $conn = null) { if (!$conn) { $conn = $this->connection; } DriverPgsqlExec($conn->getConnectionId(), $sql); }