From 21ac3587d1075771759b8383b2f8b95195ccc489 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Wed, 5 Jul 2023 15:44:32 +0200 Subject: [PATCH] Bug 27824: Add a test Signed-off-by: Owen Leonard Signed-off-by: Katrin Fischer Signed-off-by: Tomas Cohen Arazi (cherry picked from commit a91e80af7dc76c926c246b8f6f98bf6682345dcd) Signed-off-by: Martin Renvoize (cherry picked from commit 5f6f595af593c0f4dcc8a6f55177cb2a11e56096) Signed-off-by: Matt Blenkinsop --- t/db_dependent/Koha/Reports.t | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) diff --git a/t/db_dependent/Koha/Reports.t b/t/db_dependent/Koha/Reports.t index 2b0e630039..5db4d3bae9 100755 --- a/t/db_dependent/Koha/Reports.t +++ b/t/db_dependent/Koha/Reports.t @@ -49,7 +49,7 @@ $retrieved_report_1->delete; is( Koha::Reports->search->count, $nb_of_reports + 1, 'Delete should have deleted the report' ); subtest 'prep_report' => sub { - plan tests => 3; + plan tests => 4; my $report = Koha::Report->new({ report_name => 'report_name_for_test_1', @@ -68,6 +68,12 @@ subtest 'prep_report' => sub { ($sql, undef) = $report->prep_report( [],["1\n12\n\r243",'the other',"42\n32\n22\n12"] ); is( $sql, qq{SELECT * FROM items WHERE itemnumber IN ('1','12','243') AND 'the other' AND ('42','32','22','12') /* saved_sql.id: $id */},'Expected sql generated correctly with multiple params and no names'); + $report->savedsql( + q{SELECT i.itemnumber, i.itemnumber as Exemplarnummber, [[i.itemnumber| itemnumber for batch]] FROM items}) + ->store; + my $headers; + ( $sql, $headers ) = $report->prep_report( [], [] ); + is_deeply( $headers, { 'itemnumber for batch' => 'itemnumber' } ); }; $schema->storage->txn_rollback; -- 2.39.5