From f2c33d194c8fc303a7a9addda3930f04fe14c4df Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Fri, 23 Aug 2019 14:40:51 -0400 Subject: [PATCH] adding fixed fields table to migration tools data --- sql/base/fixed_fields.sql | 33 +++++++++++++++++++++++++++++++++ 1 files changed, 33 insertions(+), 0 deletions(-) diff --git a/sql/base/fixed_fields.sql b/sql/base/fixed_fields.sql index a9652c6..7ab6748 100644 --- a/sql/base/fixed_fields.sql +++ b/sql/base/fixed_fields.sql @@ -1,3 +1,36 @@ +DROP TABLE IF EXISTS migration_tools.search_format_map; +CREATE TABLE migration_tools.search_format_map (code TEXT, itype CHAR(1), iform CHAR(1), phy CHAR(1), phyv CHAR(1), phyp SMALLINT, + biblevel CHAR(1), iform_exclude CHAR(1)[], srform_exclude CHAR(1)[] ); +INSERT INTO search_format_map (code, itype, iform, phy, phyv, phyp, biblevel, iform_exclude, srform_exclude) VALUES + -- itype iform phy phyv phyp bib itemform exclude sr format exclude + ('blu-ray', 'g', NULL, 'v', 's', 4, NULL, NULL, NULL) + ,('book', 'a', NULL, NULL, NULL, NULL, 'a', '{a,b,c,f,o,q,r,s}', NULL) + ,('braille', 'a', 'f', NULL, NULL, NULL, NULL, NULL, NULL) + ,('casaudiobook', 'i', NULL, 's', 'l', 3, NULL, NULL, NULL) + ,('casmusic', 'j', NULL, 's', 'l', 3, NULL, NULL, NULL) + ,('cdaudiobook', 'i', NULL, 's', 'f', 3, NULL, NULL, NULL) + ,('cdmusic', 'j', NULL, 's', 'f', 3, NULL, NULL, NULL) + ,('dvd', 'g', NULL, 'v', 'v', 4, NULL, NULL, NULL) + ,('eaudio', 'i', 'o', NULL, NULL, NULL, NULL, NULL, NULL) + ,('ebook', 'a', 's', NULL, NULL, NULL, 'a' , NULL, NULL) + ,('electronic', 's', 'o', NULL, NULL, NULL, NULL, NULL, NULL) + ,('equip', 'r', NULL, NULL, NULL, NULL, NULL, NULL, NULL) + ,('evideo', 'g', 'o', NULL, NULL, NULL, NULL, NULL, NULL) + ,('kit', 'o', NULL, NULL, NULL, NULL, NULL, NULL, NULL) + ,('lpbook', 'a', 'd', NULL, NULL, NULL, 'a' , NULL, NULL) + ,('map', 'e', NULL, NULL, NULL, NULL, NULL, NULL, NULL) + ,('microform', 'a', 'b', NULL, NULL, NULL, NULL, NULL, NULL) + ,('music', 'j', NULL, NULL, NULL, NULL, NULL, NULL, '{a,b,c,d,e,f}') + ,('phonomusic', 'j', NULL, 's', 'a', 3, NULL, NULL, NULL) + ,('phonospoken', 'i', NULL, 's', 'a', 3, NULL, NULL, NULL) + ,('picture', 'k', NULL, NULL, NULL, NULL, NULL, NULL, NULL) + ,('preloadedaudio', 'i', 'q', NULL, NULL, NULL, NULL, NULL, '{a,b,c,d,e,f,s}') + ,('score', 'c', NULL, NULL, NULL, NULL, NULL, NULL, NULL) + ,('serial', NULL, NULL, NULL, NULL, NULL, 's' , NULL, NULL) + ,('software', 'm', NULL, NULL, NULL, NULL, NULL, NULL, NULL) + ,('vhs', 'g', NULL, 'v', 'b', 4, NULL, NULL, NULL) +; + CREATE OR REPLACE FUNCTION migration_tools.reingest_staged_record_attributes (rid BIGINT, pattr_list TEXT[] DEFAULT NULL, prmarc TEXT DEFAULT NULL, rdeleted BOOL DEFAULT TRUE) RETURNS INTEGER[] AS $func$ DECLARE transformed_xml TEXT; -- 1.7.2.5