<?php

namespace App\Commands;

use CodeIgniter\CLI\BaseCommand;
use CodeIgniter\CLI\CLI;

class DeleteExpiredQueryCache extends BaseCommand
{
    protected $group       = 'ChartBoard';
    protected $name        = 'chartboard:query-cache:purge';
    protected $description = 'Delete expired query cache entries.';

    public function run(array $params)
    {
        $builder = db_connect()->table('query_cache');
        $builder->where('expires_at <', date('Y-m-d H:i:s'));
        $builder->delete();
        $count = db_connect()->affectedRows();

        CLI::write('Expired query cache rows deleted: ' . $count, 'green');
    }
}