/
home
/
obinna
/
html
/
stage
/
phpmyadmin
/
tests
/
unit
/
Upload File
HOME
<?php declare(strict_types=1); namespace PhpMyAdmin\Tests; use PhpMyAdmin\Index; use PHPUnit\Framework\Attributes\CoversClass; #[CoversClass(Index::class)] class IndexTest extends AbstractTestCase { /** @var mixed[] */ private array $params = []; /** * Configures parameters. */ protected function setUp(): void { parent::setUp(); $this->params['Schema'] = 'PMA_Schema'; $this->params['Table'] = 'PMA_Table'; $this->params['Key_name'] = 'PMA_Key_name'; $this->params['Index_choice'] = 'PMA_Index_choice'; $this->params['Comment'] = 'PMA_Comment'; $this->params['Index_comment'] = 'PMA_Index_comment'; $this->params['Non_unique'] = 'PMA_Non_unique'; $this->params['Packed'] = 'PMA_Packed'; //test add columns $column1 = [ 'Column_name' => 'column1', 'Seq_in_index' => '1', 'Collation' => 'Collation1', 'Cardinality' => '1', 'Null' => 'null1', ]; $column2 = [ 'Column_name' => 'column2', 'Seq_in_index' => '2', 'Collation' => 'Collation2', 'Cardinality' => '2', 'Null' => 'null2', ]; $column3 = [ 'Column_name' => 'column3', 'Seq_in_index' => '3', 'Collation' => 'Collation3', 'Cardinality' => '3', 'Null' => 'null3', ]; $this->params['columns'][] = $column1; $this->params['columns'][] = $column2; $this->params['columns'][] = $column3; } /** * Test for Constructor */ public function testConstructor(): void { $index = new Index($this->params); self::assertSame( 'PMA_Index_comment', $index->getComment(), ); self::assertSame( 'PMA_Comment', $index->getRemarks(), ); self::assertSame( 'PMA_Index_choice', $index->getChoice(), ); self::assertSame( 'PMA_Packed', $index->getPacked(), ); self::assertEquals( 'PMA_Non_unique', $index->getNonUnique(), ); self::assertStringContainsString( 'PMA_Comment', $index->getComments(), ); self::assertStringContainsString( 'PMA_Index_comment', $index->getComments(), ); self::assertSame( 'PMA_Index_choice', $index->getChoice(), ); } /** * Test for isUnique */ public function testIsUniquer(): void { $this->params['Non_unique'] = '0'; $index = new Index($this->params); self::assertTrue( $index->isUnique(), ); self::assertSame( 'Yes', $index->isUnique(true), ); } /** * Test for add Columns */ public function testAddColumns(): void { $index = new Index(); $index->addColumns($this->params['columns']); self::assertTrue($index->hasColumn('column1')); self::assertTrue($index->hasColumn('column2')); self::assertTrue($index->hasColumn('column3')); self::assertSame( 3, $index->getColumnCount(), ); } /** * Test for get Name & set Name */ public function testName(): void { $index = new Index(); $index->setName('PMA_name'); self::assertSame( 'PMA_name', $index->getName(), ); } public function testColumns(): void { $index = new Index(); $index->addColumns($this->params['columns']); $indexColumns = $index->getColumns(); $indexColumn = $indexColumns['column1']; self::assertSame( 'column1', $indexColumn->getName(), ); self::assertEquals( '1', $indexColumn->getSeqInIndex(), ); self::assertSame( 'Collation1', $indexColumn->getCollation(), ); self::assertEquals( '1', $indexColumn->getCardinality(), ); } }