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:41:49 +0000 (14:41 -0400)
commit5edb9d1bb36f6da61ab39bafdc31e8221acd2194
treecef0e41c10c3154683139f22ae001cd06766fdbe
parent3bc815fe21386913432920f18479e85beb9db3e5
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]