Glooby\TaskBundle\Entity\ScheduleRepository

Complexity

Total Complexity

3

Size/Duplication

Total Lines	43
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	3

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	findByName()	0	8	1
A	findNotInNames()	0	8	1
A	findActive()	0	7	1

<?php

namespace Glooby\TaskBundle\Entity;

use Doctrine\ORM\EntityRepository;
use Doctrine\ORM\NoResultException;
use Glooby\TaskBundle\Model\ScheduleInterface;

/**
 * @author Emil Kilhage
 */
class ScheduleRepository extends EntityRepository
{
    /**
     * @param string $name
     *
     * @return ScheduleInterface
     *
     * @throws NoResultException
     */
    public function findByName($name)
    {
        return $this->getEntityManager()
            ->createQuery('SELECT r FROM GloobyTaskBundle:Schedule r WHERE r.name = :name')
            ->setParameter('name', $name)
            ->useQueryCache(true)
            ->getSingleResult();
    }

    /**
     * @param array $names
     *
     * @return ScheduleInterface[]
     */
    public function findNotInNames(array $names)
    {
        return $this->getEntityManager()
            ->createQuery('SELECT r FROM GloobyTaskBundle:Schedule r WHERE r.name NOT IN (:names)')
            ->setParameter('names', $names)
            ->useQueryCache(true)
            ->getResult();
    }

    /**
     * @return ScheduleInterface[]
     */
    public function findActive()
    {
        return $this->getEntityManager()
            ->createQuery('SELECT r FROM GloobyTaskBundle:Schedule r WHERE r.active = true')
            ->useQueryCache(true)
            ->getResult();
    }
}