public function testCanMultiQuery()
{
$dbC = new DatabaseTestingConnector();
$databaseIO = new Database_IO($dbC->getConfig());
$dbC->dropAllTables();
$databaseIO->query($dbC->getBaselineSql(), MULTI_QUERY, true);
$this->assertEqual(count($dbC->queryAndReturnAssoc('SHOW TABLES')), DIM_TEST_SQL_TABLE_COUNT);
$dbC->dropAllTables();
$databaseIO->query($dbC->getBaselineSql(), MULTI_QUERY, true);
$this->assertEqual(count($dbC->queryAndReturnAssoc('SHOW TABLES')), DIM_TEST_SQL_TABLE_COUNT);
//to finish
$dbC->dropAllTables();
}
/**
Check that it can do it multiple times per connection
May be related to a bug that we're trying to fix
*/
public function testCanImportBaselineMultipleTimes()
{
$dbConnection = new DatabaseTestingConnector();
$dbConnection->dropAllTables();
//clear just to make sure
$dbConnection->importBaseline();
$testRes = $dbConnection->queryAndReturnAssoc('SHOW TABLES');
$this->assertEqual(count($testRes), DIM_TEST_SQL_TABLE_COUNT);
/* ROUND 2 */
$dbConnection->dropAllTables();
//clear just to make sure
$dbConnection->importBaseline();
$testRes = $dbConnection->queryAndReturnAssoc('SHOW TABLES');
$this->assertEqual(count($testRes), DIM_TEST_SQL_TABLE_COUNT);
/* ROUND 3 */
$dbConnection->dropAllTables();
//clear just to make sure
$dbConnection->importBaseline();
$testRes = $dbConnection->queryAndReturnAssoc('SHOW TABLES');
$this->assertEqual(count($testRes), DIM_TEST_SQL_TABLE_COUNT);
$dbConnection->dropAllTables();
}
