public function applySQLUpdateFile($sqlFile = 'db-update.sql')
{
$this->printStartNextStepMsg('Read SQL update file');
$success = true;
$message = null;
if (!file_exists($sqlFile)) {
$message = 'file <i>' . $sqlFile . '</i> does not exist, nothing to do !';
} else {
// read sql update file and set the table prefix
$sql = str_replace(TBL_NAME_PREFIX, $this->config->getTablePrefix(), @file_get_contents($sqlFile));
$this->printEndStepMsg(true);
$this->printStartNextStepMsg('Run SQL queries');
$res = DBHelper::exec($sql, true);
if ($res != null) {
$success = false;
$message = $res;
$this->error++;
}
DBHelper::clearStoredResults();
}
$this->printEndStepMsg($success, $message);
return $success;
}
echo '<i style="padding-left:30px;" >|_ Update reports in (' . implode(', ', $issue['reports']) . ') with issue id ' . $issueId . ' ... </i>';
if (DBHelper::updateReportsIssue($issue['reports'], $issueId)) {
echo '<i>OK</i><br/>';
} else {
echo '<i style="color:red" >FAILED</i><br/>';
}
} else {
echo '<i style="color:red" >FAILED</i><br/>';
echo '<i style="padding-left:30px; color:red; font-weight:bold;" >' . DBHelper::getLastError() . '</i><br/>';
}
}
} catch (Exception $e) {
echo '<b style="padding-left:30px; color:red;" >' . $e->getMessage() . '</b><br/>';
exit;
}
echo '<b>Step 5.</b> ... OK<br/>';
echo '<b>Step 6.</b> Create database triggers ... ';
$res = DBHelper::exec($sql[1], true);
if ($res != null) {
echo '<br/><b style="padding-left:30px; color:red;" >' . $res . '</b>';
exit;
}
DBHelper::clearStoredResults();
// count triggers
$res = DBHelper::countRows('information_schema.triggers', null, true);
if ($res != 4) {
echo '<b style="color:red" >FAILED</b><br/><b style="padding-left:30px; color:red;" >All triggers not created properly !</b>';
} else {
echo 'OK<br/>';
}
echo '<p><b style="color:green" >UPDATE IS COMPLETE !</b></p>';
