use Doctrine\ORM\EntityManager;
use Psr\Http\Message\ResponseInterface;
use Psr\Http\Message\ServerRequestInterface;
use Psr\Http\Server\MiddlewareInterface;
use Psr\Http\Server\RequestHandlerInterface;
use Throwable;

class DoctrineTransactionMiddleware implements MiddlewareInterface
{
    /** @var EntityManager $entityManager */
    protected $entityManager;

    public function __construct(EntityManager $entityManager)
    {
        $this->entityManager = $entityManager;
    }

    /**
     * @param ServerRequestInterface  $request
     * @param RequestHandlerInterface $handler
     *
     * @return ResponseInterface
     *
     * @throws Throwable
     * @throws \Doctrine\DBAL\ConnectionException
     */
    public function process(ServerRequestInterface $request, RequestHandlerInterface $handler) : ResponseInterface
    {
        $this->entityManager->getConnection()->beginTransaction();

        try {
            $response = $handler->handle($request);
            $this->entityManager->flush();
            $this->entityManager->getConnection()->commit();
        } catch (Throwable $e) {
            $this->entityManager->getConnection()->rollBack();
            throw $e;
        }

        return $response;
    }
}

return [
    'dependencies' => [
        'factories' => [
            \Doctrine\ORM\EntityManager::class => \ContainerInteropDoctrine\EntityManagerFactory::class,
        ],
    ],
    'doctrine' => [
        'connection' => [
            'orm_default' => [
                'params' => [
                    'url' => 'mysql://root@localhost/database',
                ],
            ],
        ],
        'driver' => [
            'orm_default' => [
                'class' => \Doctrine\Common\Persistence\Mapping\Driver\AnnotationDriver::class,
                'paths' => [
                    __DIR__.'/../../module/application/src/Entity',
                    __DIR__.'/../../module/admin/src/Entity',
                ],
            ],
        ],
    ],

// ORM mapping by Annotation
AnnotationRegistry::registerFile('vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Driver/DoctrineAnnotations.php');
$driver = new AnnotationDriver(
    new AnnotationReader(),
    ['src/Domain']
);

// doctrine.global.php
<?php

declare(strict_types=1);

return [
    'doctrine' => [
        'configuration' => [
            'orm_default' => [
                'types' => [
                    \Ramsey\Uuid\Doctrine\UuidType::NAME => \Ramsey\Uuid\Doctrine\UuidType::class,
                ],
            ],
        ],
        'eventmanager' => [
            'orm_default' => [
                'subscribers' => [
                    'Gedmo\Tree\TreeListener',
                    'Gedmo\Timestampable\TimestampableListener',
                    'Gedmo\Sluggable\SluggableListener',
                    'Gedmo\Loggable\LoggableListener',
                    'Gedmo\Sortable\SortableListener',
                ],
            ],
        ],
    ],
];

<?php

declare(strict_types=1);

namespace Api\Books\Entity;

use Doctrine\Common\Collections\ArrayCollection;
use Doctrine\ORM\Mapping as ORM;
use Gedmo\Mapping\Annotation as Gedmo;
use Ramsey\Uuid\UuidInterface;

/**
 * @ORM\Entity
 */
class Book
{
    /**
     * @var UuidInterface
     *
     * @ORM\Id
     * @ORM\Column(type="uuid", unique=true)
     * @ORM\GeneratedValue(strategy="CUSTOM")
     * @ORM\CustomIdGenerator(class="Ramsey\Uuid\Doctrine\UuidGenerator")
     */
    public $id;

    [...]

// cli-config.php
<?php

declare(strict_types=1);

$container = require 'container.php';

/**
 * @FIXME Type is not registered by container-interop-doctrine
 * //doctrine.global.php
 * ```
 * return [
 *     'doctrine' => [
 *         'configuration' => [
 *             'orm_default' => [
 *                 'types' => [
 *                     \Ramsey\Uuid\Doctrine\UuidType::NAME => \Ramsey\Uuid\Doctrine\UuidType::class,
 *                 ],
 *             ],
 *         ],
 *     ],
 * ];
 * ```
 */
\Doctrine\DBAL\Types\Type::addType(\Ramsey\Uuid\Doctrine\UuidType::NAME, \Ramsey\Uuid\Doctrine\UuidType::class);

return new \Symfony\Component\Console\Helper\HelperSet([
    'em' => new \Doctrine\ORM\Tools\Console\Helper\EntityManagerHelper(
        $container->get('doctrine.entity_manager.orm_default')
    ),
]);

<?php
/** 
 * config/cli-config.php
 * For more details @see \DoctrineORMModule\Module
 *
 * Run next commands for Migrations work
 * $ composer require doctrine/doctrine-orm-module
 * $ composer require doctrine/migrations
 */

use Doctrine\ORM\Tools\Console\ConsoleRunner;
use Doctrine\ORM\EntityManager;

$container = require 'container.php';

/* @var $em \Doctrine\ORM\EntityManager */
$em = $container->get(EntityManager::class);
$configuration = new \Doctrine\DBAL\Migrations\Configuration\ArrayConfiguration($em->getConnection());

return new \Symfony\Component\Console\Helper\HelperSet([
    'em' => new \Doctrine\ORM\Tools\Console\Helper\EntityManagerHelper($em),
    'db' => new \Doctrine\DBAL\Tools\Console\Helper\ConnectionHelper($em->getConnection()),
    'configuration' => new \Doctrine\DBAL\Migrations\Tools\Console\Helper\ConfigurationHelper($em->getConnection(),, $configuration)
]);

return [
	'doctrine' => [
		'connection' => [
			'orm_default' => [
				// ...
			],
                ],
		
		// migrations configuration
		'migrations_configuration' => [
			'orm_default' => [
				'directory' => 'data/Migrations',
				'name'      => 'Doctrine Database Migrations',
				'namespace' => 'Migrations',
				'table'     => 'migrations',
				'column'    => 'version',
			],
		],
		
		'configuration' => [
			'orm_default' => [
				// ...
			],
		],
);