Albert221\Blog\Repository\Database\PostRepository

Complexity

Total Complexity

10

Size/Duplication

Total Lines	149
Duplicated Lines	16.78 %

Coupling/Cohesion

Components	1
Dependencies	4

Test Coverage

Coverage

0%

Importance

Changes	6
Bugs	1	Features	4

10 Methods

Rating	Name	Duplication	Size	Complexity
A	count()	0	8	1
A	paginated()	0	9	1
A	bySlug()	0	4	1
A	byCategoryCount()	12	12	1
A	byCategory()	13	13	1
A	searchCount()	0	10	1
B	search()	0	24	1
A	save()	0	5	1
A	byTagCount()	0	12	1
A	byTag()	0	13	1

<?php

namespace Albert221\Blog\Repository\Database;

use Albert221\Blog\Entity\Post;
use Albert221\Blog\Repository\PostRepositoryInterface;
use Doctrine\Common\Collections\Criteria;
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(Criteria $criteria)
    {
        $query = $this->createQueryBuilder('p')
            ->orderBy('p.published_at', 'DESC')
            ->addCriteria($criteria)
            ->getQuery();

        return $query->getResult();
    }

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

    /**
     * {@inheritdoc}
     */
    public function byCategoryCount($slug)

This method seems to be duplicated in your project.

    {
        $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, Criteria $criteria)

This method seems to be duplicated in your project.

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

        $query = $qb->join('p.category', 'c')
            ->where($qb->expr()->eq('c.slug', ':category'))
            ->setParameter(':category', $slug)
            ->orderBy('p.published_at', 'DESC')
            ->addCriteria($criteria)
            ->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.name', ':tag'))
            ->setParameter(':tag', $slug)
            ->getQuery();

        return $query->getSingleScalarResult();
    }

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

        $query = $qb->join('p.tags', 't')
            ->where($qb->expr()->eq('t.name', ':tag'))
            ->setParameter(':tag', $slug)
            ->orderBy('p.published_at', 'DESC')
            ->addCriteria($criteria)
            ->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) > 1')
            ->setParameter(':term', $term)
            ->getQuery();

        return $query->getSingleScalarResult();
    }

    /**
     * {@inheritdoc}
     */
    public function search($term, Criteria $criteria)
    {
        $query = $this->createQueryBuilder('p')
            ->select(
                'p as post',
                'MATCH (p.title) AGAINST (:term) as title_relevance',
                'MATCH (p.title, p.content) AGAINST (:term) as relevance'
            )
            ->where('MATCH (p.title, p.content) AGAINST (:term) > 1')
            ->orderBy('title_relevance', 'DESC')
            ->addOrderBy('relevance', 'DESC')
            ->setParameter(':term', $term)
            ->addCriteria($criteria)
            ->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();
    }
}