AppBundle\Repository\EventRepository

Complexity

Total Complexity

2

Size/Duplication

Total Lines	23
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Test Coverage

Coverage

0%

Importance

Changes	3
Bugs	0	Features	1

2 Methods

Rating	Name	Duplication	Size	Complexity
A	selectNotExpiredByUser()	0	11	1
A	findByGoogleId()	0	8	1

<?php

namespace AppBundle\Repository;

/**
 * EventRepository.
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class EventRepository extends \Doctrine\ORM\EntityRepository
{
    public function findByGoogleId($id)
    {
        return $this->createQueryBuilder('e')
            ->andWhere('e.googleId = :id')
            ->setParameter('id', $id)
            ->getQuery()
            ->getSingleResult();
    }

    public function selectNotExpiredByUser($user)
    {
        return $this->createQueryBuilder('e')
            ->join('e.user', 'user')
            ->andWhere('user = :user')
            ->setParameter('user', $user)
            ->andWhere('e.expiredAt >= :date')
            ->setParameter('date', new \DateTime())
            ->getQuery()
            ->getResult();
    }
}