Doctrine dbal groupby

[tugrul]

Sample usecase:

$pager = new Pagerfanta(new DoctrineDbalAdapter($query, function (QueryBuilder $queryBuilder) {
    return $queryBuilder->getConnection()
        ->createQueryBuilder()
        ->select('COUNT(*) AS total')
        ->from('(' . $queryBuilder->getSQL()  . ')', 'QL')
        ->setMaxResults(1)
        ->setParameters($queryBuilder->getParameters());
}));

[sampart]

See https://github.com/whiteoctober/Pagerfanta/issues/169

[sampart]

Thanks for this, @tugrul. I'm not able to test this, so please could you confirm what testing you've done? Thanks