protected function execute(InputInterface $input, OutputInterface $output)
{
$configuration = CodePax_Config::getInstance(CONFIG_PATH . 'config.ini');
$db_versions_model = CodePax_DbVersions::factory($configuration);
$latest_structure_version = $db_versions_model->getLatestVersion(CodePax_DbVersions::TYPE_CHANGE_SCRIPT);
$latest_data_version = $db_versions_model->getLatestVersion(CodePax_DbVersions::TYPE_DATA_CHANGE_SCRIPT);
$db_versioning_handler = CodePax_DbVersioning_Environments_Factory::factory($configuration);
$change_scripts = $db_versioning_handler->getChangeScripts();
$data_change_scripts = $db_versioning_handler->getDataChangeScripts();
$output->writeln('Environment: ' . strtoupper($configuration->application_environment));
$output->writeln('');
$output->writeln('Database name: ' . $configuration->db_name);
$output->writeln('Database structure version: ' . $latest_structure_version[CodePax_DbVersions::VERSION_ATTRIBUTE]);
$output->writeln('Database structure last update: ' . $latest_structure_version[CodePax_DbVersions::DATE_ADDED_ATTRIBUTE]);
$output->writeln('Database data version: ' . $latest_data_version[CodePax_DbVersions::VERSION_ATTRIBUTE]);
$output->writeln('Database data last update: ' . (!empty($latest_data_version[CodePax_DbVersions::DATE_ADDED_ATTRIBUTE]) ? $latest_data_version[CodePax_DbVersions::DATE_ADDED_ATTRIBUTE] : 'n/a'));
$output->writeln('');
if (strtolower($configuration->application_environment) == 'dev') {
$output->writeln('Baseline version: ' . $db_versioning_handler->getLatestBaselineVersion());
}
$output->writeln('Change structure scripts to run: ');
$output->writeln(!empty($change_scripts) ? implode("\n", array_keys($change_scripts)) : 'n/a');
$output->writeln('Change data scripts to run: ');
$output->writeln(!empty($data_change_scripts) ? implode("\n", array_keys($data_change_scripts)) : 'n/a');
}
/**
* Return the current DB version which can be
* either a change script or a data change script
*
* The array keys are: version, date_added
*
* @param int $_script_type can take values of 0,1,2
* @return array
* */
public function getLatestVersion($_script_type)
{
$query = 'SELECT TOP 1
(CAST(major AS varchar) + \'.\' + CAST(minor AS varchar) + \'.\' + CAST(point AS varchar)) as version,
date_added
FROM ' . CodePax_DbVersions::TABLE_NAME . '
WHERE script_type = ?
ORDER BY date_added DESC';
//set the script type param
$stmt = sqlsrv_prepare($this->db, $query, array(&$_script_type));
sqlsrv_execute($stmt);
$version_array = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC);
if (!empty($version_array)) {
$version_array['date_added'] = $version_array['date_added']->format('Y-m-d H:i:s');
}
if ($_script_type == CodePax_DbVersions::TYPE_CHANGE_SCRIPT) {
$_script_type = CodePax_DbVersions::TYPE_BASELINE;
sqlsrv_execute($stmt);
$baseline_version_array = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC);
if (!empty($baseline_version_array)) {
$baseline_version_array['date_added'] = $baseline_version_array['date_added']->format('Y-m-d H:i:s');
}
$version_array = CodePax_DbVersions::getLatestDbVersion($version_array, $baseline_version_array);
}
//when nothing is found, a default is returned
return empty($version_array) ? CodePax_DbVersions::getDefaultVersion() : $version_array;
}
/**
* Create required instances
*
* @return void
* */
public function __construct()
{
// create the sql handler
$this->sql_engine = CodePax_DbVersioning_SqlEngines_Factory::factory();
// factory the Model that handles the versions table
$this->db_versions_model = CodePax_DbVersions::factory();
// set the structure version
$this->setLatestDbVersion();
// set the data version
$this->setLatestDataDbVersion();
}
/**
* Return database versioning information
*
* @return stdClass
* @throws CodePax_DbVersioning_Exception
*/
public function info()
{
$databaseVersioningInfo = new stdClass();
// get current DB version
$db_versions_model = CodePax_DbVersions::factory($this->configuration);
if (in_array($this->configuration->application_environment, array('dev', 'prod'))) {
$latest_baseline_file = $this->filesManager->getLatestBaselineVersion();
if (!$db_versions_model->checkIsVersionRegistred($latest_baseline_file, CodePax_DbVersions::TYPE_BASELINE)) {
$db_versions_model->addVersion($latest_baseline_file, CodePax_DbVersions::TYPE_BASELINE);
}
}
$latest_structure_version = $db_versions_model->getLatestVersion(CodePax_DbVersions::TYPE_CHANGE_SCRIPT);
$latest_data_version = $db_versions_model->getLatestVersion(CodePax_DbVersions::TYPE_DATA_CHANGE_SCRIPT);
$databaseVersioningInfo->database_name = $this->configuration->db_name;
$databaseVersioningInfo->database_structure_version = $latest_structure_version[CodePax_DbVersions::VERSION_ATTRIBUTE];
$databaseVersioningInfo->database_structure_last_update = $latest_structure_version[CodePax_DbVersions::DATE_ADDED_ATTRIBUTE];
$databaseVersioningInfo->database_data_version = $latest_data_version[CodePax_DbVersions::VERSION_ATTRIBUTE];
$databaseVersioningInfo->database_data_last_update = !empty($latest_data_version[CodePax_DbVersions::DATE_ADDED_ATTRIBUTE]) ? $latest_data_version[CodePax_DbVersions::DATE_ADDED_ATTRIBUTE] : 'n/a';
// get change scripts to run
$db_versioning_handler = CodePax_DbVersioning_Environments_Factory::factory($this->configuration);
$change_scripts = $db_versioning_handler->getChangeScripts();
$data_change_scripts = $db_versioning_handler->getDataChangeScripts();
$new_baseline_available = false;
if (in_array($this->configuration->application_environment, array('dev', 'prod'))) {
$new_baseline_available = version_compare($latest_structure_version[CodePax_DbVersions::VERSION_ATTRIBUTE], $db_versioning_handler->getLatestBaselineVersion()) == -1;
}
// database is up-to-date
$databaseVersioningInfo->baseline_script = null;
$databaseVersioningInfo->db_versioning_dev_note = false;
$databaseVersioningInfo->db_scripts = array();
$databaseVersioningInfo->data_db_scripts = array();
if (empty($change_scripts) && empty($data_change_scripts) && !$new_baseline_available) {
$databaseVersioningInfo->db_is_updated = true;
} else {
//database is not up to date
$databaseVersioningInfo->db_is_updated = false;
// data change scripts
if (!empty($change_scripts)) {
$databaseVersioningInfo->db_scripts = array_keys($change_scripts);
}
// data change scripts
if (!empty($data_change_scripts)) {
$databaseVersioningInfo->data_db_scripts = array_keys($data_change_scripts);
}
// when on DEV, show extra info
if ($this->configuration->application_environment == 'dev') {
$databaseVersioningInfo->baseline_script = $db_versioning_handler->getLatestBaselineVersion();
$databaseVersioningInfo->db_versioning_dev_note = true;
}
}
return $databaseVersioningInfo;
}
/**
* Return the current DB version which can be
* either a change script or a data change script
*
* The array keys are: version, date_added
*
* @param int $_script_type can take values of 0,1,2
* @return array
* */
public function getLatestVersion($_script_type)
{
$query = $this->db->prepare('SELECT CONCAT(major, ".", minor, ".", point) AS version, date_added
FROM ' . CodePax_DbVersions::TABLE_NAME . '
WHERE script_type = ?
ORDER BY date_added DESC LIMIT 1');
$query->execute(array($_script_type));
$version_array = $query->fetch(PDO::FETCH_ASSOC);
if ($_script_type == CodePax_DBVersions::TYPE_CHANGE_SCRIPT) {
$query->execute(array(CodePax_DbVersions::TYPE_BASELINE));
$baseline_version_array = $query->fetch(PDO::FETCH_ASSOC);
$version_array = CodePax_DbVersions::getLatestDbVersion($version_array, $baseline_version_array);
}
//when nothing is found, a default is returned
return empty($version_array) ? CodePax_DbVersions::getDefaultVersion() : $version_array;
}
if (VERSIONING == 'SVN' && !empty($response_string) && is_numeric(strpos(strtolower($response_string), "run 'svn cleanup' to remove locks (type 'svn help cleanup' for details)"))) {
$view->working_copy_locked = true;
}
//--- show HOOKS section
if (defined('USE_HOOKS')) {
$view->use_hooks = USE_HOOKS;
$hooks_hanlder = new CodePax_Hooks_Handler();
$hooks = $hooks_hanlder->getList();
$view->hooks = array_keys($hooks);
}
//--- show Db versioning section
if (defined('USE_DB_VERSIONING') && USE_DB_VERSIONING === true) {
$view->use_db_versioning = true;
try {
// get current DB version
$db_versions_model = CodePax_DbVersions::factory();
if (in_array(APPLICATION_ENVIRONMENT, array('dev', 'prod'))) {
$latest_baseline_file = CodePax_DbVersioning_Files_Manager::getLatestBaselineVersion();
if (!$db_versions_model->checkIsVersionRegistred($latest_baseline_file, CodePax_DbVersions::TYPE_BASELINE)) {
$db_versions_model->addVersion($latest_baseline_file, CodePax_DbVersions::TYPE_BASELINE);
}
}
$latest_structure_version = $db_versions_model->getLatestVersion(CodePax_DbVersions::TYPE_CHANGE_SCRIPT);
$latest_data_version = $db_versions_model->getLatestVersion(CodePax_DbVersions::TYPE_DATA_CHANGE_SCRIPT);
$view->database_name = DB_NAME;
$view->database_structure_version = $latest_structure_version[CodePax_DbVersions::VERSION_ATTRIBUTE];
$view->database_structure_last_update = $latest_structure_version[CodePax_DbVersions::DATE_ADDED_ATTRIBUTE];
$view->database_data_version = $latest_data_version[CodePax_DbVersions::VERSION_ATTRIBUTE];
$view->database_data_last_update = !empty($latest_data_version[CodePax_DbVersions::DATE_ADDED_ATTRIBUTE]) ? $latest_data_version[CodePax_DbVersions::DATE_ADDED_ATTRIBUTE] : 'n/a';
// get change scripts to run
$db_versioning_handler = CodePax_DbVersioning_Environments_Factory::factory(APPLICATION_ENVIRONMENT);
/**
* Drop and recreate the database
* using the provided DB Engine
*
* @return void
* */
private function dropAndRecreateDb()
{
$this->sql_engine->dropAndCreateDb();
//for SQL Server get a new DB version model instance
//SQL Server closes the connection if we drop the database
if (DB_ENGINE == 'sqlsrv') {
$this->db_versions_model = CodePax_DbVersions::factory();
}
}
/**
* Class constructor for the environment object
*
* @param $configuration
* @throws CodePax_DbVersioning_Exception
*/
public function __construct($configuration)
{
// set the configuration param
$this->configuration = $configuration;
// set the files manager instance
$this->filesManager = new CodePax_DbVersioning_Files_Manager($this->configuration);
// create the sql handler
$this->sql_engine = CodePax_DbVersioning_SqlEngines_Factory::factory($this->configuration);
// factory the Model that handles the versions table
$this->db_versions_model = CodePax_DbVersions::factory($this->configuration);
// set the structure version
$this->setLatestDbVersion();
// set the data version
$this->setLatestDataDbVersion();
}
