Convert sql to doctrine symfony or DQL

Question

hello i have 2 many to one relation in database and use sql query is ok but can`t convert query mysql to dql or querybuilder please help me

SELECT * 
FROM `resturant`
LEFT JOIN `food`
    ON `resturant`.`id` = `food`.`resturant_id` 
WHERE `food`.`name`LIKE "%pizza%" 
GROUP BY `resturant`.`name`

What is causing you troubles? See http://doctrine-orm.readthedocs.io/projects/doctrine-orm/en/latest/reference/dql-doctrine-query-language.html — Rvanlaak, May 25 '16 at 09:07

score 0 · Answer 1 · answered May 25 '16 at 08:54

0

Assuming your Restaurant entity is linked to the Food entity through the attribute $foods:

$this->createQueryBuilder('restaurant')
    ->leftJoin('restaurant.foods', 'food')
    ->where('food.name LIKE %pizza%')
    ->groupBy('restaurant.name')
    ->getQuery()->getResult();

answered May 25 '16 at 08:54

Terenoth

2,458
1
14
21

[Semantical Error] line 0, col 95 near 'food WHERE food.name': Error: Class Food\AdminBundle\Entity\Resturant has no association named foods – Kaveh Yzd May 25 '16 at 09:12
I said: "Assuming your Restaurant entity is linked to the Food entity through the attribute $foods"'. Check your entity mapping. – Terenoth May 25 '16 at 09:16
relation is from food no relation in resturant – Kaveh Yzd May 25 '16 at 09:29
This must be the case if you want this request to work in DQL. – Terenoth May 25 '16 at 09:39

Convert sql to doctrine symfony or DQL

1 Answers1