V2boardInit.php 1.4 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364
  1. <?php
  2. namespace App\Console\Commands;
  3. use Illuminate\Console\Command;
  4. use Illuminate\Support\Facades\DB;
  5. class V2boardInit extends Command
  6. {
  7. /**
  8. * The name and signature of the console command.
  9. *
  10. * @var string
  11. */
  12. protected $signature = 'v2board:init';
  13. /**
  14. * The console command description.
  15. *
  16. * @var string
  17. */
  18. protected $description = 'v2board 初始化';
  19. /**
  20. * Create a new command instance.
  21. *
  22. * @return void
  23. */
  24. public function __construct()
  25. {
  26. parent::__construct();
  27. }
  28. /**
  29. * Execute the console command.
  30. *
  31. * @return mixed
  32. */
  33. public function handle()
  34. {
  35. if (\File::exists(base_path() . '/.lock')) {
  36. abort(500, 'V2board 已安装,如需重新初始化请删除目录下.lock文件');
  37. }
  38. \Artisan::call('key:generate');
  39. \Artisan::call('config:cache');
  40. DB::connection()->getPdo();
  41. $file = \File::get(base_path() . '/install.sql');
  42. if (!$file) {
  43. abort(500, '数据库文件不存在');
  44. }
  45. $sql = str_replace("\n", "", $file);
  46. $sql = preg_split("/;/", $sql);
  47. if (!is_array($sql)) {
  48. abort(500, '数据库文件格式有误');
  49. }
  50. foreach($sql as $item) {
  51. echo 'RUN ' . $item . "\r\n";
  52. try {
  53. DB::select(DB::raw($item));
  54. } catch (\Exception $e) {}
  55. }
  56. \File::put(base_path() . '/.lock', time());
  57. }
  58. }