/**
* 复原所有表
*/
public static function reset()
{
$dir = config::database() . '/migrations/';
$file = scandir($dir);
unset($file[0]);
unset($file[1]);
foreach ($file as $name) {
$name = pathinfo($name)['filename'];
$namespace = 'Console\\Database\\migrations\\' . $name;
$obj = new $namespace();
$obj->down();
echo "\ndelete {$name} successfully";
}
}
public static function seed()
{
$param = config::param();
$table_name = $param[0];
$dir = config::database() . '/seeds/';
if (strpos($table_name, '--class=') !== false) {
$table_name = explode('=', $table_name);
$table_name = end($table_name);
if (is_file($dir . $table_name . '.php')) {
$sql = file_get_contents($dir . $table_name . '.php');
self::insert($sql);
echo "\nseed table {$table_name} successfully";
}
} else {
$file = scandir($dir);
unset($file[0]);
unset($file[1]);
foreach ($file as $name) {
$sql = file_get_contents($dir . $name);
self::insert($sql);
echo "\nseed {$name} successfully";
}
}
}
public static function seeder()
{
$param = config::param();
$table_name = $param[0];
$new_file = config::database() . '/seeds/' . $table_name . '.php';
if (empty($table_name)) {
return "[0;41;1m table_name isnull\n";
}
if (is_file($new_file)) {
return "[0;41;1m{$table_name} is has\n";
}
$filename = config::database() . '/migrations/' . $table_name . '.php';
if (!is_file($filename)) {
return "[0;41;1mnot find this {$table_name} migrate\n";
}
$sql = "DESC {$table_name}";
$rs = System\Db::query($sql);
$str_sql = '';
while ($row = $rs->fetch()) {
$value = $row['Default'];
if (empty($row['Default'])) {
$value = $row['Field'];
}
if (!empty($str_sql)) {
$str_sql = $str_sql . ',';
}
$str_sql = $str_sql . "'{$value}'";
}
$nest = 'INSERT INTO `' . $table_name . '` VALUES (' . $str_sql . ');';
if (!is_dir(dirname($new_file))) {
mkdir(dirname($new_file), 0755, true);
}
file_put_contents($new_file, $nest);
echo "\ncreate {$table_name} successfully\n";
}
