test/selenium/PmaSeleniumExportTest.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Selenium TestCase for export related tests
   5  *
   6  * @package    PhpMyAdmin-test
   7  * @subpackage Selenium
   8  */
   9
  10 require_once 'TestBase.php';
  11
  12 /**
  13  * PmaSeleniumExportTest class
  14  *
  15  * @package    PhpMyAdmin-test
  16  * @subpackage Selenium
  17  * @group      selenium
  18  */
  19 class PMA_SeleniumExportTest 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             "INSERT INTO `test_table` (val) VALUES (2);"
  38         );
  39     }
  40
  41     /**
  42      * setUp function that can use the selenium session (called before each test)
  43      *
  44      * @return void
  45      */
  46     public function setUpPage()
  47     {
  48         $this->login();
  49     }
  50
  51     /**
  52      * Test for server level export
  53      *
  54      * @param string $plugin   Export format
  55      * @param array  $expected Array of expected strings
  56      *
  57      * @return void
  58      * @dataProvider exportDataProvider
  59      *
  60      * @group large
  61      */
  62     public function testServerImport($plugin, $expected)
  63     {
  64         $text = $this->_doExport('server', $plugin);
  65
  66         foreach ($expected as $str) {
  67             $this->assertContains($str, $text);
  68         }
  69
  70     }
  71
  72     /**
  73      * Test for db level export
  74      *
  75      * @param string $plugin   Export format
  76      * @param array  $expected Array of expected strings
  77      *
  78      * @return void
  79      * @dataProvider exportDataProvider
  80      *
  81      * @group large
  82      */
  83     public function testDbExport($plugin, $expected)
  84     {
  85         $this->waitForElement("byLinkText", $this->database_name)->click();
  86         $this->waitForElement(
  87             "byXPath",
  88             "//a[@class='item' and contains(., 'Database: "
  89             . $this->database_name . "')]"
  90         );
  91
  92         $text = $this->_doExport('db', $plugin);
  93
  94         foreach ($expected as $str) {
  95             $this->assertContains($str, $text);
  96         }
  97     }
  98
  99     /**
 100      * Test for table level export
 101      *
 102      * @param string $plugin   Export format
 103      * @param array  $expected Array of expected strings
 104      *
 105      * @return void
 106      * @dataProvider exportDataProvider
 107      *
 108      * @group large
 109      */
 110     public function testTableExport($plugin, $expected)
 111     {
 112         $this->dbQuery("INSERT INTO `test_table` (val) VALUES (3);");
 113
 114         $this->navigateTable('test_table');
 115
 116         $text = $this->_doExport('table', $plugin);
 117
 118         foreach ($expected as $str) {
 119             $this->assertContains($str, $text);
 120         }
 121     }
 122
 123
 124     /**
 125      * Data provider for testServerExport
 126      *
 127      * @return array Test cases data
 128      */
 129     public function exportDataProvider()
 130     {
 131         return array(
 132             array(
 133                 'CSV',
 134                 array('"1","2"')
 135             ),
 136             array(
 137                 'SQL',
 138                 array(
 139                     "CREATE TABLE IF NOT EXISTS `test_table`",
 140                     "INSERT INTO `test_table` (`id`, `val`) VALUES",
 141                     "(1, 2);"
 142                 )
 143             ),
 144             array(
 145                 'JSON',
 146                 array('[{"id":"1","val":"2"}]')
 147             )
 148         );
 149     }
 150
 151     /**
 152      * Function that goes to the import page, uploads a file and submit form
 153      *
 154      * @param string $type   level: server, db or import
 155      * @param string $plugin format: csv, json, etc
 156      *
 157      * @return string export string
 158      */
 159     private function _doExport($type, $plugin)
 160     {
 161         $this->expandMore();
 162
 163         $this->waitForElement('byLinkText', "Export")->click();
 164         $this->sleep();
 165
 166         $this->waitForElement("byId", "quick_or_custom");
 167         /*
 168          * FIXME: There should be better way to wait for javascript to be executed
 169          */
 170         $this->sleep();
 171         $this->byCssSelector("label[for=radio_custom_export]")->click();
 172
 173         if ($type == 'server') {
 174             $this->byLinkText('Unselect all')->click();
 175             $this->byCssSelector(
 176                 "option[value=" . $this->database_name . "]"
 177             )->click();
 178         }
 179
 180         if ($type == 'table') {
 181             $this->byCssSelector("label[for=radio_allrows_0]")->click();
 182             $this->sleep();
 183             $this->byName("limit_to")->clear();
 184             $this->byName("limit_to")->value("1");
 185         }
 186
 187         $this->select($this->byId("plugins"))->selectOptionByLabel($plugin);
 188         $this->byCssSelector("label[for=radio_view_as_text]")->click();
 189
 190         if ($plugin == "SQL") {
 191             $this->byCssSelector(
 192                 "label[for=radio_sql_structure_or_data_structure_and_data]"
 193             )->click();
 194
 195             if ($type != "table") {
 196                 $this->byCssSelector(
 197                     "label[for=checkbox_sql_create_database]"
 198                 )->click();
 199             }
 200         }
 201
 202         $this->byId("buttonGo")->click();
 203
 204         $text = $this->waitForElement("byId", "textSQLDUMP")->text();
 205
 206         return $text;
 207     }
 208 }