class ConnectionTest

Same name in this branch
  1. 9 core/modules/sqlite/tests/src/Unit/ConnectionTest.php \Drupal\Tests\sqlite\Unit\ConnectionTest
  2. 9 core/modules/mysql/tests/src/Kernel/mysql/ConnectionTest.php \Drupal\Tests\mysql\Kernel\mysql\ConnectionTest
  3. 9 core/tests/Drupal/KernelTests/Core/Database/ConnectionTest.php \Drupal\KernelTests\Core\Database\ConnectionTest
  4. 9 core/tests/Drupal/Tests/Core/Database/ConnectionTest.php \Drupal\Tests\Core\Database\ConnectionTest
Same name in other branches
  1. 8.9.x core/tests/Drupal/KernelTests/Core/Database/ConnectionTest.php \Drupal\KernelTests\Core\Database\ConnectionTest
  2. 8.9.x core/tests/Drupal/Tests/Core/Database/Driver/sqlite/ConnectionTest.php \Drupal\Tests\Core\Database\Driver\sqlite\ConnectionTest
  3. 8.9.x core/tests/Drupal/Tests/Core/Database/ConnectionTest.php \Drupal\Tests\Core\Database\ConnectionTest
  4. 10 core/modules/sqlite/tests/src/Unit/ConnectionTest.php \Drupal\Tests\sqlite\Unit\ConnectionTest
  5. 10 core/modules/sqlite/tests/src/Kernel/sqlite/ConnectionTest.php \Drupal\Tests\sqlite\Kernel\sqlite\ConnectionTest
  6. 10 core/modules/mysql/tests/src/Unit/ConnectionTest.php \Drupal\Tests\mysql\Unit\ConnectionTest
  7. 10 core/modules/mysql/tests/src/Kernel/mysql/ConnectionTest.php \Drupal\Tests\mysql\Kernel\mysql\ConnectionTest
  8. 10 core/tests/Drupal/KernelTests/Core/Database/ConnectionTest.php \Drupal\KernelTests\Core\Database\ConnectionTest
  9. 10 core/tests/Drupal/Tests/Core/Database/ConnectionTest.php \Drupal\Tests\Core\Database\ConnectionTest
  10. 11.x core/modules/sqlite/tests/src/Unit/ConnectionTest.php \Drupal\Tests\sqlite\Unit\ConnectionTest
  11. 11.x core/modules/mysql/tests/src/Unit/ConnectionTest.php \Drupal\Tests\mysql\Unit\ConnectionTest
  12. 11.x core/modules/mysql/tests/src/Kernel/mysql/ConnectionTest.php \Drupal\Tests\mysql\Kernel\mysql\ConnectionTest
  13. 11.x core/tests/Drupal/KernelTests/Core/Database/ConnectionTest.php \Drupal\KernelTests\Core\Database\ConnectionTest
  14. 11.x core/tests/Drupal/Tests/Core/Database/ConnectionTest.php \Drupal\Tests\Core\Database\ConnectionTest

Tests MySQL database connections.

@coversDefaultClass \Drupal\mysql\Driver\Database\mysql\Connection @group Database

Hierarchy

Expanded class hierarchy of ConnectionTest

File

core/modules/mysql/tests/src/Unit/ConnectionTest.php, line 15

Namespace

Drupal\Tests\mysql\Unit
View source
class ConnectionTest extends UnitTestCase {
    
    /**
     * A PDO statement prophecy.
     *
     * @var \PDOStatement|\Prophecy\Prophecy\ObjectProphecy
     */
    private $pdoStatement;
    
    /**
     * A PDO object prophecy.
     *
     * @var \PDO|\Prophecy\Prophecy\ObjectProphecy
     */
    private $pdoConnection;
    
    /**
     * {@inheritdoc}
     */
    public function setUp() : void {
        $this->pdoStatement = $this->prophesize(\PDOStatement::class);
        $this->pdoConnection = $this->prophesize(\PDO::class);
    }
    
    /**
     * Creates a Connection object for testing.
     *
     * @return \Drupal\mysql\Driver\Database\mysql\Connection
     */
    private function createConnection() : Connection {
        $this->pdoStatement
            ->setFetchMode(Argument::any())
            ->shouldBeCalled()
            ->willReturn(TRUE);
        $this->pdoStatement
            ->execute(Argument::any())
            ->shouldBeCalled()
            ->willReturn(TRUE);
        $this->pdoConnection
            ->prepare('SELECT VERSION()', Argument::any())
            ->shouldBeCalled()
            ->willReturn($this->pdoStatement
            ->reveal());
        
        /** @var \PDO $pdo_connection */
        $pdo_connection = $this->pdoConnection
            ->reveal();
        return new class ($pdo_connection) extends Connection {
            public function __construct(\PDO $connection) {
                $this->connection = $connection;
                $this->setPrefix('');
            }

};
    }
    
    /**
     * @covers ::version
     * @covers ::isMariaDb
     * @dataProvider providerVersionAndIsMariaDb
     */
    public function testVersionAndIsMariaDb(bool $expected_is_mariadb, string $server_version, string $expected_version) : void {
        $this->pdoStatement
            ->fetchColumn(Argument::any())
            ->shouldBeCalled()
            ->willReturn($server_version);
        $connection = $this->createConnection();
        $is_mariadb = $connection->isMariaDb();
        $version = $connection->version();
        $this->assertSame($expected_is_mariadb, $is_mariadb);
        $this->assertSame($expected_version, $version);
    }
    
    /**
     * Provides test data.
     *
     * @return array
     */
    public function providerVersionAndIsMariaDb() : array {
        return [
            // MariaDB.
[
                TRUE,
                '10.2.0-MariaDB',
                '10.2.0-MariaDB',
            ],
            [
                TRUE,
                '10.2.1-MARIADB',
                '10.2.1-MARIADB',
            ],
            [
                TRUE,
                '10.2.2-alphaX-MARIADB',
                '10.2.2-alphaX-MARIADB',
            ],
            [
                TRUE,
                '5.5.5-10.2.20-MariaDB-1:10.2.20+maria~bionic',
                '10.2.20-MariaDB-1:10.2.20+maria~bionic',
            ],
            [
                TRUE,
                '5.5.5-10.3.22-MariaDB-0+deb10u1',
                '10.3.22-MariaDB-0+deb10u1',
            ],
            [
                TRUE,
                '5.5.5-10.3.22-buzz+-MariaDB-0+deb10u1',
                '10.3.22-buzz+-MariaDB-0+deb10u1',
            ],
            // MySQL.
[
                FALSE,
                '5.5.5-10.2.20-notMariaDB',
                '5.5.5-10.2.20-notMariaDB',
            ],
            [
                FALSE,
                '5.5.5',
                '5.5.5',
            ],
            [
                FALSE,
                '5.5.5-',
                '5.5.5-',
            ],
            [
                FALSE,
                '5.7.28',
                '5.7.28',
            ],
            [
                FALSE,
                '5.7.28-31',
                '5.7.28-31',
            ],
        ];
    }

}

Members

Title Sort descending Deprecated Modifiers Object type Summary Overriden Title Overrides
ConnectionTest::$pdoConnection private property A PDO object prophecy.
ConnectionTest::$pdoStatement private property A PDO statement prophecy.
ConnectionTest::createConnection private function Creates a Connection object for testing.
ConnectionTest::providerVersionAndIsMariaDb public function Provides test data.
ConnectionTest::setUp public function Overrides UnitTestCase::setUp
ConnectionTest::testVersionAndIsMariaDb public function @covers ::version
@covers ::isMariaDb
@dataProvider providerVersionAndIsMariaDb
PhpUnitWarnings::$deprecationWarnings private static property Deprecation warnings from PHPUnit to raise with @trigger_error().
PhpUnitWarnings::addWarning public function Converts PHPUnit deprecation warnings to E_USER_DEPRECATED.
UnitTestCase::$randomGenerator protected property The random generator.
UnitTestCase::$root protected property The app root. 1
UnitTestCase::assertArrayEquals Deprecated protected function Asserts if two arrays are equal by sorting them first.
UnitTestCase::getClassResolverStub protected function Returns a stub class resolver.
UnitTestCase::getConfigFactoryStub public function Returns a stub config factory that behaves according to the passed array.
UnitTestCase::getConfigStorageStub public function Returns a stub config storage that returns the supplied configuration.
UnitTestCase::getContainerWithCacheTagsInvalidator protected function Sets up a container with a cache tags invalidator.
UnitTestCase::getRandomGenerator protected function Gets the random generator for the utility methods.
UnitTestCase::getStringTranslationStub public function Returns a stub translation manager that just returns the passed string.
UnitTestCase::randomMachineName public function Generates a unique random string containing letters and numbers.
UnitTestCase::setUpBeforeClass public static function

Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.