test/selenium/PmaSeleniumTrackingTest.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Selenium TestCase for tracking related tests
   5  *
   6  * @package    PhpMyAdmin-test
   7  * @subpackage Selenium
   8  */
   9 require_once 'Helper.php';
  10
  11 /**
  12  * PmaSeleniumTrackingTest class
  13  *
  14  * @package    PhpMyAdmin-test
  15  * @subpackage Selenium
  16  */
  17 class PmaSeleniumTrackingTest extends PHPUnit_Extensions_Selenium2TestCase
  18 {
  19     /**
  20      * Name of database for the test
  21      *
  22      * @var string
  23      */
  24     private $_dbname;
  25
  26     /**
  27      * Helper Object
  28      *
  29      * @var obj
  30      */
  31     private $_helper;
  32
  33     /**
  34      * Setup the browser environment to run the selenium test case
  35      *
  36      * @return void
  37      */
  38     public function setUp()
  39     {
  40         $this->_helper = new Helper($this);
  41         $this->setBrowser($this->_helper->getBrowserString());
  42         $this->setBrowserUrl(TESTSUITE_PHPMYADMIN_HOST . TESTSUITE_PHPMYADMIN_URL);
  43         $this->_helper->dbConnect();
  44         $this->_dbname = 'pma_db_' . time();
  45         $this->_helper->dbQuery('CREATE DATABASE ' . $this->_dbname);
  46         $this->_helper->dbQuery('USE ' . $this->_dbname);
  47         $this->_helper->dbQuery(
  48             "CREATE TABLE `test_table` ("
  49             . " `id` int(11) NOT NULL AUTO_INCREMENT,"
  50             . " `val` int(11) NOT NULL,"
  51             . " PRIMARY KEY (`id`)"
  52             . ")"
  53         );
  54         $this->_helper->dbQuery(
  55             "CREATE TABLE `test_table_2` ("
  56             . " `id` int(11) NOT NULL AUTO_INCREMENT,"
  57             . " `val` int(11) NOT NULL,"
  58             . " PRIMARY KEY (`id`)"
  59             . ")"
  60         );
  61         $this->_helper->dbQuery(
  62             "INSERT INTO `test_table` (val) VALUES (2), (3);"
  63         );
  64     }
  65
  66     /**
  67      * setUp function that can use the selenium session (called before each test)
  68      *
  69      * @return void
  70      */
  71     public function setUpPage()
  72     {
  73         $this->_helper->login(TESTSUITE_USER, TESTSUITE_PASSWORD);
  74         $this->byLinkText($this->_dbname)->click();
  75         $this->_helper->waitForElement(
  76             "byXPath",
  77             "//a[@class='item' and contains(., 'Database: ". $this->_dbname ."')]"
  78         );
  79         $ele = $this->byLinkText("More");
  80         $this->moveto($ele);
  81         $this->byLinkText("Tracking")->click();
  82         $this->_helper->waitForElement("byLinkText", "Track table");
  83         $this->byXPath("(//a[contains(., 'Track table')])[1]")->click();
  84
  85         $this->_helper->waitForElement("byName", "delete")->click();
  86         $this->byCssSelector("input[value='Create version']")->click();
  87         $this->_helper->waitForElement("byId", "versions");
  88     }
  89
  90     /**
  91      * Tests basic tracking functionality
  92      *
  93      * @return void
  94      */
  95     public function testTrackingData()
  96     {
  97         $this->_executeSqlAndReturnToTableTracking();
  98
  99         $this->byLinkText("Tracking report")->click();
 100         $this->_helper->waitForElement(
 101             "byXPath",
 102             "//h3[contains(., 'Tracking report')]"
 103         );
 104
 105         $this->assertContains(
 106             "DROP TABLE IF EXISTS `test_table`",
 107             $this->_helper->getTable("ddl_versions.1.4")
 108         );
 109
 110         $this->assertContains(
 111             "CREATE TABLE `test_table` (",
 112             $this->_helper->getTable("ddl_versions.2.4")
 113         );
 114
 115         $this->assertContains(
 116             "UPDATE test_table SET val = val + 1",
 117             $this->_helper->getTable("dml_versions.1.4")
 118         );
 119
 120         $this->assertNotContains(
 121             "DELETE FROM test_table WHERE val = 3",
 122             $this->byId("dml_versions")->text()
 123         );
 124
 125         // only structure
 126         $this->select($this->byName("logtype"))
 127             ->selectOptionByLabel("Structure only");
 128         $this->byCssSelector("input[value='Go']")->click();
 129
 130         $this->_helper->waitForElementNotPresent("byId", "loading_parent");
 131
 132         $this->assertFalse(
 133             $this->_helper->isElementPresent("byId", "dml_versions")
 134         );
 135
 136         $this->assertContains(
 137             "DROP TABLE IF EXISTS `test_table`",
 138             $this->_helper->getTable("ddl_versions.1.4")
 139         );
 140
 141         $this->assertContains(
 142             "CREATE TABLE `test_table` (",
 143             $this->_helper->getTable("ddl_versions.2.4")
 144         );
 145
 146         // only data
 147         $this->select($this->byName("logtype"))
 148             ->selectOptionByLabel("Data only");
 149         $this->byCssSelector("input[value='Go']")->click();
 150
 151         $this->_helper->waitForElementNotPresent("byId", "loading_parent");
 152
 153         $this->assertFalse(
 154             $this->_helper->isElementPresent("byId", "ddl_versions")
 155         );
 156
 157         $this->assertContains(
 158             "UPDATE test_table SET val = val + 1",
 159             $this->_helper->getTable("dml_versions.1.4")
 160         );
 161
 162         $this->assertNotContains(
 163             "DELETE FROM test_table WHERE val = 3",
 164             $this->byId("dml_versions")->text()
 165         );
 166     }
 167
 168     /**
 169      * Tests deactivation of tracking
 170      *
 171      * @return void
 172      */
 173     public function testDeactivateTracking()
 174     {
 175         $this->byCssSelector("input[value='Deactivate now']")->click();
 176         $this->_helper->waitForElement(
 177             "byCssSelector", "input[value='Activate now']"
 178         );
 179         $this->_executeSqlAndReturnToTableTracking();
 180         $this->assertFalse(
 181             $this->_helper->isElementPresent("byId", "dml_versions")
 182         );
 183     }
 184
 185     /**
 186      * Tests dropping a tracking
 187      *
 188      * @return void
 189      */
 190     public function testDropTracking()
 191     {
 192         $this->byLinkText("Database: " . $this->_dbname)->click();
 193         $this->_helper->waitForElement("byCssSelector", "table.data");
 194         usleep(1000000);
 195         $ele = $this->byLinkText("More");
 196         $this->moveto($ele);
 197         $this->byLinkText("Tracking")->click();
 198         $this->_helper->waitForElement("byId", "versions");
 199         $this->byLinkText("Drop")->click();
 200
 201         $this->_helper->waitForElement(
 202             "byXPath",
 203             "//button[contains(., 'OK')]"
 204         )->click();
 205
 206         $this->_helper->waitForElement(
 207             "byXPath",
 208             "//div[@class='success' and contains(., "
 209             . "'Your SQL query has been executed')]"
 210         );
 211
 212         $this->assertContains(
 213             "test_table",
 214             $this->_helper->getTable("noversions.1.1")
 215         );
 216
 217         $this->assertContains(
 218             "test_table_2",
 219             $this->_helper->getTable("noversions.2.1")
 220         );
 221     }
 222
 223     /**
 224      * Tests structure snapshot of a tracking
 225      *
 226      * @return void
 227      */
 228     public function testStructureSnapshot()
 229     {
 230         $this->byLinkText("Structure snapshot")->click();
 231         $this->_helper->waitForElement("byId", "tablestructure");
 232
 233         $this->assertContains(
 234             "id",
 235             $this->_helper->getTable("tablestructure.1.1")
 236         );
 237
 238         $this->assertContains(
 239             "val",
 240             $this->_helper->getTable("tablestructure.2.1")
 241         );
 242
 243         $this->assertContains(
 244             "PRIMARY",
 245             $this->_helper->getTable("tablestructure_indexes.1.1")
 246         );
 247
 248         $this->assertContains(
 249             "id",
 250             $this->_helper->getTable("tablestructure_indexes.1.5")
 251         );
 252     }
 253
 254     /**
 255      * Goes to SQL tab, executes queries, returns to tracking page
 256      *
 257      * @return void
 258      */
 259     private function _executeSqlAndReturnToTableTracking()
 260     {
 261         $this->byLinkText("SQL")->click();
 262         $this->_helper->waitForElement("byId", "queryfieldscontainer");
 263         $this->_helper->typeInTextArea(
 264             ";UPDATE test_table SET val = val + 1; "
 265             . "DELETE FROM test_table WHERE val = 3"
 266         );
 267         $this->byCssSelector("input[value='Go']")->click();
 268         $this->_helper->waitForElement("byClassName", "success");
 269
 270         $ele = $this->byLinkText("More");
 271         $this->moveto($ele);
 272         $this->byLinkText("Tracking")->click();
 273         $this->_helper->waitForElement("byId", "versions");
 274     }
 275
 276     /**
 277      * Tear Down function for test cases
 278      *
 279      * @return void
 280      */
 281     public function tearDown()
 282     {
 283         $this->_helper->dbQuery('DROP DATABASE IF EXISTS ' . $this->_dbname);
 284     }
 285
 286 }