X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Fresultset%2Fas_query.t;h=43c8ddd90734140265731d224430d33dc4853e18;hb=4dc99a0129f68ed7f37b188fd731a49f03715dd2;hp=b4fa42228f073c46e20b4fb42066d5205f23757f;hpb=152d414da2432cc95b79302a70a59b4cca4f5338;p=dbsrgits%2FDBIx-Class.git diff --git a/t/resultset/as_query.t b/t/resultset/as_query.t index b4fa422..43c8ddd 100644 --- a/t/resultset/as_query.t +++ b/t/resultset/as_query.t @@ -10,12 +10,13 @@ use DBIC::SqlMakerTest; plan tests => 4; -my $schema = DBICTest->init_schema(); -my $art_rs = $schema->resultset('Artist'); +my $schema = DBICTest->init_schema(); +my $art_rs = $schema->resultset('Artist'); +my $cdrs = $schema->resultset('CD'); { my $arr = $art_rs->as_query; - my ($query, @bind) = @$arr; + my ($query, @bind) = @{$$arr}; is_same_sql_bind( $query, \@bind, @@ -27,7 +28,7 @@ $art_rs = $art_rs->search({ name => 'Billy Joel' }); { my $arr = $art_rs->as_query; - my ($query, @bind) = @$arr; + my ($query, @bind) = @{$$arr}; is_same_sql_bind( $query, \@bind, @@ -40,7 +41,7 @@ $art_rs = $art_rs->search({ rank => 2 }); { my $arr = $art_rs->as_query; - my ($query, @bind) = @$arr; + my ($query, @bind) = @{$$arr}; is_same_sql_bind( $query, \@bind, @@ -53,7 +54,7 @@ my $rscol = $art_rs->get_column( 'charfield' ); { my $arr = $rscol->as_query; - my ($query, @bind) = @$arr; + my ($query, @bind) = @{$$arr}; is_same_sql_bind( $query, \@bind, @@ -62,4 +63,18 @@ my $rscol = $art_rs->get_column( 'charfield' ); ); } +my $cdrs2 = $cdrs->search({ + artist_id => { + -in => $art_rs->get_column( 'id' )->as_query, + }, +}); + +my @x = $cdrs2->all; +use Data::Dumper; warn Dumper \@x; +__END__ +{ + my $arr = $cdrs2->as_query; + my ($query, @bind) = @{$$arr}; +} + __END__