3 INSERT INTO config.upgrade_log (version) VALUES ('0354'); -- berick
5 CREATE OR REPLACE FUNCTION vandelay.template_overlay_bib_record ( v_marc TEXT, eg_id BIGINT, merge_profile_id INT ) RETURNS BOOL AS $$
7 merge_profile vandelay.merge_profile%ROWTYPE;
8 dyn_profile vandelay.compile_profile%ROWTYPE;
18 SELECT b.marc INTO eg_marc
19 FROM biblio.record_entry b
23 IF eg_marc IS NULL OR v_marc IS NULL THEN
24 -- RAISE NOTICE 'no marc for template or bib record';
28 dyn_profile := vandelay.compile_profile( v_marc );
30 IF merge_profile_id IS NOT NULL THEN
31 SELECT * INTO merge_profile FROM vandelay.merge_profile WHERE id = merge_profile_id;
33 dyn_profile.add_rule := BTRIM( dyn_profile.add_rule || ',' || COALESCE(merge_profile.add_spec,''), ',');
34 dyn_profile.strip_rule := BTRIM( dyn_profile.strip_rule || ',' || COALESCE(merge_profile.strip_spec,''), ',');
35 dyn_profile.replace_rule := BTRIM( dyn_profile.replace_rule || ',' || COALESCE(merge_profile.replace_spec,''), ',');
36 dyn_profile.preserve_rule := BTRIM( dyn_profile.preserve_rule || ',' || COALESCE(merge_profile.preserve_spec,''), ',');
40 IF dyn_profile.replace_rule <> '' AND dyn_profile.preserve_rule <> '' THEN
41 -- RAISE NOTICE 'both replace [%] and preserve [%] specified', dyn_profile.replace_rule, dyn_profile.preserve_rule;
45 IF dyn_profile.replace_rule <> '' THEN
47 target_marc = eg_marc;
48 replace_rule = dyn_profile.replace_rule;
50 source_marc = eg_marc;
52 replace_rule = dyn_profile.preserve_rule;
55 UPDATE biblio.record_entry
56 SET marc = vandelay.merge_record_xml( target_marc, source_marc, dyn_profile.add_rule, replace_rule, dyn_profile.strip_rule )
60 -- RAISE NOTICE 'update of biblio.record_entry failed';