[Koha-bugs] [Bug 22679] circulation_rules are not deleted when accompanying issuingrules are deleted

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Tue Apr 23 16:22:06 CEST 2019


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22679

--- Comment #1 from Nick Clemens <nick at bywatersolutions.com> ---
Created attachment 88489
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=88489&action=edit
Bug 22679: Delete related CirculationRules when Removing IssuingRule

Unfortunately, the tables here can't use a foreign key as one table uses null
where the other uses
'*' This patchset alters the delete method so delete related rules. It is
somewhat of a workaround until
all the columns in issuingrules are moved to circulation_rules

To test:
1 - Add some issuing rules in koha, making sure to set maxissueqty
2 - Check the DB: SELECT * FROM circulation_rules;
3 - note some circulation rules were created
4 - Delete your rules via the staff interface
5 - Check the DB, the circulation rules remain
6 - Apply patch
7 - Repeat
8 - Huzzah! The rules delete!
9 - Prove the tests, read the code

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.


More information about the Koha-bugs mailing list