Viewing file:  PmaSeleniumDbOperationsTest.php (3.21 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?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';
/**
* PmaSeleniumDbOperationsTest class
*
* @package PhpMyAdmin-test
* @subpackage Selenium
* @group selenium
*/
class PMA_SeleniumDbOperationsTest extends PMA_SeleniumBase
{
/**
* setUp function that can use the selenium session (called before each test)
*
* @return void
*/
public function setUpPage()
{
$this->login();
$this->waitForElement('byLinkText', $this->database_name)->click();
$this->waitForElement("byLinkText", "Structure");
$this->expandMore();
$this->waitForElement("byLinkText", "Operations")->click();
$this->waitForElement(
"byXPath", "//legend[contains(., 'Rename database to:')]"
);
}
/**
* Test for adding database comment
*
* @return void
*
* @group large
*/
public function testDbComment()
{
$this->skipIfNotPMADB();
$this->byName("comment")->value("comment_foobar");
$this->byCssSelector(
"form#formDatabaseComment input[type='submit']"
)->click();
$this->assertNotNull(
$this->waitForElement(
"byXPath",
"//span[@id='span_table_comment' and contains(., 'comment_foobar')]"
)
);
}
/**
* Test for renaming database
*
* @return void
*
* @group large
*/
public function testRenameDB()
{
$new_db_name = $this->database_name . 'rename';
$this->byCssSelector("form#rename_db_form input[name=newname]")
->value($new_db_name);
$this->byCssSelector("form#rename_db_form input[type='submit']")->click();
$this->waitForElement(
"byXPath", "//button[contains(., 'OK')]"
)->click();
$this->waitForElement(
"byXPath",
"//a[@class='item' and contains(., 'Database: $new_db_name')]"
);
$result = $this->dbQuery(
"SHOW DATABASES LIKE '$new_db_name';"
);
$this->assertEquals(1, $result->num_rows);
$result = $this->dbQuery(
"SHOW DATABASES LIKE '" . $this->database_name . "';"
);
$this->assertEquals(0, $result->num_rows);
$this->database_name = $new_db_name;
}
/**
* Test for copying database
*
* @return void
*
* @group large
*/
public function testCopyDb()
{
$new_db_name = $this->database_name . 'copy';
$this->byCssSelector("form#copy_db_form input[name=newname]")
->value($new_db_name);
$this->byCssSelector("form#copy_db_form input[type='submit']")->click();
$this->waitForElement(
"byXPath",
"//div[@class='success' and contains(., 'Database "
. $this->database_name
. " has been copied to $new_db_name')]"
);
$result = $this->dbQuery(
"SHOW DATABASES LIKE '$new_db_name';"
);
$this->assertEquals(1, $result->num_rows);
$this->dbQuery("DROP DATABASE $new_db_name");
}
}
|