test/selenium/DbStructureTest.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 namespace PhpMyAdmin\Tests\Selenium;
  11
  12 /**
  13  * DbStructureTest class
  14  *
  15  * @package    PhpMyAdmin-test
  16  * @subpackage Selenium
  17  * @group      selenium
  18  */
  19 class DbStructureTest extends TestBase
  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         parent::setUpPage();
  56
  57         $this->login();
  58         $this->navigateDatabase($this->database_name);
  59
  60         // Let the Database page load
  61         $this->waitAjax();
  62         $this->expandMore();
  63     }
  64
  65     /**
  66      * Test for truncating a table
  67      *
  68      * @return void
  69      *
  70      * @group large
  71      */
  72     public function testTruncateTable()
  73     {
  74         $this->byXPath("(//a[contains(., 'Empty')])[1]")->click();
  75
  76         $this->waitForElement(
  77             "byCssSelector",
  78             "button.submitOK"
  79         )->click();
  80
  81         $this->assertNotNull(
  82             $this->waitForElement(
  83                 "byXPath",
  84                 "//div[@class='success' and contains(., "
  85                 . "'MySQL returned an empty result')]"
  86             )
  87         );
  88
  89         $result = $this->dbQuery("SELECT count(*) as c FROM test_table");
  90         $row = $result->fetch_assoc();
  91         $this->assertEquals(0, $row['c']);
  92     }
  93
  94     /**
  95      * Tests for dropping multiple tables
  96      *
  97      * @return void
  98      *
  99      * @group large
 100      */
 101     public function testDropMultipleTables()
 102     {
 103         $this->byCssSelector("label[for='tablesForm_checkall']")->click();
 104         $this->select($this->byName("submit_mult"))
 105             ->selectOptionByLabel("Drop");
 106         $this->waitForElement("byId", "buttonYes")
 107             ->click();
 108
 109         $this->waitForElement(
 110             "byXPath",
 111             "//*[contains(., 'No tables found in database')]"
 112         );
 113
 114         $result = $this->dbQuery("SHOW TABLES;");
 115         $this->assertEquals(0, $result->num_rows);
 116
 117     }
 118 }