function setUp() { $this->connection = lmbToolkit::instance()->getDefaultDbConnection(); DriverMssqlSetup($this->connection->getConnectionId()); DriverMssqlExec($this->connection->getConnectionId(), "SET IDENTITY_INSERT founding_fathers OFF"); parent::setUp(); }
function DriverMssqlSetup($conn) { DriverMssqlExec($conn, "if EXISTS(select name from sysobjects where name='founding_fathers')DROP TABLE founding_fathers"); $sql = "CREATE TABLE founding_fathers (\r\n id int NOT null IDENTITY (4, 1),\r\n first varchar(50) NOT null default '',\r\n last varchar(50) NOT null default '',\r\n PRIMARY KEY (id)) "; DriverMssqlExec($conn, $sql); DriverMssqlExec($conn, "if EXISTS(select name from sysobjects where name='standard_types')DROP TABLE standard_types"); $sql = "\r\n CREATE TABLE standard_types (\r\n id int NOT null IDENTITY(5, 1),\r\n\t type_bit bit,\r\n type_smallint smallint,\r\n type_integer integer,\r\n type_boolean smallint,\r\n type_char char (30),\r\n type_varchar varchar (30),\r\n type_clob text,\r\n type_float float,\r\n type_double real,\r\n type_decimal decimal (30, 2),\r\n type_timestamp datetime,\r\n type_date smalldatetime,\r\n type_time datetime,\r\n type_blob binary,\r\n PRIMARY KEY (id)) "; DriverMssqlExec($conn, $sql); DriverMssqlExec($conn, 'DELETE FROM founding_fathers'); DriverMssqlExec($conn, 'DELETE FROM standard_types'); DriverMssqlExec($conn, 'UPDATE STATISTICS founding_fathers WITH FULLSCAN'); DriverMssqlExec($conn, 'UPDATE STATISTICS standard_types WITH FULLSCAN'); DriverMssqlExec($conn, "SET IDENTITY_INSERT founding_fathers ON"); $inserts = array("INSERT INTO founding_fathers (id, first, last) VALUES (1, 'George', 'Washington')", "INSERT INTO founding_fathers (id, first, last) VALUES (2, 'Alexander', 'Hamilton')", "INSERT INTO founding_fathers (id, first, last) VALUES (3, 'Benjamin', 'Franklin')"); foreach ($inserts as $sql) { DriverMssqlExec($conn, $sql); } }