X-Git-Url: http://koha-dev.rot13.org:8081/gitweb/?a=blobdiff_plain;f=t%2Fdb_dependent%2FReports%2FGuided.t;h=6373c0e64711a543ec67764a5a9655eb8125069f;hb=9d6d641d1f8b77271800f43bc027b651f9aea52b;hp=c8167488cf48c126265659bab54b5824acf24509;hpb=bb637c825bfc81066f430d5f396480bab87d531c;p=srvgit

diff --git a/t/db_dependent/Reports/Guided.t b/t/db_dependent/Reports/Guided.t
old mode 100644
new mode 100755
index c8167488cf..6373c0e647
--- a/t/db_dependent/Reports/Guided.t
+++ b/t/db_dependent/Reports/Guided.t
@@ -28,7 +28,7 @@ use Koha::Items;
 use Koha::Reports;
 use Koha::Notice::Messages;
 
-use_ok('C4::Reports::Guided');
+use_ok('C4::Reports::Guided', qw( execute_query save_report delete_report strip_limit GetReservedAuthorisedValues IsAuthorisedValueValid GetParametersFromSQL ValidateSQLParameters get_saved_reports update_sql get_report_areas convert_sql EmailReport nb_rows ));
 can_ok(
     'C4::Reports::Guided',
     qw(save_report delete_report execute_query)
@@ -117,6 +117,7 @@ subtest 'GetReservedAuthorisedValues' => sub {
         'cn_source' => 1,
         'categorycode' => 1,
         'biblio_framework' => 1,
+        'list' => 1,
     );
 
     my $reserved_authorised_values = GetReservedAuthorisedValues();
@@ -125,7 +126,7 @@ subtest 'GetReservedAuthorisedValues' => sub {
 };
 
 subtest 'IsAuthorisedValueValid' => sub {
-    plan tests => 8;
+    plan tests => 9;
     ok( IsAuthorisedValueValid('LOC'),
         'User defined authorised value category is valid');
 
@@ -217,7 +218,7 @@ subtest 'get_saved_reports' => sub {
     ok( 0 < scalar @{ get_saved_reports( $report_ids[0] ) }, "filter takes report id" );
 
     my $r1 = Koha::Reports->find($report_ids[0]);
-    $r1 = update_sql($r1->id, { borrowernumber => $r1->borrowernumber, name => 'Just another report' });
+    $r1 = update_sql($r1->id, { %{$r1->unblessed}, borrowernumber => $r1->borrowernumber, name => 'Just another report' });
     is( $r1->cache_expiry, 300, 'cache_expiry has the correct default value, from DBMS' );
 
     #Test delete_report
@@ -257,7 +258,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 +401,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 +453,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' );