tests/classes/CheckUserPrivilegesTest.php

   1 <?php
   2
   3 declare(strict_types=1);
   4
   5 namespace PhpMyAdmin\Tests;
   6
   7 use PhpMyAdmin\CheckUserPrivileges;
   8 use PhpMyAdmin\Config;
   9 use PhpMyAdmin\DatabaseInterface;
  10 use PhpMyAdmin\ShowGrants;
  11 use PhpMyAdmin\UserPrivileges;
  12 use PHPUnit\Framework\Attributes\CoversClass;
  13
  14 #[CoversClass(CheckUserPrivileges::class)]
  15 class CheckUserPrivilegesTest extends AbstractTestCase
  16 {
  17     private CheckUserPrivileges $checkUserPrivileges;
  18
  19     /**
  20      * prepares environment for tests
  21      */
  22     protected function setUp(): void
  23     {
  24         parent::setUp();
  25
  26         DatabaseInterface::$instance = $this->createDatabaseInterface();
  27         Config::getInstance()->selectedServer['DisableIS'] = false;
  28         UserPrivileges::$column = false;
  29         UserPrivileges::$database = false;
  30         UserPrivileges::$routines = false;
  31         UserPrivileges::$table = false;
  32         UserPrivileges::$isReload = false;
  33
  34         $this->checkUserPrivileges = new CheckUserPrivileges(DatabaseInterface::getInstance());
  35     }
  36
  37     /**
  38      * Test for checkRequiredPrivilegesForAdjust
  39      */
  40     public function testCheckRequiredPrivilegesForAdjust(): void
  41     {
  42         // TEST CASE 1
  43         $showGrants = new ShowGrants('GRANT ALL PRIVILEGES ON *.* TO \'root\'@\'localhost\' WITH GRANT OPTION');
  44
  45         // call the to-be-tested function
  46         $this->checkUserPrivileges->checkRequiredPrivilegesForAdjust($showGrants);
  47
  48         $this->assertTrue(UserPrivileges::$column);
  49         $this->assertTrue(UserPrivileges::$database);
  50         $this->assertTrue(UserPrivileges::$routines);
  51         $this->assertTrue(UserPrivileges::$table);
  52
  53         // re-initialise the privileges
  54         $this->setUp();
  55
  56         // TEST CASE 2
  57         $showGrants = new ShowGrants('GRANT ALL PRIVILEGES ON `mysql`.* TO \'root\'@\'localhost\' WITH GRANT OPTION');
  58
  59         // call the to-be-tested function
  60         $this->checkUserPrivileges->checkRequiredPrivilegesForAdjust($showGrants);
  61
  62         $this->assertTrue(UserPrivileges::$column);
  63         $this->assertTrue(UserPrivileges::$database);
  64         $this->assertTrue(UserPrivileges::$routines);
  65         $this->assertTrue(UserPrivileges::$table);
  66
  67         // re-initialise the privileges
  68         $this->setUp();
  69
  70         // TEST CASE 3
  71         $showGrants = new ShowGrants('GRANT SELECT, INSERT, UPDATE, DELETE ON `mysql`.* TO \'root\'@\'localhost\'');
  72
  73         // call the to-be-tested function
  74         $this->checkUserPrivileges->checkRequiredPrivilegesForAdjust($showGrants);
  75
  76         $this->assertTrue(UserPrivileges::$column);
  77         $this->assertTrue(UserPrivileges::$database);
  78         $this->assertTrue(UserPrivileges::$routines);
  79         $this->assertTrue(UserPrivileges::$table);
  80
  81         // re-initialise the privileges
  82         $this->setUp();
  83
  84         // TEST CASE 4
  85         $showGrants = new ShowGrants('GRANT SELECT, INSERT, UPDATE, DELETE ON `mysql`.`db` TO \'root\'@\'localhost\'');
  86
  87         // call the to-be-tested function
  88         $this->checkUserPrivileges->checkRequiredPrivilegesForAdjust($showGrants);
  89
  90         $this->assertFalse(UserPrivileges::$column);
  91         $this->assertTrue(UserPrivileges::$database);
  92         $this->assertFalse(UserPrivileges::$routines);
  93         $this->assertFalse(UserPrivileges::$table);
  94     }
  95 }