packages/sql-parser/tests/Unit/Sqlite/Lexer/NumberScannerTest.php

1<?php
2
3declare(strict_types=1);
4
5namespace Tests\Unit\Sqlite\Lexer;
6
7use PHPUnit\Framework\Attributes\CoversClass;
8use PHPUnit\Framework\Attributes\Small;
9use PHPUnit\Framework\Attributes\UsesClass;
10use PHPUnit\Framework\TestCase;
11use SqlParser\Lexer\Cursor;
12use SqlParser\Lexer\Lexeme;
13use SqlParser\Lexer\LexicalException;
14use SqlParser\Sqlite\Lexer\KeywordTable;
15use SqlParser\Sqlite\Lexer\NumberScanner;
16use SqlParser\Sqlite\Lexer\Scan;
17
18#[CoversClass(NumberScanner::class)]
19#[UsesClass(Cursor::class)]
20#[UsesClass(Lexeme::class)]
21#[UsesClass(LexicalException::class)]
22#[UsesClass(KeywordTable::class)]
23#[UsesClass(Scan::class)]
24#[UsesClass(\SqlParser\Lexer\SourcePosition::class)]
25#[UsesClass(\SqlParser\Lexer\SourceException::class)]
26#[Small]
27final class NumberScannerTest extends TestCase
28{
29    public function testScan(): void
30    {
31        $scanner = new NumberScanner();
32        $scan = static fn (string $sql): Scan => new Scan(new Cursor($sql), new KeywordTable([]));
33
34        self::assertSame('INTEGER', $scanner->scan($scan('42 '))?->name);
35        self::assertSame('INTEGER', $scanner->scan($scan('0x1F'))?->name);
36        self::assertSame('QNUMBER', $scanner->scan($scan('1_000'))?->name);
37        self::assertSame('QNUMBER', $scanner->scan($scan('0xF_F'))?->name);
38        self::assertSame('FLOAT', $scanner->scan($scan('1.5'))?->name);
39        self::assertSame('FLOAT', $scanner->scan($scan('.5'))?->name);
40        self::assertSame('FLOAT', $scanner->scan($scan('1e5'))?->name);
41        self::assertSame('1.', $scanner->scan($scan('1. '))?->text);
42        self::assertNull($scanner->scan($scan('.')));
43        self::assertNull($scanner->scan($scan('abc')));
44    }
45
46    public function testScanRejectsTrailingJunk(): void
47    {
48        $this->expectException(LexicalException::class);
49
50        (new NumberScanner())->scan(new Scan(new Cursor('12ab'), new KeywordTable([])));
51    }
52}
53