Re: Selecting (and accessing) from many tables

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

On Mon, Sep 20, 2004 at 05:47:52PM +0100, Tony Bowden wrote:
> On Mon, Sep 20, 2004 at 08:05:19AM -0400, Jesse Sheidlower wrote:
>
> > 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.

Thanks, Tony, and thanks Perrin for your suggestions for how to
deal with this.

I had thought that I was doing something that would _reduce_
the overall complexity; if I have to write up new subclasses
or a variety of custom accessors, it might not be worth it to
use CDBI at all, for this part of the job.

I'll go back and re-examine the whole thing.

Thanks.

Jesse Sheidlower