tests/unit/UserPrivilegesFactoryTest.php

   1 <?php
   2
   3 declare(strict_types=1);
   4
   5 namespace PhpMyAdmin\Tests;
   6
   7 use PhpMyAdmin\ShowGrants;
   8 use PhpMyAdmin\UserPrivileges;
   9 use PhpMyAdmin\UserPrivilegesFactory;
  10 use PhpMyAdmin\Utils\SessionCache;
  11 use PHPUnit\Framework\Attributes\CoversClass;
  12
  13 #[CoversClass(UserPrivilegesFactory::class)]
  14 #[CoversClass(UserPrivileges::class)]
  15 #[CoversClass(ShowGrants::class)]
  16 final class UserPrivilegesFactoryTest extends AbstractTestCase
  17 {
  18     public function testCheckRequiredPrivilegesForAdjust(): void
  19     {
  20         $userPrivilegesFactory = new UserPrivilegesFactory($this->createDatabaseInterface());
  21
  22         // TEST CASE 1
  23         $userPrivileges = new UserPrivileges();
  24         $showGrants = new ShowGrants('GRANT ALL PRIVILEGES ON *.* TO \'root\'@\'localhost\' WITH GRANT OPTION');
  25
  26         // call the to-be-tested function
  27         $userPrivilegesFactory->checkRequiredPrivilegesForAdjust($userPrivileges, $showGrants);
  28
  29         self::assertTrue($userPrivileges->column);
  30         self::assertTrue($userPrivileges->database);
  31         self::assertTrue($userPrivileges->routines);
  32         self::assertTrue($userPrivileges->table);
  33
  34         // TEST CASE 2
  35         $userPrivileges = new UserPrivileges();
  36         $showGrants = new ShowGrants('GRANT ALL PRIVILEGES ON `mysql`.* TO \'root\'@\'localhost\' WITH GRANT OPTION');
  37
  38         // call the to-be-tested function
  39         $userPrivilegesFactory->checkRequiredPrivilegesForAdjust($userPrivileges, $showGrants);
  40
  41         self::assertTrue($userPrivileges->column);
  42         self::assertTrue($userPrivileges->database);
  43         self::assertTrue($userPrivileges->routines);
  44         self::assertTrue($userPrivileges->table);
  45
  46         // TEST CASE 3
  47         $userPrivileges = new UserPrivileges();
  48         $showGrants = new ShowGrants('GRANT SELECT, INSERT, UPDATE, DELETE ON `mysql`.* TO \'root\'@\'localhost\'');
  49
  50         // call the to-be-tested function
  51         $userPrivilegesFactory->checkRequiredPrivilegesForAdjust($userPrivileges, $showGrants);
  52
  53         self::assertTrue($userPrivileges->column);
  54         self::assertTrue($userPrivileges->database);
  55         self::assertTrue($userPrivileges->routines);
  56         self::assertTrue($userPrivileges->table);
  57
  58         // TEST CASE 4
  59         $userPrivileges = new UserPrivileges();
  60         $showGrants = new ShowGrants('GRANT SELECT, INSERT, UPDATE, DELETE ON `mysql`.`db` TO \'root\'@\'localhost\'');
  61
  62         // call the to-be-tested function
  63         $userPrivilegesFactory->checkRequiredPrivilegesForAdjust($userPrivileges, $showGrants);
  64
  65         self::assertFalse($userPrivileges->column);
  66         self::assertTrue($userPrivileges->database);
  67         self::assertFalse($userPrivileges->routines);
  68         self::assertFalse($userPrivileges->table);
  69     }
  70
  71     public function testGetPrivilegesWithSkipGrantTables(): void
  72     {
  73         SessionCache::set('mysql_cur_user', '@');
  74         $userPrivilegesFactory = new UserPrivilegesFactory($this->createDatabaseInterface());
  75         $expected = new UserPrivileges(
  76             database: true,
  77             table: true,
  78             column: true,
  79             routines: true,
  80             isReload: true,
  81             isCreateDatabase: true,
  82         );
  83         self::assertEquals($expected, $userPrivilegesFactory->getPrivileges());
  84     }
  85
  86     public function testGetPrivilegesFromSessionCache(): void
  87     {
  88         SessionCache::set('mysql_cur_user', 'test_user@localhost');
  89
  90         SessionCache::set('is_create_db_priv', true);
  91         SessionCache::set('is_reload_priv', true);
  92         SessionCache::set('db_to_create', 'databaseToCreate');
  93         SessionCache::set('dbs_to_test', ['databasesToTest']);
  94         SessionCache::set('proc_priv', true);
  95         SessionCache::set('table_priv', true);
  96         SessionCache::set('col_priv', true);
  97         SessionCache::set('db_priv', true);
  98
  99         $userPrivilegesFactory = new UserPrivilegesFactory($this->createDatabaseInterface());
 100         $expected = new UserPrivileges(true, true, true, true, true, true, 'databaseToCreate', ['databasesToTest']);
 101         self::assertEquals($expected, $userPrivilegesFactory->getPrivileges());
 102     }
 103
 104     public function testGetPrivilegesWithoutShowGrantsResult(): void
 105     {
 106         $dbiDummy = $this->createDbiDummy();
 107         $dbiDummy->addResult('SHOW GRANTS', false);
 108
 109         SessionCache::set('mysql_cur_user', 'test_user@localhost');
 110         $userPrivilegesFactory = new UserPrivilegesFactory($this->createDatabaseInterface($dbiDummy));
 111         $expected = new UserPrivileges(databasesToTest: ['information_schema', 'performance_schema', 'mysql', 'sys']);
 112         self::assertEquals($expected, $userPrivilegesFactory->getPrivileges());
 113
 114         $dbiDummy->assertAllQueriesConsumed();
 115     }
 116
 117     public function testGetPrivilegesWithoutGrants(): void
 118     {
 119         $dbiDummy = $this->createDbiDummy();
 120         $dbiDummy->addResult('SHOW GRANTS', []);
 121
 122         SessionCache::set('mysql_cur_user', 'test_user@localhost');
 123         $userPrivilegesFactory = new UserPrivilegesFactory($this->createDatabaseInterface($dbiDummy));
 124         $expected = new UserPrivileges(databasesToTest: ['information_schema', 'performance_schema', 'mysql', 'sys']);
 125         self::assertEquals($expected, $userPrivilegesFactory->getPrivileges());
 126
 127         $dbiDummy->assertAllQueriesConsumed();
 128     }
 129
 130     public function testGetPrivilegesWithAllPrivileges(): void
 131     {
 132         $dbiDummy = $this->createDbiDummy();
 133         $dbiDummy->addResult(
 134             'SHOW GRANTS',
 135             [['GRANT ALL PRIVILEGES ON *.* TO \'test_user\'@\'localhost\' WITH GRANT OPTION']],
 136         );
 137
 138         SessionCache::set('mysql_cur_user', 'test_user@localhost');
 139         $userPrivilegesFactory = new UserPrivilegesFactory($this->createDatabaseInterface($dbiDummy));
 140         $expected = new UserPrivileges(true, true, true, true, true, true);
 141         self::assertEquals($expected, $userPrivilegesFactory->getPrivileges());
 142
 143         $dbiDummy->assertAllQueriesConsumed();
 144     }
 145 }