X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F91debug.t;h=bb55aba58c6eeb34ca4d65b4229da5c0e013922e;hb=fb7a3029bd5b3735ddfad05b301d55a6cd36a1ad;hp=5314ce4b09d049488b227b333f297bd38fa9226f;hpb=9b4591296c196ea0a32e67159e35091b02ecc539;p=dbsrgits%2FDBIx-Class.git diff --git a/t/91debug.t b/t/91debug.t index 5314ce4..bb55aba 100644 --- a/t/91debug.t +++ b/t/91debug.t @@ -4,8 +4,8 @@ use warnings; use Test::More; use lib qw(t/lib); use DBICTest; -use DBICTest::DBICDebugObj; -use SQL::Abstract::Test import => ['is_same_sql_bind']; +use DBIC::DebugObj; +use DBIC::SqlMakerTest; my $schema = DBICTest->init_schema(); @@ -51,22 +51,21 @@ 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 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(DBICTest::DBICDebugObj->new(\$sql, \@bind)); @cds = $schema->resultset('CD')->search( { artist => 1, cdid => { -between => [ 1, 3 ] }, } ); is_same_sql_bind( $sql, \@bind, - "SELECT me.cdid, me.artist, me.title, me.year, me.genreid FROM cd me WHERE ( artist = ? AND cdid BETWEEN ? AND ? )", ["'1'", "'1'", "'3'"], + "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'"], 'got correct SQL with all bind parameters (debugobj)' ); }