JBAS-2098 Migrate browse data back to stock tables
authorBill Erickson <berickxx@gmail.com>
Thu, 30 Aug 2018 21:34:45 +0000 (17:34 -0400)
committerBill Erickson <berickxx@gmail.com>
Thu, 21 Mar 2019 19:46:23 +0000 (15:46 -0400)
commited2b027ce63db782d81e074514c230943d3b7b36
treefa0ee2bdd066b79d6700aed0dca7c4629157ba00
parentb68c56e731efb4fdd7886412dbf199bac2a46c11
JBAS-2098 Migrate browse data back to stock tables

Move data from the various
metabib.browse_[title|author|subject|series|call_number]_entry_* tables into
the stock metabib.browse_entry_* tables.

The data migration step handles de-duplication and creation of entry,
def_map, and simple_heading_map rows.

UI code is updated to refer to the stock tables as well.

Some local additions added to improve stock browse speed and resolve
index-size issues (combo_sort_value field, metabib_fields_cache field,
and substr indexes).

Includes updates to the new headings report to reference the new tables,
including a materialized view to speed up the initial report collection.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
19 files changed:
KCLS/openils/var/templates_kcls/opac/browse_results.tt2
KCLS/openils/var/templates_kcls/opac/parts/qtype_selector.tt2
KCLS/sql/schema/deploy/stock-browse-cleanup.sql [new file with mode: 0644]
KCLS/sql/schema/deploy/stock-browse-headings-report.sql [new file with mode: 0644]
KCLS/sql/schema/deploy/stock-browse-schema.sql [new file with mode: 0644]
KCLS/sql/schema/revert/stock-browse-cleanup.sql [new file with mode: 0644]
KCLS/sql/schema/revert/stock-browse-headings-report.sql [new file with mode: 0644]
KCLS/sql/schema/revert/stock-browse-schema.sql [new file with mode: 0644]
KCLS/sql/schema/sqitch.plan
KCLS/utility-scripts/CRONTAB
KCLS/utility-scripts/headings_report/refresh_mat_view.sh [new file with mode: 0755]
Open-ILS/examples/fm_IDL.xml
Open-ILS/src/perlmods/lib/OpenILS/Application/Search.pm
Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm
Open-ILS/src/perlmods/lib/OpenILS/WWW/EGCatLoader/Browse.pm
Open-ILS/web/js/dojo/openils/CGI.js
Open-ILS/web/js/ui/default/cat/authority/new_headings.js
Open-ILS/web/js/ui/default/opac/browse_set_navigation.js
recover-stock-browse-db.sql [new file with mode: 0644]