function siremisFillDB()
{
siremisReplaceDbConfig();
BizSystem::log(LOG_DEBUG, "SIREMIS", "install module siremis sql - " . $_REQUEST['db1type']);
if ($_REQUEST['db1type'] == "Pdo_Pgsql" || $_REQUEST['db1type'] == "pdo_pgsql") {
$sqlfile = MODULE_PATH . "/ser/mod.install.siremis.pgsql.sql";
} else {
$sqlfile = MODULE_PATH . "/ser/mod.install.siremis.sql";
}
if (!file_exists($sqlfile)) {
return true;
}
// Getting the SQL file content
$query = trim(file_get_contents($sqlfile));
if (empty($query)) {
return true;
}
// $db = BizSystem::dbConnection("Serdb");
$db = siremisConnectDB();
include_once MODULE_PATH . "/system/lib/MySQLDumpParser.php";
$queryArr = MySQLDumpParser::parse($query);
foreach ($queryArr as $query) {
try {
$db->exec($query);
} catch (Exception $e) {
BizSystem::log(LOG_DEBUG, "SIREMIS", $e->getMessage());
echo 'ERROR: ' . $e->getMessage();
exit;
}
}
return true;
}
protected function uninstallModuleSql()
{
$this->log("Uninstall Module Sql.");
$sqlfile = Openbiz::$app->getModulePath() . "/" . $this->objectName . "/mod.uninstall.sql";
if (!file_exists($sqlfile)) {
return true;
}
// Getting the SQL file content
$query = trim(file_get_contents($sqlfile));
if (empty($query)) {
return true;
}
$db = $this->DBConnection();
include_once Openbiz::$app->getModulePath() . "/system/lib/MySQLDumpParser.php";
$queryArr = MySQLDumpParser::parse($query);
foreach ($queryArr as $query) {
try {
$db->exec($query);
} catch (Exception $e) {
$this->errors = $e->getMessage();
$this->log($e->getMessage());
return false;
}
}
return true;
}
private function _restoreDB($db, $sqlfile, $charset = null)
{
$query = trim(file_get_contents($sqlfile));
if (empty($query)) {
return true;
}
$db = Openbiz::$app->getDbConnection($db);
if ($charset) {
$db->exec("SET NAMES '{$charset}';");
}
include_once Openbiz::$app->getModulePath() . "/system/lib/MySQLDumpParser.php";
$queryArr = MySQLDumpParser::parse($query);
foreach ($queryArr as $query) {
try {
$db->exec($query);
} catch (Exception $e) {
return false;
}
}
return true;
}
