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 }