class UrlConversionTest

Same name in other branches
  1. 8.9.x core/tests/Drupal/Tests/Core/Database/UrlConversionTest.php \Drupal\Tests\Core\Database\UrlConversionTest
  2. 10 core/tests/Drupal/Tests/Core/Database/UrlConversionTest.php \Drupal\Tests\Core\Database\UrlConversionTest
  3. 11.x core/tests/Drupal/Tests/Core/Database/UrlConversionTest.php \Drupal\Tests\Core\Database\UrlConversionTest

Tests for database URL to/from database connection array conversions.

These tests run in isolation since we don't want the database static to affect other tests.

@coversDefaultClass \Drupal\Core\Database\Database

@runTestsInSeparateProcesses @preserveGlobalState disabled

@group Database

Hierarchy

Expanded class hierarchy of UrlConversionTest

File

core/tests/Drupal/Tests/Core/Database/UrlConversionTest.php, line 21

Namespace

Drupal\Tests\Core\Database
View source
class UrlConversionTest extends UnitTestCase {
    
    /**
     * {@inheritdoc}
     */
    protected function setUp() : void {
        parent::setUp();
        $this->root = dirname(__FILE__, 7);
        // Mock the container so we don't need to mock drupal_valid_test_ua().
        // @see \Drupal\Core\Extension\ExtensionDiscovery::scan()
        $container = $this->createMock('Symfony\\Component\\DependencyInjection\\ContainerInterface');
        $container->expects($this->any())
            ->method('has')
            ->with('kernel')
            ->willReturn(TRUE);
        $container->expects($this->any())
            ->method('getParameter')
            ->with('site.path')
            ->willReturn('');
        \Drupal::setContainer($container);
    }
    
    /**
     * @covers ::convertDbUrlToConnectionInfo
     *
     * @dataProvider providerConvertDbUrlToConnectionInfo
     */
    public function testDbUrlToConnectionConversion($url, $database_array, $include_test_drivers) {
        $result = Database::convertDbUrlToConnectionInfo($url, $this->root, $include_test_drivers);
        $this->assertEquals($database_array, $result);
    }
    
    /**
     * Data provider for testDbUrlToConnectionConversion().
     *
     * @return array
     *   Array of arrays with the following elements:
     *   - url: The full URL string to be tested.
     *   - database_array: An array containing the expected results.
     */
    public function providerConvertDbUrlToConnectionInfo() {
        $root = dirname(__FILE__, 7);
        return [
            'MySql without prefix' => [
                'mysql://test_user:test_pass@test_host:3306/test_database',
                [
                    'driver' => 'mysql',
                    'username' => 'test_user',
                    'password' => 'test_pass',
                    'host' => 'test_host',
                    'database' => 'test_database',
                    'port' => 3306,
                    'namespace' => 'Drupal\\mysql\\Driver\\Database\\mysql',
                    'autoload' => 'core/modules/mysql/src/Driver/Database/mysql/',
                ],
                FALSE,
            ],
            'SQLite, relative to root, without prefix' => [
                'sqlite://localhost/test_database',
                [
                    'driver' => 'sqlite',
                    'host' => 'localhost',
                    'database' => $root . '/test_database',
                    'namespace' => 'Drupal\\sqlite\\Driver\\Database\\sqlite',
                    'autoload' => 'core/modules/sqlite/src/Driver/Database/sqlite/',
                ],
                FALSE,
            ],
            'MySql with prefix' => [
                'mysql://test_user:test_pass@test_host:3306/test_database#bar',
                [
                    'driver' => 'mysql',
                    'username' => 'test_user',
                    'password' => 'test_pass',
                    'host' => 'test_host',
                    'database' => 'test_database',
                    'prefix' => 'bar',
                    'port' => 3306,
                    'namespace' => 'Drupal\\mysql\\Driver\\Database\\mysql',
                    'autoload' => 'core/modules/mysql/src/Driver/Database/mysql/',
                ],
                FALSE,
            ],
            'SQLite, relative to root, with prefix' => [
                'sqlite://localhost/test_database#foo',
                [
                    'driver' => 'sqlite',
                    'host' => 'localhost',
                    'database' => $root . '/test_database',
                    'prefix' => 'foo',
                    'namespace' => 'Drupal\\sqlite\\Driver\\Database\\sqlite',
                    'autoload' => 'core/modules/sqlite/src/Driver/Database/sqlite/',
                ],
                FALSE,
            ],
            'SQLite, absolute path, without prefix' => [
                'sqlite://localhost//baz/test_database',
                [
                    'driver' => 'sqlite',
                    'host' => 'localhost',
                    'database' => '/baz/test_database',
                    'namespace' => 'Drupal\\sqlite\\Driver\\Database\\sqlite',
                    'autoload' => 'core/modules/sqlite/src/Driver/Database/sqlite/',
                ],
                FALSE,
            ],
            'MySQL contrib test driver without prefix' => [
                'DrivertestMysql://test_user:test_pass@test_host:3306/test_database?module=driver_test',
                [
                    'driver' => 'DrivertestMysql',
                    'username' => 'test_user',
                    'password' => 'test_pass',
                    'host' => 'test_host',
                    'database' => 'test_database',
                    'port' => 3306,
                    'namespace' => 'Drupal\\driver_test\\Driver\\Database\\DrivertestMysql',
                    'autoload' => 'core/modules/system/tests/modules/driver_test/src/Driver/Database/DrivertestMysql/',
                ],
                TRUE,
            ],
            'MySQL contrib test driver with prefix' => [
                'DrivertestMysql://test_user:test_pass@test_host:3306/test_database?module=driver_test#bar',
                [
                    'driver' => 'DrivertestMysql',
                    'username' => 'test_user',
                    'password' => 'test_pass',
                    'host' => 'test_host',
                    'database' => 'test_database',
                    'prefix' => 'bar',
                    'port' => 3306,
                    'namespace' => 'Drupal\\driver_test\\Driver\\Database\\DrivertestMysql',
                    'autoload' => 'core/modules/system/tests/modules/driver_test/src/Driver/Database/DrivertestMysql/',
                ],
                TRUE,
            ],
            'PostgreSQL contrib test driver without prefix' => [
                'DrivertestPgsql://test_user:test_pass@test_host:5432/test_database?module=driver_test',
                [
                    'driver' => 'DrivertestPgsql',
                    'username' => 'test_user',
                    'password' => 'test_pass',
                    'host' => 'test_host',
                    'database' => 'test_database',
                    'port' => 5432,
                    'namespace' => 'Drupal\\driver_test\\Driver\\Database\\DrivertestPgsql',
                    'autoload' => 'core/modules/system/tests/modules/driver_test/src/Driver/Database/DrivertestPgsql/',
                ],
                TRUE,
            ],
            'PostgreSQL contrib test driver with prefix' => [
                'DrivertestPgsql://test_user:test_pass@test_host:5432/test_database?module=driver_test#bar',
                [
                    'driver' => 'DrivertestPgsql',
                    'username' => 'test_user',
                    'password' => 'test_pass',
                    'host' => 'test_host',
                    'database' => 'test_database',
                    'prefix' => 'bar',
                    'port' => 5432,
                    'namespace' => 'Drupal\\driver_test\\Driver\\Database\\DrivertestPgsql',
                    'autoload' => 'core/modules/system/tests/modules/driver_test/src/Driver/Database/DrivertestPgsql/',
                ],
                TRUE,
            ],
            'MySql with a custom query parameter' => [
                'mysql://test_user:test_pass@test_host:3306/test_database?extra=value',
                [
                    'driver' => 'mysql',
                    'username' => 'test_user',
                    'password' => 'test_pass',
                    'host' => 'test_host',
                    'database' => 'test_database',
                    'port' => 3306,
                    'namespace' => 'Drupal\\mysql\\Driver\\Database\\mysql',
                    'autoload' => 'core/modules/mysql/src/Driver/Database/mysql/',
                ],
                FALSE,
            ],
            'MySql with the module name mysql' => [
                'mysql://test_user:test_pass@test_host:3306/test_database?module=mysql',
                [
                    'driver' => 'mysql',
                    'username' => 'test_user',
                    'password' => 'test_pass',
                    'host' => 'test_host',
                    'database' => 'test_database',
                    'port' => 3306,
                    'namespace' => 'Drupal\\mysql\\Driver\\Database\\mysql',
                    'autoload' => 'core/modules/mysql/src/Driver/Database/mysql/',
                ],
                FALSE,
            ],
            'PostgreSql without the module name set' => [
                'pgsql://test_user:test_pass@test_host/test_database',
                [
                    'driver' => 'pgsql',
                    'username' => 'test_user',
                    'password' => 'test_pass',
                    'host' => 'test_host',
                    'database' => 'test_database',
                    'namespace' => 'Drupal\\pgsql\\Driver\\Database\\pgsql',
                    'autoload' => 'core/modules/pgsql/src/Driver/Database/pgsql/',
                ],
                FALSE,
            ],
            'PostgreSql with the module name pgsql' => [
                'pgsql://test_user:test_pass@test_host/test_database?module=pgsql',
                [
                    'driver' => 'pgsql',
                    'username' => 'test_user',
                    'password' => 'test_pass',
                    'host' => 'test_host',
                    'database' => 'test_database',
                    'namespace' => 'Drupal\\pgsql\\Driver\\Database\\pgsql',
                    'autoload' => 'core/modules/pgsql/src/Driver/Database/pgsql/',
                ],
                FALSE,
            ],
            'SQLite, relative to root, without prefix and with the module name sqlite' => [
                'sqlite://localhost/test_database?module=sqlite',
                [
                    'driver' => 'sqlite',
                    'host' => 'localhost',
                    'database' => $root . '/test_database',
                    'namespace' => 'Drupal\\sqlite\\Driver\\Database\\sqlite',
                    'autoload' => 'core/modules/sqlite/src/Driver/Database/sqlite/',
                ],
                FALSE,
            ],
        ];
    }
    
    /**
     * Tests ::convertDbUrlToConnectionInfo() exception for invalid arguments.
     *
     * @dataProvider providerInvalidArgumentsUrlConversion
     */
    public function testGetInvalidArgumentExceptionInUrlConversion($url, $root, $expected_exception_message) {
        $this->expectException(\InvalidArgumentException::class);
        $this->expectExceptionMessage($expected_exception_message);
        Database::convertDbUrlToConnectionInfo($url, $root);
    }
    
    /**
     * Data provider for testGetInvalidArgumentExceptionInUrlConversion().
     *
     * @return array
     *   Array of arrays with the following elements:
     *   - An invalid URL string.
     *   - Drupal root string.
     *   - The expected exception message.
     */
    public function providerInvalidArgumentsUrlConversion() {
        return [
            [
                'foo',
                '',
                "Missing scheme in URL 'foo'",
            ],
            [
                'foo',
                'bar',
                "Missing scheme in URL 'foo'",
            ],
            [
                'foo://',
                'bar',
                "Can not convert 'foo://' to a database connection, class 'Drupal\\Driver\\Database\\foo\\Connection' does not exist",
            ],
            [
                'foo://bar',
                'baz',
                "Can not convert 'foo://bar' to a database connection, class 'Drupal\\Driver\\Database\\foo\\Connection' does not exist",
            ],
            [
                'foo://bar:port',
                'baz',
                "Can not convert 'foo://bar:port' to a database connection, class 'Drupal\\Driver\\Database\\foo\\Connection' does not exist",
            ],
            [
                'foo/bar/baz',
                'bar2',
                "Missing scheme in URL 'foo/bar/baz'",
            ],
            [
                'foo://bar:baz@test1',
                'test2',
                "Can not convert 'foo://bar:baz@test1' to a database connection, class 'Drupal\\Driver\\Database\\foo\\Connection' does not exist",
            ],
        ];
    }
    
    /**
     * @covers ::getConnectionInfoAsUrl
     *
     * @dataProvider providerGetConnectionInfoAsUrl
     */
    public function testGetConnectionInfoAsUrl(array $info, $expected_url) {
        Database::addConnectionInfo('default', 'default', $info);
        $url = Database::getConnectionInfoAsUrl();
        $this->assertEquals($expected_url, $url);
    }
    
    /**
     * Data provider for testGetConnectionInfoAsUrl().
     *
     * @return array
     *   Array of arrays with the following elements:
     *   - An array mocking the database connection info. Possible keys are
     *     database, username, password, prefix, host, port, namespace and driver.
     *   - The expected URL after conversion.
     */
    public function providerGetConnectionInfoAsUrl() {
        $info1 = [
            'database' => 'test_database',
            'username' => 'test_user',
            'password' => 'test_pass',
            'prefix' => '',
            'host' => 'test_host',
            'port' => '3306',
            'driver' => 'mysql',
        ];
        $expected_url1 = 'mysql://test_user:test_pass@test_host:3306/test_database?module=mysql';
        $info2 = [
            'database' => 'test_database',
            'username' => 'test_user',
            'password' => 'test_pass',
            'prefix' => 'pre',
            'host' => 'test_host',
            'port' => '3306',
            'driver' => 'mysql',
        ];
        $expected_url2 = 'mysql://test_user:test_pass@test_host:3306/test_database?module=mysql#pre';
        $info3 = [
            'database' => 'test_database',
            'driver' => 'sqlite',
        ];
        $expected_url3 = 'sqlite://localhost/test_database?module=sqlite';
        $info4 = [
            'database' => 'test_database',
            'driver' => 'sqlite',
            'prefix' => 'pre',
        ];
        $expected_url4 = 'sqlite://localhost/test_database?module=sqlite#pre';
        $info5 = [
            'database' => 'test_database',
            'username' => 'test_user',
            'password' => 'test_pass',
            'prefix' => '',
            'host' => 'test_host',
            'port' => '3306',
            'driver' => 'DrivertestMysql',
            'namespace' => 'Drupal\\driver_test\\Driver\\Database\\DrivertestMysql',
            'autoload' => 'core/modules/system/tests/modules/driver_test/src/Driver/Database/DrivertestMysql/',
        ];
        $expected_url5 = 'DrivertestMysql://test_user:test_pass@test_host:3306/test_database?module=driver_test';
        $info6 = [
            'database' => 'test_database',
            'username' => 'test_user',
            'password' => 'test_pass',
            'prefix' => 'pre',
            'host' => 'test_host',
            'port' => '3306',
            'driver' => 'DrivertestMysql',
            'namespace' => 'Drupal\\driver_test\\Driver\\Database\\DrivertestMysql',
            'autoload' => 'core/modules/system/tests/modules/driver_test/src/Driver/Database/DrivertestMysql/',
        ];
        $expected_url6 = 'DrivertestMysql://test_user:test_pass@test_host:3306/test_database?module=driver_test#pre';
        $info7 = [
            'database' => 'test_database',
            'username' => 'test_user',
            'password' => 'test_pass',
            'prefix' => '',
            'host' => 'test_host',
            'port' => '5432',
            'driver' => 'DrivertestPgsql',
            'namespace' => 'Drupal\\driver_test\\Driver\\Database\\DrivertestPgsql',
            'autoload' => 'core/modules/system/tests/modules/driver_test/src/Driver/Database/drivertestpqsql/',
        ];
        $expected_url7 = 'DrivertestPgsql://test_user:test_pass@test_host:5432/test_database?module=driver_test';
        $info8 = [
            'database' => 'test_database',
            'username' => 'test_user',
            'password' => 'test_pass',
            'prefix' => 'pre',
            'host' => 'test_host',
            'port' => '5432',
            'driver' => 'DrivertestPgsql',
            'namespace' => 'Drupal\\driver_test\\Driver\\Database\\DrivertestPgsql',
            'autoload' => 'core/modules/system/tests/modules/driver_test/src/Driver/Database/drivertestpqsql/',
        ];
        $expected_url8 = 'DrivertestPgsql://test_user:test_pass@test_host:5432/test_database?module=driver_test#pre';
        return [
            [
                $info1,
                $expected_url1,
            ],
            [
                $info2,
                $expected_url2,
            ],
            [
                $info3,
                $expected_url3,
            ],
            [
                $info4,
                $expected_url4,
            ],
            [
                $info5,
                $expected_url5,
            ],
            [
                $info6,
                $expected_url6,
            ],
            [
                $info7,
                $expected_url7,
            ],
            [
                $info8,
                $expected_url8,
            ],
        ];
    }
    
    /**
     * Tests ::getConnectionInfoAsUrl() exception for invalid arguments.
     *
     * @covers ::getConnectionInfoAsUrl
     *
     * @param array $connection_options
     *   The database connection information.
     * @param string $expected_exception_message
     *   The expected exception message.
     *
     * @dataProvider providerInvalidArgumentGetConnectionInfoAsUrl
     */
    public function testGetInvalidArgumentGetConnectionInfoAsUrl(array $connection_options, $expected_exception_message) {
        Database::addConnectionInfo('default', 'default', $connection_options);
        $this->expectException(\InvalidArgumentException::class);
        $this->expectExceptionMessage($expected_exception_message);
        $url = Database::getConnectionInfoAsUrl();
    }
    
    /**
     * Data provider for testGetInvalidArgumentGetConnectionInfoAsUrl().
     *
     * @return array
     *   Array of arrays with the following elements:
     *   - An array mocking the database connection info. Possible keys are
     *     database, username, password, prefix, host, port, namespace and driver.
     *   - The expected exception message.
     */
    public function providerInvalidArgumentGetConnectionInfoAsUrl() {
        return [
            'Missing database key' => [
                [
                    'driver' => 'sqlite',
                    'host' => 'localhost',
                    'namespace' => 'Drupal\\sqlite\\Driver\\Database\\sqlite',
                ],
                "As a minimum, the connection options array must contain at least the 'driver' and 'database' keys",
            ],
        ];
    }
    
    /**
     * @covers ::convertDbUrlToConnectionInfo
     */
    public function testDriverModuleDoesNotExist() {
        $url = 'mysql://test_user:test_pass@test_host:3306/test_database?module=does_not_exist';
        $this->expectException(\RuntimeException::class);
        $this->expectExceptionMessage("Cannot find the module 'does_not_exist' for the database driver namespace 'Drupal\\does_not_exist\\Driver\\Database\\mysql'");
        Database::convertDbUrlToConnectionInfo($url, $this->root, TRUE);
    }
    
    /**
     * @covers ::convertDbUrlToConnectionInfo
     */
    public function testModuleDriverDoesNotExist() {
        $url = 'mysql://test_user:test_pass@test_host:3306/test_database?module=driver_test';
        $this->expectException(\RuntimeException::class);
        $this->expectExceptionMessage("Cannot find the database driver namespace 'Drupal\\driver_test\\Driver\\Database\\mysql' in module 'driver_test'");
        Database::convertDbUrlToConnectionInfo($url, $this->root, TRUE);
    }

}

Members

Title Sort descending Deprecated Modifiers Object type Summary Overriden Title Overrides
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
UrlConversionTest::providerConvertDbUrlToConnectionInfo public function Data provider for testDbUrlToConnectionConversion().
UrlConversionTest::providerGetConnectionInfoAsUrl public function Data provider for testGetConnectionInfoAsUrl().
UrlConversionTest::providerInvalidArgumentGetConnectionInfoAsUrl public function Data provider for testGetInvalidArgumentGetConnectionInfoAsUrl().
UrlConversionTest::providerInvalidArgumentsUrlConversion public function Data provider for testGetInvalidArgumentExceptionInUrlConversion().
UrlConversionTest::setUp protected function Overrides UnitTestCase::setUp
UrlConversionTest::testDbUrlToConnectionConversion public function @covers ::convertDbUrlToConnectionInfo
UrlConversionTest::testDriverModuleDoesNotExist public function @covers ::convertDbUrlToConnectionInfo
UrlConversionTest::testGetConnectionInfoAsUrl public function @covers ::getConnectionInfoAsUrl
UrlConversionTest::testGetInvalidArgumentExceptionInUrlConversion public function Tests ::convertDbUrlToConnectionInfo() exception for invalid arguments.
UrlConversionTest::testGetInvalidArgumentGetConnectionInfoAsUrl public function Tests ::getConnectionInfoAsUrl() exception for invalid arguments.
UrlConversionTest::testModuleDriverDoesNotExist public function @covers ::convertDbUrlToConnectionInfo

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