@@ -, +, @@ --- t/db_dependent/Illrequests.t | 2 +- t/db_dependent/Reports/Guided.t | 8 ++++---- t/db_dependent/api/v1/acquisitions_orders.t | 2 +- t/db_dependent/api/v1/libraries.t | 2 +- t/db_dependent/api/v1/patrons.t | 8 ++++---- t/db_dependent/api/v1/return_claims.t | 2 +- 6 files changed, 12 insertions(+), 12 deletions(-) --- a/t/db_dependent/Illrequests.t +++ a/t/db_dependent/Illrequests.t @@ -893,7 +893,7 @@ subtest 'Checking out' => sub { item_type => $itemtype->itemtype, branchcode => '---' }); - } qr/^DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails/, + } qr/DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails/, "Item creation fails on bad parameters"; is_deeply($form_stage_bad_branchcode->{value}->{errors}, { --- a/t/db_dependent/Reports/Guided.t +++ a/t/db_dependent/Reports/Guided.t @@ -257,7 +257,7 @@ subtest 'get_saved_reports' => sub { warning_like {local $dbh->{RaiseError} = 0; ($sth, $errors) = execute_query( 'SELECT surname FRM borrowers', # error in the query is intentional 0, 10 ) } - qr/^DBD::mysql::st execute failed: You have an error in your SQL syntax;/, + qr/DBD::mysql::st execute failed: You have an error in your SQL syntax;/, "Wrong SQL syntax raises warning"; ok( defined($errors) && exists($errors->{queryerr}), @@ -400,7 +400,7 @@ subtest 'Email report test' => sub { # for next test, we want to let execute_query capture any SQL errors warning_like { local $dbh->{RaiseError} = 0; ($emails, $errors ) = C4::Reports::Guided::EmailReport({report_id => $report2, module => $letter1->{module} , code => $letter1->{code} }) } - qr/^DBD::mysql::st execute failed/, + qr/DBD::mysql::st execute failed/, 'Error from bad report'; is( $errors->[0]{FATAL}, 'REPORT_FAIL', "Bad report returns failure"); @@ -452,8 +452,8 @@ subtest 'nb_rows() tests' => sub { # for next test, we want to let execute_query capture any SQL errors warning_like - { local $dbh->{RaiseError} = 0; $nb_rows = nb_rows( $bad_query ) } - qr/^DBD::mysql::st execute failed:/, + { $nb_rows = nb_rows( $bad_query ) } + qr/DBD::mysql::st execute failed:/, 'Bad queries raise a warning'; is( $nb_rows, 0, 'nb_rows returns 0 on bad queries' ); --- a/t/db_dependent/api/v1/acquisitions_orders.t +++ a/t/db_dependent/api/v1/acquisitions_orders.t @@ -222,7 +222,7 @@ subtest 'add() tests' => sub { ->status_is(409) ->json_has( '/error' => "Fails when trying to add an existing order_id") ->json_like( '/conflict' => qr/(aqorders\.)?PRIMARY/ ); } - qr/^DBD::mysql::st execute failed: Duplicate entry '(.*)' for key '(aqorders\.)?PRIMARY'/; + qr/DBD::mysql::st execute failed: Duplicate entry '(.*)' for key '(aqorders\.)?PRIMARY'/; $schema->storage->txn_rollback; }; --- a/t/db_dependent/api/v1/libraries.t +++ a/t/db_dependent/api/v1/libraries.t @@ -203,7 +203,7 @@ subtest 'add() tests' => sub { ->status_is(409) ->json_has( '/error' => "Fails when trying to add an existing library_id") ->json_like( '/conflict' => qr/(branches\.)?PRIMARY/ ); } - qr/^DBD::mysql::st execute failed: Duplicate entry '(.*)' for key '(branches\.)?PRIMARY'/; + qr/DBD::mysql::st execute failed: Duplicate entry '(.*)' for key '(branches\.)?PRIMARY'/; $schema->storage->txn_rollback; }; --- a/t/db_dependent/api/v1/patrons.t +++ a/t/db_dependent/api/v1/patrons.t @@ -160,7 +160,7 @@ subtest 'add() tests' => sub { $t->post_ok("//$userid:$password@/api/v1/patrons" => json => $newpatron) ->status_is(409) ->json_is('/error' => "Duplicate ID"); } - qr/^DBD::mysql::st execute failed: Duplicate entry/; + qr/DBD::mysql::st execute failed: Duplicate entry/; $newpatron->{library_id} = $patron->branchcode; @@ -208,7 +208,7 @@ subtest 'add() tests' => sub { ->status_is(409) ->json_has( '/error', 'Fails when trying to POST duplicate cardnumber' ) ->json_like( '/conflict' => qr/(borrowers\.)?cardnumber/ ); } - qr/^DBD::mysql::st execute failed: Duplicate entry '(.*?)' for key '(borrowers\.)?cardnumber'/; + qr/DBD::mysql::st execute failed: Duplicate entry '(.*?)' for key '(borrowers\.)?cardnumber'/; $schema->storage->txn_rollback; }; @@ -287,7 +287,7 @@ subtest 'update() tests' => sub { $t->put_ok("//$userid:$password@/api/v1/patrons/" . $patron_2->borrowernumber => json => $newpatron) ->status_is(400) ->json_is('/error' => "Given library_id does not exist"); } - qr/^DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails/; + qr/DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails/; # Restore the valid library_id $newpatron->{library_id} = $patron_2->branchcode; @@ -312,7 +312,7 @@ subtest 'update() tests' => sub { ->status_is(409) ->json_has( '/error', "Fails when trying to update to an existing cardnumber or userid") ->json_like( '/conflict' => qr/(borrowers\.)?cardnumber/ ); } - qr/^DBD::mysql::st execute failed: Duplicate entry '(.*?)' for key '(borrowers\.)?cardnumber'/; + qr/DBD::mysql::st execute failed: Duplicate entry '(.*?)' for key '(borrowers\.)?cardnumber'/; $newpatron->{ cardnumber } = $patron_1->id . $patron_2->id; $newpatron->{ userid } = "user" . $patron_1->id.$patron_2->id; --- a/t/db_dependent/api/v1/return_claims.t +++ a/t/db_dependent/api/v1/return_claims.t @@ -93,7 +93,7 @@ subtest 'claim_returned() tests' => sub { } )->status_is(409) } - qr/^DBD::mysql::st execute failed: Duplicate entry/; + qr/DBD::mysql::st execute failed: Duplicate entry/; $issue->delete; --