class EntryRepository extends EntityRepository
{
- private $lifeTime;
-
/**
* Return a query builder to used by other getBuilderFor* method.
*
$qb->andWhere('e.isStarred =:isStarred')->setParameter('isStarred', (bool) $isStarred);
}
- if ($since >= 0) {
+ if ($since > 0) {
$qb->andWhere('e.updatedAt > :since')->setParameter('since', new \DateTime(date('Y-m-d H:i:s', $since)));
}
public function findByUrlAndUserId($url, $userId)
{
$res = $this->createQueryBuilder('e')
- ->where('e.url = :url')->setParameter('url', $url)
+ ->where('e.url = :url')->setParameter('url', urldecode($url))
->andWhere('e.user = :user_id')->setParameter('user_id', $userId)
->getQuery()
->getResult();
return $qb->getQuery()->getSingleScalarResult();
}
-
- public function setLifeTime($lifeTime)
- {
- $this->lifeTime = $lifeTime;
- }
-
- /**
- * Enable cache for a query.
- *
- * @param Query $query
- *
- * @return Query
- */
- public function enableCache(Query $query)
- {
- $query->useQueryCache(true);
- $query->useResultCache(true);
- $query->setResultCacheLifetime($this->lifeTime);
-
- return $query;
- }
}