tests/unit/Dbal/DbiMysqliTest.php

   1 <?php
   2
   3 declare(strict_types=1);
   4
   5 namespace PhpMyAdmin\Tests\Dbal;
   6
   7 use mysqli;
   8 use mysqli_result;
   9 use PhpMyAdmin\Dbal\Connection;
  10 use PhpMyAdmin\Dbal\DbiMysqli;
  11 use PhpMyAdmin\Dbal\MysqliResult;
  12 use PhpMyAdmin\Tests\AbstractTestCase;
  13 use PHPUnit\Framework\Attributes\CoversClass;
  14
  15 #[CoversClass(DbiMysqli::class)]
  16 #[CoversClass(Connection::class)]
  17 class DbiMysqliTest extends AbstractTestCase
  18 {
  19     protected DbiMysqli $object;
  20
  21     /**
  22      * Sets up the fixture, for example, opens a network connection.
  23      * This method is called before a test is executed.
  24      */
  25     protected function setUp(): void
  26     {
  27         parent::setUp();
  28
  29         $this->object = new DbiMysqli();
  30     }
  31
  32     public function testGetClientInfo(): void
  33     {
  34         self::assertNotEmpty($this->object->getClientInfo());
  35     }
  36
  37     /**
  38      * Test for selectDb
  39      */
  40     public function testSelectDb(): void
  41     {
  42         $databaseName = 'test';
  43         $mysqli = self::createMock(mysqli::class);
  44         $mysqli->expects(self::once())
  45             ->method('select_db')
  46             ->with(self::equalTo($databaseName))
  47             ->willReturn(true);
  48
  49         self::assertTrue($this->object->selectDb($databaseName, new Connection($mysqli)));
  50     }
  51
  52     /**
  53      * Test for realMultiQuery
  54      */
  55     public function testRealMultiQuery(): void
  56     {
  57         $query = 'test';
  58         $mysqli = self::createMock(mysqli::class);
  59         $mysqli->expects(self::once())
  60             ->method('multi_query')
  61             ->with(self::equalTo($query))
  62             ->willReturn(true);
  63
  64         self::assertTrue($this->object->realMultiQuery(new Connection($mysqli), $query));
  65     }
  66
  67     /**
  68      * Test for realQuery
  69      */
  70     public function testrealQuery(): void
  71     {
  72         $query = 'test';
  73         $mysqliResult = self::createMock(mysqli_result::class);
  74         $mysqli = self::createMock(mysqli::class);
  75         $mysqli->expects(self::once())
  76             ->method('query')
  77             ->with(self::equalTo($query))
  78             ->willReturn($mysqliResult);
  79
  80         self::assertInstanceOf(MysqliResult::class, $this->object->realQuery($query, new Connection($mysqli)));
  81     }
  82
  83     /**
  84      * Test for nextResult
  85      */
  86     public function testNextResult(): void
  87     {
  88         $mysqli = self::createMock(mysqli::class);
  89         $mysqli->expects(self::once())
  90             ->method('next_result')
  91             ->willReturn(true);
  92
  93         self::assertTrue($this->object->nextResult(new Connection($mysqli)));
  94     }
  95
  96     /**
  97      * Test for storeResult
  98      */
  99     public function testStoreResult(): void
 100     {
 101         $mysqli = self::createMock(mysqli::class);
 102         $mysqliResult = self::createMock(mysqli_result::class);
 103         $mysqli->expects(self::once())
 104             ->method('store_result')
 105             ->willReturn($mysqliResult);
 106
 107         self::assertInstanceOf(MysqliResult::class, $this->object->storeResult(new Connection($mysqli)));
 108     }
 109
 110     /**
 111      * Test for escapeString
 112      */
 113     public function testEscapeString(): void
 114     {
 115         $string = 'test';
 116         $mysqli = self::createMock(mysqli::class);
 117         $mysqli->expects(self::once())
 118             ->method('real_escape_string')
 119             ->willReturn($string);
 120
 121         self::assertSame($string, $this->object->escapeString(new Connection($mysqli), $string));
 122     }
 123
 124     public function testGetWarningCount(): void
 125     {
 126         $mysqli = (object) ['warning_count' => 30];
 127         self::assertSame(30, $this->object->getWarningCount(new Connection($mysqli)));
 128     }
 129 }