createDb($mysqlAdminUsername, $mysqlAdminPassword, $dbName);
createDatabaseUserWithGrantsOnDb($mysqlAdminUsername, $mysqlAdminPassword, $dbName, $username, $password);
$cmd = new nbMysqlDumpCommand();
$commandLine = sprintf('%s %s %s %s', $dbName, $dumpPath, $username, $password);
$t->ok($cmd->run(new nbCommandLineParser(), $commandLine), 'MysqlDump executed successfully');
$timestamp = date('YmdHi', time());
$dumpFile = sprintf('%s/%s/%s-%s.sql', getcwd(), $dumpPath, $dbName, $timestamp);
$t->ok(file_exists($dumpFile), 'Dump file exists');
// Tear Down
$fs->delete($dumpFile);
dropDb($mysqlAdminUsername, $mysqlAdminPassword, $dbName);
dropDatabaseUser($mysqlAdminUsername, $mysqlAdminPassword, $username);
// Setup
createDb($mysqlAdminUsername, $mysqlAdminPassword, $dbName);
createDatabaseUserWithGrantsOnDb($mysqlAdminUsername, $mysqlAdminPassword, $dbName, $username);
$cmd = new nbMysqlDumpCommand();
$commandLine = sprintf('%s %s %s', $dbName, $dumpPath, $username);
$t->ok($cmd->run(new nbCommandLineParser(), $commandLine), 'MysqlDump executed successfully');
$timestamp = date('YmdHi', time());
$dumpFile = sprintf('%s/%s/%s-%s.sql', getcwd(), $dumpPath, $dbName, $timestamp);
$t->ok(file_exists($dumpFile), 'Dump file exists');
// Tear Down
$fs->delete($dumpFile);
dropDb($mysqlAdminUsername, $mysqlAdminPassword, $dbName);
dropDatabaseUser($mysqlAdminUsername, $mysqlAdminPassword, $username);
// Setup
createDb($mysqlAdminUsername, $mysqlAdminPassword, $dbName);
createDatabaseUserWithGrantsOnDb($mysqlAdminUsername, $mysqlAdminPassword, $dbName, $username, $password);
$parser = new nbCommandLineParser();
$parser->setDefaultConfigurationDirs(dirname(__FILE__) . '/../data/config');
$commandLine = '--config-file=mysql-plugin.yml';
protected function execute(array $arguments = array(), array $options = array())
{
$this->logLine('Diem Deploy');
$configParser = new nbYamlConfigParser();
$configParser->parseFile($arguments['config-file']);
$symfonyExePath = nbConfig::get('symfony_project-deploy_symfony-root-dir');
// Put website offline
if (nbConfig::has('symfony_project-deploy_site-applications')) {
foreach (nbConfig::get('symfony_project-deploy_site-applications') as $key => $value) {
$cmd = new nbSymfonyGoOfflineCommand();
$application = nbConfig::get('symfony_project-deploy_site-applications_' . $key . "_name");
$environment = nbConfig::get('symfony_project-deploy_site-applications_' . $key . "_env");
$cmd->run(new nbCommandLineParser(), sprintf('%s %s %s', $symfonyExePath, $application, $environment));
}
}
// Archive site directory
if (nbConfig::has('archive_inflate-dir')) {
$cmd = new nbInflateDirCommand();
$commandLine = '--config-file=' . $arguments['config-file'];
$cmd->run(new nbCommandLineParser(), $commandLine);
}
// Dump database
if (nbConfig::has('mysql_dump')) {
$cmd = new nbMysqlDumpCommand();
$commandLine = '--config-file=' . $arguments['config-file'];
$cmd->run(new nbCommandLineParser(), $commandLine);
}
// Sync project
if (nbConfig::has('filesystem_dir-transfer')) {
$cmd = new nbDirTransferCommand();
$commandLine = '--doit --delete --config-file=' . $arguments['config-file'];
$cmd->run(new nbCommandLineParser(), $commandLine);
}
// Check dirs
$cmd = new nbSymfonyCheckDirsCommand();
$commandLine = $symfonyExePath;
$cmd->run(new nbCommandLineParser(), $commandLine);
// Check permissions
$cmd = new nbSymfonyCheckPermissionsCommand();
$commandLine = $symfonyExePath;
$cmd->run(new nbCommandLineParser(), $commandLine);
// Change ownership
$cmd = new nbSymfonyChangeOwnershipCommand();
$commandLine = sprintf('%s %s %s', nbConfig::get('symfony_project-deploy_site-dir'), nbConfig::get('symfony_project-deploy_site-user'), nbConfig::get('symfony_project-deploy_site-group'));
$cmd->run(new nbCommandLineParser(), $commandLine);
// Restore database
if (nbConfig::has('mysql_restore')) {
$cmd = new nbMysqlRestoreCommand();
$commandLine = '--config-file=' . $arguments['config-file'];
$cmd->run(new nbCommandLineParser(), $commandLine);
}
// Diem setup
$cmd = new nbSymfonyDiemSetupCommand();
$commandLine = $symfonyExePath;
$cmd->run(new nbCommandLineParser(), $commandLine);
// Clear cache
$cmd = new nbSymfonyClearCacheCommand();
$commandLine = $symfonyExePath;
$cmd->run(new nbCommandLineParser(), $commandLine);
// Put site online
if (nbConfig::has('symfony_project-deploy_site-applications')) {
foreach (nbConfig::get('symfony_project-deploy_site-applications') as $key => $value) {
$cmd = new nbSymfonyGoOnlineCommand();
$application = nbConfig::get('symfony_project-deploy_site-applications_' . $key . "_name");
$environment = nbConfig::get('symfony_project-deploy_site-applications_' . $key . "_env");
$cmd->run(new nbCommandLineParser(), sprintf('%s %s %s', $symfonyExePath, $application, $environment));
}
}
$this->logLine('Done - Diem Deploy');
return true;
}