tests/end-to-end/CreateRemoveUserTest.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 use function bin2hex;
  11 use function random_bytes;
  12
  13 #[CoversNothing]
  14 #[Large]
  15 class CreateRemoveUserTest extends TestBase
  16 {
  17     /**
  18      * Create a test database for this test class
  19      */
  20     protected static bool $createDatabase = false;
  21
  22     /**
  23      * Username for the user
  24      */
  25     private string $txtUsername;
  26
  27     /**
  28      * Password for the user
  29      */
  30     private string $txtPassword;
  31
  32     /**
  33      * Setup the browser environment to run the selenium test case
  34      */
  35     protected function setUp(): void
  36     {
  37         parent::setUp();
  38
  39         $this->skipIfNotSuperUser();
  40         $this->txtUsername = 'test_user_' . bin2hex(random_bytes(4));
  41         $this->txtPassword = 'abc_123';
  42         $this->login();
  43     }
  44
  45     /**
  46      * Creates and removes a user
  47      */
  48     public function testCreateRemoveUser(): void
  49     {
  50         $this->waitForElement('partialLinkText', 'User accounts')->click();
  51
  52         // Let the User Accounts page load
  53         $this->waitAjax();
  54
  55         $this->scrollIntoView('add_user_anchor');
  56         $this->waitForElement('id', 'usersForm');
  57         $ele = $this->waitForElement('id', 'add_user_anchor');
  58         $this->moveto($ele);
  59         $ele->click();
  60
  61         $this->waitAjax();
  62         $userField = $this->waitForElement('name', 'username');
  63         $userField->sendKeys($this->txtUsername);
  64
  65         $this->selectByLabel($this->byId('select_pred_hostname'), 'Local');
  66
  67         $this->scrollIntoView('button_generate_password');
  68         $genButton = $this->waitForElement('id', 'button_generate_password');
  69         $genButton->click();
  70
  71         self::assertNotSame('', $this->byId('text_pma_pw')->getAttribute('value'));
  72         self::assertNotSame('', $this->byId('text_pma_pw2')->getAttribute('value'));
  73         self::assertNotSame('', $this->byId('generated_pw')->getAttribute('value'));
  74
  75         $this->byId('text_pma_pw')->sendKeys($this->txtPassword);
  76         $this->byId('text_pma_pw2')->sendKeys($this->txtPassword);
  77
  78         // Make sure the element is visible before clicking
  79         $this->scrollIntoView('createdb-1');
  80         $this->waitForElement('id', 'createdb-1')->click();
  81         $this->waitForElement('id', 'createdb-2')->click();
  82
  83         $this->scrollIntoView('addUsersForm_checkall');
  84         $this->byId('addUsersForm_checkall')->click();
  85
  86         $this->scrollIntoView('adduser_submit');
  87         $this->waitForElement('id', 'adduser_submit')->click();
  88
  89         $success = $this->waitForElement('cssSelector', '.alert-success');
  90         self::assertStringContainsString('You have added a new user', $success->getText());
  91
  92         // Removing the newly added user
  93         $this->waitForElement('partialLinkText', 'User accounts')->click();
  94         $this->waitForElement('id', 'usersForm');
  95         $temp = $this->txtUsername . '&amp;#27;localhost';
  96
  97         $this->byXPath("(//input[@name='selected_usr[]'])[@value='" . $temp . "']")->click();
  98
  99         $this->scrollIntoView('deleteUserCard');
 100         $this->byId('dropUsersDbCheckbox')->click();
 101
 102         $this->byId('buttonGo')->click();
 103         $this->waitForElement('id', 'functionConfirmOkButton')->click();
 104         $this->acceptAlert();
 105
 106         $success = $this->waitForElement('cssSelector', '.alert-success');
 107         self::assertStringContainsString(
 108             'The selected users have been deleted',
 109             $success->getText(),
 110         );
 111     }
 112 }