LP1910546 Prevent Copy Location Delete With Active Copies user/berick/lp1910546-reject-active-acpl-delete
authorBill Erickson <berickxx@gmail.com>
Tue, 19 Jul 2022 14:19:29 +0000 (10:19 -0400)
committerBill Erickson <berickxx@gmail.com>
Tue, 19 Jul 2022 14:19:34 +0000 (10:19 -0400)
commit9705701d80fad8c93171102945976c93cf280c31
treeab3b07eaba89cc7375915311496444196999963e
parentba2fc41399e9723361245a95e64d78a6c1eb2e59
LP1910546 Prevent Copy Location Delete With Active Copies

Raise a database exception when any attempt is made to marke a copy
location as deleted when the location contains non-deleted copies.

To Test:

1. Navigate to /eg2/staff/admin/local/asset/copy_location

2. Attempt to delete a copy location that is known to contain
   non-deleted copies.

3. Confirm an error message is displayed and the location is not marked
   as deleted.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Open-ILS/src/sql/Pg/800.fkeys.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.reject-active-acpl-delete.sql [new file with mode: 0644]