liquid_feedback_core
changeset 317:09e2805decd3
Count non-fulfilled suggestions with positive opinion and fulfilled suggestions with negative opinion for "harmonic_weight" of suggestions
author | jbe |
---|---|
date | Sat Feb 02 20:37:03 2013 +0100 (2013-02-02) |
parents | 727926e290e7 |
children | 89974afd890b |
files | core.sql update/core-update.v2.1.0-v2.1.1.sql |
line diff
1.1 --- a/core.sql Sat Feb 02 20:21:16 2013 +0100 1.2 +++ b/core.sql Sat Feb 02 20:37:03 2013 +0100 1.3 @@ -3184,7 +3184,10 @@ 1.4 JOIN "opinion" 1.5 ON "direct_interest_snapshot"."member_id" = "opinion"."member_id" 1.6 AND "initiative"."id" = "opinion"."initiative_id" 1.7 - AND "opinion"."degree" > 0 1.8 + AND ( 1.9 + ("opinion"."degree" > 0 AND "opinion"."fulfilled" = FALSE) OR 1.10 + ("opinion"."degree" < 0 AND "opinion"."fulfilled" = TRUE) 1.11 + ) 1.12 GROUP BY 1.13 "initiative"."issue_id", 1.14 "opinion"."initiative_id",
2.1 --- a/update/core-update.v2.1.0-v2.1.1.sql Sat Feb 02 20:21:16 2013 +0100 2.2 +++ b/update/core-update.v2.1.0-v2.1.1.sql Sat Feb 02 20:37:03 2013 +0100 2.3 @@ -137,7 +137,10 @@ 2.4 JOIN "opinion" 2.5 ON "direct_interest_snapshot"."member_id" = "opinion"."member_id" 2.6 AND "initiative"."id" = "opinion"."initiative_id" 2.7 - AND "opinion"."degree" > 0 2.8 + AND ( 2.9 + ("opinion"."degree" > 0 AND "opinion"."fulfilled" = FALSE) OR 2.10 + ("opinion"."degree" < 0 AND "opinion"."fulfilled" = TRUE) 2.11 + ) 2.12 GROUP BY 2.13 "initiative"."issue_id", 2.14 "opinion"."initiative_id",