From a21fedf285b2e410eb501f947acecced584a4404 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Tue, 8 Jan 2019 13:08:04 -0800 Subject: [PATCH] JBAS-2115 3.2 Sample data update (display field maps) Signed-off-by: Bill Erickson --- .../sql/sample-data/exports/kcls-dev-db-export.sql | 138 ++++++++++++++++----- 1 file changed, 106 insertions(+), 32 deletions(-) diff --git a/KCLS/sql/sample-data/exports/kcls-dev-db-export.sql b/KCLS/sql/sample-data/exports/kcls-dev-db-export.sql index abaa5be323..99e109147b 100644 --- a/KCLS/sql/sample-data/exports/kcls-dev-db-export.sql +++ b/KCLS/sql/sample-data/exports/kcls-dev-db-export.sql @@ -19506,12 +19506,12 @@ COPY actor.toolbar (id, ws, org, usr, label, layout) FROM stdin; SELECT pg_catalog.setval('actor.toolbar_id_seq', 2, true); -SET search_path = public, asset, pg_catalog; - -- -- Data for Name: call_number_class; Type: TABLE DATA; Schema: asset; Owner: evergreen -- +SET search_path = public, asset, pg_catalog; + COPY asset.call_number_class (id, name, normalizer, field) FROM stdin; 1 Generic asset.label_normalizer_generic 050ab,055ab,060ab,070ab,080ab,082ab,086ab,088ab,090,092,096,098,099 4 KCLS asset.label_normalizer_dewey 092ab,099ab,086ab @@ -27427,6 +27427,74 @@ SELECT pg_catalog.setval('authority.heading_field_id_seq', 24, true); -- +-- Data for Name: index_normalizer; Type: TABLE DATA; Schema: config; Owner: evergreen +-- + +COPY config.index_normalizer (id, name, description, func, param_count) FROM stdin; +2 Normalize date range Split date ranges in the form of "XXXX-YYYY" into "XXXX YYYY" for proper index. split_date_range 0 +4 Strip Diacritics Convert text to NFD form and remove non-spacing combining marks. remove_diacritics 0 +5 Up-case Convert text upper case. uppercase 0 +6 Down-case Convert text lower case. lowercase 0 +7 Extract Dewey-like number Extract a string of numeric characters ther resembles a DDC number. call_number_dewey 0 +8 Left truncation Discard the specified number of characters from the left side of the string. left_trunc 1 +9 Right truncation Include only the specified number of characters from the left side of the string. right_trunc 1 +10 First word Include only the first space-separated word of a string. first_word 0 +11 ISBN 10/13 conversion Translate ISBN10 to ISBN13, and vice versa, for indexing purposes. translate_isbn1013 0 +12 Replace Replace all occurances of first parameter in the string with the second parameter. replace 2 +13 Remove Parenthesized Substring Remove any parenthesized substrings from the extracted text, such as the agency code preceding authority record control numbers in subfield 0. remove_paren_substring 0 +14 Trim Surrounding Space Trim leading and trailing spaces from extracted text. btrim 0 +17 Generic Mapping Normalizer Map values or sets of values to new values generic_map_normalizer 1 +18 Coded Value Map Normalizer Applies coded_value_map mapping of values coded_value_map_normalizer 1 +19 Search Normalize Apply search normalization rules to the extracted text. A less extreme version of NACO normalization. search_normalize 0 +20 Number or NULL Normalize Normalize the value to NULL if it is not a number integer_or_null 0 +21 Approximate Low Date Normalize Normalize the value to the nearest date-ish value, rounding down approximate_low_date 0 +22 Approximate High Date Normalize Normalize the value to the nearest date-ish value, rounding up approximate_high_date 0 +23 Trim Trailing Punctuation Eliminate extraneous trailing commas and periods in text metabib.trim_trailing_punctuation 0 +1 NACO Normalize Apply NACO normalization rules to the extracted text. See https://www.loc.gov/aba/pcc/naco/normrule-2.html for details. naco_normalize 0 +3 NACO Normalize -- retain first comma Apply NACO normalization rules to the extracted text, retaining the first comma. See https://www.loc.gov/aba/pcc/naco/normrule-2.html for details. naco_normalize_keep_comma 0 +\. + + +-- +-- Data for Name: heading_field_norm_map; Type: TABLE DATA; Schema: authority; Owner: evergreen +-- + +COPY authority.heading_field_norm_map (id, field, norm, params, pos) FROM stdin; +1 1 1 \N 0 +2 2 1 \N 0 +3 3 1 \N 0 +4 4 1 \N 0 +5 5 1 \N 0 +6 6 1 \N 0 +7 7 1 \N 0 +8 8 1 \N 0 +9 9 1 \N 0 +10 10 1 \N 0 +11 11 1 \N 0 +12 12 1 \N 0 +13 13 1 \N 0 +14 14 1 \N 0 +15 15 1 \N 0 +16 16 1 \N 0 +17 17 1 \N 0 +18 18 1 \N 0 +19 19 1 \N 0 +20 20 1 \N 0 +21 21 1 \N 0 +22 22 1 \N 0 +23 23 1 \N 0 +24 24 1 \N 0 +\. + + +-- +-- Name: heading_field_norm_map_id_seq; Type: SEQUENCE SET; Schema: authority; Owner: evergreen +-- + +SELECT pg_catalog.setval('authority.heading_field_norm_map_id_seq', 24, true); + + +-- -- Data for Name: thesaurus; Type: TABLE DATA; Schema: authority; Owner: evergreen -- @@ -31484,6 +31552,40 @@ COPY config.db_patch_dependencies (db_patch, supersedes, deprecates) FROM stdin; -- +-- Data for Name: display_field_map; Type: TABLE DATA; Schema: config; Owner: evergreen +-- + +COPY config.display_field_map (name, field, multi) FROM stdin; +title 6 f +creators 37 t +subject 16 t +isbn 18 t +series_title 1 t +subject_geographic 11 t +subject_name 12 t +subject_temporal 13 t +subject_topic 14 t +issn 19 t +upc 20 t +tcn 26 f +edition 38 f +physical_description 39 t +genre 33 t +bibliography 46 t +thesis 47 t +performers 49 t +production_credits 48 t +general_note 50 t +publisher 52 f +abstract 41 f +toc 42 f +type_of_resource 43 f +pubdate 44 f +author 51 f +\. + + +-- -- Data for Name: filter_dialog_interface; Type: TABLE DATA; Schema: config; Owner: evergreen -- @@ -38641,35 +38743,6 @@ SELECT pg_catalog.setval('config.idl_field_doc_id_seq', 14, true); -- --- Data for Name: index_normalizer; Type: TABLE DATA; Schema: config; Owner: evergreen --- - -COPY config.index_normalizer (id, name, description, func, param_count) FROM stdin; -2 Normalize date range Split date ranges in the form of "XXXX-YYYY" into "XXXX YYYY" for proper index. split_date_range 0 -4 Strip Diacritics Convert text to NFD form and remove non-spacing combining marks. remove_diacritics 0 -5 Up-case Convert text upper case. uppercase 0 -6 Down-case Convert text lower case. lowercase 0 -7 Extract Dewey-like number Extract a string of numeric characters ther resembles a DDC number. call_number_dewey 0 -8 Left truncation Discard the specified number of characters from the left side of the string. left_trunc 1 -9 Right truncation Include only the specified number of characters from the left side of the string. right_trunc 1 -10 First word Include only the first space-separated word of a string. first_word 0 -11 ISBN 10/13 conversion Translate ISBN10 to ISBN13, and vice versa, for indexing purposes. translate_isbn1013 0 -12 Replace Replace all occurances of first parameter in the string with the second parameter. replace 2 -13 Remove Parenthesized Substring Remove any parenthesized substrings from the extracted text, such as the agency code preceding authority record control numbers in subfield 0. remove_paren_substring 0 -14 Trim Surrounding Space Trim leading and trailing spaces from extracted text. btrim 0 -17 Generic Mapping Normalizer Map values or sets of values to new values generic_map_normalizer 1 -18 Coded Value Map Normalizer Applies coded_value_map mapping of values coded_value_map_normalizer 1 -19 Search Normalize Apply search normalization rules to the extracted text. A less extreme version of NACO normalization. search_normalize 0 -20 Number or NULL Normalize Normalize the value to NULL if it is not a number integer_or_null 0 -21 Approximate Low Date Normalize Normalize the value to the nearest date-ish value, rounding down approximate_low_date 0 -22 Approximate High Date Normalize Normalize the value to the nearest date-ish value, rounding up approximate_high_date 0 -23 Trim Trailing Punctuation Eliminate extraneous trailing commas and periods in text metabib.trim_trailing_punctuation 0 -1 NACO Normalize Apply NACO normalization rules to the extracted text. See https://www.loc.gov/aba/pcc/naco/normrule-2.html for details. naco_normalize 0 -3 NACO Normalize -- retain first comma Apply NACO normalization rules to the extracted text, retaining the first comma. See https://www.loc.gov/aba/pcc/naco/normrule-2.html for details. naco_normalize_keep_comma 0 -\. - - --- -- Name: index_normalizer_id_seq; Type: SEQUENCE SET; Schema: config; Owner: evergreen -- @@ -42965,6 +43038,7 @@ COPY permission.grp_perm_map (id, grp, perm, depth, grantable) FROM stdin; 111 3 95 0 f 1025 2 6 0 f 1026 2 5 0 f +1027 3 608 0 f \. @@ -42972,7 +43046,7 @@ COPY permission.grp_perm_map (id, grp, perm, depth, grantable) FROM stdin; -- Name: grp_perm_map_id_seq; Type: SEQUENCE SET; Schema: permission; Owner: evergreen -- -SELECT pg_catalog.setval('permission.grp_perm_map_id_seq', 1026, true); +SELECT pg_catalog.setval('permission.grp_perm_map_id_seq', 1027, true); -- -- 2.11.0