From 1465e5b424b8e4c28ab013ff5385c1a57a7d3eae Mon Sep 17 00:00:00 2001 From: Steven Callender Date: Tue, 4 Jun 2013 14:11:50 -0400 Subject: [PATCH] Remove [ and ] characters from seriestitle index LP#1187521 Signed-off-by: Steven Callender Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 20 +++++++++++++ .../upgrade/xxxx.data.series_normalizer.sql | 28 +++++++++++++++++++ 2 files changed, 48 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/xxxx.data.series_normalizer.sql diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql index e524142e97..9893eaea87 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -7530,6 +7530,26 @@ INSERT INTO config.metabib_field_index_norm_map (field,norm,params) WHERE i.func IN ('replace') AND m.id IN (19); +INSERT INTO config.metabib_field_index_norm_map (field,norm,params, pos) + SELECT m.id, + i.id, + $$["]",""]$$, + '-1' + FROM config.metabib_field m, + config.index_normalizer i + WHERE i.func IN ('replace') + AND m.id IN (1); + +INSERT INTO config.metabib_field_index_norm_map (field,norm,params, pos) + SELECT m.id, + i.id, + $$["[",""]$$, + '-1' + FROM config.metabib_field m, + config.index_normalizer i + WHERE i.func IN ('replace') + AND m.id IN (1); + INSERT INTO config.metabib_field_index_norm_map (field,norm,pos) SELECT m.id, i.id, diff --git a/Open-ILS/src/sql/Pg/upgrade/xxxx.data.series_normalizer.sql b/Open-ILS/src/sql/Pg/upgrade/xxxx.data.series_normalizer.sql new file mode 100644 index 0000000000..1249a63a29 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/xxxx.data.series_normalizer.sql @@ -0,0 +1,28 @@ +BEGIN; + +-- Remove [ and ] characters from seriestitle. +-- Those characters don't play well when searching. + +SELECT evergreen.upgrade_deps_block_check('xxxx', :eg_version); -- Callender + +INSERT INTO config.metabib_field_index_norm_map (field,norm,params, pos) + SELECT m.id, + i.id, + $$["]",""]$$, + '-1' + FROM config.metabib_field m, + config.index_normalizer i + WHERE i.func IN ('replace') + AND m.id IN (1); + +INSERT INTO config.metabib_field_index_norm_map (field,norm,params, pos) + SELECT m.id, + i.id, + $$["[",""]$$, + '-1' + FROM config.metabib_field m, + config.index_normalizer i + WHERE i.func IN ('replace') + AND m.id IN (1); + +COMMIT; -- 2.43.2