From ddbf47a6f25b92f0ec9fa41b6e9e2492f2fe9a52 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Wed, 23 Mar 2016 17:31:46 -0400 Subject: [PATCH] LP#1549505: Add back the global (copy/uri unaware) fixed rating population function Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql | 9 +++++++++ 1 file changed, 9 insertions(+) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql index 5ac1aebec9..ff24030682 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql @@ -970,6 +970,15 @@ BEGIN END; $f$ LANGUAGE PLPGSQL STRICT; +CREATE OR REPLACE FUNCTION rating.generic_fixed_rating_global(badge_id INT) + RETURNS TABLE (record BIGINT, value NUMERIC) AS $f$ +BEGIN + PERFORM rating.precalc_bibs_by_copy_or_uri(badge_id); + RETURN QUERY + SELECT id, 1.0 FROM precalc_filter_bib_list; +END; +$f$ LANGUAGE PLPGSQL STRICT; + CREATE INDEX hold_fulfillment_time_idx ON action.hold_request (fulfillment_time) WHERE fulfillment_time IS NOT NULL; CREATE INDEX hold_request_time_idx ON action.hold_request (request_time); -- 2.11.0