In case of M:M relation, columns "local" and "foreign" refers to columns on "refClass".
2010/12/31 himanshu <hisupa...@yahoo.com> > Hi Alan, > Your solution works! > I thank you for your help. This kind of cooperation helps to grow a novice > developers like me. > > I would appreciate if you can help me to understand following/or give some > reference link to read. > > Your solution has created following class properties in setup() method of > base class. > Tax > public function setUp() > { > parent::setUp(); > $this->hasMany('Property as Properties', array( > 'refClass' => 'PropertyTax', > *'local' => 'tax_id'*, > 'foreign' => 'property_id')); > $this->hasMany('PropertyTax', array( > 'local' => 'id', > 'foreign' => 'tax_id')); > } > > Property: > $this->hasMany('PropertyTax', array( > 'local' => 'id', > 'foreign' => 'property_id')); > $this->hasMany('Tax as Taxes', array( > 'refClass' => 'PropertyTax', > *'local' => 'property_id', > * 'foreign' => 'tax_id')); > > PropertyTax: > $this->hasOne('Tax', array( > 'local' => 'tax_id', > 'foreign' => 'id', > 'onDelete' => 'CASCADE')); > $this->hasOne('Property', array( > 'local' => 'property_id', > 'foreign' => 'id', > 'onDelete' => 'CASCADE')); > > If you see above underlined code, you will get my question. > Tax and Proeprty table do not have 'tax_id' and 'property_id' fields. Still > it refers thise columns in local field value. I dont understand it. Would > you please explain? > > Thanking you again. > > Himanshu > > ------------------------------ > *From:* Alan Bem <alan....@gmail.com> > *To:* symfony-users@googlegroups.com > *Sent:* Fri, 31 December, 2010 4:31:34 PM > *Subject:* Re: [symfony-users] doctrine many-to-many relation > > Tax: > actAs: > Timestampable: ~ > columns: > # your columns > relations: > Properties: > class: Property > local: tax_id > foreign: property_id > refClass: PropertyTax > foreignAlias: Taxes > > Property: > actAs: > Timestampable: ~ > columns: > # your columns > > PropertyTax: > actAs: > Timestampable: ~ > columns: > property_id: > type: integer > primary: true > tax_id: > type: integer > primary: true > relations: > Tax: > local: tax_id > onDelete: CASCADE > Property: > local: property_id > onDelete: CASCADE > > -- > If you want to report a vulnerability issue on symfony, please send it to > security at symfony-project.com > > You received this message because you are subscribed to the Google > Groups "symfony users" group. > To post to this group, send email to symfony-users@googlegroups.com > To unsubscribe from this group, send email to > symfony-users+unsubscr...@googlegroups.com<symfony-users%2bunsubscr...@googlegroups.com> > For more options, visit this group at > http://groups.google.com/group/symfony-users?hl=en > > -- > If you want to report a vulnerability issue on symfony, please send it to > security at symfony-project.com > > You received this message because you are subscribed to the Google > Groups "symfony users" group. > To post to this group, send email to symfony-users@googlegroups.com > To unsubscribe from this group, send email to > symfony-users+unsubscr...@googlegroups.com<symfony-users%2bunsubscr...@googlegroups.com> > For more options, visit this group at > http://groups.google.com/group/symfony-users?hl=en > -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en