Albert221\Blog\Repository\Database\PostRepository

Complexity

Total Complexity

10

Size/Duplication

Total Lines	159
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	4

Test Coverage

Coverage

0%

Importance

Changes	2
Bugs	0	Features	2

10 Methods

Rating	Name	Duplication	Size	Complexity
A	count()	0	8	1
A	paginated()	0	11	1
A	bySlug()	0	4	1
A	byCategoryCount()	0	12	1
A	byCategory()	0	15	1
A	byTagCount()	0	12	1
A	byTag()	0	16	1
A	searchCount()	0	10	1
B	search()	0	27	1
A	save()	0	5	1

<?php

namespace Albert221\Blog\Repository\Database;

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

class PostRepository extends EntityRepository implements PostRepositoryInterface
{
    /**
     * {@inheritdoc}
     */
    public function count()
    {
        $query = $this->createQueryBuilder('p')
            ->select('count(p.id)')
            ->getQuery();

        return $query->getSingleScalarResult();
    }

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

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

        return $query->getResult();
    }

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

    /**
     * {@inheritdoc}
     */
    public function byCategoryCount($slug)
    {
        $qb = $this->createQueryBuilder('p');

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

        return $query->getSingleScalarResult();
    }

    /**
     * {@inheritdoc}
     */
    public function byCategory($slug, $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', $slug)
            ->setFirstResult($first)
            ->setMaxResults($perPage)
            ->getQuery();

        return $query->getResult();
    }

    public function byTagCount($slug)
    {
        $qb = $this->createQueryBuilder('p');

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

        return $query->getSingleScalarResult();
    }

    /**
     * {@inheritdoc}
     */
    public function byTag($slug, $page, $perPage)
    {
        $first = ($page - 1) * $perPage;

        $qb = $this->createQueryBuilder('p');

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

        return $query->getResult();
        
    }

    /**
     * {@inheritdoc}
     */
    public function searchCount($term)
    {
        $query = $this->createQueryBuilder('p')
            ->select('COUNT(p.id)')
            ->where('MATCH (p.title, p.content) AGAINST (:term EXPAND) > 1')
            ->setParameter(':term', $term)
            ->getQuery();

        return $query->getSingleScalarResult();
    }

    /**
     * {@inheritdoc}
     */
    public function search($term, $page, $perPage)
    {
        $first = ($page - 1) * $perPage;

        $query = $this->createQueryBuilder('p')
            ->select(
                'p as post',
                'MATCH (p.title) AGAINST (:term) as title_relevance',
                'MATCH (p.title, p.content) AGAINST (:term EXPAND) as relevance'
            )
            ->where('MATCH (p.title, p.content) AGAINST (:term EXPAND) > 1')
            ->orderBy('title_relevance', 'DESC')
            ->addOrderBy('relevance', 'DESC')
            ->setParameter(':term', $term)
            ->setFirstResult($first)
            ->setMaxResults($perPage)
            ->getQuery();

        $result = $query->getResult();

        // because we don't want an array of post and relevances, a post only
        array_walk($result, function (&$value) {
            $value = $value['post'];
        });

        return $result;
    }

    /**
     * {@inheritdoc}
     */
    public function save(Post $post)
    {
        $this->getEntityManager()->persist($post);
        $this->getEntityManager()->flush();
    }
}