From 3a3f3a0cdc2a674b6cae036d0b61b20101898371 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 19 Jan 2012 11:03:44 -0500 Subject: [PATCH] Default Vandelay merge profiles Adds 2 default vandelay merge profiles, in part so users will have some useful sample data, but also so the community can have some basic/consistent profiles for documentation purposes. 1. Match-Only Merge This is a no-op merge. It's only purpose is to allow Vandelay, which requires a profile of some sort to do anything, to find matching records. This is useful for importing holdings when the MARC from the source record is not desired. It will also be useful in the (forthecoming) Vandelay-driven Acquisitions lineitem linking (LP pending). The target/incumbent record is not affected. 2. Full Overlay Used for overlaying an entire inbound MARC record over its target record. The target/incumbent record is completely replaced by the inbound record. For both, 901c is used because it's automatically updated on the target record to match the internal ID, regardless of any field preservation/stripping. Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 6 ++++++ .../upgrade/XXXX.data.vandelay-default-merge-profiles.sql | 14 ++++++++++++++ 2 files changed, 20 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.vandelay-default-merge-profiles.sql diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql index ddb6b39fe3..89e327c2a3 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -11865,4 +11865,10 @@ INSERT INTO action_trigger.environment ( 'owning_lib.billing_address' ); +INSERT INTO vandelay.merge_profile (owner, name, replace_spec) + VALUES (1, 'Match-Only Merge', '901c'); + +INSERT INTO vandelay.merge_profile (owner, name, preserve_spec) + VALUES (1, 'Full Overlay', '901c'); + diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.vandelay-default-merge-profiles.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.vandelay-default-merge-profiles.sql new file mode 100644 index 0000000000..df3d014340 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.vandelay-default-merge-profiles.sql @@ -0,0 +1,14 @@ +-- Evergreen DB patch XXXX.data.vandelay-default-merge-profiles.sql +BEGIN; + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +INSERT INTO vandelay.merge_profile (owner, name, replace_spec) + VALUES (1, 'Match-Only Merge', '901c'); + +INSERT INTO vandelay.merge_profile (owner, name, preserve_spec) + VALUES (1, 'Full Overlay', '901c'); + + +COMMIT; -- 2.11.0