README

Laminas module that provides features that help you run your Laminas App's testsuite more efficiently with isolated tests.

Based on Symfony's doctrine-test-bundle.

It provides a StaticDriver that will wrap your originally configured Driver class (like DBAL\Driver\PDOMysql\Driver) and keeps a database connection statically in the current php process.

With the help of a PHPUnit extension class it will begin a transaction before every testcase and roll it back again after the test finished for all configured DBAL connections. This results in a performance boost as there is no need to rebuild the schema, import a backup SQL dump or re-insert fixtures before every testcase. As long as you avoid issuing DDL queries that might result in implicit transaction commits (Like ALTER TABLE, DROP TABLE etc; see https://wiki.postgresql.org/wiki/Transactional_DDL_in_PostgreSQL:_A_Competitive_Analysis) your tests will be isolated and all see the same database state.

How to install and use this Module?

1. install via composer

   composer require --dev facile-it/doctrine-test-module

2. Enable the module for your test environment in your config/application.php

   <?php
   
   return [
       'modules' => [
          'Facile\DoctrineTestModule',
       ],
   ];

Using the Module with PHPUnit

1. Add the Extension to your PHPUnit XML config

   • PHPUnit 9:

     <phpunit>
         ...
         <extensions>
             <extension class="Facile\DoctrineTestModule\PHPUnit\PHPUnitExtension" />
         </extensions>
     </phpunit>

   • PHPUnit 10+:

     <phpunit>
         ...
         <extensions>
             <bootstrap class="Facile\DoctrineTestModule\PHPUnit\PHPUnitExtension" />
         </extensions>
     </phpunit>

2. Make sure you also have phpunit/phpunit available as a dev dependency (versions 9 and 10 are supported with the built-in extension) to run your tests.

3. That's it! From now on whatever changes you do to the database within each single testcase are automatically rolled back for you 😊

Configuration

The module exposes a configuration that looks like this by default:

use Facile\DoctrineTestModule\ConfigProvider;

return [
    ConfigProvider::CONFIGURATION: [
        'enable_static_connection' => true,
    ]
];

Setting enable_static_connection: true means it will enable it for all configured doctrine dbal connections.

You can selectively only enable it for some connections if required:

use Facile\DoctrineTestModule\ConfigProvider;

return [
    ConfigProvider::CONFIGURATION: [
        'enable_static_connection' => [
            'orm_default' => true,
        ],
    ]
];