The King of Relations: ManyToOne
Selecting between ManyToOne and ManyToMany
Each genus
will have many genus_notes
. But, each genus_note
that someone adds
will relate to only one genus
. There are only two possible types of relationships,
and this is by far the most common. It's called a ManyToOne association.
The second type is called a ManyToMany association. To use a different example,
this would be if each product
had many tags, but also each tag related to many
products.
And when it comes to Doctrine relations - don't trust the Internet! Some people
will try to confuse you with other relationships like OneToMany
, OneToOne
and some
garbage about unidirectional and bidirectional associations. Gross. Ignore it all.
I guarantee, all of that will make sense really soon.
So your first job is simple: decide if you have a ManyToOne
or ManyToMany
relationship.
And it's easy. Just answer this question:
Do either of the sides of the relationship belong to only one of the other?
Each genus_note
belongs to only one genus
, so we have a classic ManyToOne
relationship.
Setting up a ManyToOne Relation
Forget about Doctrine: just think about the database. If every genus_note
should
belong to exactly one genus
, How would you set that up? You'd probably add a
genus_id
column to the genus_note
table. Simple!
Since we need to add a new column to GenusNote
, open that entity class. You probably
feel like you want to add a $genusId
integer property here. That makes sense. But
don't! Instead, add a $genus
property and give it a ManyToOne
annotation. Inside
that, add targetEntity="Genus"
:
// ... lines 1 - 10 | |
class GenusNote | |
{ | |
// ... lines 13 - 39 | |
/** | |
* @ORM\ManyToOne(targetEntity="Genus") | |
*/ | |
private $genus; | |
// ... lines 44 - 98 | |
} |
Tip
You can also use the full namespace: AppBundle\Entity\Genus
- and that's required
if the two entities do not live in the same namespace/directory.
Umm, guys? That's it. Relationship finished. Seriously.