3 SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
5 INSERT INTO config.global_flag (name, label) -- defaults to enabled=FALSE
7 'ingest.skip_browse_indexing',
9 'ingest.skip_browse_indexing',
10 'Bibliographic Record Ingest: Disable extraction and indexing of browse data',
16 INSERT INTO config.global_flag (name, label) -- defaults to enabled=FALSE
18 'ingest.skip_search_indexing',
20 'ingest.skip_search_indexing',
21 'Bibliographic Record Ingest: Disable extraction and indexing of search data',
27 INSERT INTO config.global_flag (name, label) -- defaults to enabled=FALSE
29 'ingest.skip_facet_indexing',
31 'ingest.skip_facet_indexing',
32 'Bibliographic Record Ingest: Disable extraction and indexing of facet data',
38 CREATE OR REPLACE FUNCTION metabib.reingest_metabib_field_entries( bib_id BIGINT, skip_facet BOOL DEFAULT FALSE, skip_browse BOOL DEFAULT FALSE, skip_search BOOL DEFAULT FALSE ) RETURNS VOID AS $func$
41 ind_data metabib.field_entry_template%ROWTYPE;
42 mbe_row metabib.browse_entry%ROWTYPE;
49 SELECT COALESCE(NULLIF(skip_facet, FALSE), enabled) INTO b_skip_facet FROM config.internal_flag WHERE name = 'ingest.skip_facet_indexing';
50 SELECT COALESCE(NULLIF(skip_browse, FALSE), enabled) INTO b_skip_browse FROM config.internal_flag WHERE name = 'ingest.skip_browse_indexing';
51 SELECT COALESCE(NULLIF(skip_search, FALSE), enabled) INTO b_skip_search FROM config.internal_flag WHERE name = 'ingest.skip_search_indexing';
53 PERFORM * FROM config.internal_flag WHERE name = 'ingest.assume_inserts_only' AND enabled;
55 IF NOT b_skip_search THEN
56 FOR fclass IN SELECT * FROM config.metabib_class LOOP
57 -- RAISE NOTICE 'Emptying out %', fclass.name;
58 EXECUTE $$DELETE FROM metabib.$$ || fclass.name || $$_field_entry WHERE source = $$ || bib_id;
61 IF NOT b_skip_facet THEN
62 DELETE FROM metabib.facet_entry WHERE source = bib_id;
64 IF NOT b_skip_browse THEN
65 DELETE FROM metabib.browse_entry_def_map WHERE source = bib_id;
69 FOR ind_data IN SELECT * FROM biblio.extract_metabib_field_entry( bib_id ) LOOP
70 IF ind_data.field < 0 THEN
71 ind_data.field = -1 * ind_data.field;
74 IF ind_data.facet_field AND NOT b_skip_facet THEN
75 INSERT INTO metabib.facet_entry (field, source, value)
76 VALUES (ind_data.field, ind_data.source, ind_data.value);
79 IF ind_data.browse_field AND NOT b_skip_browse THEN
80 -- A caveat about this SELECT: this should take care of replacing
81 -- old mbe rows when data changes, but not if normalization (by
82 -- which I mean specifically the output of
83 -- evergreen.oils_tsearch2()) changes. It may or may not be
84 -- expensive to add a comparison of index_vector to index_vector
85 -- to the WHERE clause below.
86 SELECT INTO mbe_row * FROM metabib.browse_entry WHERE value = ind_data.value;
90 INSERT INTO metabib.browse_entry (value) VALUES
91 (metabib.browse_normalize(ind_data.value, ind_data.field));
92 mbe_id := CURRVAL('metabib.browse_entry_id_seq'::REGCLASS);
95 INSERT INTO metabib.browse_entry_def_map (entry, def, source)
96 VALUES (mbe_id, ind_data.field, ind_data.source);
99 IF ind_data.search_field AND NOT b_skip_search THEN
101 INSERT INTO metabib.$$ || ind_data.field_class || $$_field_entry (field, source, value)
103 quote_literal(ind_data.field) || $$, $$ ||
104 quote_literal(ind_data.source) || $$, $$ ||
105 quote_literal(ind_data.value) ||
113 $func$ LANGUAGE PLPGSQL;