From d40a54380abcc0266b2ea8cf3f8053a064e50892 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Fri, 23 Oct 2015 09:53:59 -0400 Subject: [PATCH] Bug 12803 [QA Followup] - Fix unit tests --- t/db_dependent/HoldsQueue.t | 16 +++++++++++++--- 1 file changed, 13 insertions(+), 3 deletions(-) diff --git a/t/db_dependent/HoldsQueue.t b/t/db_dependent/HoldsQueue.t index b2a0967..db52ab8 100755 --- a/t/db_dependent/HoldsQueue.t +++ b/t/db_dependent/HoldsQueue.t @@ -48,6 +48,19 @@ my $library3 = $builder->build({ source => 'Branch', }); +$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 $borrower = $builder->build({ @@ -75,7 +88,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); @@ -109,8 +121,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 -- 1.7.10.4