tests/end-to-end/TrackingTest.php

   1 <?php
   2
   3 declare(strict_types=1);
   4
   5 namespace PhpMyAdmin\Tests\Selenium;
   6
   7 use PHPUnit\Framework\Attributes\CoversNothing;
   8 use PHPUnit\Framework\Attributes\Large;
   9
  10 #[CoversNothing]
  11 #[Large]
  12 class TrackingTest extends TestBase
  13 {
  14     /**
  15      * Setup the browser environment to run the selenium test case
  16      */
  17     protected function setUp(): void
  18     {
  19         parent::setUp();
  20
  21         $this->dbQuery(
  22             'USE `' . $this->databaseName . '`;'
  23             . 'CREATE TABLE `test_table` ('
  24             . ' `id` int(11) NOT NULL AUTO_INCREMENT,'
  25             . ' `val` int(11) NOT NULL,'
  26             . ' PRIMARY KEY (`id`)'
  27             . ');'
  28             . 'CREATE TABLE `test_table_2` ('
  29             . ' `id` int(11) NOT NULL AUTO_INCREMENT,'
  30             . ' `val` int(11) NOT NULL,'
  31             . ' PRIMARY KEY (`id`)'
  32             . ');'
  33             . 'INSERT INTO `test_table` (val) VALUES (2), (3);',
  34         );
  35
  36         $this->login();
  37         $this->skipIfNotPMADB();
  38
  39         $this->navigateDatabase($this->databaseName);
  40         $this->expandMore();
  41
  42         $this->waitForElement('partialLinkText', 'Tracking')->click();
  43         $this->waitAjax();
  44
  45         $this->waitForElement('partialLinkText', 'Track table');
  46         $this->byXPath("(//a[contains(., 'Track table')])[1]")->click();
  47
  48         $this->waitAjax();
  49         $this->waitForElement('name', 'delete')->click();
  50         $this->byCssSelector("input[value='Create version']")->click();
  51         $this->waitForElement('id', 'versions');
  52     }
  53
  54     /**
  55      * Tests basic tracking functionality
  56      */
  57     public function testTrackingData(): void
  58     {
  59         $this->executeSqlAndReturnToTableTracking();
  60
  61         $this->byPartialLinkText('Tracking report')->click();
  62         $this->waitForElement('xpath', "//h3[contains(., 'Tracking report')]");
  63
  64         self::assertStringContainsString(
  65             'DROP TABLE IF EXISTS `test_table`',
  66             $this->getCellByTableId('ddl_versions', 1, 4),
  67         );
  68
  69         self::assertStringContainsString(
  70             'CREATE TABLE `test_table` (',
  71             $this->getCellByTableId('ddl_versions', 2, 4),
  72         );
  73
  74         self::assertStringContainsString(
  75             'UPDATE test_table SET val = val + 1',
  76             $this->getCellByTableId('dml_versions', 1, 4),
  77         );
  78
  79         self::assertStringNotContainsString(
  80             'DELETE FROM test_table WHERE val = 3',
  81             $this->byId('dml_versions')->getText(),
  82         );
  83
  84         // only structure
  85         $this->selectByLabel($this->byName('log_type'), 'Structure only');
  86
  87         $this->byCssSelector("input[value='Go']")->click();
  88
  89         $this->waitAjax();
  90
  91         self::assertFalse(
  92             $this->isElementPresent('id', 'dml_versions'),
  93         );
  94
  95         self::assertStringContainsString(
  96             'DROP TABLE IF EXISTS `test_table`',
  97             $this->getCellByTableId('ddl_versions', 1, 4),
  98         );
  99
 100         self::assertStringContainsString(
 101             'CREATE TABLE `test_table` (',
 102             $this->getCellByTableId('ddl_versions', 2, 4),
 103         );
 104
 105         // only data
 106         $this->selectByLabel($this->waitForElement('name', 'log_type'), 'Data only');
 107
 108         $this->byCssSelector("input[value='Go']")->click();
 109
 110         $this->waitAjax();
 111
 112         self::assertFalse(
 113             $this->isElementPresent('id', 'ddl_versions'),
 114         );
 115
 116         self::assertStringContainsString(
 117             'UPDATE test_table SET val = val + 1',
 118             $this->getCellByTableId('dml_versions', 1, 4),
 119         );
 120
 121         self::assertStringNotContainsString(
 122             'DELETE FROM test_table WHERE val = 3',
 123             $this->byId('dml_versions')->getText(),
 124         );
 125     }
 126
 127     /**
 128      * Tests deactivation of tracking
 129      */
 130     public function testDeactivateTracking(): void
 131     {
 132         $this->byCssSelector("input[value='Deactivate now']")->click();
 133         $this->waitForElement('cssSelector', "input[value='Activate now']");
 134         $this->executeSqlAndReturnToTableTracking();
 135         self::assertFalse(
 136             $this->isElementPresent('id', 'dml_versions'),
 137         );
 138     }
 139
 140     /**
 141      * Tests dropping a tracking
 142      */
 143     public function testDropTracking(): void
 144     {
 145         $this->navigateDatabase($this->databaseName, true);
 146         $this->expandMore();
 147
 148         $this->byPartialLinkText('Tracking')->click();
 149
 150         $this->waitAjax();
 151         $this->waitForElement('id', 'versions');
 152
 153         $ele = $this->waitForElement('cssSelector', 'table#versions tbody tr:nth-child(1) td:nth-child(7) a');
 154         $this->moveto($ele);
 155         $this->click();
 156
 157         $this->waitForElement('id', 'functionConfirmOkButton')->click();
 158
 159         $this->waitAjax();
 160         $success = $this->waitForElement('cssSelector', '.alert-success');
 161         self::assertStringContainsString('Tracking data deleted successfully.', $success->getText());
 162
 163         // Can not use getCellByTableId,
 164         // since this is under 'th' and not 'td'
 165         self::assertStringContainsString(
 166             'test_table',
 167             $this->waitForElement(
 168                 'cssSelector',
 169                 'table#noversions tbody tr:nth-child(1) th:nth-child(2)',
 170             )->getText(),
 171         );
 172         self::assertStringContainsString(
 173             'test_table_2',
 174             $this->waitForElement(
 175                 'cssSelector',
 176                 'table#noversions tbody tr:nth-child(2) th:nth-child(2)',
 177             )->getText(),
 178         );
 179     }
 180
 181     /**
 182      * Tests structure snapshot of a tracking
 183      */
 184     public function testStructureSnapshot(): void
 185     {
 186         $this->byPartialLinkText('Structure snapshot')->click();
 187         $this->waitForElement('id', 'tablestructure');
 188
 189         self::assertStringContainsString(
 190             'id',
 191             $this->getCellByTableId('tablestructure', 1, 2),
 192         );
 193
 194         self::assertStringContainsString(
 195             'val',
 196             $this->getCellByTableId('tablestructure', 2, 2),
 197         );
 198
 199         self::assertStringContainsString(
 200             'PRIMARY',
 201             $this->getCellByTableId('tablestructure_indexes', 1, 1),
 202         );
 203
 204         self::assertStringContainsString(
 205             'id',
 206             $this->getCellByTableId('tablestructure_indexes', 1, 5),
 207         );
 208     }
 209
 210     /**
 211      * Goes to SQL tab, executes queries, returns to tracking page
 212      */
 213     private function executeSqlAndReturnToTableTracking(): void
 214     {
 215         $this->byPartialLinkText('SQL')->click();
 216         $this->waitAjax();
 217
 218         $this->waitForElement('id', 'queryfieldscontainer');
 219         $this->typeInTextArea(';UPDATE test_table SET val = val + 1; DELETE FROM test_table WHERE val = 3');
 220         $this->scrollToBottom();
 221         $this->byCssSelector("input[value='Go']")->click();
 222         $this->waitAjax();
 223         $this->waitForElement('className', 'alert-success');
 224
 225         $this->expandMore();
 226         $this->byPartialLinkText('Tracking')->click();
 227         $this->waitAjax();
 228         $this->waitForElement('id', 'versions');
 229     }
 230 }