<?php

namespace App\Console\Commands\Test;

use App\Models\Collect\CollectTask;
use App\Models\Com\UpdateLog;
use App\Services\ProjectServer;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\DB;

class Temp extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'test_temp';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = '临时脚本';


    public function handle()
    {
        $data = UpdateLog::where('api_type', 'website_info')->get();

        foreach ($data as $item) {
            $project_id = $item->project_id;
            $project = ProjectServer::useProject($project_id);
            if ($project) {
                try {
                    DB::connection('custom_mysql')->statement("ALTER TABLE `gl_news_category` ADD COLUMN  `original_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '来源id'");
                } catch (\Exception $e) {
                    echo $project_id . '已存在'.PHP_EOL;
                    continue;
                }
            }
            //关闭数据库
            DB::disconnect('custom_mysql');

            echo $project_id.'成功'.PHP_EOL;
        }
    }
}