packages/ztd-query-mysqli-adapter/tests/Integration/MysqliFullTextSearchTest.php

1<?php
2
3declare(strict_types=1);
4
5namespace Tests\Integration;
6
7use Container\Endpoint;
8use Container\MySqlRelease;
9use mysqli;
10use mysqli_result;
11use PHPUnit\Framework\Attributes\Large;
12use PHPUnit\Framework\TestCase;
13use Testcontainers\Testcontainers;
14use ZtdQuery\Adapter\Mysqli\ZtdMysqli;
15
16#[\PHPUnit\Framework\Attributes\CoversClass(ZtdMysqli::class)]
17#[\PHPUnit\Framework\Attributes\CoversClass(\ZtdQuery\Adapter\Mysqli\Session\ConnectionExecution::class)]
18#[\PHPUnit\Framework\Attributes\CoversClass(\ZtdQuery\Adapter\Mysqli\ZtdMysqliStatement::class)]
19#[\PHPUnit\Framework\Attributes\CoversClass(\ZtdQuery\Adapter\Mysqli\Session\StatementExecution::class)]
20#[\PHPUnit\Framework\Attributes\CoversClass(\ZtdQuery\Adapter\Mysqli\Driver\MysqliConnection::class)]
21#[\PHPUnit\Framework\Attributes\CoversClass(\ZtdQuery\Adapter\Mysqli\Driver\MysqliResultStatement::class)]
22#[\PHPUnit\Framework\Attributes\CoversClass(\ZtdQuery\Adapter\Mysqli\Driver\MysqliResultColumnExtractor::class)]
23#[\PHPUnit\Framework\Attributes\CoversClass(\ZtdQuery\Adapter\Mysqli\Native\MysqliStatementBindingBridge::class)]
24#[\PHPUnit\Framework\Attributes\CoversClass(\ZtdQuery\Adapter\Mysqli\ZtdMysqliException::class)]
25#[\PHPUnit\Framework\Attributes\CoversClass(\ZtdQuery\Adapter\Mysqli\Native\MysqliPropertyReader::class)]
26#[\PHPUnit\Framework\Attributes\CoversClass(\ZtdQuery\Adapter\Mysqli\Session\MysqliResultProcessor::class)]
27#[Large]
28final class MysqliFullTextSearchTest extends TestCase
29{
30    public function testMatchAgainstReadsOnlyShadowRows(): void
31    {
32        $container = Testcontainers::run(MySqlRelease::fromEnvironment());
33        $endpoint = $container->getData(Endpoint::class);
34        try {
35            $rawMysqli = new mysqli($endpoint->host, $endpoint->username, $endpoint->password, $endpoint->database, $endpoint->port);
36            $rawMysqli->set_charset('utf8mb4');
37
38            $rawMysqli->query(
39                'CREATE TABLE articles (id INT PRIMARY KEY, title VARCHAR(255), body TEXT, '
40                . 'FULLTEXT KEY article_search (title, body)) ENGINE=InnoDB',
41            );
42            $ztdMysqli = ZtdMysqli::fromMysqli($rawMysqli);
43            self::assertNotFalse($ztdMysqli->query(
44                "INSERT INTO articles VALUES (1, 'Search guide', 'exact search terms'), "
45                . "(2, 'Other', 'unrelated')",
46            ));
47
48            $result = $ztdMysqli->query(
49                "SELECT id FROM articles WHERE MATCH(title, body) AGAINST ('search terms')",
50            );
51            self::assertInstanceOf(mysqli_result::class, $result);
52            self::assertSame([['id' => 1]], $result->fetch_all(MYSQLI_ASSOC));
53
54            $physical = $rawMysqli->query('SELECT COUNT(*) AS aggregate FROM articles');
55            self::assertInstanceOf(mysqli_result::class, $physical);
56            self::assertSame([['aggregate' => '0']], $physical->fetch_all(MYSQLI_ASSOC));
57        } finally {
58            $container->stop();
59        }
60    }
61}
62