public static function convertToSql($input_filepath, $dbname)
{
$objPHPExcel = self::loadFile($input_filepath);
$tables = array();
foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
$tbl = new \excel2sql\SqlTable($worksheet, $input_filepath);
if ($tbl->finalize()) {
$tables[$tbl->name] = $tbl->finalize();
} else {
error_log("table import failed: {$input_filepath}/{$tbl->name}");
}
}
$sql = new \sql\Database();
$sql->selectDB($dbname);
$table_names = array();
foreach ($tables as $tname => $queries) {
$sql->query($queries["drop"]);
$sql->query($queries["creation"]);
$sql->query($queries["insertion"]);
$table_names[] = $tname;
}
return $table_names;
}
public static function update($report)
{
$sql = new \sql\Database();
$sql->selectDB(\util\Config::$database->reportsDB);
$sql->query("UPDATE reports SET serial='" . $report->serialize() . "'" . "WHERE title='" . $report->title() . "'");
}
