LP1883171 & LP1940663: Database & IDL updates for copy inventory table
authorJason Stephenson <jason@sigio.com>
Sun, 24 Oct 2021 16:54:31 +0000 (12:54 -0400)
committerMike Rylander <mrylander@gmail.com>
Thu, 24 Mar 2022 21:24:23 +0000 (17:24 -0400)
commitc21c8f591a5140541b111acb0e69d020615c7bb6
treeda81943ec6a1f2ed0b9c408922ab72c133032c02
parentb3b256184d59702c488d8f05f1029cee799e17e9
LP1883171 & LP1940663: Database & IDL updates for copy inventory table

Add new asset.copy_inventory table with constraints:
  * Foreign Key on copy -> asset.copy.id
  * Unique index on inventory_date and copy
  * Require that copy is at home or may float to inventory_workstation org.

Add IDL entry for asset.copy_inventory table (aci).

Change asset.latest_inventory table into a view.

Mark the asset.latest_inventory IDL entry (alci) read-only.

Provide database upgrade script to make the database changes and move
entries from the asset.latest_inventory table to the
asset.copy_inventory table.

Add pgtap schema tests to validate that the above tables, views, and
constraints exist.

Add pgtap live tests to validate that the table and view constraints
work as intended.

MERGE NOTE: IDL permissions on the new real table were updated to
match previously modified permissions on the old real table.

This work was sponsored by NOBLE.

Signed-off-by: Jason Stephenson <jason@sigio.com>
Signed-off-by: Michele Morgan <mmorgan@noblenet.org>
Signed-off-by: Mike Rylander <mrylander@gmail.com>
Open-ILS/examples/fm_IDL.xml
Open-ILS/src/sql/Pg/040.schema.asset.sql
Open-ILS/src/sql/Pg/800.fkeys.sql
Open-ILS/src/sql/Pg/live_t/lp1883171-copy_inventory.pg [new file with mode: 0644]
Open-ILS/src/sql/Pg/t/lp1883171-copy_inventory-schema.pg [new file with mode: 0644]
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.asset.copy_inventory.sql [new file with mode: 0644]