Symfony many-to-many

Question

Usually i have solved many-to-many cases in the way of one-to-many-to-one way: first --< second >-- third. Code is implemented like described int this tutorial: http://www.prowebdev.us/2012/07/symfnoy2-many-to-many-relation-with.html and everything works like a charm.

ORM Designer offers and easy way to generate many-to-many relationships, and i decided to give it a try.

My entities are created by ORM Designer in following way:

Products Entity:

class Product { <....> /** * @ORM\ManyToMany(targetEntity="Crm\AdminBundle\Entity\Memberships", inversedBy="Membershipses") * @ORM\JoinTable( * name="MembershipsHasProduct", * joinColumns={@ORM\JoinColumn(name="Product_id", referencedColumnName="id", nullable=false)}, * inverseJoinColumns={@ORM\JoinColumn(name="Memberships_id", referencedColumnName="id", nullable=false)} * ) */ private $Products; <....> }

In database it looks like:

CREATE TABLE IF NOT EXISTS `product` ( `id` int(11) NOT NULL AUTO_INCREMENT, `category_id` int(11) NOT NULL, `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `eanCode` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `productCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `description` longtext COLLATE utf8_unicode_ci, `deleted` tinyint(1) NOT NULL DEFAULT '0', `notes` longtext COLLATE utf8_unicode_ci, `createdTime` datetime NOT NULL, `virtual` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_D34A04AD12469DE2` (`category_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

Memberships entity:

class Memberships{ /** * @ORM\ManyToMany(targetEntity="Crm\StockBundle\Entity\Product", mappedBy="Products", cascade={"all"}) */ private $Membershipses; }

In database it looks like:

CREATE TABLE IF NOT EXISTS `memberships` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `comembers` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;

MembershipsHasProduct table does not have entity symfony, still this table is generated in database:

CREATE TABLE IF NOT EXISTS `membershipshasproduct` ( `Product_id` int(11) NOT NULL, `Memberships_id` int(11) NOT NULL, PRIMARY KEY (`Product_id`,`Memberships_id`), KEY `IDX_7FF740F6AD9658A` (`Product_id`), KEY `IDX_7FF740F6CFDFC8A4` (`Memberships_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

I've used Symfony's console app to auto generate form, and this is the result:

public function buildForm(FormBuilderInterface $builder, array $options) { $builder ->add('name') ->add('comembers') ->add('Membershipses') ->add('Save','submit') ; }

Form itself is working creat, products are presented in picklist (by field 'Membershipses') and Membership data is saved into database. But 'MembershipsHasProduct' table does not get any data in database.

I assume i have something 'Special' to do, in order to get this table filled with Membership-Product relation data ?

It would be helpful to know how Product is structured in terms of attributes (how does the product table in database look like?). — Jim Martens
– Jim Martens, Commented Dec 23, 2013 at 14:03
I mean for example the same you did for the membershiphasproduct table. A SQL statement that is used to create that table. — Jim Martens
– Jim Martens, Commented Dec 23, 2013 at 15:01

shacharsol · Accepted Answer · 2013-12-23 15:59:06Z

You need to implement add methods like the following:

/** * {@inheritDoc} */ public function addMembership($membership) { if (!$this->getMemberhips()->contains($membership)) { $this->getMemberhips()->add($membership); $membership->addProduct($this); } return $this; }

And initiate the membership collection on constructor:

public function _construct(){ $this->memberships = new ArrayCollection(); }

Only at the owning side, otherwise you will have a infinite calls.

Collectives™ on Stack Overflow

Symfony many-to-many

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related