Re: Class::DBI::Set

[prev] [thread] [next] [Date index for 2004/06/28]

On Mon, Jun 28, 2004 at 01:19:40AM -0700, steve shapero wrote:
> how  are people doing this?  it's not so useful for me to just search 
> on one table.  Especially b/c i'd like to be able to this:
> my $tracks = find_tracks(track_name => '%something', artist_name => '$else');

my @tracks = grep $_->artist->name =~ /whatever/, 
	Tracks->search(name => "whatever");

or

my @tracks = map $_->tracks(name => "whatever"), 
  Artist->search(name => "whatever");

If there are too many for that to be practical, then you can use set_sql
to write the query required.

Tony