LP1910546 Prevent Copy Location Delete With Active Copies
authorBill Erickson <berickxx@gmail.com>
Tue, 19 Jul 2022 14:19:29 +0000 (10:19 -0400)
committerMichele Morgan <mmorgan@noblenet.org>
Mon, 1 Aug 2022 18:22:24 +0000 (14:22 -0400)
commitfe2fdc97b2f676fbc93fc59423c3ee3abc3995e4
tree6f6cb701020d6e0f2691bf097d1b75486903143b
parent9c24b92601980f7a46a7044f8eb4a07538c17115
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>
Signed-off-by: Tiffany Little <tlittle@georgialibraries.org>
Signed-off-by: Michele Morgan <mmorgan@noblenet.org>
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]