/**
* Determines what action should be performed and takes that action.
*
* @uses MpmDownController::displayHelp()
* @uses MpmCommandLineWriter::getInstance()
* @uses MpmCommandLineWriter::writeHeader()
* @uses MpmMigrationHelper::getListOfMigrations()
* @uses MpmMigrationHelper::getCurrentMigrationNumber()
* @uses MpmMigrationHelper::getTimestampFromId()
* @uses MpmMigrationHelper::runMigration()
* @uses MpmMigrationHelper::setCurrentMigration()
*
* @return void
*/
public function doAction($quiet = false)
{
// write the header
$clw = MpmCommandLineWriter::getInstance();
$skip_headers = false;
if (!empty($this->arguments[2])) {
$skip_headers = true;
}
if (!$quiet && !$skip_headers) {
$clw->writeHeader();
}
// correct number of command line arguments?
if (count($this->arguments) == 0) {
return $this->displayHelp();
}
// ID of the migration we are going down to
$down_to = $this->arguments[0];
if (!is_numeric($down_to)) {
return $this->displayHelp();
}
if ($down_to == 0) {
$down_to = -1;
}
// are we forcing this?
$forced = false;
if (isset($this->arguments[1]) && strcasecmp($this->arguments[1], '--force') == 0) {
$forced = true;
}
// get list of migrations and the current migration number
$list = MpmMigrationHelper::getListOfMigrations($down_to, 'down');
$total = count($list);
$current = MpmMigrationHelper::getCurrentMigrationNumber();
if ($down_to == '-1') {
if (!$quiet) {
echo "Removing all migrations... ";
}
$down_to = 0;
} else {
if (!$quiet) {
echo "Migrating to " . MpmMigrationHelper::getTimestampFromId($down_to) . ' (ID ' . $down_to . ')... ';
}
}
foreach ($list as $id => $obj) {
MpmMigrationHelper::runMigration($obj, 'down', $forced);
}
MpmMigrationHelper::setCurrentMigration($down_to);
if (!$skip_headers && !$quiet) {
echo "\n";
$clw->writeFooter();
}
}
/**
* Determines what action should be performed and takes that action.
*
* @uses MpmDbHelper::test()
* @uses MpmMigrationHelper::getCurrentMigrationTimestamp()
* @uses MpmMigrationHelper::getCurrentMigrationNumber()
* @uses MpmListHelper::getFullList()
* @uses MpmCommandLineWriter::getInstance()
* @uses MpmCommandLineWriter::writeHeader()
* @uses MpmCommandLineWriter::writeFooter()
*
* @return void
*/
public function doAction()
{
// make sure we're init'd
MpmDbHelper::test();
// get latest timestamp
$latest = MpmMigrationHelper::getCurrentMigrationTimestamp();
// get latest number
$num = MpmMigrationHelper::getCurrentMigrationNumber();
// get list of migrations
$list = MpmListHelper::getFullList();
// get command line writer
$clw = MpmCommandLineWriter::getInstance();
$clw->writeHeader();
if (empty($latest)) {
echo "You have not performed any migrations yet.";
} else {
echo "You are currently on migration {$num} -- " . $latest . '.';
}
echo "\n";
$clw->writeFooter();
}
/**
* Determines what action should be performed and takes that action.
*
* @uses MpmDownController::displayHelp()
* @uses MpmCommandLineWriter::getInstance()
* @uses MpmCommandLineWriter::writeHeader()
* @uses MpmMigrationHelper::getListOfMigrations()
* @uses MpmMigrationHelper::getCurrentMigrationNumber()
* @uses MpmMigrationHelper::getTimestampFromId()
* @uses MpmMigrationHelper::runMigration()
* @uses MpmMigrationHelper::setCurrentMigration()
*
* @return void
*/
public function doAction()
{
// write the header
$clw = MpmCommandLineWriter::getInstance();
$clw->writeHeader();
// correct number of command line arguments?
if (count($this->arguments) == 0) {
return $this->displayHelp();
}
// ID of the migration we are going down to
$down_to = $this->arguments[0];
if (!is_numeric($down_to)) {
return $this->displayHelp();
}
if ($down_to == 0) {
$down_to = -1;
}
// parse other optional arguments
list($forced, $dryrun) = $this->parse_options($this->arguments);
// get list of migrations and the current migration number
$list = MpmMigrationHelper::getListOfMigrations($down_to, 'down');
$total = count($list);
$current = MpmMigrationHelper::getCurrentMigrationNumber();
if ($down_to == '-1') {
echo "Removing all migrations... ";
$down_to = 0;
} else {
echo "Migrating to " . MpmMigrationHelper::getTimestampFromId($down_to) . ' (ID ' . $down_to . ')... ';
}
foreach ($list as $id => $obj) {
MpmMigrationHelper::runMigration($obj, 'down', array('forced' => $forced, 'dryrun' => $dryrun));
}
MpmMigrationHelper::setCurrentMigration($down_to, $dryrun);
echo "\n";
$clw->writeFooter();
}
/**
* Determines what action should be performed and takes that action.
*
* @uses MpmLatestController::displayHelp()
* @uses MpmDbHelper::test()
* @uses MpmMigrationHelper::getMigrationCount()
* @uses MpmCommandLineWriter::getInstance()
* @uses MpmMigrationHelper::getLatestMigration()
* @uses MpmUpController::doAction()
*
* @param bool $quiet supresses certain text when true
*
* @return void
*/
public function doAction($quiet = false)
{
// make sure we're init'd
MpmDbHelper::test();
//get completed migrations from database
//get migrations from file
$oldest_migration_id = MpmMigrationHelper::getOldestMigration();
$current_timestamp = MpmMigrationHelper::getCurrentMigrationTimestamp();
$current_num = MpmMigrationHelper::getCurrentMigrationNumber();
/*$latest_num = MpmMigrationHelper::getLatestMigration();
$latest_timestamp = MpmMigrationHelper::getTimestampFromId($latest_num);*/
$db_migrations = MpmListHelper::getListFromDb($current_timestamp, 'down');
$files = MpmListHelper::getListOfFiles();
$all_file_timestamps = MpmListHelper::getTimestampArray($files);
$file_timestamps = array();
foreach ($all_file_timestamps as $timestamp) {
if ($timestamp <= $current_timestamp) {
$file_timestamps[] = $timestamp;
}
}
end($all_file_timestamps);
$latest_timestamp = current($all_file_timestamps);
//compare timestamps that are in either array to timestamps that are in both arrays to find missing timestamps in either
//$missing_merges = array_diff(array_unique( array_merge($file_timestamps,$db_migrations) ), array_intersect($file_timestamps,$db_migrations) );
$missing_database = array_diff($file_timestamps, $db_migrations);
$missing_files = array_diff($db_migrations, $file_timestamps);
$missing_merges = array_merge($missing_files, $missing_database);
sort($missing_merges);
reset($missing_merges);
$oldest_missing = current($missing_merges);
$clw = MpmCommandLineWriter::getInstance();
$clw->writeHeader();
if (!$current_num) {
echo 'You have not run any migrations';
} else {
echo "You are currently on migration {$current_num} -- " . $current_timestamp . '.';
}
if (!empty($missing_files)) {
echo "\n\nCompleted migrations that are no longer in migrations directory\n----------\n";
foreach ($missing_files as $file) {
echo " {$file}\n";
}
}
if (!empty($missing_database)) {
echo "\n\nOld migrations that have not been run\n----------";
foreach ($missing_database as $db) {
echo "\n {$db}";
}
}
if ($current_timestamp < $latest_timestamp) {
echo "\nLatest migration is: {$latest_timestamp}.";
}
if ($oldest_missing && $oldest_missing <= $current_timestamp || $current_timestamp < $latest_timestamp) {
echo "\n\n--- Migration Path --------------------------\n";
$post_down_timestamp = $current_timestamp;
if ($oldest_missing && $oldest_missing <= $current_timestamp) {
//find target down timestamp
$previous_migration = MpmMigrationHelper::getNextTimestamp($oldest_missing, 'down');
if ($previous_migration) {
$post_down_timestamp = $previous_migration->timestamp;
echo "\n Migrate down to: {$previous_migration->id} -- {$previous_migration->timestamp}";
} else {
$post_down_timestamp = 0;
echo "\n Remove all migrations";
}
}
if ($post_down_timestamp < $latest_timestamp) {
echo "\n Migrate up to latest: {$latest_timestamp}";
}
} else {
echo "\n\n You are up to date";
}
/*$total_migrations = MpmMigrationHelper::getMigrationCount();
if ($total_migrations == 0)
{
$clw = MpmCommandLineWriter::getInstance();
$clw->addText('No migrations exist.');
$clw->write();
exit;
}
$to_id = MpmMigrationHelper::getLatestMigration();
$obj = new MpmUpController('up', array ( $to_id, $forced ));
$obj->doAction($quiet);
*/
$clw->writeFooter();
}
/**
* Determines what action should be performed and takes that action.
*
* @uses MpmLatestController::displayHelp()
* @uses MpmDbHelper::test()
* @uses MpmMigrationHelper::getMigrationCount()
* @uses MpmCommandLineWriter::getInstance()
* @uses MpmMigrationHelper::getLatestMigration()
* @uses MpmUpController::doAction()
*
* @param bool $quiet supresses certain text when true
*
* @return void
*/
public function doAction($quiet = false)
{
// make sure we're init'd
MpmDbHelper::test();
$clw = MpmCommandLineWriter::getInstance();
$clw->writeHeader();
// are we forcing this?
$forced = '';
if (isset($this->arguments[0]) && strcasecmp($this->arguments[0], '--force') == 0) {
$forced = '--force';
}
//get completed migrations from database
//get migrations from file
$oldest_migration_id = MpmMigrationHelper::getOldestMigration();
$current_timestamp = MpmMigrationHelper::getCurrentMigrationTimestamp();
$current_num = MpmMigrationHelper::getCurrentMigrationNumber();
//$latest_num = MpmMigrationHelper::getLatestMigration();
//$latest_timestamp = MpmMigrationHelper::getTimestampFromId($latest_num);
$db_migrations = MpmListHelper::getListFromDb($current_timestamp, 'down');
$files = MpmListHelper::getListOfFiles();
$all_file_timestamps = MpmListHelper::getTimestampArray($files);
$file_timestamps = array();
foreach ($all_file_timestamps as $timestamp) {
if ($timestamp <= $current_timestamp) {
$file_timestamps[] = $timestamp;
}
}
end($file_timestamps);
$latest_timestamp = current($file_timestamps);
//compare timestamps that are in either array to timestamps that are in both arrays to find missing timestamps in either
//$missing_merges = array_diff(array_unique( array_merge($file_timestamps,$db_migrations) ), array_intersect($file_timestamps,$db_migrations) );
$missing_database = array_diff($file_timestamps, $db_migrations);
$missing_files = array_diff($db_migrations, $file_timestamps);
$missing_merges = array_merge($missing_files, $missing_database);
sort($missing_merges);
reset($missing_merges);
$oldest_missing = current($missing_merges);
try {
if ($oldest_missing && $oldest_missing <= $current_timestamp) {
$previous_migration = MpmMigrationHelper::getNextTimestamp($oldest_missing, 'down');
if ($previous_migration) {
$target_down = $previous_migration->id;
} else {
$target_down = -1;
}
$down = new MpmDownController('down', array($target_down, $forced, true));
$down->doAction($quiet);
}
//merge files with database
MpmListHelper::mergeFilesWithDb();
$newest_id = MpmMigrationHelper::getLatestMigration();
if ($newest_id) {
$newest_timestamp = MpmMigrationHelper::getTimestampFromId($newest_id);
$current_timestamp = MpmMigrationHelper::getCurrentMigrationTimestamp();
if ($newest_timestamp > $current_timestamp) {
$obj = new MpmUpController('up', array($newest_id, $forced, true));
$obj->doAction($quiet);
} else {
echo "\nUp to Date";
}
} else {
echo "\nUp to Date";
}
} catch (Exception $e) {
echo "\n\nERROR: " . $e->getMessage() . "\n\n";
exit;
}
$clw->writeFooter();
}
