Allow database.url in the config for example for symfony based applications

[amenk]

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

When dumping a database of a symfony project such as Shopware, the database credentials are usually stored in the environment / .env / .env.local in such a format:

DATABASE_URL=mysql://foo:password@localhost:3306/databasename

The configuration file expects the database settings separated.

Describe the solution you'd like

Add optional setting url to the database node which can be used instead of the other fields to specific the database connection URL.

So we could write in the config:

database:
    url: '%env(DATABASE_URL)%'

and then just call

source .env.local
gdpr-dump

which would simplify our scripts.

Describe alternatives you've considered

We currently parse the URL ourselves and pass it on into the environment.

More

What do you think about the future? Is it in scope? Shall we try to provide a PR?

[back-2-95]

Can also help if doing the dump creation e.g. in Github Actions and you'd like to give the DATABASE_URL in one secret instead of e.g. 5

[amenk]

I can try to make a PR, entry point:

gdpr-dump/src/Console/Command/DumpCommand.php

Line 79 in b789cfc

$database = $config->get('database', []);

idea: add a function which parses the URL and pre-populates the fields. Parts of the URL could still be overwritten by the single parameters than, allowing both

probably it can be a config compiler...