feature #143 Replace query builder with DQL (bocharsky-bw)

javiereguiluz · javiereguiluz · commit d8c53bb0efe4 · 2015-08-19T17:18:35.000+02:00
This PR was merged into the master branch. Discussion ---------- Replace query builder with DQL The `select` and `from` methods are optional Commits ------- 83e5b9a Replace query builder with DQL
diff --git a/src/AppBundle/Repository/PostRepository.php b/src/AppBundle/Repository/PostRepository.php
@@ -26,13 +26,15 @@ class PostRepository extends EntityRepository
 {
     public function findLatest($limit = Post::NUM_ITEMS)
     {
-        return $this
-            ->createQueryBuilder('p')
-            ->select('p')
-            ->where('p.publishedAt <= :now')->setParameter('now', new \DateTime())
-            ->orderBy('p.publishedAt', 'DESC')
+        return $this->getEntityManager()
+            ->createQuery('
+                SELECT p
+                FROM AppBundle:Post p
+                WHERE p.publishedAt <= :now
+                ORDER BY p.publishedAt DESC
+            ')
+            ->setParameter('now', new \DateTime())
             ->setMaxResults($limit)
-            ->getQuery()
             ->getResult()
         ;
     }

Original file line number	Diff line number	Diff line change
`@@ -26,13 +26,15 @@ class PostRepository extends EntityRepository`
`26`	`26`	`{`
`27`	`27`	`public function findLatest($limit = Post::NUM_ITEMS)`
`28`	`28`	`{`
`29`		`- return $this`
`30`		`- ->createQueryBuilder('p')`
`31`		`- ->select('p')`
`32`		`- ->where('p.publishedAt <= :now')->setParameter('now', new \DateTime())`
`33`		`- ->orderBy('p.publishedAt', 'DESC')`
	`29`	`+ return $this->getEntityManager()`
	`30`	`+ ->createQuery('`
	`31`	`+ SELECT p`
	`32`	`+ FROM AppBundle:Post p`
	`33`	`+ WHERE p.publishedAt <= :now`
	`34`	`+ ORDER BY p.publishedAt DESC`
	`35`	`+ ')`
	`36`	`+ ->setParameter('now', new \DateTime())`
`34`	`37`	`->setMaxResults($limit)`
`35`		`- ->getQuery()`
`36`	`38`	`->getResult()`
`37`	`39`	`;`
`38`	`40`	`}`