tests/selenium/NormalizationTest.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\Group;
   9
  10 #[CoversNothing]
  11 class NormalizationTest extends TestBase
  12 {
  13     /**
  14      * Setup the browser environment to run the selenium test case
  15      */
  16     protected function setUp(): void
  17     {
  18         parent::setUp();
  19
  20         $this->dbQuery(
  21             'USE `' . $this->databaseName . '`;'
  22             . 'CREATE TABLE `test_table` ('
  23             . ' `id` int(11) NOT NULL AUTO_INCREMENT,'
  24             . ' `val` int(11) NOT NULL,'
  25             . ' `val2` varchar(64) NOT NULL,'
  26             . 'PRIMARY KEY(id)'
  27             . ');',
  28         );
  29
  30         $this->login();
  31         $this->navigateTable('test_table');
  32         $this->waitForElement('xpath', "(//a[contains(., 'Structure')])")->click();
  33
  34         $this->waitAjax();
  35
  36         $this->waitForElement('id', 'tablestructure');
  37         $this->byPartialLinkText('Normalize')->click();
  38         $this->waitForElement('id', 'normalizeTable');
  39     }
  40
  41     /**
  42      * Test for normalization to 1NF
  43      */
  44     #[Group('large')]
  45     public function testNormalizationTo1NF(): void
  46     {
  47         $this->assertEquals(
  48             'First step of normalization (1NF)',
  49             $this->byCssSelector('label[for=normalizeToRadio1]')->getText(),
  50         );
  51         $this->assertTrue(
  52             $this->isElementPresent(
  53                 'cssSelector',
  54                 'input[id=normalizeToRadio1][type=radio]:checked',
  55             ),
  56         );
  57         $this->byCssSelector('input[name=submit_normalize]')->click();
  58         $this->waitForElement('id', 'mainContent');
  59         $this->assert1NFSteps();
  60     }
  61
  62     /**
  63      * assertions in 1NF steps 1.1, 1.2, 1.3
  64      */
  65     private function assert1NFSteps(): void
  66     {
  67         $this->assertEquals(
  68             'First step of normalization (1NF)',
  69             $this->byCssSelector('#page_content h3')->getText(),
  70         );
  71         $this->assertTrue(
  72             $this->isElementPresent(
  73                 'cssSelector',
  74                 '#mainContent h4',
  75             ),
  76         );
  77         $this->assertTrue(
  78             $this->isElementPresent(
  79                 'cssSelector',
  80                 '#mainContent #newCols',
  81             ),
  82         );
  83         $this->assertTrue(
  84             $this->isElementPresent(
  85                 'cssSelector',
  86                 '#selectNonAtomicCol option[value=val2]',
  87             ),
  88         );
  89         $this->assertFalse(
  90             $this->isElementPresent(
  91                 'cssSelector',
  92                 '#selectNonAtomicCol option[value=val]',
  93             ),
  94         );
  95         $this->assertTrue(
  96             $this->isElementPresent(
  97                 'cssSelector',
  98                 '#selectNonAtomicCol option[value=no_such_col]',
  99             ),
 100         );
 101
 102         $this->selectByValue(
 103             $this->byId('selectNonAtomicCol'),
 104             'no_such_col',
 105         );
 106
 107         $this->waitForElement('xpath', "//div[contains(., 'Step 1.2 Have a primary key')]");
 108         $text = $this->byCssSelector('#mainContent h4')->getText();
 109         $this->assertStringContainsString('Primary key already exists.', $text);
 110         $this->waitForElement('xpath', "//div[contains(., 'Step 1.3 Move repeating groups')]");
 111         $this->byCssSelector('input[value="No repeating group"]')->click();
 112         $this->waitForElement('xpath', "//div[contains(., 'Step 1.4 Remove redundant columns')]");
 113         $this->assertTrue(
 114             $this->isElementPresent(
 115                 'cssSelector',
 116                 '#mainContent #extra',
 117             ),
 118         );
 119         $this->assertTrue(
 120             $this->isElementPresent(
 121                 'cssSelector',
 122                 '#extra input[value=val2][type=checkbox]',
 123             ),
 124         );
 125         $this->assertTrue(
 126             $this->isElementPresent(
 127                 'cssSelector',
 128                 '#extra input[value=id][type=checkbox]',
 129             ),
 130         );
 131         $this->byCssSelector('#extra input[value=val][type=checkbox]')->click();
 132         $this->byCssSelector('#removeRedundant')->click();
 133         $this->waitForElement('xpath', "//div[contains(., 'End of step')]");
 134         $this->assertStringContainsString(
 135             "The first step of normalization is complete for table 'test_table'.",
 136             $this->byCssSelector('#mainContent h4')->getText(),
 137         );
 138     }
 139 }