<?php
declare(strict_types=1);

// Housekeeping: expired sessions and old login attempts. Run daily from cron.
$api = __DIR__ . '/../api';
require $api . '/lib/Config.php';
require $api . '/lib/DB.php';
Config::load($api . '/config/config.php');

echo DB::run('DELETE FROM user_sessions WHERE expires_at < NOW()'), " expired sessions removed\n";
echo DB::run('DELETE FROM login_attempts WHERE created_at < DATE_SUB(NOW(), INTERVAL 90 DAY)'), " old login attempts removed\n";
echo DB::run('DELETE FROM email_queue WHERE status = "sent" AND sent_at < DATE_SUB(NOW(), INTERVAL 60 DAY)'), " sent mail rows removed\n";
