admin_api/tests/Unit/WorldCupOddsSqlSeedTest.php

<?php

namespace Tests\Unit;

use PHPUnit\Framework\TestCase;

class WorldCupOddsSqlSeedTest extends TestCase
{
    public function testWinnerOddsUseDraftKingsDecimal(): void
    {
        $sql = $this->worldCupSql();

        $this->assertContains("(NULL, 'winner', 'Brazil', 10.00", $sql);
        $this->assertContains("(NULL, 'winner', 'Argentina', 10.50", $sql);
        $this->assertContains("(NULL, 'winner', 'France', 5.80", $sql);
        $this->assertNotContains("(NULL, 'winner', 'Brazil', 9.50", $sql);
        $this->assertNotContains("(NULL, 'winner', 'Argentina', 10.17", $sql);
    }

    public function testPostedRoundOneMatchOddsAreSeededByExistingMatchId(): void
    {
        $sql = $this->worldCupSql();

        $this->assertContains("(1, '1x2', 'home', 1.40", $sql);
        $this->assertContains("(1, '1x2', 'draw', 4.60", $sql);
        $this->assertContains("(1, '1x2', 'away', 8.00", $sql);
        $this->assertContains("(7, '1x2', 'home', 2.05", $sql);
        $this->assertContains("(7, '1x2', 'away', 3.90", $sql);
    }

    public function testOddsSeedUsesMergeForRepeatableDeploys(): void
    {
        $sql = $this->worldCupSql();

        $this->assertContains('MERGE agent.dbo.world_cup_odds AS target', $sql);
        $this->assertContains('WHEN MATCHED THEN', $sql);
        $this->assertContains('WHEN NOT MATCHED THEN', $sql);
    }

    private function worldCupSql(): string
    {
        return file_get_contents(__DIR__ . '/../../database/world_cup_activity.sql');
    }
}