| Server IP : 62.109.13.187 / Your IP : 216.73.216.11 [ Web Server : Apache/2.4.6 (CentOS) mpm-itk/2.4.7-04 OpenSSL/1.0.2k-fips PHP/8.2.28 System : Linux robothost.ru 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : mosrembit ( 6064) PHP Version : 8.2.28 Disable Function : NONE Domains : 0 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/phpMyAdmin/test/selenium/ |
Upload File : |
<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* Selenium TestCase for table related tests
*
* @package PhpMyAdmin-test
* @subpackage Selenium
*/
require_once 'TestBase.php';
/**
* PmaSeleniumTableCreateTest class
*
* @package PhpMyAdmin-test
* @subpackage Selenium
* @group selenium
*/
class PMA_SeleniumTableCreateTest extends PMA_SeleniumBase
{
/**
* Creates a table
*
* @return void
*
* @group large
*/
public function testCreateTable()
{
$this->login();
$this->waitForElement('byLinkText', $this->database_name)->click();
$this->waitForElement('byId', 'create_table_form_minimal');
$this->byCssSelector(
"form#create_table_form_minimal input[name=table]"
)->value("test_table");
$this->byName("num_fields")->value("4");
$this->byCssSelector('input[value=Go]')->click();
$this->waitForElement('byName', 'do_save_data');
// column details
$column_text_details = array(
"field_0_1" => "test_id",
"field_0_3" => "14",
"field_0_10" => "comm1",
"field_1_1" => "test_column",
"field_1_3" => "10",
"field_1_10" => "comm2",
);
foreach ($column_text_details as $field => $val) {
$this->byId($field)->value($val);
}
$column_dropdown_details = array(
"field_0_6" => "UNSIGNED",
"field_0_8" => "PRIMARY",
"field_1_2" => "VARCHAR",
"field_1_5" => "utf8_general_ci",
"field_1_4" => "As defined:"
);
foreach ($column_dropdown_details as $selector => $value) {
$sel = $this->select($this->byId($selector));
$sel->selectOptionByLabel($value);
}
$this->byName("field_default_value[1]")->value("def");
$this->byId("field_0_9")->click(); // auto increment
$this->byId("field_1_7")->click(); // null
// post
$this->byName("do_save_data")->click();
$this->waitForElement("byLinkText", "test_table");
$this->_tableStructureAssertions();
}
/**
* Make assertions for table structure
*
* @return void
*/
private function _tableStructureAssertions()
{
// go to structure page
$this->byLinkText("Structure")->click();
$this->waitForElement("byId", "tablestructure");
// make assertions for first row
$this->assertContains(
"test_id",
$this->byCssSelector('label[for=checkbox_row_1]')->text()
);
$this->assertEquals(
"int(14)",
$this->getCellByTableId('tablestructure', 1, 4)
);
$this->assertEquals(
"UNSIGNED",
$this->getCellByTableId('tablestructure', 1, 6)
);
$this->assertEquals(
"No",
$this->getCellByTableId('tablestructure', 1, 7)
);
$this->assertEquals(
"None",
$this->getCellByTableId('tablestructure', 1, 8)
);
$this->assertEquals(
"AUTO_INCREMENT",
$this->getCellByTableId('tablestructure', 1, 9)
);
$this->assertFalse(
$this->isElementPresent(
'byCssSelector',
'table#tablestructure tbody tr:nth-child(1) "
. "ul.table-structure-actions li.primary a'
)
);
// make assertions for second row
$this->assertContains(
"test_column",
$this->byCssSelector('label[for=checkbox_row_2]')->text()
);
$this->assertEquals(
"varchar(10)",
$this->getCellByTableId('tablestructure', 2, 4)
);
$this->assertEquals(
"utf8_general_ci",
$this->getCellByTableId('tablestructure', 2, 5)
);
$this->assertEquals(
"Yes",
$this->getCellByTableId('tablestructure', 2, 7)
);
$this->assertEquals(
"def",
$this->getCellByTableId('tablestructure', 2, 8)
);
$this->assertFalse(
$this->isElementPresent(
'byCssSelector',
'css=ul.table-structure-actions:nth-child(2) li.primary a'
)
);
}
}