Bump doctrine/dbal from 2.13.9 to 3.6.0

[dependabot[bot]]

Bumps doctrine/dbal from 2.13.9 to 3.6.0.

Release notes

Sourced from doctrine/dbal's releases.

3.6.0

Release Notes for 3.6.0

3.6.0

• Total issues resolved: 0
• Total pull requests resolved: 20
• Total contributors: 2

CI,MariaDB

• 5913: Run tests with MariaDB 10.10 thanks to @​derrabus

Drivers,Improvement,PostgreSQL,pgsql

• 5908: Free pgsql results on destruct thanks to @​derrabus
• 5889: Optimize pgsql queries without parameters thanks to @​derrabus

Drivers,Improvement,PostgreSQL,Prepared Statements,pgsql

• 5893: Deallocate prepared statements in destructor thanks to @​derrabus

Bug,Connections,PostgreSQL,pgsql

• 5892: Close pgsql connection in destructor thanks to @​derrabus

Drivers,Error Handling,Improvement,PostgreSQL,pgsql

• 5888: Raise exception if pg_send_*() calls fail thanks to @​derrabus

Documentation

• 5878: Prepare release 3.6.0 thanks to @​derrabus

Static Analysis

• 5877: Use psalm-assert to get rid of assert() calls thanks to @​derrabus
• 5855: Reuse the Params type alias for getConnection() thanks to @​derrabus
• 5854: Test the return type of DriverManager::getAvailableDrivers() thanks to @​MidnightDesign
• 5853: Use a narrower return type for DriverManager::getAvailableDrivers() thanks to @​MidnightDesign

Deprecation,New Feature

• 5876: Introduce the SchemaManagerFactory interface thanks to @​derrabus

Configuration,Connecting,New Feature,PHP

• 5866: Flag parameters as sensitive if they could contain the database password thanks to @​derrabus

... (truncated)

Upgrade guide

Sourced from doctrine/dbal's upgrade guide.

Note about upgrading: Doctrine uses static and runtime mechanisms to raise awareness about deprecated code.

• Use of @deprecated docblock that is detected by IDEs (like PHPStorm) or Static Analysis tools (like Psalm, phpstan)
• Use of our low-overhead runtime deprecation API, details: https://github.com/doctrine/deprecations/

Upgrade to 3.6

Deprecated not setting a schema manager factory

DBAL 4 will change the way the schema manager is created. To opt in to the new behavior, please configure the schema manager factory:

$configuration = new Configuration();
$configuration->setSchemaManagerFactory(new DefaultSchemaManagerFactory());
$connection = DriverManager::getConnection(
[/* your parameters */],
$configuration,
);

If you use a custom platform implementation, please make sure it implements the createSchemaManager()method . Otherwise, the connection will fail to create a schema manager.

Deprecated the url connection parameter

DBAL ships with a new and configurable DSN parser that can be used to parse a database URL into connection parameters understood by DriverManager.

Before

$connection = DriverManager::getConnection(
    ['url' => 'mysql://my-user:t0ps3cr3t@my-host/my-database']
);

After

$dsnParser  = new DsnParser(['mysql' => 'pdo_mysql']);
$connection = DriverManager::getConnection(
    $dsnParser->parse('mysql://my-user:t0ps3cr3t@my-host/my-database')
);

... (truncated)

Commits

• 85b98cb Merge pull request #5913 from derrabus/ci/mariadb-10.10
• 73a8501 Merge pull request #5878 from derrabus/chore/prepare-release
• ca5bc62 Run tests with MariaDB 10.10
• 0b56647 Prepare 3.6.0
• cb208f8 Merge 3.5.x into 3.6.x (#5911)
• e002157 Merge pull request #5910 from derrabus/bump/automatic-releases
• 7d00d3d Bump laminas/automatic-releases to 1.24.0
• b5bf7dc Merge pull request #5908 from derrabus/bugfix/free-result-on-destruct
• ef04fd9 Merge pull request #5907 from derrabus/bump/phpunit
• 3c1ad27 Free pgsql results on destruct
• Additional commits viewable in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

---

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot merge` will merge this PR after your CI passes on it - `@dependabot squash and merge` will squash and merge this PR after your CI passes on it - `@dependabot cancel merge` will cancel a previously requested merge and block automerging - `@dependabot reopen` will reopen this PR if it is closed - `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually - `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

[dependabot[bot]]

Superseded by #170.