[Dbix-class] Thoughts about "complex" searches.

Sam Vilain sam at vilain.net
Wed Dec 7 04:01:56 CET 2005


On Tue, 2005-12-06 at 09:58 +0100, Jesper Krogh wrote:
> This is easily composed in SQL by :
> 
> select tid from artists,tracks where artist.aid = tracks.aid and
> artists.birth < $date;

If somebody gets around to porting a Tangram::Expr like system to
DBIx::Class, you could use Tangram's syntax for building basic join
queries like this.

  $storage->select( $track,
                    ($track->{artist} == $artist) &
                    ($artist->{birth} < $date)
                  );

Sam.




More information about the Dbix-class mailing list