.docs

Contributte Doctrine DBAL

Doctrine/DBAL for Nette Framework.

Content

• Setup
• Relying
• Configuration
• Usage
  • Types
  • Debug
  • Events
• Bridges
  • PSR3
• Examples
• Other

Setup

Install package

composer require nettrine/dbal

Register extension

extensions:
  nettrine.dbal: Nettrine\DBAL\DI\DbalExtension

Relying

Take advantage of enpowering this package with 2 extra packages:

• doctrine/cache
• symfony/console

doctrine/cache

This package relies on doctrine/cache, use prepared nettrine/cache integration.

composer require nettrine/cache

extensions:
  nettrine.cache: Nettrine\Cache\DI\CacheExtension

Doctrine DBAL needs Doctrine Cache to be configured. If you register nettrine/cache extension it will detect it automatically.

symfony/console

This package relies on symfony/console, use prepared contributte/console integration.

composer require contributte/console

extensions:
  console: Contributte\Console\DI\ConsoleExtension(%consoleMode%)

  nettrine.dbal: Nettrine\DBAL\DI\DbalExtension
  nettrine.dbal.console: Nettrine\DBAL\DI\DbalConsoleExtension(%consoleMode%)

Since this moment when you type bin/console, there'll be registered commands from Doctrine DBAL.

Configuration

Schema definition

nettrine.dbal:
 debug:
   panel: <boolean>
   sourcePaths: <string[]>
 configuration:
   sqlLogger: <service>
   resultCache: <service>
   filterSchemaAssetsExpression: <string>
   autoCommit: <boolean>

 connection:
   url: <string>
   pdo: <string>
   memory: <string>
   driver: <string>
   driverClass: <string>
   host: <string>
   dbname: <string>
   servicename: <string>
   user: <string>
   password: <string>
   charset: <string>
   portability: <int>
   fetchCase: <int>
   persistent: <boolean>
   wrapperClass: <class>
   types: []
   typesMapping: []

Under the hood

Minimal configuration could look like this:

nettrine.dbal:
  debug:
    panel: %debugMode%
    sourcePaths: [%appDir%]
  connection:
    host: localhost
    driver: mysqli
    dbname: nettrine
    user: root
    password: root

Take a look at real Nettrine DBAL configuration example at contributte/webapp-project.

Types

Here is an example of how to register custom type for UUID.

dbal:
  connection:
    types:
      uuid: Ramsey\Uuid\Doctrine\UuidType

      uuid_binary_ordered_time:
        class: Ramsey\Uuid\Doctrine\UuidBinaryOrderedTimeType
        commented: false

    typesMapping:
      uuid_binary_ordered_time: binary

For more information about custom types, take a look at the official documention.

• http://docs.doctrine-project.org/projects/doctrine-dbal/en/latest/reference/types.html
• http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/cookbook/custom-mapping-types.html

Debug

Enable or disable Tracy panel via debug.panel key.

Alternatively, specify your application root path under the debug.sourcePaths key to display correct queries source map in Tracy panel.

Events

You can use native Doctrine DBAL event system.

Create your subscriber class by implementing the EventSubscriber interface. Dependency injection with autowiring is enabled.

namespace App;

use Doctrine\Common\EventSubscriber;
use Doctrine\DBAL\Event\ConnectionEventArgs;
use Doctrine\DBAL\Events;

final class PostConnectSubscriber implements EventSubscriber
{
  public function postConnect(ConnectionEventArgs $args): void
  {
    // Magic goes here...
  }

  public function getSubscribedEvents(): array
  {
    return [Events::postConnect];
  }
}

Register your subscriber as a service in NEON file.

services:
  subscriber1:
    class: App\PostConnectSubscriber

Bridges

PSR-3

To log all queries with a PSR-3 logger, define the service under the configuration.sqlLogger key. Monolog provides PSR compatible services.

dbal:
  configuration:
    sqlLogger: Nettrine\DBAL\Logger\PsrLogger()

Examples

1. Manual example

composer require nettrine/annotations nettrine/cache nettrine/migrations nettrine/fixtures nettrine/dbal nettrine/orm

# Extension > Nettrine
# => order is crucial
#
extensions:
  # Common
  nettrine.annotations: Nettrine\Annotations\DI\AnnotationsExtension
  nettrine.cache: Nettrine\Cache\DI\CacheExtension
  nettrine.migrations: Nettrine\Migrations\DI\MigrationsExtension
  nettrine.fixtures: Nettrine\Fixtures\DI\FixturesExtension

  # DBAL
  nettrine.dbal: Nettrine\DBAL\DI\DbalExtension
  nettrine.dbal.console: Nettrine\DBAL\DI\DbalConsoleExtension

  # ORM
  nettrine.orm: Nettrine\ORM\DI\OrmExtension
  nettrine.orm.cache: Nettrine\ORM\DI\OrmCacheExtension
  nettrine.orm.console: Nettrine\ORM\DI\OrmConsoleExtension
  nettrine.orm.annotations: Nettrine\ORM\DI\OrmAnnotationsExtension

2. Example projects

We've made a few skeletons with preconfigured Nettrine nad Contributte packages.

• https://github.com/contributte/webapp-skeleton
• https://github.com/contributte/apitte-skeleton

3. Example playground

• https://github.com/contributte/playground (playground)
• https://contributte.org/examples.html (more examples)

Other

This repository is inspired by these packages.

• https://github.com/doctrine
• https://gitlab.com/Kdyby/Doctrine
• https://gitlab.com/etten/doctrine
• https://github.com/DTForce/nette-doctrine
• https://github.com/portiny/doctrine

Thank you guys.