packages/sql-faker/tests/Unit/Sqlite/Generation/Rewrite/IdentifierListRuleTest.php

1<?php
2
3declare(strict_types=1);
4
5namespace Tests\Unit\SqlFaker\Sqlite\Generation\Rewrite;
6
7use PHPUnit\Framework\Attributes\CoversClass;
8use PHPUnit\Framework\Attributes\UsesClass;
9use PHPUnit\Framework\TestCase;
10use SqlFaker\Generation\Derivation\DerivationTrace;
11use SqlFaker\Grammar\Model\NonTerminal;
12use SqlFaker\Grammar\Model\Production;
13use SqlFaker\Grammar\Model\Terminal;
14use SqlFaker\Sqlite\Generation\Rewrite\IdentifierListRule;
15
16#[CoversClass(IdentifierListRule::class)]
17#[UsesClass(DerivationTrace::class)]
18#[UsesClass(NonTerminal::class)]
19#[UsesClass(Production::class)]
20#[UsesClass(Terminal::class)]
21#[UsesClass(\SqlFaker\Generation\Token\ProductionOccurrence::class)]
22#[UsesClass(\SqlFaker\Generation\Token\TerminalOccurrence::class)]
23#[UsesClass(\SqlFaker\Generation\Token\TerminalSequence::class)]
24final class IdentifierListRuleTest extends TestCase
25{
26    public function testRewriteRemovesLegacyIdentifierSuffixesAndKeepsOrderBy(): void
27    {
28        $trace = new DerivationTrace('root');
29        $trace->expand(0, new Production([new NonTerminal('eidlist'), new NonTerminal('orderby')]), 0);
30        $trace->expand(0, new Production([new Terminal('ID'), new NonTerminal('collate'), new NonTerminal('sortorder')]), 0);
31        $trace->expand(1, new Production([new Terminal('COLLATE'), new Terminal('ID')]), 1);
32        $trace->expand(3, new Production([new Terminal('DESC')]), 1);
33        $trace->expand(4, new Production([new Terminal('ID'), new NonTerminal('sortorder')]), 0);
34        $trace->expand(5, new Production([new Terminal('DESC')]), 1);
35        $input = $trace->terminals();
36        $result = (new IdentifierListRule())->rewrite($input);
37        self::assertSame(['ID', 'ID', 'DESC'], $result->names());
38        self::assertSame($input->original, $result->original);
39        self::assertCount(count($result->terminals), array_unique(array_map(static fn ($terminal): int => $terminal->id, $result->terminals)));
40        self::assertSame($input->terminals[5], $result->terminals[2]);
41    }
42}
43