X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F91debug.t;h=bb55aba58c6eeb34ca4d65b4229da5c0e013922e;hb=af6aac2d51a435fa60151ac047e1559257fd4eba;hp=5b5514beed886450daec1070f9aaf84193df0952;hpb=af29cd123d78f75d4cc5b622925b7b2860d2d0b7;p=dbsrgits%2FDBIx-Class.git diff --git a/t/91debug.t b/t/91debug.t index 5b5514b..bb55aba 100644 --- a/t/91debug.t +++ b/t/91debug.t @@ -51,18 +51,17 @@ open(STDERR, '>&STDERRCOPY'); # test trace output correctness for bind params { - my ($sql, @bind) = (''); - $schema->storage->debugcb( sub { $sql = $_[1] } ); + my ($sql, @bind); + $schema->storage->debugobj(DBIC::DebugObj->new(\$sql, \@bind)); my @cds = $schema->resultset('CD')->search( { artist => 1, cdid => { -between => [ 1, 3 ] }, } ); is_same_sql_bind( - $sql, [], - "SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track FROM cd me WHERE ( artist = ? AND (cdid BETWEEN ? AND ?) ): '1', '1', '3'", [], + $sql, \@bind, + "SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track FROM cd me WHERE ( artist = ? AND (cdid BETWEEN ? AND ?) ): '1', '1', '3'", + [qw/'1' '1' '3'/], 'got correct SQL with all bind parameters (debugcb)' ); - $schema->storage->debugcb(undef); - $schema->storage->debugobj(DBIC::DebugObj->new(\$sql, \@bind)); @cds = $schema->resultset('CD')->search( { artist => 1, cdid => { -between => [ 1, 3 ] }, } ); is_same_sql_bind( $sql, \@bind,