From d6bb59bf1728cd548834cc87f548eda579944227 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Fri, 26 Feb 2016 16:06:34 -0500 Subject: [PATCH] LP#1549505: more fixes to badge recalculator * set last calculation timestamp when handling fixed badges * fix a syntax error and typo Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) 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 015060565d..3808459b46 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 @@ -291,9 +291,11 @@ BEGIN DELETE FROM rating.record_badge_score WHERE badge = badge_id; EXECUTE $e$ INSERT INTO rating.record_badge_score (record, badge, score) - SELECT bib, $1, $2, FROM $e$ || param.func || $e$($1)$e$ + SELECT record, $1, value FROM $e$ || param.func || $e$($1)$e$ USING badge_id, badge_row.fixed_rating; + UPDATE rating.badge SET last_calc = NOW() WHERE id = badge_id; + RETURN; END IF; -- else, calculate! -- 2.11.0