Re: Selecting (and accessing) from many tables

[prev] [thread] [next] [Date index for 2004/09/20]

On Mon, Sep 20, 2004 at 08:05:19AM -0400, Jesse Sheidlower wrote:
> >   SELECT __ESSENTIAL(t)__, __ESSENTIAL(c)__, __ESSENTIAL(a)__
> >     FROM __TABLE(=t)__, __TABLE(CD=c)__, __TABLE(Artist=a)__
> >    WHERE __JOIN(t c a)__
> >      AND t.id = ? 
> > });
> My. OK, I didn't realized it worked this way, but this is
> terrific. Thanks.
> When retrieving in such a manner, what is the syntax for
> acessing the elements of this from my Track object? 

That in and of itself won't give you a Track object, as you're selecting
lots of things from lots of different places. You're going to need to wrap
your own accessor around this to do whatever you need it to do. There's
only so much magic we support at the minute! :)

The quick and dirty way, assuming this is read only, is probably to
do this in a subclass of track, and set up TEMP columns for the things
coming from the other classes. The more correct way would be for it to
fake up the relationships without needing to do the extra fetch.

Tony