phpmyadmin/tests/unit/DbTableExistsTest.php

<?php

declare(strict_types=1);

namespace PhpMyAdmin\Tests;

use PhpMyAdmin\Dbal\DatabaseInterface;
use PhpMyAdmin\DbTableExists;
use PhpMyAdmin\Identifiers\DatabaseName;
use PhpMyAdmin\Identifiers\TableName;
use PHPUnit\Framework\Attributes\CoversClass;

#[CoversClass(DbTableExists::class)]
final class DbTableExistsTest extends AbstractTestCase
{
    public function testHasDatabase(): void
    {
        $dbiDummy = $this->createDbiDummy();
        $dbiDummy->removeDefaultResults();
        $dbiDummy->addSelectDb('test_db');
        $dbi = $this->createDatabaseInterface($dbiDummy);
        $dbTableExists = new DbTableExists($dbi);
        self::assertTrue($dbTableExists->selectDatabase(DatabaseName::from('test_db')));
        $dbiDummy->assertAllSelectsConsumed();
    }

    public function testHasDatabaseWithNoDatabase(): void
    {
        $db = DatabaseName::from('test_db');
        $dbi = $this->createMock(DatabaseInterface::class);
        $dbi->expects(self::once())->method('selectDb')->with($db)->willReturn(false);
        $dbTableExists = new DbTableExists($dbi);
        self::assertFalse($dbTableExists->selectDatabase($db));
    }

    public function testHasTable(): void
    {
        $dbiDummy = $this->createDbiDummy();
        $dbiDummy->removeDefaultResults();
        $dbiDummy->addResult('SELECT 1 FROM `test_db`.`test_table` LIMIT 1;', [['1']], ['1']);
        $dbi = $this->createDatabaseInterface($dbiDummy);
        $dbTableExists = new DbTableExists($dbi);
        self::assertTrue($dbTableExists->hasTable(DatabaseName::from('test_db'), TableName::from('test_table')));
        // cached result
        self::assertTrue($dbTableExists->hasTable(DatabaseName::from('test_db'), TableName::from('test_table')));
        $dbiDummy->assertAllQueriesConsumed();
    }

    public function testHasTableWithTempTable(): void
    {
        $dbiDummy = $this->createDbiDummy();
        $dbiDummy->removeDefaultResults();
        $dbiDummy->addResult('SELECT 1 FROM `test_db`.`test_table` LIMIT 1;', [['1']], ['1']);
        $dbi = $this->createDatabaseInterface($dbiDummy);
        $dbTableExists = new DbTableExists($dbi);
        self::assertTrue($dbTableExists->hasTable(DatabaseName::from('test_db'), TableName::from('test_table')));
        // cached result
        self::assertTrue($dbTableExists->hasTable(DatabaseName::from('test_db'), TableName::from('test_table')));
        $dbiDummy->assertAllQueriesConsumed();
    }

    public function testHasTableWithNoTable(): void
    {
        $dbiDummy = $this->createDbiDummy();
        $dbiDummy->removeDefaultResults();
        $dbiDummy->addResult('SELECT 1 FROM `test_db`.`test_table` LIMIT 1;', false);
        $dbi = $this->createDatabaseInterface($dbiDummy);
        $dbTableExists = new DbTableExists($dbi);
        self::assertFalse($dbTableExists->hasTable(DatabaseName::from('test_db'), TableName::from('test_table')));
        $dbiDummy->assertAllQueriesConsumed();
    }
}