Add connection profiler if "--profile" is used for CLI commands

[AndreasA]

PHP Version

8.1

Shopware Version

6.5 & 6.6

Expected behaviour

If the new Symfoyn 6.4+ option "--profile" is used, then I expect the database middleware to be used even in CLI mode.

see https://symfony.com/blog/new-in-symfony-6-4-command-profiler

Actual behaviour

Databae middleware is not used and therefore queries are not collected

How to reproduce

Call any command with --profile and open the command profiler for it. it does not log any queries.

[shopware-issue-bot]

We found the following existing issues which may help or are related to your topic:

• SQL queries are not collected when running web_profiler with CLI commands
• Symfony Profiler shows no doctrine informations
• Elasticsearch Integration into Symfony Profiler
• added optional argument for profile name
• CLI command "database:clean-personal-data" doesn't have any effect
• bin/console import:entity - profile name not found
• NEXT-00000 - Fix profiler table & icons
• [Github] NEXT-00000 - Fix profiler table & icons

[AndreasA]

the easiest solution would be to just replace the check to something like this.

if ((\PHP_SAPI !== 'cli' || (new \Symfony\Component\Console\Input\ArgvInput())->hasParameterOption('--profile')) && $this->environment !== 'prod' && InstalledVersions::isInstalled('symfony/doctrine-bridge')) {

or

if ((\PHP_SAPI !== 'cli' || in_array('--profile', $_SERVER['argv'] ?? [], true)) && $this->environment !== 'prod' && InstalledVersions::isInstalled('symfony/doctrine-bridge')) {