Symfony query syntax

Question

I have question or problem with query syntax. I have 2 entity tables related with ManyToMany:

Person.php

/**
 * @ORM/ManyToMany(targetEntity="Deal", inversedBy="persons")
 * @ORM/JoinTable(name="persons_deals")
 * /
 protected $deals;

Deal.php

/*
 * @ORM/ManyToMany(targetEntity="Person", mappedBy="deals")
 * /
protected $persons;

This creates an "extra" table called persons_deals in the database. In that table is "person_id" and "deal_id"

If a deal is done there is (for example):

  person_id ---- deal_id

    1 -------------- 1 
    2 -------------- 1

So if I want to get deal_id 1 and persons connected to it. What kind of query should I make?

You should look into Doctrine (which this is using). You don't really work with SQL or tables, you work with objects and classes. $person->setDeal($deal) — Koalabaerchen
– Koalabaerchen, Commented Jul 10, 2015 at 8:19

Dmitry Malyshenko · Accepted Answer · 2015-07-10 08:45:09Z

1

There is no such thing as Symfony Query Language (or Syntax). You are probably talking about Doctrine.

So it's better covered at Doctrine documentation how to organize many-to-many relation.

Pay your attention, you'll probably have to fix namespaces from example to make it work at your code

So instead

you will need to make

answered Jul 10, 2015 at 8:45

Dmitry Malyshenko

3,2991 gold badge14 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mickburkejnr · Accepted Answer · 2015-07-10 08:18:26Z

0

This is covered in the documentation.

answered Jul 10, 2015 at 8:18

mickburkejnr

3,72013 gold badges78 silver badges111 bronze badges