| Server IP : www.kowitt.ac.th / Your IP : 216.73.216.118 Web Server : Microsoft-IIS/7.5 System : Windows NT SERVER02 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586 User : IUSR ( 0) PHP Version : 5.6.31 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/inetpub/wwwroot/phpMyAdmin/test/classes/ |
Upload File : |
<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* Test for Index class
*
* @package PhpMyAdmin-test
*/
/*
* Include to test.
*/
require_once 'test/PMATestCase.php';
/**
* Test for Index class
*
* @package PhpMyAdmin-test
*/
class IndexTest extends PMATestCase
{
private $_params = array();
/**
* Configures parameters.
*
* @return void
*/
public function 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 = array("Column_name"=>"column1","Seq_in_index"=>"index1",
"Collation"=>"Collation1","Cardinality"=>"Cardinality1",
"Null"=>"null1"
);
$column2 = array("Column_name"=>"column2","Seq_in_index"=>"index2",
"Collation"=>"Collation2","Cardinality"=>"Cardinality2",
"Null"=>"null2"
);
$column3 = array("Column_name"=>"column3","Seq_in_index"=>"index3",
"Collation"=>"Collation3","Cardinality"=>"Cardinality3",
"Null"=>"null3"
);
$this->_params['columns'][] = $column1;
$this->_params['columns'][] = $column2;
$this->_params['columns'][] = $column3;
}
/**
* Test for Constructor
*
* @return void
*/
public function testConstructor()
{
$index = new PMA\libraries\Index($this->_params);
$this->assertEquals(
'PMA_Index_comment',
$index->getComment()
);
$this->assertEquals(
'PMA_Comment',
$index->getRemarks()
);
$this->assertEquals(
'PMA_Index_choice',
$index->getChoice()
);
$this->assertEquals(
'PMA_Packed',
$index->getPacked()
);
$this->assertEquals(
'PMA_Non_unique',
$index->getNonUnique()
);
$this->assertContains(
'PMA_Comment',
$index->getComments()
);
$this->assertContains(
'PMA_Index_comment',
$index->getComments()
);
$this->assertEquals(
'PMA_Index_choice',
$index->getChoice()
);
}
/**
* Test for getIndexChoices
*
* @return void
*/
public function testGetIndexChoices()
{
$index_choices = PMA\libraries\Index::getIndexChoices();
$this->assertEquals(
5,
count($index_choices)
);
$this->assertEquals(
'PRIMARY,INDEX,UNIQUE,SPATIAL,FULLTEXT',
implode(",", $index_choices)
);
}
/**
* Test for isUnique
*
* @return void
*/
public function testIsUniquer()
{
$this->_params['Non_unique'] = "0";
$index = new PMA\libraries\Index($this->_params);
$this->assertTrue(
$index->isUnique()
);
$this->assertEquals(
'Yes',
$index->isUnique(true)
);
}
/**
* Test for add Columns
*
* @return void
*/
public function testAddColumns()
{
$index = new PMA\libraries\Index();
$index->addColumns($this->_params['columns']);
$this->assertTrue($index->hasColumn("column1"));
$this->assertTrue($index->hasColumn("column2"));
$this->assertTrue($index->hasColumn("column3"));
$this->assertEquals(
3,
$index->getColumnCount()
);
}
/**
* Test for get Name & set Name
*
* @return void
*/
public function testName()
{
$index = new PMA\libraries\Index();
$index->setName('PMA_name');
$this->assertEquals(
'PMA_name',
$index->getName()
);
}
/**
* Test for PMA\libraries\Index_Column
*
* @return void
*/
public function testColumns()
{
$index = new PMA\libraries\Index();
$index->addColumns($this->_params['columns']);
$index_columns = $index->getColumns();
$index_column = $index_columns['column1'];
$this->assertEquals(
'column1',
$index_column->getName()
);
$this->assertEquals(
'index1',
$index_column->getSeqInIndex()
);
$this->assertEquals(
'Collation1',
$index_column->getCollation()
);
$this->assertEquals(
'Cardinality1',
$index_column->getCardinality()
);
}
}