Test::DatabaseRow fail
examples/db/dbrow_fail.t
#!/usr/bin/perl use strict; use warnings; use Test::More tests => 1; use Test::DatabaseRow; use DBI; system "$^X examples/dbi/create_sample.pl"; END { unlink 'sample.db' } my ($email, $pw) = ('foo@bar.com', 'secret'); my $dbh = DBI->connect("dbi:SQLite:dbname=sample.db"); local $Test::DatabaseRow::dbh = $dbh; row_ok( sql => ['SELECT * FROM people WHERE email=? AND pw=?', $email, $pw], tests => [ fname => 'Foo', lname => 'Zorg'], label => "Foo Zorg", ); $dbh->disconnect;
The only difference in the test is that we are expecting SZabo instead of Szabo
Results:
1..1 not ok 1 - Foo Zorg # Failed test 'Foo Zorg' # at examples/db/dbrow_fail.t line 15. # While checking column 'lname' on 1st row # got: 'Bar' # expected: 'Zorg' # Looks like you failed 1 test of 1.