for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
declare(strict_types=1);
namespace League\Tactician\Doctrine\DBAL;
use Doctrine\DBAL\Connection;
use League\Tactician\Middleware;
use Throwable;
/**
* Verifies if there is a connection established with the database. If not it will reconnect.
*/
final class PingConnectionMiddleware implements Middleware
{
private Connection $connection;
public function __construct(Connection $connection)
$this->connection = $connection;
}
* Reconnects to the database if the connection is expired.
*
* @return mixed
public function execute(object $command, callable $next)
if (! $this->ping($this->connection)) {
$this->connection->close();
$this->connection->connect();
return $next($command);
private function ping(Connection $connection): bool
try {
$dummySelectSQL = $connection->getDatabasePlatform()->getDummySelectSQL();
$connection->executeQuery($dummySelectSQL);
return true;
} catch (Throwable $exception) {
return false;
thephpleague /
tactician-doctrine
