From 9ea568ea2f150b7a42eb3de14b001fcd7739febf Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Fri, 25 Feb 2022 08:45:26 -0300 Subject: [PATCH] Bug 30165: Regression tests --- t/db_dependent/api/v1/query.t | 104 ++++++++++++++++++++++++++++++++++ 1 file changed, 104 insertions(+) create mode 100755 t/db_dependent/api/v1/query.t diff --git a/t/db_dependent/api/v1/query.t b/t/db_dependent/api/v1/query.t new file mode 100755 index 0000000000..7fa9443197 --- /dev/null +++ b/t/db_dependent/api/v1/query.t @@ -0,0 +1,104 @@ +#!/usr/bin/env perl + +# This file is part of Koha. +# +# Koha is free software; you can redistribute it and/or modify it +# under the terms of the GNU General Public License as published by +# the Free Software Foundation; either version 3 of the License, or +# (at your option) any later version. +# +# Koha is distributed in the hope that it will be useful, but +# WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with Koha; if not, see . + +use Modern::Perl; + +use Test::More tests => 1; +use Test::Mojo; + +use t::lib::TestBuilder; +use t::lib::Mocks; + +use Koha::Cities; +use Koha::Database; + +my $schema = Koha::Database->new->schema; +my $builder = t::lib::TestBuilder->new; + +my $t = Test::Mojo->new('Koha::REST::V1'); +t::lib::Mocks::mock_preference( 'RESTBasicAuth', 1 ); + +subtest 'q handling tests' => sub { + + plan tests => 16; + + $schema->storage->txn_begin; + + my $librarian = $builder->build_object( + { + class => 'Koha::Patrons', + value => { flags => 2**2 } # catalogue flag = 2 + } + ); + my $password = 'thePassword123'; + $librarian->set_password( { password => $password, skip_validation => 1 } ); + my $userid = $librarian->userid; + + # delete all cities + Koha::Cities->new->delete; + + # No cities, so empty array should be returned + $t->get_ok("//$userid:$password@/api/v1/cities")->status_is(200) + ->json_is( [] ); + + my $names = [ 'AA', 'BA', 'BA', 'CA', 'DA', 'EB', 'FB', 'GB', 'HB', 'IB', ]; + + # Add 10 cities + foreach my $i ( 0 .. 9 ) { + $builder->build_object( + { class => 'Koha::Cities', value => { city_name => $names->[$i] } } + ); + } + + t::lib::Mocks::mock_preference( 'RESTdefaultPageSize', 20 ); + + my $q_ends_with_a = 'q={"name":{"-like":"%A"}}'; + + my $cities = + $t->get_ok( + "//$userid:$password@/api/v1/cities?$q_ends_with_a") + ->status_is(200)->tx->res->json; + + is( scalar @{$cities}, 5, '5 cities retrieved' ); + + my $q_starts_with_a = 'q={"name":{"-like":"A%"}}'; + + $cities = + $t->get_ok( + "//$userid:$password@/api/v1/cities?$q_ends_with_a&$q_starts_with_a") + ->status_is(200)->tx->res->json; + + is( scalar @{$cities}, 1, '1 city retrieved' ); + + my $q_empty_list = "q=[]"; + + $cities = + $t->get_ok( + "//$userid:$password@/api/v1/cities?$q_ends_with_a&$q_starts_with_a&$q_empty_list") + ->status_is(200)->tx->res->json; + + is( scalar @{$cities}, 1, 'empty list as trailing query, 1 city retrieved' ); + + $cities = + $t->get_ok( + "//$userid:$password@/api/v1/cities?$q_empty_list&$q_ends_with_a&$q_starts_with_a") + ->status_is(200)->tx->res->json; + + is( scalar @{$cities}, 1, 'empty list as first query, 1 city retrieved' ); + + $schema->storage->txn_rollback; +}; -- 2.32.0