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