/**
* Imports the SQL statements from the db_sync.sql file, or from the file provided through file upload.
* This function can only be called from the Symphony backend, the CDI extension must be enabled and running in Database Synchronisation mode.
*/
public static function import() {
// We should not be processing any queries when the extension is disabled or when it is in 'Continuous Database Integration' mode
if((!class_exists('Administration')) || !CdiUtil::isEnabled() || !CdiUtil::isCdiDBSyncSlave()) {
throw new Exception("You can only import the Database Synchroniser file from the Preferences page. The CDI extension must be enabled and should be a 'Slave' instance in 'Database Synchronisation' mode.");
}
// Prevent the CdiLogQuery::log() from persisting queries that are executed by CDI itself
// This should not be possible anyway because we can only import in "Slave" mode, but just to be sure!
CdiLogQuery::isUpdating(true);
// Handle file upload
$syncFile = CDI_DB_SYNC_FILE;
if(!empty($_FILES['cdi_import_file']['tmp_name'])) {
$syncFile = $_FILES['cdi_import_file']['tmp_name'];
}
//Execute the queries from file
try {
if(file_exists($syncFile)) {
$contents = file_get_contents($syncFile);
$queries = explode(';',$contents);
foreach($queries as $query) {
$query = trim($query);
// ommit comments and empty statements
if(!preg_match('/^--/i', $query) && !$query=='') {
Symphony::Database()->query($query);
}
}
if(isset($_POST['settings']['cdi']['deleteSyncFile'])) {
unlink($syncFile);
}
}
} catch (Exception $e) {
// Re-enable CdiLogQuery::log() to persist queries
CdiLogQuery::isUpdating(false);
throw $e;
}
// Save the last update date to configuration
Symphony::Configuration()->set('last-update', time(), 'cdi');
Symphony::Configuration()->write();
// Re-enable CdiLogQuery::log() to persist queries
CdiLogQuery::isUpdating(false);
}
public static function appendInstanceMode() {
$div = new XMLElement('div', NULL, array('class' => 'instanceMode'));
$div->appendChild(new XMLElement('h3','Instance Mode',array('style' => 'margin: 5px 0;')));
$label = Widget::Label();
if(!CdiUtil::isCdiSlave() && !CdiUtil::isCdiDBSyncSlave()) {
$label->setAttribute('style','position:relative;padding-left:18px;');
} else {
$label->setAttribute('style','margin-bottom: 2px;position:relative;padding-left:18px;');
}
$input = Widget::Input('settings[cdi][is-slave]', 'yes', 'checkbox');
$input->setAttribute('style','position:absolute;left:0px;');
$input->setAttribute('class','instance-mode');
if(CdiUtil::canBeMasterInstance()) {
if(CdiUtil::isCdiSlave() || CdiUtil::isCdiDBSyncSlave()) { $input->setAttribute('checked', 'checked'); }
$label->setValue($input->generate() . ' This is a "Slave" instance (no structural changes will be registered)');
} else {
$input->setAttribute('checked', 'checked');
$input->setAttribute('disabled', 'disabled');
$label->setValue($input->generate() . ' This can only be a "Slave" instance due to insufficient write permissions.');
}
$div->appendChild($label);
if(CdiUtil::isCdiSlave() || CdiUtil::isCdiDBSyncSlave())
{
$label = Widget::Label();
$label->setAttribute('style','position:relative;padding-left:18px;');
$input = Widget::Input('settings[cdi][disable_blueprints]', 'yes', 'checkbox');
$input->setAttribute('style','position:absolute;left:0px;');
if(CdiUtil::hasDisabledBlueprints()) {
$input->setAttribute('checked', 'checked');
}
$label->setValue($input->generate() . ' Disable structural changes on this instance.');
$div->appendChild($label);
}
if(CdiUtil::isCdiMaster() || CdiUtil::isCdiSlave()) {
$div->appendChild(new XMLElement('p', 'The extension is designed to allow automatic propagation of structural changes between environments in a DTAP setup.
It is imperitive that you have a single "Master" instance (usually your development environment). This is important because the auto-increment values need to be exactly the same on each database table in every environment.
Switching between modes is therefore not recommended. If needed, make sure you only switch instance mode after you have ensured that you have restored all databases from the same source and cleared the CDI logs on all instances.', array('class' => 'help')));
} else if (CdiUtil::isCdiDBSync()) {
$div->appendChild(new XMLElement('p', 'The extension is designed to allow manual propagation of structural changes between environments in a DTAP setup.
It is imperitive that you have a single "Master" instance (usually your development environment). This is important because the auto-increment values need to be exactly the same on each database table in every environment.
Switching between modes is therefore not recommended. If needed, make sure you only switch instance mode after you have ensured that you have restored all databases from the same source.', array('class' => 'help')));
}
$div->appendChild(new XMLElement('p', 'You need to save your changes before you can configure this instance, or reload the page to cancel.<br />Be advised: changing instances mode will reset any instance specific configuration settings', array('class' => 'cdiInstanceRestart', 'style' => 'display:none;')));
return $div;
}
