my $schema = DBICTest->init_schema();
my $sdebug = $schema->storage->debug;
-my $artist = $schema->resultset ('Artist')->first;
+my $artist = $schema->resultset ('Artist')->find(1);
my $genre = $schema->resultset ('Genre')
->create ({ name => 'par excellence' });
is_same_sql (
$search_sql,
'SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track
- FROM cd me
+ FROM cd me
WHERE ( me.artist = ? AND me.title = ? AND me.genreid = ? )
',
'expected select issued',