phpmyadmin/tests/unit/Utils/ForeignKeyTest.php

<?php

declare(strict_types=1);

namespace PhpMyAdmin\Tests\Utils;

use PhpMyAdmin\Config;
use PhpMyAdmin\Dbal\DatabaseInterface;
use PhpMyAdmin\Tests\AbstractTestCase;
use PhpMyAdmin\Utils\ForeignKey;
use PHPUnit\Framework\Attributes\CoversClass;
use PHPUnit\Framework\Attributes\DataProvider;

#[CoversClass(ForeignKey::class)]
class ForeignKeyTest extends AbstractTestCase
{
    protected function setUp(): void
    {
        parent::setUp();

        DatabaseInterface::$instance = $this->createDatabaseInterface();
    }

    /**
     * foreign key supported test
     *
     * @param string $a Engine
     * @param bool   $e Expected Value
     */
    #[DataProvider('providerIsSupported')]
    public function testIsSupported(string $a, bool $e): void
    {
        self::assertSame(
            $e,
            ForeignKey::isSupported($a),
        );
    }

    /**
     * data provider for foreign key supported test
     *
     * @return array<array{string, bool}>
     */
    public static function providerIsSupported(): array
    {
        return [['MyISAM', false], ['innodb', true], ['pBxT', true], ['ndb', true]];
    }

    public function testIsCheckEnabled(): void
    {
        $config = Config::getInstance();
        $config->set('DefaultForeignKeyChecks', 'enable');
        self::assertTrue(
            ForeignKey::isCheckEnabled(),
        );

        $config->set('DefaultForeignKeyChecks', 'disable');
        self::assertFalse(
            ForeignKey::isCheckEnabled(),
        );

        $config->set('DefaultForeignKeyChecks', 'default');
        self::assertTrue(
            ForeignKey::isCheckEnabled(),
        );
    }

    /** @return mixed[][] */
    public static function providerCheckInit(): array
    {
        return [['', 'OFF'], ['0', 'OFF'], ['1', 'ON']];
    }

    #[DataProvider('providerCheckInit')]
    public function testHandleDisableCheckInit(string $checksValue, string $setVariableParam): void
    {
        $dbi = $this->createMock(DatabaseInterface::class);
        DatabaseInterface::$instance = $dbi;

        $_REQUEST['fk_checks'] = $checksValue;

        $dbi->expects(self::once())
            ->method('getVariable')
            ->willReturn('ON');

        $dbi->expects(self::once())
            ->method('setVariable')
            ->with('FOREIGN_KEY_CHECKS', $setVariableParam);

        self::assertTrue(ForeignKey::handleDisableCheckInit());
    }

    #[DataProvider('providerCheckInit')]
    public function testHandleDisableCheckInitVarFalse(string $checksValue, string $setVariableParam): void
    {
        $dbi = $this->createMock(DatabaseInterface::class);
        DatabaseInterface::$instance = $dbi;

        $_REQUEST['fk_checks'] = $checksValue;

        $dbi->expects(self::once())
            ->method('getVariable')
            ->willReturn('OFF');

        $dbi->expects(self::once())
            ->method('setVariable')
            ->with('FOREIGN_KEY_CHECKS', $setVariableParam);

        self::assertFalse(ForeignKey::handleDisableCheckInit());
    }

    /** @return mixed[][] */
    public static function providerCheckCleanup(): array
    {
        return [[true, 'ON'], [false, 'OFF']];
    }

    #[DataProvider('providerCheckCleanup')]
    public function testHandleDisableCheckCleanup(bool $checkValue, string $setVariableParam): void
    {
        $dbi = $this->createMock(DatabaseInterface::class);
        DatabaseInterface::$instance = $dbi;

        $dbi->expects(self::once())
            ->method('setVariable')
            ->with('FOREIGN_KEY_CHECKS', $setVariableParam);

        ForeignKey::handleDisableCheckCleanup($checkValue);
    }
}