if (file_exists($class_path)) {
echo "\tClass god file exists" . PHP_EOL;
} else {
$column_list = $db_obj->getTableColumns($table_name);
if (ModelHelper::createClassGodFile($table_name)) {
echo 'ok' . PHP_EOL;
} else {
echo 'fail' . PHP_EOL;
}
}
// sync table data
$sql_path = DATA_SQL_ROOT . '/' . $table_name . '.sql';
if (file_exists($sql_path)) {
echo "\tTruncate `{$table_name}` data...";
$sql = "TRUNCATE {$table_name}";
if ($db_obj->query($sql)) {
echo 'ok' . PHP_EOL;
echo "\t\tImport `{$table_name}` data...";
$sql = file_get_contents($sql_path);
if ($db_obj->query($sql)) {
echo 'ok' . PHP_EOL;
} else {
echo 'fail' . PHP_EOL;
}
} else {
echo 'fail' . PHP_EOL;
}
} else {
echo "\tNo data to import" . PHP_EOL;
}
} else {
public static function syncData($table_name)
{
$sql_path = DATA_SQL_ROOT . '/' . $table_name . '.sql';
if (!file_exists($sql_path)) {
return false;
} else {
// end if (!file_exists($sql_path))
$db_obj = new DatabaseAccess();
$sql = "TRUNCATE {$table_name}";
$auto_increment_result = $db_obj->query($sql);
$sql = file_get_contents($sql_path);
$import_result = $db_obj->query($sql);
unset($db_obj);
return $import_result;
}
// end if (!file_exists($sql_path)) else
}
