/** * 复原所有表 */ 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"; }