/**
* Goes to SQL tab, executes queries, returns to tracking page
*
* @return void
*/
private function _executeSqlAndReturnToTableTracking()
{
$this->byLinkText("SQL")->click();
$this->_helper->waitForElement("byId", "queryfieldscontainer");
$this->_helper->typeInTextArea(
";UPDATE test_table SET val = val + 1; "
. "DELETE FROM test_table WHERE val = 3"
);
$this->byCssSelector("input[value='Go']")->click();
$this->_helper->waitForElement("byClassName", "success");
$ele = $this->byLinkText("More");
$this->moveto($ele);
$this->byLinkText("Tracking")->click();
$this->_helper->waitForElement("byId", "versions");
}
/**
* Function that goes to the import page, uploads a file and submit form
*
* @param string $type level: server, db or import
* @param string $plugin format: csv, json, etc
*
* @return string export string
*/
private function _doExport($type, $plugin)
{
$this->byLinkText("Export")->click();
$this->_helper->waitForElement("byName", "dump");
$this->byCssSelector("label[for=radio_custom_export]")->click();
if ($type == 'server') {
$this->byLinkText('Unselect All')->click();
$this->byCssSelector("option[value=" . $this->_dbname . "]")->click();
}
if ($type == 'table') {
$this->byCssSelector("label[for=radio_allrows_0]")->click();
$this->byName("limit_to")->clear();
$this->byName("limit_to")->value("1");
}
$this->select($this->byId("plugins"))->selectOptionByLabel($plugin);
$this->byCssSelector("label[for=radio_view_as_text]")->click();
if ($plugin == "SQL") {
$this->byCssSelector(
"label[for=radio_sql_structure_or_data_structure_and_data]"
)->click();
if ($type != "table") {
$this->byCssSelector(
"label[for=checkbox_sql_create_database]"
)->click();
}
}
$this->byId("buttonGo")->click();
$text = $this->_helper->waitForElement("byId", "textSQLDUMP")->text();
return $text;
}
