24 lines
638 B
PHP
24 lines
638 B
PHP
<?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');
|
|
}
|
|
}
|