@@ -, +, @@ --- t/db_dependent/HoldsQueue.t | 16 +++++++++++++--- 1 files changed, 13 insertions(+), 3 deletions(-) --- a/t/db_dependent/HoldsQueue.t +++ a/t/db_dependent/HoldsQueue.t @@ -30,6 +30,19 @@ my $dbh = C4::Context->dbh; $dbh->{AutoCommit} = 0; $dbh->{RaiseError} = 1; +$dbh->do("DELETE FROM reserves"); +$dbh->do("DELETE FROM issues"); +$dbh->do("DELETE FROM items"); +$dbh->do("DELETE FROM biblio"); +$dbh->do("DELETE FROM biblioitems"); +$dbh->do("DELETE FROM transport_cost"); +$dbh->do("DELETE FROM tmp_holdsqueue"); +$dbh->do("DELETE FROM hold_fill_targets"); +$dbh->do("DELETE FROM default_branch_circ_rules"); +$dbh->do("DELETE FROM default_branch_item_rules"); +$dbh->do("DELETE FROM default_circ_rules"); +$dbh->do("DELETE FROM branch_item_rules"); + my $TITLE = "Test Holds Queue XXX"; my %data = ( @@ -59,7 +72,6 @@ $dbh->do("UPDATE systempreferences SET value = ? WHERE variable = 'StaticHoldsQu join( ',', @other_branches, $borrower_branchcode, $least_cost_branch_code)); $dbh->do("UPDATE systempreferences SET value = '0' WHERE variable = 'RandomizeHoldsQueueWeight'"); -$dbh->do("DELETE FROM transport_cost"); my $transport_cost_insert_sth = $dbh->prepare("insert into transport_cost (frombranch, tobranch, cost) values (?, ?, ?)"); # Favour $least_cost_branch_code $transport_cost_insert_sth->execute($borrower_branchcode, $least_cost_branch_code, 0.2); @@ -93,8 +105,6 @@ foreach ( $borrower_branchcode, $least_cost_branch_code, @other_branches ) { $items_insert_sth->execute($barcode++, $_, $borrower_branchcode); } -# Remove existing reserves, makes debugging easier -$dbh->do("DELETE FROM reserves"); my $bibitems = undef; my $priority = 1; # Make a reserve --