tests/unit/Engines/InnodbTest.php

   1 <?php
   2
   3 declare(strict_types=1);
   4
   5 namespace PhpMyAdmin\Tests\Engines;
   6
   7 use PhpMyAdmin\Dbal\DatabaseInterface;
   8 use PhpMyAdmin\Engines\Innodb;
   9 use PhpMyAdmin\Tests\AbstractTestCase;
  10 use PHPUnit\Framework\Attributes\CoversClass;
  11
  12 use function __;
  13
  14 #[CoversClass(Innodb::class)]
  15 class InnodbTest extends AbstractTestCase
  16 {
  17     protected Innodb $object;
  18
  19     /**
  20      * Sets up the fixture, for example, opens a network connection.
  21      * This method is called before a test is executed.
  22      */
  23     protected function setUp(): void
  24     {
  25         parent::setUp();
  26
  27         DatabaseInterface::$instance = $this->createDatabaseInterface();
  28         $this->object = new Innodb('innodb');
  29     }
  30
  31     /**
  32      * Tears down the fixture, for example, closes a network connection.
  33      * This method is called after a test is executed.
  34      */
  35     protected function tearDown(): void
  36     {
  37         parent::tearDown();
  38
  39         unset($this->object);
  40     }
  41
  42     /**
  43      * Test for getVariables
  44      */
  45     public function testGetVariables(): void
  46     {
  47         self::assertSame(
  48             [
  49                 'innodb_data_home_dir' => [
  50                     'title' => __('Data home directory'),
  51                     'desc' => __('The common part of the directory path for all InnoDB data files.'),
  52                 ],
  53                 'innodb_data_file_path' => ['title' => __('Data files')],
  54                 'innodb_autoextend_increment' => [
  55                     'title' => __('Autoextend increment'),
  56                     'desc' => __(
  57                         'The increment size for extending the size of'
  58                         . ' an autoextending tablespace when it becomes full.',
  59                     ),
  60                     'type' => 2,
  61                 ],
  62                 'innodb_buffer_pool_size' => [
  63                     'title' => __('Buffer pool size'),
  64                     'desc' => __('The size of the memory buffer InnoDB uses to cache data and indexes of its tables.'),
  65                     'type' => 1,
  66                 ],
  67                 'innodb_additional_mem_pool_size' => ['title' => 'innodb_additional_mem_pool_size', 'type' => 1],
  68                 'innodb_buffer_pool_awe_mem_mb' => ['type' => 1],
  69                 'innodb_checksums' => [],
  70                 'innodb_commit_concurrency' => [],
  71                 'innodb_concurrency_tickets' => ['type' => 2],
  72                 'innodb_doublewrite' => [],
  73                 'innodb_fast_shutdown' => [],
  74                 'innodb_file_io_threads' => ['type' => 2],
  75                 'innodb_file_per_table' => [],
  76                 'innodb_flush_log_at_trx_commit' => [],
  77                 'innodb_flush_method' => [],
  78                 'innodb_force_recovery' => [],
  79                 'innodb_lock_wait_timeout' => ['type' => 2],
  80                 'innodb_locks_unsafe_for_binlog' => [],
  81                 'innodb_log_arch_dir' => [],
  82                 'innodb_log_archive' => [],
  83                 'innodb_log_buffer_size' => ['type' => 1],
  84                 'innodb_log_file_size' => ['type' => 1],
  85                 'innodb_log_files_in_group' => ['type' => 2],
  86                 'innodb_log_group_home_dir' => [],
  87                 'innodb_max_dirty_pages_pct' => ['type' => 2],
  88                 'innodb_max_purge_lag' => [],
  89                 'innodb_mirrored_log_groups' => ['type' => 2],
  90                 'innodb_open_files' => ['type' => 2],
  91                 'innodb_support_xa' => [],
  92                 'innodb_sync_spin_loops' => ['type' => 2],
  93                 'innodb_table_locks' => ['type' => 3],
  94                 'innodb_thread_concurrency' => ['type' => 2],
  95                 'innodb_thread_sleep_delay' => ['type' => 2],
  96             ],
  97             $this->object->getVariables(),
  98         );
  99     }
 100
 101     /**
 102      * Test for getVariablesLikePattern
 103      */
 104     public function testGetVariablesLikePattern(): void
 105     {
 106         self::assertSame(
 107             'innodb\\_%',
 108             $this->object->getVariablesLikePattern(),
 109         );
 110     }
 111
 112     /**
 113      * Test for getInfoPages
 114      */
 115     public function testGetInfoPages(): void
 116     {
 117         self::assertSame(
 118             [],
 119             $this->object->getInfoPages(),
 120         );
 121         $this->object->support = 2;
 122         self::assertSame(
 123             ['Bufferpool' => 'Buffer Pool', 'Status' => 'InnoDB Status'],
 124             $this->object->getInfoPages(),
 125         );
 126     }
 127
 128     /**
 129      * Test for getPageBufferpool
 130      */
 131     public function testGetPageBufferpool(): void
 132     {
 133         self::assertSame(
 134             '<table class="table table-striped table-hover w-auto float-start caption-top">' . "\n" .
 135             '    <caption>' . "\n" .
 136             '        Buffer Pool Usage' . "\n" .
 137             '    </caption>' . "\n" .
 138             '    <tfoot>' . "\n" .
 139             '        <tr>' . "\n" .
 140             '            <th colspan="2">' . "\n" .
 141             '                Total: 4,096&nbsp;pages / 65,536&nbsp;KiB' . "\n" .
 142             '            </th>' . "\n" .
 143             '        </tr>' . "\n" .
 144             '    </tfoot>' . "\n" .
 145             '    <tbody>' . "\n" .
 146             '        <tr>' . "\n" .
 147             '            <th scope="row">Free pages</th>' . "\n" .
 148             '            <td class="font-monospace text-end">0</td>' . "\n" .
 149             '        </tr>' . "\n" .
 150             '        <tr>' . "\n" .
 151             '            <th scope="row">Dirty pages</th>' . "\n" .
 152             '            <td class="font-monospace text-end">0</td>' . "\n" .
 153             '        </tr>' . "\n" .
 154             '        <tr>' . "\n" .
 155             '            <th scope="row">Pages containing data</th>' . "\n" .
 156             '            <td class="font-monospace text-end">0' . "\n" .
 157             '</td>' . "\n" .
 158             '        </tr>' . "\n" .
 159             '        <tr>' . "\n" .
 160             '            <th scope="row">Pages to be flushed</th>' . "\n" .
 161             '            <td class="font-monospace text-end">0' . "\n" .
 162             '</td>' . "\n" .
 163             '        </tr>' . "\n" .
 164             '        <tr>' . "\n" .
 165             '            <th scope="row">Busy pages</th>' . "\n" .
 166             '            <td class="font-monospace text-end">0' . "\n" .
 167             '</td>' . "\n" .
 168             '        </tr>    </tbody>' . "\n" .
 169             '</table>' . "\n\n" .
 170             '<table class="table table-striped table-hover w-auto ms-4 float-start caption-top">' . "\n" .
 171             '    <caption>' . "\n" .
 172             '        Buffer Pool Activity' . "\n" .
 173             '    </caption>' . "\n" .
 174             '    <tbody>' . "\n" .
 175             '        <tr>' . "\n" .
 176             '            <th scope="row">Read requests</th>' . "\n" .
 177             '            <td class="font-monospace text-end">64' . "\n" .
 178             '</td>' . "\n" .
 179             '        </tr>' . "\n" .
 180             '        <tr>' . "\n" .
 181             '            <th scope="row">Write requests</th>' . "\n" .
 182             '            <td class="font-monospace text-end">64' . "\n" .
 183             '</td>' . "\n" .
 184             '        </tr>' . "\n" .
 185             '        <tr>' . "\n" .
 186             '            <th scope="row">Read misses</th>' . "\n" .
 187             '            <td class="font-monospace text-end">32' . "\n" .
 188             '</td>' . "\n" .
 189             '        </tr>' . "\n" .
 190             '        <tr>' . "\n" .
 191             '            <th scope="row">Write waits</th>' . "\n" .
 192             '            <td class="font-monospace text-end">0' . "\n" .
 193             '</td>' . "\n" .
 194             '        </tr>' . "\n" .
 195             '        <tr>' . "\n" .
 196             '            <th scope="row">Read misses in %</th>' . "\n" .
 197             '            <td class="font-monospace text-end">50   %' . "\n" .
 198             '</td>' . "\n" .
 199             '        </tr>' . "\n" .
 200             '        <tr>' . "\n" .
 201             '            <th scope="row">Write waits in %</th>' . "\n" .
 202             '            <td class="font-monospace text-end">0 %' . "\n" .
 203             '</td>' . "\n" .
 204             '        </tr>' . "\n" .
 205             '    </tbody>' . "\n" .
 206             '</table>' . "\n",
 207             $this->object->getPageBufferpool(),
 208         );
 209     }
 210
 211     /**
 212      * Test for getPageStatus
 213      */
 214     public function testGetPageStatus(): void
 215     {
 216         self::assertSame(
 217             '<pre id="pre_innodb_status">' . "\n\n" . '</pre>' . "\n",
 218             $this->object->getPageStatus(),
 219         );
 220     }
 221
 222     /**
 223      * Test for getPage
 224      */
 225     public function testGetPage(): void
 226     {
 227         self::assertSame(
 228             '',
 229             $this->object->getPage('Status'),
 230         );
 231         $this->object->support = 2;
 232         self::assertSame(
 233             '<pre id="pre_innodb_status">' . "\n\n" . '</pre>' . "\n",
 234             $this->object->getPage('Status'),
 235         );
 236     }
 237
 238     /**
 239      * Test for getMysqlHelpPage
 240      */
 241     public function testGetMysqlHelpPage(): void
 242     {
 243         self::assertSame(
 244             'innodb-storage-engine',
 245             $this->object->getMysqlHelpPage(),
 246         );
 247     }
 248
 249     /**
 250      * Test for getInnodbPluginVersion
 251      */
 252     public function testGetInnodbPluginVersion(): void
 253     {
 254         self::assertSame(
 255             '1.1.8',
 256             $this->object->getInnodbPluginVersion(),
 257         );
 258     }
 259
 260     /**
 261      * Test for supportsFilePerTable
 262      */
 263     public function testSupportsFilePerTable(): void
 264     {
 265         self::assertFalse(
 266             $this->object->supportsFilePerTable(),
 267         );
 268     }
 269
 270     /**
 271      * Test for getInnodbFileFormat
 272      */
 273     public function testGetInnodbFileFormat(): void
 274     {
 275         self::assertSame(
 276             'Antelope',
 277             $this->object->getInnodbFileFormat(),
 278         );
 279     }
 280 }