liquid_feedback_core
changeset 567:797282760db4
Removed unused function "calculate_area_quorum" (done by function "issue_admission")
author | jbe |
---|---|
date | Thu Sep 28 20:12:23 2017 +0200 (2017-09-28) |
parents | 74f98b2196ef |
children | b1326d149247 |
files | core.sql update/core-update.v3.2.2-v4.0.0.sql |
line diff
1.1 --- a/core.sql Wed Sep 27 15:32:36 2017 +0200 1.2 +++ b/core.sql Thu Sep 28 20:12:23 2017 +0200 1.3 @@ -4666,21 +4666,6 @@ 1.4 COMMENT ON FUNCTION "calculate_member_counts"() IS 'Updates "member_count" table and "member_count" column of table "area" by materializing data from views "member_count_view" and "unit_member_count"'; 1.5 1.6 1.7 -CREATE FUNCTION "calculate_area_quorum"() 1.8 - RETURNS VOID 1.9 - LANGUAGE 'plpgsql' VOLATILE AS $$ 1.10 - BEGIN 1.11 - PERFORM "dont_require_transaction_isolation"(); 1.12 - UPDATE "area" SET "issue_quorum" = "view"."issue_quorum" 1.13 - FROM "area_quorum" AS "view" 1.14 - WHERE "view"."area_id" = "area"."id"; 1.15 - RETURN; 1.16 - END; 1.17 - $$; 1.18 - 1.19 -COMMENT ON FUNCTION "calculate_area_quorum"() IS 'Calculate column "issue_quorum" in table "area" from view "area_quorum"'; 1.20 - 1.21 - 1.22 1.23 ------------------------------------ 1.24 -- Calculation of harmonic weight --
2.1 --- a/update/core-update.v3.2.2-v4.0.0.sql Wed Sep 27 15:32:36 2017 +0200 2.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql Thu Sep 28 20:12:23 2017 +0200 2.3 @@ -2531,21 +2531,6 @@ 2.4 COMMENT ON FUNCTION "calculate_member_counts"() IS 'Updates "member_count" table and "member_count" column of table "area" by materializing data from views "member_count_view" and "unit_member_count"'; 2.5 2.6 2.7 -CREATE FUNCTION "calculate_area_quorum"() 2.8 - RETURNS VOID 2.9 - LANGUAGE 'plpgsql' VOLATILE AS $$ 2.10 - BEGIN 2.11 - PERFORM "dont_require_transaction_isolation"(); 2.12 - UPDATE "area" SET "issue_quorum" = "view"."issue_quorum" 2.13 - FROM "area_quorum" AS "view" 2.14 - WHERE "view"."area_id" = "area"."id"; 2.15 - RETURN; 2.16 - END; 2.17 - $$; 2.18 - 2.19 -COMMENT ON FUNCTION "calculate_area_quorum"() IS 'Calculate column "issue_quorum" in table "area" from view "area_quorum"'; 2.20 - 2.21 - 2.22 DROP VIEW "remaining_harmonic_initiative_weight_summands"; 2.23 DROP VIEW "remaining_harmonic_supporter_weight"; 2.24