class ContainerRepository extends \Doctrine\ORM\EntityRepository
21
{
22
/**
23
* Get Query for Container searched by name.
24
*
25
* @param string $name
26
*
27
* @return \Doctrine\ORM\Query
28
*/
29
public function getByName($name)
30
{
31
$qb = $this->createQueryBuilder('c')
32
->where('c.name = :name')
33
->setParameters([
34
'name' => $name,
35
]);
36
37
return $qb->getQuery();
38
}
39
40
/**
41
* Get Query for Container searched by id.
42
*
43
* @param string $id
44
*
45
* @return \Doctrine\ORM\Query
46
*/
47
public function getById($id)
48
{
49
$qb = $this->createQueryBuilder('c')
50
->where('c.id = :id')
51
->setParameters([
52
'id' => $id,
53
]);
54
55
return $qb->getQuery();
56
}
57
58
/**
59
* Get Query for Container searched by id but only with id, createdAt and updatedAt fields.
60
*
61
* @param string $id
62
*
63
* @return \Doctrine\ORM\Query
64
*/
65
public function getHttpCacheCheckQuery($id)
66
{
67
$query = $this->getEntityManager()->createQuery("select partial c.{id,createdAt,updatedAt} from SWP\TemplateEngineBundle\Model\Container c WHERE c.id = :id");
superdesk /
web-publisher
