Re: Selecting (and accessing) from many tables

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

On Mon, 2004-09-20 at 08:05, Jesse Sheidlower wrote:
> When retrieving in such a manner, what is the syntax for
> acessing the elements of this from my Track object? 

Jesse,

Here are some options:

1) Create a whole bunch of Class::DBI objects from this data using 
construct() calls.  See the recent thread "loading many objects from one
query" for some sample code.

2) Don't worry about efficiency and use the initial query to just get a
set of track objects which you will use to get any other data you want. 
For example:

my @tracks = Music::Tracks->search_by_year(1992);
foreach my $track (@tracks) {
    my $cd          = $track->cd();
    my $title       = $cd->title();
    my $artist      = $cd->artist();
    my $artist_name = $artist->name();
    ... etc ...
}

In general, I don't think Class::DBI is the right tool for complex
report data.  However, if all you want is the relationships between
objects, and you are not having performance problems, the second option
is pretty easy and natural.

- Perrin