Sorry, I didn't mention that I use cakephp 1.1!
I've read the post on teknoids blog. The disadvantage is, that this
solution only works for hasOne associations and not for hasMany.
But: I used the idea mentioned there and tried to create a LEFT JOIN
in the sql-query.
I found out, that this is possible with the 'finderQuery' value.
My new associations in PostModel:
var $hasMany = array(
'Comment' => array(
'className' => 'Comment',
'conditions' => '',
'foreignKey' => 'post_id',
'finderQuery' => '
SELECT * FROM comments
LEFT JOIN users ON (users.id = comments.user_id)
WHERE comments.post_id IN ({$__cakeID__$})'
)
);
return:
array(
'Post' => array(...),
'Comment' => array(
'User' => array(...)
)
)
This works for me in 1.1 (don't know, if this is also possible in 1.2)
Thanks for your help!
derlippe
On 9 Sep., 17:24, "Bernhard J. M. Grün"
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> This should be solvable with with Containable behavior. Or - if you want to
> do this with just one query - use the infos you can find in teknoids
> blog:http://teknoid.wordpress.com/2008/07/17/forcing-an-sql-join-in-cakephp/
> Those infos are also present in the manual for 1.2.
>
> 2008/9/9 [EMAIL PROTECTED] <[EMAIL PROTECTED]>
>
>
>
> > Hello newsgroup!
>
> > I have defined the following associations in my models:
> > PostModel: "Post _hasMany_ Comments"
>
> > var $hasMany = array(
> > 'Comment' => array(
> > 'className' => 'Comment',
> > 'conditions' => '',
> > 'foreignKey' => 'post_id',
> > )
> > );
>
> > CommentModel: "Comment _belongsTo_ User"
>
> > var $belongsTo = array(
> > 'User' => array(
> > 'className' => 'User',
> > 'conditions' => '',
> > 'foreignKey' => 'user_id'
> > )
> > );
>
> > When I use the query $this->Post->find(), cakephp only uses the
> > associations in the PostModel (this is ok).
> > This works for simple requests like $this->Post->find() and it returns
> > the data array:
> > array(
> > 'Post' => array(...),
> > 'Comment' => array(...)
> > )
>
> > But is it also possible to include the second association "Comment
> > _belongsTo_ User" into the query $this->Post->find()?
> > How do I have to define this or other associations in my Post-Model to
> > get a data array like this:
> > array(
> > 'Post' => array(...),
> > 'Comment' => array(
> > 'User' => array(...)
> > )
> > )
>
> > I have tried many possibilities in the Post model... still the same
> > results!
> > The version I used now is a foreach(), which finds all Users for the
> > returned Comments of $this->Post->find().
> > ...this makes my CakeApp a little bit slow! Any ideas for a faster
> > association?
>
> > Many thanks for your answers!
>
> > derlippe
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
