makinacorpus/goat-query-bundle

Symfony bundle for makinacorpus/goat-query

3.1.7 2023-02-14 12:49 UTC

Requires

• php: >=7.4
• makinacorpus/goat-query: ^3.0.14
• makinacorpus/profiling: ^1.1.1 || ^2.0.1
• psr/log: ^1.0 || ^2 || ^3

Requires (Dev)

• doctrine/dbal: ^2.10
• doctrine/sql-formatter: ^1.0
• phpunit/phpunit: 9.*
• symfony/config: ^4.4 || ^5.0
• symfony/console: ^4.0 || ^5.0
• symfony/dependency-injection: ^4.2 || ^5.0
• symfony/event-dispatcher: ^4.0 || ^5.0
• symfony/http-kernel: ^4.4 || ^5.0
• symfony/yaml: ^5.0
• twig/twig: ^3.0

Conflicts

• makinacorpus/goat: <2.0

GPL-2.0-or-later

• Pierre RINEAU
• Régis LEROY
• Simon MELLERIN
• Makina Corpus

• database
• orm
• symfony
• mysql
• postgresql
• pdo

README

This packages provides autoconfiguration and integration of makinacorpus/goat-query for the Symfony framework.

Installation

composer req makinacorpus/goat-query-bundle

Then add the following bundles into your Symfony config/bundles.php file:

return [
    // Your bundles...
    Goat\Query\Symfony\GoatQueryBundle::class => ['all' => true],
];

Usage

If everything was successfuly configured, you may use one of the following classes in dependency injection context (ie. services constructor arguments or controllers action methods parameters):

• Goat\Runner\Runner gives you a runner instance plugged onto the default Doctrine DBAL connection,

• Goat\Query\QueryBuilder gives you a query factory instance.

Configuration

Manual configuration (standalone)

Manually configuring your connections is as simple as:

parameters:
    env(DATABASE_URL): 'pgsql://username:password@host:5432/database'
    env(DATABASE_URL_OTHER): 'pgsql://username:password@host:5432/other'
goat_query:
    runner:
        default:
            url: '%env(resolve:DATABASE_URL)%'
        other:
            url: '%env(resolve:DATABASE_URL_OTHER)%'

Automatic configuration (side by side with Doctrine)

Per default, if you installed and configured Doctrine in Symfony, this bundle will create one runner per Doctrine connexion, re-using Doctrine DBAL PDO connexion for each one, sharing its sessions.

Considering the following Doctrine configuration:

doctrine:
    dbal:
        url: '%env(resolve:DATABASE_URL)%'

You will obtain a single Goat\Runner\Runner instance in the container, named goat.runner.default.

Using a more advanced configuration, such as:

doctrine:
    dbal:
        connections:
            default:
                url: '%env(resolve:DATABASE_URL)%'
            logging:
                url: '%env(resolve:DATABASE_URL)%'

You will obtain 2 different runners:

• goat.runner.default
• goat.runner.logging

No further configuration is required.

Advanced configuration

Runners

A runner is a connection, you may have one or more. Per default, you should always configure the default connection.

Re-using a Doctrine connection

goat_query:
    runner:
        default:
              doctrine_connection: default
              driver: doctrine
              metadata_cache: apcu
              metadata_cache_prefix: "%goat.runner.metadata_cache_prefix%"
    query:
        enabled: true

Using the ext-pgsql driver

goat_query:
    runner:
        default:
              driver: ext-pgsql
              url: '%env(resolve:DATABASE_URL)%'
        logging:
              driver: ext-pgsql
              url: '%env(resolve:DATABASE_URL)%'

You will notice that for ext-pgsl we do not configure a metadata cache, because ext-pgsql is very fast and using APCu to store metadata doesn't bring any performance boost (it would slower the runner actually).

Using <any> driver

The previous section works for any driver, just replace all ext-pgsql section by any of:

• ext-pgsql : for PostgreSQL via PHP ext-pgsql,
• pdo-pgsql : for PostgreSQL via PDO,
• pgsql : for PostgreSQL via driver autoselection (ext-pgsql is prefered),
• pdo-mysql : for MySQL via PDO,
• mysql : for MySQL via driver autoselection (only PDO is supported right now).

More than one database connexion

goat_query:
    runner:
        default:
              doctrine_connection: default
              driver: doctrine
              metadata_cache: apcu
              metadata_cache_prefix: "%goat.runner.metadata_cache_prefix%"
        some_business_connection:
              driver: ext-pgsql
              url: '%env(resolve:ANOTHER_DATABASE_URL)%'
        logging:
              autocommit: true
              doctrine_connection: another_connnection
              driver: doctrine
              metadata_cache: apcu
              metadata_cache_prefix: "%goat.runner.metadata_cache_prefix%"
    query:
        enabled: true

The default runner is the one that per default will be injected into services using the \Goat\Runner\Runner interface as type-hint when using autowiring.

In order to inject a specific runner, you may use the goat.runner.NAME service identifier, in the above example, you would have the following two services available:

• goat.runner.default, the default one,
• goat.runner.logging, the other one.

Driver configuration

Read the `` file in this package for more information.

@todo