Skobkin\Bundle\PointToolsBundle\Repository\Blogs\PostRepository

Complexity

Total Complexity

2

Size/Duplication

Total Lines	22
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	4

Test Coverage

Coverage

100%

Importance

Changes	2
Bugs	1	Features	1

2 Methods

Rating	Name	Duplication	Size	Complexity
A	add()	0	4	1
A	getPostWithComments()	0	14	1

<?php

namespace Skobkin\Bundle\PointToolsBundle\Repository\Blogs;

use Doctrine\ORM\EntityRepository;
use Doctrine\ORM\QueryBuilder;
use Skobkin\Bundle\PointToolsBundle\Entity\Blogs\Post;

class PostRepository extends EntityRepository
{
    public function add(Post $entity)
    {
        $this->getEntityManager()->persist($entity);
    }

    public function getPostWithComments($postId)
    {
        /** @var QueryBuilder $qb */
        $qb = $this->createQueryBuilder('p');
        return $qb
            ->select(['p', 'c', 'a'])
            ->leftJoin('p.comments', 'c')
            ->leftJoin('c.author', 'a')
            ->where($qb->expr()->eq('p.id', ':post_id'))
            ->orderBy('c.number', 'asc')
            ->setParameter('post_id', $postId)
            ->getQuery()->getOneOrNullResult()
        ;
    }
}