Files
wp-donations/tests/Unit/MaintenancePurgeTest.php
shadowdaoandClaude Sonnet 5.5 11ac72b23b
Test and Release / test (push) Successful in 1m20s
Test and Release / release (push) Successful in 5s
Test: pin down which rows the abandoned-checkout purge may delete
Co-Authored-By: Claude Sonnet 5.5 <noreply@anthropic.com>
2026-11-15 12:30:21 -08:00

52 lines
2.0 KiB
PHP

<?php
declare( strict_types=1 );
namespace StreamGoals\Tests\Unit;
use PHPUnit\Framework\TestCase;
use StreamGoals\Core\Maintenance;
/**
* The purge deletes rows, so pin down exactly what it may touch: only never-paid pending checkouts,
* only older than a week, never test donations, never anything with a PayPal capture id.
*/
final class MaintenancePurgeTest extends TestCase {
private $previous;
protected function setUp(): void {
foreach ( array( 'HOUR_IN_SECONDS' => 3600, 'DAY_IN_SECONDS' => 86400 ) as $k => $v ) {
if ( ! defined( $k ) ) {
define( $k, $v );
}
}
$this->previous = $GLOBALS['wpdb'] ?? null;
}
protected function tearDown(): void {
$GLOBALS['wpdb'] = $this->previous;
}
public function test_purge_sql_only_targets_abandoned_pending_rows_older_than_a_week(): void {
$GLOBALS['wpdb'] = new class() {
public string $prefix = 'wp_';
public array $queries = array();
public function prepare( string $q, ...$args ): string { return vsprintf( str_replace( '%s', "'%s'", $q ), $args ); }
public function query( string $q ): int { $this->queries[] = $q; return 3; }
};
$before = time();
$n = Maintenance::purge_abandoned();
$sql = $GLOBALS['wpdb']->queries[0] ?? '';
$this->assertSame( 3, $n );
$this->assertStringStartsWith( 'DELETE FROM wp_sg_donations', $sql );
$this->assertStringContainsString( "status = 'pending'", $sql, 'completed donations must never be deleted' );
$this->assertStringContainsString( "paypal_capture_id IS NULL OR paypal_capture_id = ''", $sql, 'anything with a PayPal capture must be kept' );
$this->assertStringContainsString( 'goal_id > 0', $sql, 'test donations (goal_id 0) are handled separately and kept' );
$this->assertMatchesRegularExpression( "/created_at < '(\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2})'/", $sql );
preg_match( "/created_at < '([^']+)'/", $sql, $m );
$cutoff = strtotime( $m[1] . ' UTC' );
$this->assertEqualsWithDelta( $before - 7 * 86400, $cutoff, 5, 'cutoff must be 7 days ago' );
}
}