9 use DBIC::SqlMakerTest;
11 my $schema = DBICTest->init_schema();
13 my $new_rs = $schema->resultset('Artist')->search({
14 'artwork_to_artist.artist_id' => 1
16 join => 'artwork_to_artist'
18 lives_ok { $new_rs->count } 'regular search works';
19 lives_ok { $new_rs->search({ 'artwork_to_artist.artwork_cd_id' => 1})->count }
20 '... and chaining off that using join works';
21 lives_ok { $new_rs->search({ 'artwork_to_artist.artwork_cd_id' => 1})->as_subselect_rs->count }
22 '... and chaining off the virtual view works';
23 dies_ok { $new_rs->as_subselect_rs->search({'artwork_to_artist.artwork_cd_id'=> 1})->count }
24 q{... but chaining off of a virtual view using join doesn't work};
26 my $book_rs = $schema->resultset ('BooksInLibrary')->search ({}, { join => 'owner' });
29 $book_rs->as_subselect_rs->as_query,
30 '(SELECT me.id, me.source, me.owner, me.title, me.price
32 SELECT me.id, me.source, me.owner, me.title, me.price
34 JOIN owners owner ON owner.id = me.owner
38 [ [ { sqlt_datatype => 'varchar', sqlt_size => 100, dbic_colname => 'source' }
40 'Resultset-class attributes do not seep outside of the subselect',