[FEATURE] DBAL 3

[keithbrink]

Following on the work of #519 and #520, I went through the code to fix all the breaking changes related to DBAL 3, as well as some deprecations that came up.

I would prefer to target a new 2.0 branch with this, since there are many breaking changes.

• Removed the Json type since the json_array type has been removed in DBAL 3.
• Removed the MasterSlaveConnection as it has been removed from DBAL 3.
• Removed the FluentExporter, GenerateEntitiesCommand, GenerateRepositoriesCommand, ConvertMappingCommand, as in #520
• Removed the flush option from the various cache clearing commands; these have been in place since the initial commit to this repository, so I couldn't find any reason why it existed in the first place. (Ideas? @patrickbrouwers) Flush is no longer supported by Symfony cache anyways.
• Remove the deprecated namespace feature.
• Updated the PHP CS Fixer file to the new format, using the PSR12 ruleset. Can move this to a separate PR if preferred.
• Bumped the doctrine/orm version requirement to 2.14 due to the new ORMSetup class and the deprecated create method on the EntityManager: https://github.com/doctrine/orm/pull/9961

[dpslwk]

Any reason you did no start with #520 ?? We were close on that PR and just a few tweaks requested, was goin to pick it up myself later in the month to finish off

[keithbrink]

@dpslwk Didn't see it! I'll have a look at it now.

[keithbrink]

Working on converting the caches over, marked as draft for now.

[dpslwk]

MasterSlaveConnection was not remove so much as changed to PrimaryReadReplicaConnection we had a request to make the same changes https://github.com/laravel-doctrine/orm/pull/520#discussion_r973195088 in #520

[keithbrink]

MasterSlaveConnection was not remove so much as changed to PrimaryReadReplicaConnection we had a request to make the same changes #520 (comment) in #520

Yeah, to be more precise, the new PrimaryReadReplica was already supported in Laravel Doctrine, but it also supported the old MasterSlaveConnection for backwards compatibility. This has now been completely removed from DBAL 3: https://github.com/doctrine/dbal/blob/3.5.x/UPGRADE.md#removed-masterslaveconnection

[codecov-commenter]

Codecov Report

Base: 53.56% // Head: 57.94% // Increases project coverage by +4.37% :tada:

Coverage data is based on head (ff3ea4c) compared to base (d2c8bc0). Patch coverage: 78.78% of modified lines in pull request are covered.

:mega: This organization is not using Codecov’s GitHub App Integration. We recommend you install it so Codecov can continue to function properly for your repositories. Learn more

Additional details and impacted files

```diff @@ Coverage Diff @@ ## 2.0 #541 +/- ## ============================================ + Coverage 53.56% 57.94% +4.37% + Complexity 828 660 -168 ============================================ Files 101 92 -9 Lines 2662 2197 -465 ============================================ - Hits 1426 1273 -153 + Misses 1236 924 -312 ``` | [Impacted Files](https://codecov.io/gh/laravel-doctrine/orm/pull/541?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None) | Coverage Δ | | |---|---|---| | [src/Configuration/CustomTypeManager.php](https://codecov.io/gh/laravel-doctrine/orm/pull/541?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None#diff-c3JjL0NvbmZpZ3VyYXRpb24vQ3VzdG9tVHlwZU1hbmFnZXIucGhw) | `100.00% <ø> (ø)` | | | [src/Console/ClearMetadataCacheCommand.php](https://codecov.io/gh/laravel-doctrine/orm/pull/541?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None#diff-c3JjL0NvbnNvbGUvQ2xlYXJNZXRhZGF0YUNhY2hlQ29tbWFuZC5waHA=) | `0.00% <0.00%> (ø)` | | | [src/Console/ClearQueryCacheCommand.php](https://codecov.io/gh/laravel-doctrine/orm/pull/541?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None#diff-c3JjL0NvbnNvbGUvQ2xlYXJRdWVyeUNhY2hlQ29tbWFuZC5waHA=) | `0.00% <0.00%> (ø)` | | | [src/Console/ClearResultCacheCommand.php](https://codecov.io/gh/laravel-doctrine/orm/pull/541?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None#diff-c3JjL0NvbnNvbGUvQ2xlYXJSZXN1bHRDYWNoZUNvbW1hbmQucGhw) | `0.00% <0.00%> (ø)` | | | [src/Console/InfoCommand.php](https://codecov.io/gh/laravel-doctrine/orm/pull/541?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None#diff-c3JjL0NvbnNvbGUvSW5mb0NvbW1hbmQucGhw) | `0.00% <ø> (ø)` | | | [src/Console/MappingImportCommand.php](https://codecov.io/gh/laravel-doctrine/orm/pull/541?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None#diff-c3JjL0NvbnNvbGUvTWFwcGluZ0ltcG9ydENvbW1hbmQucGhw) | `0.00% <0.00%> (ø)` | | | [src/DoctrineManager.php](https://codecov.io/gh/laravel-doctrine/orm/pull/541?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None#diff-c3JjL0RvY3RyaW5lTWFuYWdlci5waHA=) | `85.71% <ø> (-1.25%)` | :arrow_down: | | [src/DoctrineServiceProvider.php](https://codecov.io/gh/laravel-doctrine/orm/pull/541?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None#diff-c3JjL0RvY3RyaW5lU2VydmljZVByb3ZpZGVyLnBocA==) | `0.00% <ø> (ø)` | | | [src/Extensions/ExtensionManager.php](https://codecov.io/gh/laravel-doctrine/orm/pull/541?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None#diff-c3JjL0V4dGVuc2lvbnMvRXh0ZW5zaW9uTWFuYWdlci5waHA=) | `94.59% <ø> (ø)` | | | [src/Queue/FailedJobsServiceProvider.php](https://codecov.io/gh/laravel-doctrine/orm/pull/541?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None#diff-c3JjL1F1ZXVlL0ZhaWxlZEpvYnNTZXJ2aWNlUHJvdmlkZXIucGhw) | `0.00% <0.00%> (ø)` | | | ... and [9 more](https://codecov.io/gh/laravel-doctrine/orm/pull/541?src=pr&el=tree-more&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None) | | Help us with your feedback. Take ten seconds to tell us [how you rate us](https://about.codecov.io/nps?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None). Have a feature suggestion? [Share it here.](https://app.codecov.io/gh/feedback/?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=None)

:umbrella: View full report at Codecov.
:loudspeaker: Do you have feedback about the report comment? Let us know in this issue.

[keithbrink]

Using this branch within my application and all seems to be good - ready for review.

[dpslwk]

Could you add an UPGRADE.md with notes on moving to 2.x version of laravel-doctrine/orm

[keithbrink]

Could you add an UPGRADE.md with notes on moving to 2.x version of laravel-doctrine/orm

Done.

[eigan]

Did some research into the namespaces thing.

• We are creating a MappingDriverChain with a default driver
• This default driver is using the namespace LaravelDoctrine
  • The driver is registered as default, which means that it can be used even though the namespace doesn't match an entity classname.
  • The laravel-doctrine/acl package uses this default driver for its own entities (Permission entity). It calls the MappingDriverChain::addPaths().
• The namespace support we have in orm ^1 works by reusing the same driver for each namespace

Basically the namespace support doesn't seem to have any effect at all. The entities doesn't need to be in any of the namespaces.

[eigan]

@keithbrink I merged 1.7 into 1.8 and noticed the cs-fixer things was already handled there. Sorry about that 🤦🏻‍♂️

[keithbrink]

@eigan No problem, I rebased on 1.8.

[eigan]

@keithbrink Thank you! This is a good starting point for 2.0. Going to update the other laravel-doctrine packages to allow this version soon. Will try to get this out to our staging env tomorrow, then production next friday.

[keithbrink]

@eigan Thanks for getting this across the finish line!