function runSqlFiles($origVersion, $destVersion)
{
global $logpath;
global $unzip_dir;
writeLog("Upgrading the database from {$origVersion} to version {$destVersion}");
$origVersion = substr($origVersion, 0, 2) . 'x';
$destVersion = substr($destVersion, 0, 2) . 'x';
if (strcmp($origVersion, $destVersion) == 0) {
writeLog("*** Skipping schema upgrade for point release.");
return;
}
$schemaFileName = "{$unzip_dir}/scripts/{$origVersion}_to_{$destVersion}_" . $GLOBALS['db']->getScriptName() . ".sql";
if (is_file($schemaFileName)) {
writeLog("Running SQL file {$schemaFileName}");
ob_start();
@parseAndExecuteSqlFile($schemaFileName);
ob_end_clean();
} else {
writeLog("*** Schema change script [{$schemaFileName}] could not be found!");
}
}
function runSqlFiles($origVersion, $destVersion, $queryType, $resumeFromQuery = '')
{
global $sugar_config;
global $unzip_dir;
global $sugar_config;
global $sugar_version;
global $path;
global $_SESSION;
$self_dir = "{$unzip_dir}/scripts";
// This flag is determined by the preflight check in the installer
if (!isset($_SESSION['schema_change']) || $_SESSION['schema_change'] == 'sugar') {
_logThis("Upgrading the database from {$origVersion} to version {$destVersion}", $path);
$origVersion = implodeVersion($origVersion, 3, 'x');
$destVersion = implodeVersion($destVersion, 3, 'x');
$schemaFileName = $origVersion . "_to_" . $destVersion;
switch ($sugar_config['dbconfig']['db_type']) {
case 'mysql':
$schemaFileName = $schemaFileName . '_mysql.sql';
break;
case 'mssql':
$schemaFileName = $schemaFileName . '_mssql.sql';
break;
case 'oci8':
$schemaFileName = $schemaFileName . '_oracle.sql';
break;
case 'ibm_db2':
$schemaFileName = $schemaFileName . '_ibm_db2.sql';
break;
}
$schemaFile = $_SESSION['unzip_dir'] . '/scripts/' . $schemaFileName;
_logThis("Running SQL file {$schemaFile}", $path);
if (is_file($schemaFile)) {
//$sql_run_result = _run_sql_file($schemaFile);
ob_start();
@parseAndExecuteSqlFile($schemaFile, $queryType, $resumeFromQuery);
ob_end_clean();
} else {
if (strcmp($origVersion, $destVersion) == 0) {
_logThis("*** Skipping schema upgrade for point release.", $path);
} else {
_logThis("*** ERROR: Schema change script [{$schemaFile}] could not be found!", $path);
}
}
} else {
_logThis('*** Skipping Schema Change Scripts - Admin opted to run queries manually and should have done so by now.', $path);
}
}
