John,
Thanks for your help.
Yes, the containable behavior is critical. I use it all over.
I have 'persons' and 'organizations' tables. Here's the outcome I'm trying to
get:
$following = $this->Person->find('all', array(
'contain' => array('Following' =>
array('FollowPerson','FollowOrganization')),
'conditions' => array('Person.id' => 1234),
));
$following will return all the Person and Organization records that are
following Person 1234.
$followers = $this->Person->find('all', array(
'contain' => array('Follower' => array('Person')),
'conditions' => array('Person.id' => 1234),
));
$followers will return all the Person records that Person 1234 is following.
Same for Organization:
$followers = $this->Organization->find('all', array(
'contain' => array('Follower' => array('Person')),
'conditions' => array('Organization.id' => 5678),
));
The $followers logic currently works correctly. But the $following logic is
very close, except that it returns all records matching the table_id, not
filtering on the table_name.
Since is is always a person that is following something else (Person,
Organization, and more in future), I have:
Person hasMany PersonFollow (tableName='person_follows'; realize not
alphabetical).
PersonFollow belongsTo Person
The challenging part from here is PersonFollow HABTM Persons and Organizations.
I tried this in the PersonFollow model:
public $hasAndBelongsToMany = array(
'FollowPerson' => array(
'className' => 'Person',
'joinTable' => 'person_follows',
'foreignKey' => 'table_id',
'associationForeignKey' => 'id',
'conditions' => array('PersonFollow.table_name' => 'persons'),
),
'FollowOrganization' => array(
'className' => 'Organization',
'joinTable' => 'person_follows',
'foreignKey' => 'table_id',
'associationForeignKey' => 'id',
'conditions' => array('PersonFollow.table_name' => 'organizations'),
),
);
Seems to make no difference.
Should I be taking an entirely different approach here?
--
Matt Myers
Sent with Sparrow (http://www.sparrowmailapp.com/?sig)
On Thursday, January 8, 2015 at 12:17 PM, John Andersen wrote:
> Just an addition to my previous post
>
> Take a look at the Containable behaviour in the CakePHP book here:
> http://book.cakephp.org/2.0/en/core-libraries/behaviors/containable.html
>
> Understand it and then use it - it will make your life so much simpler when
> you later need to retrieve data.
> Enjoy, John
> --
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to a topic in the Google
> Groups "CakePHP" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/cake-php/MAW94cc-jeQ/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> [email protected]
> (mailto:[email protected]).
> To post to this group, send email to [email protected]
> (mailto:[email protected]).
> Visit this group at http://groups.google.com/group/cake-php.
> For more options, visit https://groups.google.com/d/optout.
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
