test/selenium/PmaSeleniumDbProceduresTest.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Selenium TestCase for table related tests
   5  *
   6  * @package    PhpMyAdmin-test
   7  * @subpackage Selenium
   8  */
   9
  10 require_once 'TestBase.php';
  11
  12 /**
  13  * PmaSeleniumDbProceduresTest class
  14  *
  15  * @package    PhpMyAdmin-test
  16  * @subpackage Selenium
  17  * @group      selenium
  18  */
  19 class PMA_SeleniumDbProceduresTest extends PMA_SeleniumBase
  20 {
  21     /**
  22      * Setup the browser environment to run the selenium test case
  23      *
  24      * @return void
  25      */
  26     public function setUp()
  27     {
  28         parent::setUp();
  29         $this->dbQuery(
  30             "CREATE TABLE `test_table` ("
  31             . " `id` int(11) NOT NULL AUTO_INCREMENT,"
  32             . " `name` varchar(20) NOT NULL,"
  33             . " `datetimefield` datetime NOT NULL,"
  34             . " PRIMARY KEY (`id`)"
  35             . ")"
  36         );
  37
  38     }
  39
  40     /**
  41      * setUp function that can use the selenium session (called before each test)
  42      *
  43      * @return void
  44      */
  45     public function setUpPage()
  46     {
  47         $this->login();
  48         $this->waitForElement('byLinkText', $this->database_name)->click();
  49         $this->waitForElement(
  50             "byXPath", "//a[contains(., 'test_table')]"
  51         );
  52         $this->expandMore();
  53     }
  54
  55     /**
  56      * Creates procedure for tests
  57      *
  58      * @return void
  59      */
  60     private function _procedureSQL()
  61     {
  62         $this->dbQuery(
  63             "CREATE PROCEDURE `test_procedure`(IN `inp` VARCHAR(10), OUT `outp` INT)"
  64             . " NOT DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER SELECT char_"
  65             . "length(inp) + count(*) FROM test_table INTO outp"
  66         );
  67     }
  68
  69     /**
  70      * Create a procedure
  71      *
  72      * @return void
  73      *
  74      * @group large
  75      */
  76     public function testAddProcedure()
  77     {
  78         $ele = $this->waitForElement("byPartialLinkText", "Routines");
  79         $ele->click();
  80
  81         $ele = $this->waitForElement("byLinkText", "Add routine");
  82         $ele->click();
  83
  84         $this->waitForElement("byClassName", "rte_form");
  85
  86         $this->byName("item_name")->value("test_procedure");
  87
  88         $this->byName("item_param_name[0]")->value("inp");
  89         $this->select(
  90             $this->byName("item_param_type[0]")
  91         )->selectOptionByLabel("VARCHAR");
  92         $this->byName("item_param_length[0]")->value("10");
  93
  94         $this->byCssSelector("input[value='Add parameter']")->click();
  95
  96         $this->select(
  97             $this->byName("item_param_dir[1]")
  98         )->selectOptionByLabel("OUT");
  99         $ele = $this->waitForElement("byName", "item_param_name[1]");
 100         $ele->value("outp");
 101
 102         $proc = "SELECT char_length(inp) + count(*) FROM test_table INTO outp";
 103         $this->typeInTextArea($proc);
 104
 105         $this->select(
 106             $this->byName("item_sqldataaccess")
 107         )->selectOptionByLabel("READS SQL DATA");
 108
 109         $this->byXPath("//button[contains(., 'Go')]")->click();
 110
 111         $ele = $this->waitForElement(
 112             "byXPath",
 113             "//div[@class='success' and contains(., "
 114             . "'Routine `test_procedure` has been created')]"
 115         );
 116
 117         $result = $this->dbQuery(
 118             "SHOW PROCEDURE STATUS WHERE Db='" . $this->database_name . "'"
 119         );
 120
 121         $this->assertEquals(1, $result->num_rows);
 122         $this->_executeProcedure("abcabcabcabcabcabcabc", 10);
 123     }
 124
 125     /**
 126      * Test for editing procedure
 127      *
 128      * @return void
 129      *
 130      * @group large
 131      */
 132     public function testEditProcedure()
 133     {
 134         $this->_procedureSQL();
 135         $ele = $this->waitForElement("byPartialLinkText", "Routines");
 136         $ele->click();
 137
 138         $this->waitForElement(
 139             "byXPath",
 140             "//legend[contains(., 'Routines')]"
 141         );
 142
 143         $this->byLinkText("Edit")->click();
 144         $this->waitForElement("byClassName", "rte_form");
 145         $this->byName("item_param_length[0]")->clear();
 146         $this->byName("item_param_length[0]")->value("12");
 147
 148         $this->byXPath("//button[contains(., 'Go')]")->click();
 149
 150         $ele = $this->waitForElement(
 151             "byXPath",
 152             "//div[@class='success' and contains(., "
 153             . "'Routine `test_procedure` has been modified')]"
 154         );
 155
 156         $this->_executeProcedure("abcabcabcabcabcabcabc", 12);
 157     }
 158
 159     /**
 160      * Test for dropping procedure
 161      *
 162      * @return void
 163      *
 164      * @group large
 165      */
 166     public function testDropProcedure()
 167     {
 168         $this->_procedureSQL();
 169         $ele = $this->waitForElement("byPartialLinkText", "Routines");
 170         $ele->click();
 171
 172         $this->waitForElement(
 173             "byXPath",
 174             "//legend[contains(., 'Routines')]"
 175         );
 176
 177         $this->byLinkText("Drop")->click();
 178         $this->waitForElement(
 179             "byXPath", "//button[contains(., 'OK')]"
 180         )->click();
 181
 182         $this->waitForElement("byId", "nothing2display");
 183
 184         usleep(1000000);
 185         $result = $this->dbQuery(
 186             "SHOW PROCEDURE STATUS WHERE Db='" . $this->database_name . "'"
 187         );
 188         $this->assertEquals(0, $result->num_rows);
 189     }
 190
 191     /**
 192      * Execute procedure
 193      *
 194      * @param string $text   String to pass as inp param
 195      * @param int    $length Expected output length
 196      *
 197      * @return void
 198      */
 199     private function _executeProcedure($text, $length)
 200     {
 201         $this->waitForElement("byLinkText", "Execute")->click();
 202         $this->waitForElement("byName", "params[inp]")->value($text);
 203         $this->byCssSelector("div.ui-dialog-buttonset button:nth-child(1)")->click();
 204         $this->waitForElement(
 205             "byCssSelector",
 206             "span#PMA_slidingMessage table tbody"
 207         );
 208         $head = $this->byCssSelector("span#PMA_slidingMessage table tbody")->text();
 209         $this->assertEquals("outp\n$length", $head);
 210     }
 211 }