Albert221\Blog\Repository\DatabaseCategoryRepository

Complexity

Total Complexity

4

Size/Duplication

Total Lines	54
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	4

Test Coverage

Coverage

0%

Importance

Changes	1
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	count()	0	8	1
A	paginated()	0	11	1
A	postsCount()	0	12	1
A	postsPaginated()	0	17	1

<?php

namespace Albert221\Blog\Repository;

use Albert221\Blog\Entity\Post;
use Doctrine\ORM\EntityRepository;

class DatabaseCategoryRepository 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 postsCount($slug)
    {
        $qb = $this->createQueryBuilder('c');

        $query = $qb->select('count(p.id)')
            ->join('c.posts', 'p')
            ->where($qb->expr()->eq('c.slug', ':slug'))
            ->setParameter(':slug', $slug)
            ->getQuery();

        return $query->getSingleScalarResult();
    }

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

        $qb = $this->getEntityManager()->createQueryBuilder();

        $query = $qb->select('p')
            ->from(Post::class, 'p')
            ->join('p.category', 'c')
            ->where($qb->expr()->eq('c.slug', ':slug'))
            ->setParameter(':slug', $slug)
            ->setFirstResult($first)
            ->setMaxResults($perPage)
            ->getQuery();

        return $query->getResult();
    }
}