Viewing file:  PmaSeleniumDbEventsTest.php (5.45 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';
/**
* PmaSeleniumDbEventsTest class
*
* @package PhpMyAdmin-test
* @subpackage Selenium
* @group selenium
*/
class PMA_SeleniumDbEventsTest extends PMA_SeleniumBase
{
/**
* Setup the browser environment to run the selenium test case
*
* @return void
*/
public function setUp()
{
parent::setUp();
$this->dbQuery(
"CREATE TABLE `test_table` ("
. " `id` int(11) NOT NULL AUTO_INCREMENT,"
. " `val` int(11) NOT NULL,"
. " PRIMARY KEY (`id`)"
. ")"
);
$this->dbQuery(
"INSERT INTO `test_table` (val) VALUES (2);"
);
}
/**
* 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(
"byXPath", "//a[contains(., 'test_table')]"
);
$this->expandMore();
}
/**
* Creates procedure for tests
*
* @return void
*/
private function _eventSQL()
{
$start = date('Y-m-d H:i:s', strtotime('-1 day'));
$end = date('Y-m-d H:i:s', strtotime('+1 day'));
$this->dbQuery(
"CREATE EVENT `test_event` ON SCHEDULE EVERY 2 MINUTE_SECOND STARTS "
. "'$start' ENDS '$end' ON COMPLETION NOT PRESERVE ENABLE "
. "DO UPDATE `" . $this->database_name
. "`.`test_table` SET val = val + 1"
);
}
/**
* Create an event
*
* @return void
*
* @group large
*/
public function testAddEvent()
{
$ele = $this->waitForElement("byPartialLinkText", "Events");
$ele->click();
$ele = $this->waitForElement("byLinkText", "Add event");
$ele->click();
$this->waitForElement("byClassName", "rte_form");
$this->byName("item_name")->value("test_event");
$this->select($this->byName("item_type"))
->selectOptionByLabel("RECURRING");
$this->byName("item_interval_value")->value("1");
$this->select($this->byName("item_interval_field"))
->selectOptionByLabel("MINUTE_SECOND");
$this->byName("item_starts")
->value(date('Y-m-d H:i:s', strtotime('-1 day')));
$this->byName("item_ends")
->value(date('Y-m-d H:i:s', strtotime('+1 day')));
$proc = "UPDATE " . $this->database_name . ".`test_table` SET val=val+1";
$this->typeInTextArea($proc);
$this->byXPath("//button[contains(., 'Go')]")->click();
$ele = $this->waitForElement(
"byXPath",
"//div[@class='success' and contains(., "
. "'Event `test_event` has been created')]"
);
$this->assertTrue(
$this->isElementPresent(
'byXPath',
"//td[contains(., 'test_event')]"
)
);
$result = $this->dbQuery(
"SHOW EVENTS WHERE Db='" . $this->database_name
. "' AND Name='test_event'"
);
$this->assertEquals(1, $result->num_rows);
usleep(2200000);
$result = $this->dbQuery(
"SELECT val FROM `" . $this->database_name . "`.`test_table`"
);
$row = $result->fetch_assoc();
$this->assertGreaterThan(2, $row['val']);
}
/**
* Test for editing events
*
* @return void
*
* @group large
*/
public function testEditEvents()
{
$this->_eventSQL();
$ele = $this->waitForElement("byPartialLinkText", "Events");
$ele->click();
$this->waitForElement(
"byXPath",
"//legend[contains(., 'Events')]"
);
$this->byLinkText("Edit")->click();
$this->waitForElement("byClassName", "rte_form");
$this->byName("item_interval_value")->clear();
$this->byName("item_interval_value")->value("1");
$this->typeInTextArea("00");
$this->byXPath("//button[contains(., 'Go')]")->click();
$ele = $this->waitForElement(
"byXPath",
"//div[@class='success' and contains(., "
. "'Event `test_event` has been modified')]"
);
usleep(2000000);
$result = $this->dbQuery(
"SELECT val FROM `" . $this->database_name . "`.`test_table`"
);
$row = $result->fetch_assoc();
$this->assertGreaterThan(100, $row['val']);
}
/**
* Test for dropping event
*
* @return void
*
* @group large
*/
public function testDropEvent()
{
$this->_eventSQL();
$this->waitForElement("byPartialLinkText", "Events")->click();
$this->waitForElement(
"byXPath",
"//legend[contains(., 'Events')]"
);
$this->byLinkText("Drop")->click();
$this->waitForElement(
"byXPath", "//button[contains(., 'OK')]"
)->click();
$this->waitForElement("byId", "nothing2display");
usleep(1000000);
$result = $this->dbQuery(
"SHOW EVENTS WHERE Db='" . $this->database_name
. "' AND Name='test_event'"
);
$this->assertEquals(0, $result->num_rows);
}
}
|