[Feature Request]: Upgrading doctrine/dbal Connection handling

[sven-ahrens]

Is your feature request related to a problem? Please describe.

When I use this package and run my tests, I'm getting mutliple deprecation messages by the package: doctrine/dbal

34x: Subscribing to onSchemaCreateTable events is deprecated. (AbstractPlatform.php:2145 called by AbstractPlatform.php:2064, doctrine/dbal#5784, package doctrine/dbal)

1x: Not configuring a schema manager factory is deprecated. Use Doctrine\DBAL\Schema\DefaultSchemaManagerFactory which is going to be the default in DBAL 4. (Connection.php:221 called by DriverManager.php:197, doctrine/dbal#5812, package doctrine/dbal)

1x: Public access to Connection::connect() is deprecated. (Connection.php:366 called by ORMDatabaseTool.php:180, doctrine/dbal#4966, package doctrine/dbal)

1x: Connection::getSchemaManager() is deprecated, use Connection::createSchemaManager() instead. (Connection.php:1697 called by ORMDatabaseTool.php:182, doctrine/dbal#4515, package doctrine/dbal)

This only ocurrs when I use stuff made by this package like:

$databaseTool = static::getContainer()->get(DatabaseToolCollection::class)->get();

        $databaseTool->loadAliceFixture(

Describe alternatives you've considered

Additional context

• Symfony Version: 7.0.*
• liip/test-fixtures-bundle: 2.7.2
• liip/functional-test-bundle: 4.11.0
• PHPUnit: 9.5
• doctrine/doctrine-bundle 2.11
• PHP Version 8.3
• MariaDB: 10.6.16

Hope this helps as additional context.

The test itself did nothing in this case. I purged everything and just run the code like I mentioned above and then got those deprecation messages.

[alexisLefebvre]

Thanks for the report.

Would you be able to open a PR?

[sven-ahrens]

Thanks for the report.

Would you be able to open a PR?

I'm new to Symfony and this package, but I'm willing to give it a shot this weekend. :)

[Chris53897]

My solution in another PR is like this.
But of course a PR should support multiple versions of doctrine/dbal

LiipTestFixturesBundle/src/Services/DatabaseTools/ORMDatabaseTool.php

Line 183 in b75c271

$tmpConnection = DriverManager::getConnection($params);

[Chris53897]

@sven-ahrens Can this be closed as implemented? https://github.com/liip/LiipTestFixturesBundle/releases/tag/2.7.3

[PromedPromed]

Still an issue with liip/test-fixtures-bundle 2.9.0.

• Subscribing to onSchemaCreateTable events is deprecated. (AbstractPlatform.php:2145 called by AbstractPlatform.php:2064, https://github.com/doctrine/dbal/issues/5784, package doctrine/dbal)
• Not configuring a schema manager factory is deprecated. Use Doctrine\DBAL\Schema\DefaultSchemaManagerFactory which is going to be the default in DBAL 4. (Connection.php:221 called by DriverManager.php:197, https://github.com/doctrine/dbal/issues/5812, package doctrine/dbal)