test/selenium/SqlQueryTest.php

   1 <?php
   2 /**
   3  * Selenium TestCase for typing and executing SQL query tests
   4  */
   5 declare(strict_types=1);
   6
   7 namespace PhpMyAdmin\Tests\Selenium;
   8
   9 /**
  10  * SqlQueryTest class
  11  *
  12  * @group      selenium
  13  */
  14 class SqlQueryTest extends TestBase
  15 {
  16     /**
  17      * Setup the browser environment to run the selenium test case
  18      */
  19     protected function setUp(): void
  20     {
  21         parent::setUp();
  22
  23         $this->dbQuery(
  24             'CREATE TABLE `test_table` ('
  25             . ' `id` int(11) NOT NULL AUTO_INCREMENT,'
  26             . ' `val` int(11) NOT NULL,'
  27             . ' PRIMARY KEY (`id`)'
  28             . ')'
  29         );
  30         $this->dbQuery(
  31             'INSERT INTO `test_table` (val) VALUES (2), (3), (4), (5);'
  32         );
  33         $this->login();
  34     }
  35
  36     /**
  37      * Test typing a SQL query on Server SQL page and submitting it
  38      *
  39      * @return void
  40      */
  41     public function testServerSqlQuery()
  42     {
  43         $this->waitForElement('partialLinkText', 'SQL')->click();
  44         $this->waitAjax();
  45
  46         $this->typeInTextArea(
  47             'SET @t1=1, @t2=2, @t3:=4;'
  48             . 'SELECT 1 as `id`,  @t1, @t2, @t3, @t4 := @t1+@t2+@t3;'
  49         );
  50         $this->byId('button_submit_query')->click();
  51         $this->waitAjax();
  52
  53         $this->waitForElement('cssSelector', 'table.table_results');
  54         $this->assertEquals(
  55             1,
  56             $this->getCellByTableClass('table_results', 1, 1)
  57         );
  58         $this->assertEquals(
  59             1,
  60             $this->getCellByTableClass('table_results', 1, 2)
  61         );
  62         $this->assertEquals(
  63             2,
  64             $this->getCellByTableClass('table_results', 1, 3)
  65         );
  66         $this->assertEquals(
  67             4,
  68             $this->getCellByTableClass('table_results', 1, 4)
  69         );
  70         $this->assertEquals(
  71             7,
  72             $this->getCellByTableClass('table_results', 1, 5)
  73         );
  74
  75         // test inline edit button
  76         $this->_testInlineEdit();
  77     }
  78
  79     /**
  80      * Test typing a SQL query on Database SQL page and submitting it
  81      *
  82      * @return void
  83      */
  84     public function testDatabaseSqlQuery()
  85     {
  86         $this->navigateDatabase($this->database_name);
  87
  88         $this->waitForElement('partialLinkText', 'SQL')->click();
  89         $this->waitAjax();
  90
  91         $this->typeInTextArea('SHOW TABLE STATUS');
  92         $this->byId('button_submit_query')->click();
  93         $this->waitAjax();
  94
  95         $this->waitForElement('cssSelector', 'table.table_results');
  96         $this->assertEquals(
  97             'test_table',
  98             $this->getCellByTableClass('table_results', 1, 1)
  99         );
 100         $this->assertEquals(
 101             'InnoDB',
 102             $this->getCellByTableClass('table_results', 1, 2)
 103         );
 104         $this->assertEquals(
 105             4,
 106             $this->getCellByTableClass('table_results', 1, 5)
 107         );
 108
 109         // test inline edit button
 110         $this->_testInlineEdit();
 111     }
 112
 113     /**
 114      * Test typing a SQL query on Table SQL page and submitting it
 115      *
 116      * @return void
 117      */
 118     public function testTableSqlQuery()
 119     {
 120         $this->navigateTable('test_table');
 121
 122         $this->waitForElement('partialLinkText', 'SQL')->click();
 123         $this->waitAjax();
 124
 125         $this->typeInTextArea('SELECT * FROM `test_table` WHERE `val` NOT IN (2, 3);');
 126         $this->scrollToBottom();
 127         $this->byId('button_submit_query')->click();
 128         $this->waitAjax();
 129
 130         $this->waitForElement('cssSelector', 'table.table_results');
 131         $this->assertEquals(
 132             3,
 133             $this->getCellByTableClass('table_results', 1, 5)
 134         );
 135         $this->assertEquals(
 136             4,
 137             $this->getCellByTableClass('table_results', 2, 5)
 138         );
 139         $this->assertEquals(
 140             4,
 141             $this->getCellByTableClass('table_results', 1, 6)
 142         );
 143         $this->assertEquals(
 144             5,
 145             $this->getCellByTableClass('table_results', 2, 6)
 146         );
 147
 148         // test inline edit button
 149         $this->_testInlineEdit();
 150     }
 151
 152     /**
 153      * @return void
 154      */
 155     private function _testInlineEdit()
 156     {
 157         $this->waitForElement('cssSelector', 'a.inline_edit_sql')->click();
 158         // empty current query
 159         $this->typeInTextArea('', 1);
 160
 161         // type in next sql query
 162         $this->typeInTextArea('SELECT 1', 1);
 163
 164         $this->scrollIntoView('sql_query_edit_save');
 165         $this->byId('sql_query_edit_save')->click();
 166         $this->waitAjax();
 167
 168         $this->waitForElement('cssSelector', 'table.table_results');
 169         $this->assertEquals(
 170             1,
 171             $this->getCellByTableClass('table_results', 1, 1)
 172         );
 173     }
 174 }