Add unit test for the DatabaseInterface::prepare method

MauricioFauth · MauricioFauth · commit a3228b8d54de · 2022-09-02T21:06:26.000-03:00
Signed-off-by: Maurício Meneghini Fauth &lt;mauricio@fauth.dev&gt;
diff --git a/test/classes/DatabaseInterfaceTest.php b/test/classes/DatabaseInterfaceTest.php
@@ -4,9 +4,11 @@
 
 namespace PhpMyAdmin\Tests;
 
+use mysqli_stmt;
 use PhpMyAdmin\ConfigStorage\Relation;
 use PhpMyAdmin\Database\DatabaseList;
 use PhpMyAdmin\DatabaseInterface;
+use PhpMyAdmin\Dbal\DbiExtension;
 use PhpMyAdmin\Dbal\ResultInterface;
 use PhpMyAdmin\Query\Utilities;
 use PhpMyAdmin\SystemDatabase;
@@ -718,4 +720,17 @@ public function testGetDatabasesFullDisabledISAndSortIntColumn(): void
 
         $dummyDbi->assertAllQueriesConsumed();
     }
+
+    public function testPrepare(): void
+    {
+        $query = 'SELECT * FROM `mysql`.`user` WHERE `User` = ? AND `Host` = ?;';
+        $stmtStub = $this->createStub(mysqli_stmt::class);
+        $dummyDbi = $this->createMock(DbiExtension::class);
+        $dummyDbi->expects($this->once())->method('prepare')
+            ->with($this->identicalTo(2), $this->equalTo($query))
+            ->willReturn($stmtStub);
+        $dbi = $this->createDatabaseInterface($dummyDbi);
+        $stmt = $dbi->prepare($query, DatabaseInterface::CONNECT_CONTROL);
+        $this->assertSame($stmtStub, $stmt);
+    }
 }
