<?php
/**
 * @remark :
 * @name   :lyhDemo.php
 * @author :lyh
 * @method :post
 * @time   :2025/3/24 9:38
 */

namespace App\Console\Commands\LyhTest;

use Illuminate\Console\Command;
use Illuminate\Support\Facades\DB;

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

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = '更新路由';

    public function handle(){
        $missingTaskIds = array_diff(
            DB::table('article')->pluck('task_id')->toArray(),
            DB::table('gl_ai_blog_task')->pluck('task_id')->toArray()
        );
        echo '数据'.json_encode($missingTaskIds,true).PHP_EOL;
        if (!empty($missingTaskIds)) {
            DB::connection('custom_mysql')->table('article')
                ->whereIn('task_id', $missingTaskIds)
                ->delete();
        }
        return true;
    }
}