From a6cbc679a458c5691cef9301a1c26ef5e9dd0ac6 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Tue, 22 Dec 2015 15:43:31 -0500 Subject: [PATCH] LP#1527342 SQL / IDL Signed-off-by: Bill Erickson --- .../sql/Pg/upgrade/XXXX.schema.decouple_co_history.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.decouple_co_history.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.decouple_co_history.sql index e363e9a69a..4689e1cc69 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.decouple_co_history.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.decouple_co_history.sql @@ -194,8 +194,16 @@ DECLARE cur_usr INTEGER; cur_circ action.circulation%ROWTYPE; last_circ action.circulation%ROWTYPE; + counter INTEGER DEFAULT 1; BEGIN + RAISE NOTICE + 'Migrating circ history for % users. This might take a while...', + (SELECT COUNT(DISTINCT(au.id)) FROM actor.usr au + JOIN actor.usr_setting aus ON (aus.usr = au.id) + WHERE NOT au.deleted AND + aus.name ~ '^history.circ.retention_'); + FOR cur_usr IN SELECT DISTINCT(au.id) FROM actor.usr au @@ -224,6 +232,13 @@ BEGIN cur_circ.id ); + -- useful for alleviating administrator anxiety. + IF counter % 10000 = 0 THEN + RAISE NOTICE 'Migrated history for % total users', counter; + END IF; + + counter := counter + 1; + END LOOP; END LOOP; -- 2.11.0