tests/end-to-end/SqlQueryTest.php

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