liquid_feedback_core
diff core.sql @ 121:8a1a488a1a67
Bugfix in function "freeze_after_snapshot"; Simplified function "close_voting"
Constraint "valid_state" on table "issue" requires, that "ranks_available" is set to true, if state is set to 'canceled_no_initiative_admitted'.
Function "close_voting" assumes that there was at least one initiative to be voted on (ensured by "freeze_after_snapshot").
Constraint "valid_state" on table "issue" requires, that "ranks_available" is set to true, if state is set to 'canceled_no_initiative_admitted'.
Function "close_voting" assumes that there was at least one initiative to be voted on (ensured by "freeze_after_snapshot").
author | jbe |
---|---|
date | Mon Mar 07 19:15:14 2011 +0100 (2011-03-07) |
parents | 30e0200f82e9 |
children | 1af27a67ee1a |
line diff
1.1 --- a/core.sql Mon Mar 07 14:15:53 2011 +0100 1.2 +++ b/core.sql Mon Mar 07 19:15:14 2011 +0100 1.3 @@ -3258,11 +3258,12 @@ 1.4 WHERE "id" = "issue_id_p"; 1.5 ELSE 1.6 UPDATE "issue" SET 1.7 - "state" = 'canceled_no_initiative_admitted', 1.8 - "accepted" = coalesce("accepted", now()), 1.9 - "half_frozen" = coalesce("half_frozen", now()), 1.10 - "fully_frozen" = now(), 1.11 - "closed" = now() 1.12 + "state" = 'canceled_no_initiative_admitted', 1.13 + "accepted" = coalesce("accepted", now()), 1.14 + "half_frozen" = coalesce("half_frozen", now()), 1.15 + "fully_frozen" = now(), 1.16 + "closed" = now(), 1.17 + "ranks_available" = TRUE 1.18 WHERE "id" = "issue_id_p"; 1.19 -- NOTE: The following DELETE statements have effect only when 1.20 -- issue state has been manipulated 1.21 @@ -3800,17 +3801,10 @@ 1.22 -- mark issue as finished 1.23 UPDATE "issue" SET 1.24 "state" = 1.25 - CASE WHEN NOT EXISTS ( 1.26 - SELECT NULL FROM "initiative" 1.27 - WHERE "issue_id" = "issue_id_p" AND "admitted" 1.28 - ) THEN 1.29 - 'canceled_no_initiative_admitted'::"issue_state" 1.30 + CASE WHEN "dimension_v" = 0 THEN 1.31 + 'finished_without_winner'::"issue_state" 1.32 ELSE 1.33 - CASE WHEN "dimension_v" = 0 THEN 1.34 - 'finished_without_winner'::"issue_state" 1.35 - ELSE 1.36 - 'finished_with_winner'::"issue_state" 1.37 - END 1.38 + 'finished_with_winner'::"issue_state" 1.39 END, 1.40 "ranks_available" = TRUE 1.41 WHERE "id" = "issue_id_p";