Display database table contents using Symfony Table helper and Doctrine\DBAL\Connection

SfConsoleDisplayDbTable.php

/**
 * @param \Doctrine\DBAL\Connection $connection
 * @param string $table db table name
 * @param array $predicates
 */
private function displayDbTable(\Doctrine\DBAL\Connection $connection, $table, array $predicates = [])
{
    $query = $connection->createQueryBuilder();
    $query
        ->select('*')
        ->from($table)
        ->where('1=1')
    ;

    $i = 0;
    foreach ($predicates as $predicate => $value) {
        $query->andWhere($predicate);
        $query->setParameter($i++, $value);
    }

    $stmt = $query->execute();
    $data = $stmt->fetchAll(\PDO::FETCH_ASSOC);
    if (empty($data)) {
        echo "$table is empty", PHP_EOL;
        return;
    }

    $table = new \Symfony\Component\Console\Helper\Table(
        new \Symfony\Component\Console\Output\ConsoleOutput()
    );
    $table
        ->setHeaders(array_keys($data[0]))
        ->setRows($data)
    ;
    $table->render();
}