From 289875836a09944f5993d33753042abfef13809e Mon Sep 17 00:00:00 2001 From: Jeremy Benoist Date: Sun, 25 Sep 2016 12:23:44 +0200 Subject: Fix tag count for PostgreSQL --- src/Wallabag/CoreBundle/Repository/TagRepository.php | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'src/Wallabag/CoreBundle/Repository') diff --git a/src/Wallabag/CoreBundle/Repository/TagRepository.php b/src/Wallabag/CoreBundle/Repository/TagRepository.php index f5c4ea6a..9d127da7 100644 --- a/src/Wallabag/CoreBundle/Repository/TagRepository.php +++ b/src/Wallabag/CoreBundle/Repository/TagRepository.php @@ -7,17 +7,17 @@ use Doctrine\ORM\EntityRepository; class TagRepository extends EntityRepository { /** - * Find all tags per user. + * Count all tags per user. * * @param int $userId * @param int $cacheLifeTime Duration of the cache for this query * - * @return array + * @return int */ - public function findAllTags($userId, $cacheLifeTime = null) + public function countAllTags($userId, $cacheLifeTime = null) { $query = $this->createQueryBuilder('t') - ->select('t') + ->select('t.slug') ->leftJoin('t.entries', 'e') ->where('e.user = :userId')->setParameter('userId', $userId) ->groupBy('t.slug') @@ -29,7 +29,7 @@ class TagRepository extends EntityRepository $query->setResultCacheLifetime($cacheLifeTime); } - return $query->getArrayResult(); + return count($query->getArrayResult()); } /** -- cgit v1.2.3