From d02a1e5c27aa6f92988d39274cabac18b4436ad5 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Fri, 14 Jul 2017 12:29:37 -0400 Subject: [PATCH] Split bib re-fingerprinting into separate post upgrade file; Comment out reingest so we can use pingest.pl instead. --- .../version-upgrade/2.11.3-2.12.0-upgrade-db.sql | 34 +++++++++++----------- .../pines-post-upgrade-2.11-2.12.sql | 10 +++++++ 2 files changed, 27 insertions(+), 17 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/version-upgrade/pines-post-upgrade-2.11-2.12.sql diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.11.3-2.12.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.11.3-2.12.0-upgrade-db.sql index ad5e3e7af6..00faea7516 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/2.11.3-2.12.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.11.3-2.12.0-upgrade-db.sql @@ -955,20 +955,20 @@ REINDEX INDEX actor.actor_usr_first_given_name_unaccent_idx; REINDEX INDEX actor.actor_usr_second_given_name_unaccent_idx; REINDEX INDEX actor.actor_usr_family_name_unaccent_idx; -\qecho Recalculating bib fingerprints; this may take a while -ALTER TABLE biblio.record_entry DISABLE TRIGGER USER; -UPDATE biblio.record_entry SET fingerprint = biblio.extract_fingerprint(marc) WHERE NOT deleted; -ALTER TABLE biblio.record_entry ENABLE TRIGGER USER; - -\qecho Remapping metarecords -SELECT metabib.remap_metarecord_for_bib(id, fingerprint) -FROM biblio.record_entry -WHERE NOT deleted; - -\qecho Running a browse and reingest of your bib records. It may take a while. -\qecho You may cancel now without losing the effect of the rest of the -\qecho upgrade script, and arrange the reingest later. -\qecho . -SELECT metabib.reingest_metabib_field_entries(id, FALSE, FALSE, TRUE) - FROM biblio.record_entry; - +-- \qecho Recalculating bib fingerprints; this may take a while +-- ALTER TABLE biblio.record_entry DISABLE TRIGGER USER; +-- UPDATE biblio.record_entry SET fingerprint = biblio.extract_fingerprint(marc) WHERE NOT deleted; +-- ALTER TABLE biblio.record_entry ENABLE TRIGGER USER; +-- +-- \qecho Remapping metarecords +-- SELECT metabib.remap_metarecord_for_bib(id, fingerprint) +-- FROM biblio.record_entry +-- WHERE NOT deleted; + +-- \qecho Running a browse and reingest of your bib records. It may take a while. +-- \qecho You may cancel now without losing the effect of the rest of the +-- \qecho upgrade script, and arrange the reingest later. +-- \qecho . +-- SELECT metabib.reingest_metabib_field_entries(id, FALSE, FALSE, TRUE) +-- FROM biblio.record_entry; +-- diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-post-upgrade-2.11-2.12.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-upgrade-2.11-2.12.sql new file mode 100644 index 0000000000..f618eeb224 --- /dev/null +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-upgrade-2.11-2.12.sql @@ -0,0 +1,10 @@ +\qecho Recalculating bib fingerprints; this may take a while +ALTER TABLE biblio.record_entry DISABLE TRIGGER USER; +UPDATE biblio.record_entry SET fingerprint = biblio.extract_fingerprint(marc) WHERE NOT deleted; +ALTER TABLE biblio.record_entry ENABLE TRIGGER USER; + +\qecho Remapping metarecords +SELECT metabib.remap_metarecord_for_bib(id, fingerprint) +FROM biblio.record_entry +WHERE NOT deleted; + -- 2.11.0