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);
}
}
