App\Movies\Repository\MovieReviewRepository

Complexity

Total Complexity

3

Size/Duplication

Total Lines	32
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	3

Test Coverage

Coverage

100%

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	findOne()	0	10	1
A	findAllByMovie()	0	10	1

<?php

namespace App\Movies\Repository;

use App\Movies\Entity\MovieReview;
use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
use Doctrine\ORM\Query;
use Symfony\Bridge\Doctrine\RegistryInterface;
use App\Users\Entity\UserWatchedMovie;

/**
 * @method MovieReview|null find($id, $lockMode = null, $lockVersion = null)
 * @method MovieReview|null findOneBy(array $criteria, array $orderBy = null)
 * @method MovieReview[]    findAll()
 * @method MovieReview[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
 */
class MovieReviewRepository extends ServiceEntityRepository
{
    public function __construct(RegistryInterface $registry)
    {
        parent::__construct($registry, MovieReview::class);
    }

    /**
     * use this method instead of find(), because doctrine dont know how to map uwm correctly
     */
    public function findOne(int $id): ?MovieReview
    {
        return $this->createQueryBuilder('review')
            ->leftJoin('review.userWatchedMovie', 'uwm')
            ->addSelect('uwm')
            ->where('review.id = :id')
            ->setParameter('id', $id)
            ->getQuery()
            ->getOneOrNullResult();
    }

    public function findAllByMovie(string $locale, int $movieId): Query
    {
        return $this->createQueryBuilder('review')
            ->leftJoin('review.userWatchedMovie', 'uwm')
            ->addSelect('uwm')
            ->where('review.movie = :movieId AND review.locale = :locale')
            ->setParameter('movieId', $movieId)
            ->setParameter('locale', $locale)
            ->getQuery();
    }
}