Hi Winzou! Thanks for that!
But, I think that that approach won't do the trick.
e.g :
select a, b objecA A JOIN objectB b where b.is_public_content = true
If that query is an INNER JOIN, then it will return only those objectA that
has at least one related objectB which is_public_content attribute is set to
TRUE.
In other words, objectACollection will be a partial collection.
I need to fetch all objectA and then iterate through its objectBCollection
if any (If it has one) of every objectA.
A LEFT JOIN won't help so much, although it will return all objectA from
database, when I access an objectA's objectBCollection it will
have ALL releted objectB (even those with is_public_content set to FALSE).
If there were no rules I would:
#entity objectA
class objectA {
public function getPublicObjectBCollection()
{
return my_magic_dql_query("Select * From objectB where
is_public_content = true and objectB.objectA_id = ?", $this->id );
}
}
In fact, this was allowed in S1.4 and Doctrine1. (in the lib/model/doctrine
dir there were ayourTableName.class.php file where you could have done this,
it also had a pair: yourTableName.Table.class.php for other matters).
Thanks again!!!!
2011/6/7 winzou <[email protected]>
> It doesn't change so much the solution.
> Implement a findAllWithPublic() method in the ObjectA repository. This
> method selects objects A, makes the join on objects B with the appropriate
> condition (the is_public_content = true), and returns all that.
> Then you can do your for without any problem.
>
> My point is : you can do almost everything you want with the repository
> concept, use it!
>
> --
> 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 [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> 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 [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
