You are browsing a version that is no longer maintained.

Laminas Developer Tools in DoctrineORMModule

If you ever tried Laminas Developer Tools you will surely understand the importance of being able to track performance pitfalls or excessive amount of queries in your applications when developing.

Setup

To setup Laminas Developer Tools, run

$ composer require laminas/laminas-developer-tools

Then enable Laminas\DeveloperTools in your modules and enable profiling and the toolbar (see docs of Laminas Developer Tools for that).

Once Laminas\DeveloperTools is enabled, having doctrine.entity_manager.orm_default as your default EntityManager, you will notice that the queries performed by the ORM get logged and displayed in the toolbar.

Customization

If you want to customize this behavior (or track multiple EntityManager instances) you can do it in different ways. Please note that if you have set an SQLLogger in your configuration, this functionality won't override it, so you can use these features in total safety.

Multiple EntityManager/Connection instances and logging

WARNING! These are advanced features! Even if the code is fully tested, this is usually not required for most users!

To setup logging for an additional DBAL Connection or EntityManager, put something like following in your module:

1<?php namespace MyNamespace; class Module { public function getConfig() { return [ 'doctrine' => [ 'sql_logger_collector' => [ 'other_orm' => [ // name of the sql logger collector (used by Laminas\DeveloperTools) 'name' => 'other_orm', // name of the configuration service at which to attach the logger 'configuration' => 'doctrine.configuration.other_orm', // uncomment following if you want to use a particular SQL logger instead of relying on // the attached one //'sql_logger' => 'service_name_of_my_dbal_sql_logger', ], ], ], 'laminas-developer-tools' => [ // registering the profiler with Laminas\DeveloperTools 'profiler' => [ 'collectors' => [ // reference to the service we have defined 'other_orm' => 'doctrine.sql_logger_collector.other_orm', ], ], // registering a new toolbar item with Laminas\DeveloperTools (name must be the same of the collector name) 'toolbar' => [ 'entries' => [ // this is actually a name of a view script to use - you can use your custom one 'other_orm' => 'laminas-developer-tools/toolbar/doctrine-orm', ], ], ], ]; } public function getServiceConfiguration() { return [ 'factories' => [ // defining a service (any name is valid as long as you use it consistently across this example) 'doctrine.sql_logger_collector.other_orm' => new \DoctrineORMModule\Service\SQLLoggerCollectorFactory('other_orm'), ], ]; } public function onBootstrap(\Laminas\EventManager\EventInterface $e) { $config = $e->getTarget()->getServiceManager()->get('Config'); if (isset($config['laminas-developer-tools']['profiler']['enabled']) && $config['laminas-developer-tools']['profiler']['enabled'] ) { // when Laminas\DeveloperTools is enabled, initialize the sql collector $app->getServiceManager()->get('doctrine.sql_logger_collector.other_orm'); } } }
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68

This example will simply generate a new icon in the toolbar, with the log results of your other_orm connection: