Alpixel\Bundle\MediaBundle\Repository\MediaRepository

Complexity

Total Complexity

1

Size/Duplication

Total Lines	16
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
A	findExpiredMedias()	0	13	1

<?php

namespace Alpixel\Bundle\MediaBundle\Repository;

use Alpixel\Bundle\MediaBundle\Entity\Media;
use Doctrine\ORM\EntityRepository;
use Doctrine\ORM\QueryBuilder;

class MediaRepository extends EntityRepository
{
    public function findExpiredMedias()
    {
        $qb = new QueryBuilder($this->getEntityManager());

        return $qb
        ->select('m')
        ->from('AlpixelMediaBundle:Media', 'm')
        ->where('m.lifetime is not null')
        ->andWhere('m.lifetime < :now')
        ->setParameter('now', new \DateTime())
        ->getQuery()
        ->getResult();
    }
}