V2boardUpdate.php 1.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061
  1. <?php
  2. namespace App\Console\Commands;
  3. use Illuminate\Console\Command;
  4. use Illuminate\Support\Facades\DB;
  5. class V2boardUpdate extends Command
  6. {
  7. /**
  8. * The name and signature of the console command.
  9. *
  10. * @var string
  11. */
  12. protected $signature = 'v2board:update';
  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. \Artisan::call('config:cache');
  36. DB::connection()->getPdo();
  37. $file = \File::get(base_path() . '/update.sql');
  38. if (!$file) {
  39. abort(500, '数据库文件不存在');
  40. }
  41. $sql = str_replace("\n", "", $file);
  42. $sql = preg_split("/;/", $sql);
  43. if (!is_array($sql)) {
  44. abort(500, '数据库文件格式有误');
  45. }
  46. $this->info('正在导入数据库请稍等...');
  47. foreach ($sql as $item) {
  48. try {
  49. DB::select(DB::raw($item));
  50. } catch (\Exception $e) {
  51. }
  52. }
  53. $this->info('更新完毕');
  54. }
  55. }