|
Lines 432-438
subtest q{Test Koha::Database->schema()->resultset('Item')->itemtype()} => sub {
Link Here
|
| 432 |
}; |
432 |
}; |
| 433 |
|
433 |
|
| 434 |
subtest 'SearchItems test' => sub { |
434 |
subtest 'SearchItems test' => sub { |
| 435 |
plan tests => 15; |
435 |
plan tests => 17; |
| 436 |
|
436 |
|
| 437 |
$schema->storage->txn_begin; |
437 |
$schema->storage->txn_begin; |
| 438 |
my $dbh = C4::Context->dbh; |
438 |
my $dbh = C4::Context->dbh; |
|
Lines 630-635
subtest 'SearchItems test' => sub {
Link Here
|
| 630 |
($items, $total_results) = SearchItems($filter); |
630 |
($items, $total_results) = SearchItems($filter); |
| 631 |
is($total_results, 1, "Search items.issues issues = 0 returns result (items.issues defaults to 0)"); |
631 |
is($total_results, 1, "Search items.issues issues = 0 returns result (items.issues defaults to 0)"); |
| 632 |
|
632 |
|
|
|
633 |
# Is null |
| 634 |
$filter = { |
| 635 |
field => 'new_status', |
| 636 |
query => 0, |
| 637 |
operator => '=' |
| 638 |
}; |
| 639 |
($items, $total_results) = SearchItems($filter); |
| 640 |
ok(scalar @$items == 0, 'found no item with new_status=0 without ifnull'); |
| 641 |
|
| 642 |
$filter->{ifnull} = 0; |
| 643 |
($items, $total_results) = SearchItems($filter); |
| 644 |
ok(scalar @$items == 3, 'found all items with new_status=0 with ifnull = 0'); |
| 645 |
|
| 633 |
$schema->storage->txn_rollback; |
646 |
$schema->storage->txn_rollback; |
| 634 |
}; |
647 |
}; |
| 635 |
|
648 |
|
| 636 |
- |
|
|