/**
* Fetches a list of migrations which have already been run.
*
* @uses MpmDbHelper::doSingleRowSelect()
* @uses MpmDbHelper::doMultiRowSelect()
*
* @param string $latestTimestamp the current timestamp of the migration run last
* @param string $direction the way we are migrating; should either be up or down
*
* @return array
*/
public static function getListFromDb($latestTimestamp, $direction = 'up')
{
$db_config = $GLOBALS['db_config'];
$migrations_table = $db_config->migrations_table;
if ($direction == 'down') {
$sql = "SELECT * FROM `{$migrations_table}` WHERE `timestamp` <= '{$latestTimestamp}' AND `active` = 1";
$countSql = "SELECT COUNT(*) as total FROM `{$migrations_table}` WHERE `timestamp` <= '{$latestTimestamp}' AND `active` = 1";
} else {
$sql = "SELECT * FROM `{$migrations_table}` WHERE `timestamp` >= '{$latestTimestamp}' AND `active` = 1";
$countSql = "SELECT COUNT(*) as total FROM `{$migrations_table}` WHERE `timestamp` >= '{$latestTimestamp}' AND `active` = 1";
}
$list = array();
$countObj = MpmDbHelper::doSingleRowSelect($countSql);
if ($countObj->total > 0) {
$results = MpmDbHelper::doMultiRowSelect($sql);
foreach ($results as $obj) {
$list[] = $obj->timestamp;
}
}
return $list;
}
/**
* Clears the migrations table and then rebuilds it.
*
* @uses MpmListHelper::mergeFilesWithDb()
* @uses MpmDbHelper::doSingleRowSelect()
*
* @return void
*/
public function reloadMigrations()
{
$db_config = $GLOBALS['db_config'];
$migrations_table = $db_config->migrations_table;
echo 'Clearing out existing migration data... ';
$this->dbObj->exec('TRUNCATE TABLE `' . $migrations_table . '`');
echo 'done.', "\n\n", 'Rebuilding migration data... ';
MpmListHelper::mergeFilesWithDb();
echo 'done.', "\n";
if ($this->initialMigrationTimestamp != null) {
echo "\n", 'Updating initial migration timestamp to ', $this->initialMigrationTimestamp, '... ';
$result = MpmDbHelper::doSingleRowSelect('SELECT COUNT(*) AS total FROM `' . $migrations_table . '` WHERE `timestamp` = "' . $this->initialMigrationTimestamp . '"', $this->dbObj);
if ($result->total == 1) {
$this->dbObj->exec('UPDATE `' . $migrations_table . '` SET `is_current` = 0');
$this->dbObj->exec('UPDATE `' . $migrations_table . '` SET `is_current` = 1 WHERE `timestamp` = "' . $this->initialMigrationTimestamp . '"');
$this->dbObj->exec('UPDATE `' . $migrations_table . '` SET `active` = 1 WHERE `timestamp` <= "' . $this->initialMigrationTimestamp . '"');
}
echo 'done.', "\n";
}
}
