Пример #1
0
 public static function insert($sql)
 {
     $sql = str_replace("\r", "\n", $sql);
     $sql = explode(";\n", $sql);
     foreach ($sql as $value) {
         $value = trim($value);
         if (empty($value)) {
             continue;
         }
         \Console\System\Db::query($value);
     }
 }
Пример #2
0
 public static function seeder()
 {
     $param = config::param();
     $table_name = $param[0];
     $new_file = config::database() . '/seeds/' . $table_name . '.php';
     if (empty($table_name)) {
         return " table_name isnull\n";
     }
     if (is_file($new_file)) {
         return "{$table_name} is has\n";
     }
     $filename = config::database() . '/migrations/' . $table_name . '.php';
     if (!is_file($filename)) {
         return "not 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";
 }