[eluser]sheldonnbbaker[/eluser]
Thanks for the help.
I've gone over the example app and the documentation and have been fooling with this for a while, unable to get a basic setup going (as you can see). I guess I was expecting to be able to get very deep relationships very easily (my whole app will have many deep relationships like this - this is but a simple example).
After thinking about it though, it's really not even that easy with plain MySQL (I assume one would have to do a bunch of GROUP_CONCAT'ing and PHP trickery to get, for example, 0 or more ratings, comments, and descriptions inside every widget_version array inside every widget array inside every user group array, etc.).
And from what you're suggesting, the best way to go about very deep relationships is to find the deepest 'has_one' model and get the queries from there, and do whatever logic is needed afterwards.
EDIT: Assuming I use your example to get my widgets:
Code:
$versions = new Widget_version();
$versions->include_related('widget')->get();
foreach ($versions as ...
What would be a good way to get the ratings (and eventually comments, descriptions, etc.) for that widget_version (they would be has_many relationships)?
