X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Fresultset%2Fas_query.t;h=9cf2e3604c09b5f4e6cbb943f5e7468686aac061;hb=af6aac2d51a435fa60151ac047e1559257fd4eba;hp=f3a09fc80db9277954e119c688d14d2a05ed24f1;hpb=af29cd123d78f75d4cc5b622925b7b2860d2d0b7;p=dbsrgits%2FDBIx-Class.git diff --git a/t/resultset/as_query.t b/t/resultset/as_query.t index f3a09fc..9cf2e36 100644 --- a/t/resultset/as_query.t +++ b/t/resultset/as_query.t @@ -18,11 +18,8 @@ my $art_rs = $schema->resultset('Artist'); my $cdrs = $schema->resultset('CD'); { - my $arr = $art_rs->as_query; - my ($query, @bind) = @{$$arr}; - is_same_sql_bind( - $query, \@bind, + $art_rs->as_query, "(SELECT me.artistid, me.name, me.rank, me.charfield FROM artist me)", [], ); } @@ -30,11 +27,8 @@ my $cdrs = $schema->resultset('CD'); $art_rs = $art_rs->search({ name => 'Billy Joel' }); { - my $arr = $art_rs->as_query; - my ($query, @bind) = @{$$arr}; - is_same_sql_bind( - $query, \@bind, + $art_rs->as_query, "(SELECT me.artistid, me.name, me.rank, me.charfield FROM artist me WHERE ( name = ? ))", [ [ name => 'Billy Joel' ] ], ); @@ -43,11 +37,8 @@ $art_rs = $art_rs->search({ name => 'Billy Joel' }); $art_rs = $art_rs->search({ rank => 2 }); { - my $arr = $art_rs->as_query; - my ($query, @bind) = @{$$arr}; - is_same_sql_bind( - $query, \@bind, + $art_rs->as_query, "(SELECT me.artistid, me.name, me.rank, me.charfield FROM artist me WHERE ( ( ( rank = ? ) AND ( name = ? ) ) ) )", [ [ rank => 2 ], [ name => 'Billy Joel' ] ], ); @@ -56,11 +47,8 @@ $art_rs = $art_rs->search({ rank => 2 }); my $rscol = $art_rs->get_column( 'charfield' ); { - my $arr = $rscol->as_query; - my ($query, @bind) = @{$$arr}; - is_same_sql_bind( - $query, \@bind, + $rscol->as_query, "(SELECT me.charfield FROM artist me WHERE ( ( ( rank = ? ) AND ( name = ? ) ) ) )", [ [ rank => 2 ], [ name => 'Billy Joel' ] ], );