tests/unit/ShowGrantsTest.php

   1 <?php
   2
   3 declare(strict_types=1);
   4
   5 namespace PhpMyAdmin\Tests;
   6
   7 use PhpMyAdmin\ShowGrants;
   8 use PHPUnit\Framework\Attributes\CoversClass;
   9
  10 #[CoversClass(ShowGrants::class)]
  11 class ShowGrantsTest extends AbstractTestCase
  12 {
  13     public function test1(): void
  14     {
  15         $showGrants = new ShowGrants('GRANT ALL PRIVILEGES ON *.* TO \'root\'@\'localhost\' WITH GRANT OPTION');
  16         self::assertSame('ALL PRIVILEGES', $showGrants->grants);
  17         self::assertSame('*', $showGrants->dbName);
  18         self::assertSame('*', $showGrants->tableName);
  19     }
  20
  21     public function test2(): void
  22     {
  23         $showGrants = new ShowGrants('GRANT ALL PRIVILEGES ON `mysql`.* TO \'root\'@\'localhost\' WITH GRANT OPTION');
  24         self::assertSame('ALL PRIVILEGES', $showGrants->grants);
  25         self::assertSame('mysql', $showGrants->dbName);
  26         self::assertSame('*', $showGrants->tableName);
  27     }
  28
  29     public function test3(): void
  30     {
  31         $showGrants = new ShowGrants(
  32             'GRANT SELECT, INSERT, UPDATE, DELETE ON `mysql`.`columns_priv` TO \'root\'@\'localhost\'',
  33         );
  34         self::assertSame('SELECT, INSERT, UPDATE, DELETE', $showGrants->grants);
  35         self::assertSame('mysql', $showGrants->dbName);
  36         self::assertSame('columns_priv', $showGrants->tableName);
  37     }
  38
  39     public function test4(): void
  40     {
  41         $showGrants = new ShowGrants('GRANT ALL PRIVILEGES ON `cptest\_.`.* TO \'cptest\'@\'localhost\'');
  42         self::assertSame('cptest\_.', $showGrants->dbName);
  43
  44         $showGrants = new ShowGrants(
  45             'GRANT ALL PRIVILEGES ON `cptest\_.a.b.c.d.e.f.g.h.i.j.k.'
  46                 . 'l.m.n.o.p.q.r.s.t.u.v.w.x.y.z`.* TO \'cptest\'@\'localhost\'',
  47         );
  48         self::assertSame('cptest\_.a.b.c.d.e.f.g.h.i.j.k.l.m.n.o.p.q.r.s.t.u.v.w.x.y.z', $showGrants->dbName);
  49     }
  50 }