test/selenium/PmaSeleniumDbStructureTest.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  * PmaSeleniumDbStructureTest class
  14  *
  15  * @package    PhpMyAdmin-test
  16  * @subpackage Selenium
  17  * @group      selenium
  18  */
  19 class PMA_SeleniumDbStructureTest 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             . " `val` int(11) NOT NULL,"
  33             . " PRIMARY KEY (`id`)"
  34             . ")"
  35         );
  36         $this->dbQuery(
  37             "CREATE TABLE `test_table2` ("
  38             . " `id` int(11) NOT NULL AUTO_INCREMENT,"
  39             . " `val` int(11) NOT NULL,"
  40             . " PRIMARY KEY (`id`)"
  41             . ")"
  42         );
  43         $this->dbQuery(
  44             "INSERT INTO `test_table` (val) VALUES (2);"
  45         );
  46     }
  47
  48     /**
  49      * setUp function that can use the selenium session (called before each test)
  50      *
  51      * @return void
  52      */
  53     public function setUpPage()
  54     {
  55         $this->login();
  56         $this->waitForElement('byLinkText', $this->database_name)->click();
  57         $this->waitForElement(
  58             'byCssSelector',
  59             'li.last.table'
  60         );
  61         $this->waitForElement(
  62             "byXPath", "//a[contains(., 'test_table')]"
  63         );
  64     }
  65
  66     /**
  67      * Test for truncating a table
  68      *
  69      * @return void
  70      *
  71      * @group large
  72      */
  73     public function testTruncateTable()
  74     {
  75         $this->byXPath("(//a[contains(., 'Empty')])[1]")->click();
  76
  77         $this->waitForElement(
  78             "byXPath",
  79             "//button[contains(., 'OK')]"
  80         )->click();
  81
  82         $this->assertNotNull(
  83             $this->waitForElement(
  84                 "byXPath",
  85                 "//div[@class='success' and contains(., "
  86                 . "'MySQL returned an empty result')]"
  87             )
  88         );
  89
  90         $result = $this->dbQuery("SELECT count(*) as c FROM test_table");
  91         $row = $result->fetch_assoc();
  92         $this->assertEquals(0, $row['c']);
  93     }
  94
  95     /**
  96      * Tests for dropping multiple tables
  97      *
  98      * @return void
  99      *
 100      * @group large
 101      */
 102     public function testDropMultipleTables()
 103     {
 104         $this->byCssSelector("label[for='tablesForm_checkall']")->click();
 105         $this->select($this->byName("submit_mult"))
 106             ->selectOptionByLabel("Drop");
 107         $this->waitForElement("byId", "buttonYes")
 108             ->click();
 109
 110         $this->waitForElement(
 111             "byXPath",
 112             "//p[contains(., 'No tables found in database')]"
 113         );
 114
 115         $result = $this->dbQuery("SHOW TABLES;");
 116         $this->assertEquals(0, $result->num_rows);
 117
 118     }
 119 }