phpmyadmin/test/classes/Query/GeneratorTest.php

<?php

declare(strict_types=1);

namespace PhpMyAdmin\Tests\Query;

use PhpMyAdmin\Query\Generator;
use PhpMyAdmin\Tests\AbstractTestCase;
use PHPUnit\Framework\Attributes\CoversClass;

/**
 * @covers \PhpMyAdmin\Query\Generator
 */
#[CoversClass(Generator::class)]
class GeneratorTest extends AbstractTestCase
{
    public function testGetColumnsSql(): void
    {
        self::assertSame(
            'SHOW  COLUMNS FROM `mydb`.`mytable`',
            Generator::getColumnsSql('mydb', 'mytable')
        );
        self::assertSame(
            'SHOW  COLUMNS FROM `mydb`.`mytable` LIKE \'_idcolumn\'',
            Generator::getColumnsSql('mydb', 'mytable', '_idcolumn')
        );
        self::assertSame(
            'SHOW FULL COLUMNS FROM `mydb`.`mytable`',
            Generator::getColumnsSql('mydb', 'mytable', null, true)
        );
        self::assertSame(
            'SHOW FULL COLUMNS FROM `mydb`.`mytable` LIKE \'_idcolumn\'',
            Generator::getColumnsSql('mydb', 'mytable', '_idcolumn', true)
        );
    }

    public function testGetTableIndexesSql(): void
    {
        self::assertSame(
            'SHOW INDEXES FROM `mydb`.`mytable`',
            Generator::getTableIndexesSql('mydb', 'mytable')
        );
        self::assertSame(
            'SHOW INDEXES FROM `mydb`.`mytable` WHERE (1)',
            Generator::getTableIndexesSql('mydb', 'mytable', '1')
        );
    }

    public function testGetSqlQueryForIndexRename(): void
    {
        self::assertSame(
            'ALTER TABLE `mydb`.`mytable` RENAME INDEX `oldIndexName` TO `newIndexName`;',
            Generator::getSqlQueryForIndexRename('mydb', 'mytable', 'oldIndexName', 'newIndexName')
        );
    }

    public function testGetQueryForReorderingTable(): void
    {
        self::assertSame(
            'ALTER TABLE `mytable` ORDER BY `myOrderField` ASC;',
            Generator::getQueryForReorderingTable('mytable', 'myOrderField', '')
        );
        self::assertSame(
            'ALTER TABLE `mytable` ORDER BY `myOrderField` ASC;',
            Generator::getQueryForReorderingTable('mytable', 'myOrderField', 'S')
        );
        self::assertSame(
            'ALTER TABLE `mytable` ORDER BY `myOrderField` ASC;',
            Generator::getQueryForReorderingTable('mytable', 'myOrderField', 'DESC')
        );
        self::assertSame(
            'ALTER TABLE `mytable` ORDER BY `myOrderField` DESC;',
            Generator::getQueryForReorderingTable('mytable', 'myOrderField', 'desc')
        );
        self::assertSame(
            'ALTER TABLE `mytable` ORDER BY `myOrderField` ASC;',
            Generator::getQueryForReorderingTable('mytable', 'myOrderField', null)
        );
    }

    public function testGetQueryForPartitioningTable(): void
    {
        self::assertSame(
            'ALTER TABLE `mytable`  PARTITION ;',
            Generator::getQueryForPartitioningTable('mytable', '', [])
        );
        self::assertSame(
            'ALTER TABLE `mytable`  PARTITION p1;',
            Generator::getQueryForPartitioningTable('mytable', '', ['p1'])
        );
        self::assertSame(
            'ALTER TABLE `mytable`  PARTITION p1, p2;',
            Generator::getQueryForPartitioningTable('mytable', '', ['p1', 'p2'])
        );
        self::assertSame(
            'ALTER TABLE `mytable` COALESCE PARTITION 2',
            Generator::getQueryForPartitioningTable('mytable', 'COALESCE', ['p1', 'p2'])
        );
    }
}