/**
* @param InputInterface $input
* @param OutputInterface $output
* @param string $env
* @param string $mysqlBin
* @param null $versionsPath
* @param bool $noSchema
* @param bool $installProvisionalVersion
* @param string $provisionalVersion
*
* @return int
*/
public function execute(InputInterface $input, OutputInterface $output, $env, $mysqlBin = 'mysql', $versionsPath = null, $noSchema = false, $installProvisionalVersion = false, $provisionalVersion = null)
{
$buildConn = DbConfig::getPDO($env, true);
$runConn = DbConfig::getPDO($env);
$output->writeln('Checking database status... ');
if (!$buildConn instanceof \PDO) {
$output->writeln('<error>Failed: unable to obtain a database connection.</error>');
return 1;
}
if ($buildConn->query("SHOW TABLES LIKE 'db_config'")->rowCount()) {
$output->writeln('<info>Database version control is already installed.</info>');
} else {
$output->writeln('Installing version control...');
$result = $buildConn->prepare("CREATE TABLE `db_config`\n(\n `key` VARCHAR(50) COLLATE 'utf8_general_ci' NOT NULL,\n `value` TEXT,\n `created_at` DATETIME,\n `updated_at` DATETIME,\n PRIMARY KEY (`key`),\n UNIQUE INDEX `db_config_U_1` (`key`)\n) ENGINE=MyISAM;")->execute();
if (!$result) {
$output->writeln('<error>Installing version control failed.</error>');
return 1;
}
$output->writeln('<info>Installed version control successfully.</info>');
}
// Check for current version and available version
// what is the versions path?
$versionsPath = VersionPaths::resolveVersionsPath($versionsPath);
// what is the current version?
$statusReceiver = new Status();
$currentVersion = $statusReceiver->getCurrentVersion($env);
$output->writeln('Current version: ' . $currentVersion);
// what is the available version?
$availableVersion = $statusReceiver->getAvailableVersion($versionsPath);
$output->writeln('Available version: ' . $availableVersion);
// Let's scan these versions and build a stack of files
$filesToLookFor = VersionPaths::getVersioningFilesToLookFor(!$noSchema, in_array($env, DbConfig::getTestingEnvironments()));
$stack = array();
if ($currentVersion < $availableVersion) {
for ($i = $currentVersion + 1; $i <= $availableVersion; $i++) {
$path = $versionsPath . DIRECTORY_SEPARATOR . $i;
if (!is_dir($path) || !is_readable($path)) {
continue;
}
foreach ($filesToLookFor as $file) {
if (is_readable($path . DIRECTORY_SEPARATOR . $file) && is_file($path . DIRECTORY_SEPARATOR . $file)) {
$stack[$i][$file] = $path . DIRECTORY_SEPARATOR . $file;
}
}
}
}
// Look for a provisional version?
if ($installProvisionalVersion) {
$output->writeln('Looking for provisional version: ' . $provisionalVersion);
$path = VersionPaths::resolveProvisionalVersionPath($versionsPath, $provisionalVersion);
if (is_readable($path) && is_dir($path)) {
foreach ($filesToLookFor as $file) {
if (is_readable($path . DIRECTORY_SEPARATOR . $file) && is_file($path . DIRECTORY_SEPARATOR . $file)) {
$stack[$provisionalVersion][$file] = $path . DIRECTORY_SEPARATOR . $file;
}
}
}
}
$updates = count($stack);
if (!$updates) {
$output->writeln('<info>Database version is already up to date.</info>');
return 0;
}
$noun = $updates > 1 ? 'updates' : 'update';
$report = "Current version: {$currentVersion}, Available version: {$availableVersion}";
if (is_string($provisionalVersion) && array_key_exists($provisionalVersion, $stack)) {
$report .= ", Provisional version: {$provisionalVersion}";
}
$output->writeln("Installing database {$noun} ({$report})...");
$s = '\\' == DIRECTORY_SEPARATOR ? "%s" : "'%s'";
// Windows doesn't like quoted params
// loop sql file stack and execute on mysql CLI
$dbConf = DbConfig::getConfig($env);
$previousVersion = $currentVersion;
$result = true;
foreach ($stack as $version => $files) {
$output->write($previousVersion . " -> {$version} ");
if (!$result) {
$output->write('skipped');
continue;
}
foreach ($files as $file) {
if ('schema.sql' === $file) {
$conf = $dbConf['buildtime'];
} else {
$conf = $dbConf['runtime'];
}
$host = $conf['host'];
$user = $conf['user'];
$pass = $conf['password'];
$name = $conf['database'];
$port = isset($conf['port']) ? $conf['port'] : null;
if ('.sql' === substr($file, -4)) {
$cmdMySQL = "{$mysqlBin} -h {$s} --user={$s} --password={$s} --database={$s}";
if ($port) {
$cmdMySQL .= " --port=" . (int) $port;
}
$cmdMySQL .= " < %s";
$command = sprintf($cmdMySQL, $host, $user, $pass, $name, $file);
$process = new Process($command);
$process->run();
if (!$process->isSuccessful()) {
$result = false;
break;
}
continue;
}
if ('.php' === substr($file, -4)) {
$feedback = (require_once $file);
}
}
if ($result && is_int($version)) {
$result = $buildConn->query("REPLACE INTO `db_config` (`key`, `value`, `updated_at`) VALUES ('version', {$version}, now())")->execute();
}
$statusMsg = $result ? '<info>OK</info>' : '<error>Failed</error>';
$output->write($statusMsg, true);
if (isset($feedback) && is_string($feedback) && strlen($feedback)) {
$output->write($feedback);
unset($feedback);
}
if (!$result) {
$output->write('<error>' . $process->getErrorOutput() . '</error>');
}
$previousVersion = $version;
}
if ($result) {
$output->writeln('<info>Database updates installed successfully.</info>');
return 0;
} else {
$output->writeln('<error>Installing database updates failed.</error>');
return 1;
}
}
/**
* Returns true iff there is a provisional version directory with at least one recognized file inside it.
*
* @param string|null $versionsPath
* @param string|null $provisionalVersion
*
* @return bool
*/
public function hasProvisionalVersion($versionsPath, $provisionalVersion)
{
$filesToLookFor = VersionPaths::getVersioningFilesToLookFor(true, true);
$path = VersionPaths::resolveProvisionalVersionPath($versionsPath, $provisionalVersion);
if (is_readable($path) && is_dir($path)) {
foreach ($filesToLookFor as $file) {
if (is_readable($path . DIRECTORY_SEPARATOR . $file) && is_file($path . DIRECTORY_SEPARATOR . $file)) {
return true;
}
}
}
return false;
}