/**
* testing for invalid version to upgrade and upgrade required
* does not test for absent database
*
*/
function test_checkExistingTables()
{
$oUpgrade = new OA_Upgrade();
$oUpgrade->initDatabaseConnection();
$this->_createTestTableConfig($oUpgrade->oDbh, 'preference');
// pan config exists
$this->assertFalse($oUpgrade->checkExistingTables(), '');
$oUpgrade->oLogger->logClear();
$this->_createTestTableConfig($oUpgrade->oDbh, 'config');
// both configs exist
$this->assertFalse($oUpgrade->checkExistingTables(), '');
$oUpgrade->oLogger->logClear();
$this->_dropTestTable($oUpgrade->oDbh, 'preference');
// max config exists
$this->assertFalse($oUpgrade->checkExistingTables(), '');
$oUpgrade->oLogger->logClear();
$this->_dropTestTable($oUpgrade->oDbh, 'config');
// no config exists but other prefixed tables do exist
$this->_createTestTableConfig($oUpgrade->oDbh, 'other');
$this->assertFalse($oUpgrade->checkExistingTables(), '');
$oUpgrade->oLogger->logClear();
$this->_dropTestTable($oUpgrade->oDbh, 'other');
// no config or other prefixed tables exist
$prefix = $oUpgrade->aDsn['table']['prefix'];
$oUpgrade->aDsn['table']['prefix'] = 'xxx_';
$this->assertTrue($oUpgrade->checkExistingTables(), '');
$oUpgrade->oLogger->logClear();
}
