12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061 |
- <?php
- namespace App\Console\Commands;
- use Illuminate\Console\Command;
- use Illuminate\Support\Facades\DB;
- class V2boardUpdate extends Command
- {
- /**
- * The name and signature of the console command.
- *
- * @var string
- */
- protected $signature = 'v2board:update';
- /**
- * The console command description.
- *
- * @var string
- */
- protected $description = 'v2board 更新';
- /**
- * Create a new command instance.
- *
- * @return void
- */
- public function __construct()
- {
- parent::__construct();
- }
- /**
- * Execute the console command.
- *
- * @return mixed
- */
- public function handle()
- {
- \Artisan::call('config:cache');
- DB::connection()->getPdo();
- $file = \File::get(base_path() . '/database/update.sql');
- if (!$file) {
- abort(500, '数据库文件不存在');
- }
- $sql = str_replace("\n", "", $file);
- $sql = preg_split("/;/", $sql);
- if (!is_array($sql)) {
- abort(500, '数据库文件格式有误');
- }
- $this->info('正在导入数据库请稍等...');
- foreach ($sql as $item) {
- try {
- DB::select(DB::raw($item));
- } catch (\Exception $e) {
- }
- }
- $this->info('更新完毕');
- }
- }
|