Albert221\Blog\Repository\DatabasePostRepository

Complexity

Total Complexity

4

Size/Duplication

Total Lines	44
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	3

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	bySlug()	0	4	1
A	byCategory()	0	15	1

<?php

namespace Albert221\Blog\Repository;

use Doctrine\ORM\EntityRepository;

class DatabasePostRepository extends EntityRepository implements PostRepositoryInterface
{
    public function count()
    {
        $query = $this->createQueryBuilder('p')
            ->select('count(p.id)')
            ->getQuery();

        return $query->getSingleScalarResult();
    }
    
    public function paginated($page, $perPage)
    {
        $first = ($page - 1) * $perPage;

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

        return $query->getResult();
    }

    public function bySlug($slug)
    {
        return $this->findOneBy(['slug' => $slug]);
    }

    public function byCategory($category, $page, $perPage)
    {
        $first = ($page - 1) * $perPage;
        
        $qb = $this->createQueryBuilder('p');

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

        return $query->getResult();
    }
}