LP1883171&1940663: Database & IDL updates for copy inventory table
authorJason Stephenson <jason@sigio.com>
Sun, 24 Oct 2021 16:54:31 +0000 (12:54 -0400)
committerJason Stephenson <jason@sigio.com>
Sat, 13 Nov 2021 20:13:05 +0000 (15:13 -0500)
commitdc9691e8b2ac932abac1c379e9c00fad096a9073
tree2bbd694e55d8d854e142969167cb2f3ee42c2461
parent9d72b7184f6e706d1bcbd352d3cc8f8f73d4700b
LP1883171&1940663: 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.

Signed-off-by: Jason Stephenson <jason@sigio.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.actor.copy_inventory.sql [new file with mode: 0644]