coolify/tests/Feature/CleanupDatabaseCommandTest.php

<?php

use Illuminate\Foundation\Testing\RefreshDatabase;
use Illuminate\Support\Facades\DB;
use Spatie\Activitylog\Models\Activity;

uses(RefreshDatabase::class);

function cleanupTestActivity(int $ageInDays): Activity
{
    $activity = activity()->withProperties(['type' => 'inline', 'status' => 'finished'])->event('inline')->log('[]');
    Activity::query()->whereKey($activity->id)->toBase()->update(['created_at' => now()->subDays($ageInDays)]);

    return $activity;
}

beforeEach(function () {
    $this->old = collect(range(1, 12))->map(fn () => cleanupTestActivity(61));
    $this->recent = collect(range(1, 2))->map(fn () => cleanupTestActivity(5));
});

it('reports the real number of old activities in a dry run and deletes nothing', function () {
    $this->artisan('cleanup:database')
        ->expectsOutputToContain('Delete 12 entries from activity_log.')
        ->assertSuccessful();

    expect(Activity::query()->count())->toBe(14);
});

it('deletes all activities older than the retention and keeps newer ones', function () {
    $this->artisan('cleanup:database --yes')
        ->expectsOutputToContain('Delete 12 entries from activity_log.')
        ->assertSuccessful();

    expect(Activity::query()->pluck('id')->sort()->values()->all())
        ->toBe($this->recent->pluck('id')->sort()->values()->all());
});

it('deletes sessions older than the session lifetime', function () {
    config(['session.lifetime' => 10080]);
    $insertSession = fn (string $id, int $ageInMinutes) => DB::table('sessions')->insert([
        'id' => $id,
        'payload' => '',
        'last_activity' => now()->subMinutes($ageInMinutes)->timestamp,
    ]);
    $insertSession('expired', 10080 + 60);
    $insertSession('active', 10080 - 60);

    $this->artisan('cleanup:database --yes')
        ->expectsOutputToContain('Delete 1 entries from sessions.')
        ->assertSuccessful();

    expect(DB::table('sessions')->pluck('id')->all())->toBe(['active']);
});