Albert221\Blog\Repository\Database\CategoryRepository

Complexity

Total Complexity

3

Size/Duplication

Total Lines	34
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	2

Test Coverage

Coverage

0%

Importance

Changes	1
Bugs	0	Features	1

3 Methods

Rating	Name	Duplication	Size	Complexity
A	count()	0	8	1
A	paginated()	0	11	1
A	last()	0	10	1

<?php

namespace Albert221\Blog\Repository\Database;

use Albert221\Blog\Repository\CategoryRepositoryInterface;
use Doctrine\ORM\EntityRepository;

class CategoryRepository extends EntityRepository implements CategoryRepositoryInterface
{
    public function count()
    {
        $query = $this->createQueryBuilder('c')
            ->select('count(c.id)')
            ->getQuery();

        return $query->getSingleScalarResult();
    }

    public function paginated($page, $perPage)
    {
        $first = ($page - 1) * $perPage;

        $query = $this->createQueryBuilder('c')
            ->setFirstResult($first)
            ->setMaxResults($perPage)
            ->getQuery();

        return $query->getResult();
    }

    public function last($count)
    {
        $query = $this->createQueryBuilder('c')
            ->join('c.posts', 'p')
            ->orderBy('p.published_at', 'DESC')
            ->setMaxResults($count)
            ->getQuery();
        
        return $query->getResult();
    }
}