public function testCanConnect()
{
$databaseConnector = new DatabaseTestingConnector();
$databaseIO = new Database_IO($databaseConnector->getConfig());
/**
check connectivity to both DB
*/
$c = $databaseConnector->getConnection();
$this->assertEqual($c->connect_errno, 0);
$d = $databaseIO->getConnection();
$this->assertEqual($d->connect_errno, 0);
/*
check that the databaseIO can actually perform operations
*/
$res = $databaseIO->query("CREATE TABLE IF NOT EXISTS `test` (\n\t\t\t\t\tid INT NOT NULL AUTO_INCREMENT,\n\t\t\t\t\ttest VARCHAR(100) NOT NULL,\n\t\t\t\t\tPRIMARY KEY(id)\n\t\t\t\t)", RETURN_VALUE, true);
$this->assertEqual(count($databaseConnector->queryAndReturnAssoc('SHOW TABLES')), 1);
$databaseConnector->dropAllTables();
}
/**
Test what happens if multiple occur at the same time
*/
public function testCanMultiConnect()
{
$db1 = new DatabaseTestingConnector();
$db2 = new DatabaseTestingConnector();
$db1C = $db1->getConnection();
$db2C = $db2->getConnection();
$this->assertEqual($db1C->connect_errno, 0);
$this->assertEqual($db2C->connect_errno, 0);
/*
Create tables with 1 and query with 2
Used to check that this won't interfere when using multiple mysqli connections for actual testing
*/
$db1->createSampleTable("test", true);
$db1->createSampleTable("test_two");
$this->assertEqual(count($db2->queryAndReturnAssoc('SHOW TABLES')), 2);
$this->assertEqual(count($db1->queryAndReturnAssoc('SHOW TABLES')), 2);
}
