liquid_feedback_core
changeset 152:652be62683cb
Backported bugfixes in functions "close_voting" and "clean_issue" to v1.4.0_rcX
- In "close_voting": Only add autoreject votes for admitted issues
- In "clean_issue": Temporarily update "issue"."state" to avoid constraint violation
- In "close_voting": Only add autoreject votes for admitted issues
- In "clean_issue": Temporarily update "issue"."state" to avoid constraint violation
author | jbe |
---|---|
date | Thu Jun 02 03:18:21 2011 +0200 (2011-06-02) |
parents | 0fa3c4739ca7 |
children | c7dbb24108de 2fd12a390f56 |
files | core.sql |
line diff
1.1 --- a/core.sql Thu Jun 02 01:22:41 2011 +0200 1.2 +++ b/core.sql Thu Jun 02 03:18:21 2011 +0200 1.3 @@ -7,7 +7,7 @@ 1.4 BEGIN; 1.5 1.6 CREATE VIEW "liquid_feedback_version" AS 1.7 - SELECT * FROM (VALUES ('1.4.0_rc2', 1, 4, -1)) 1.8 + SELECT * FROM (VALUES ('1.4.0_rc4', 1, 4, -1)) 1.9 AS "subquery"("string", "major", "minor", "revision"); 1.10 1.11 1.12 @@ -3489,7 +3489,8 @@ 1.13 "issue_id_p" AS "issue_id", 1.14 "id" AS "initiative_id", 1.15 -1 AS "grade" 1.16 - FROM "initiative" WHERE "issue_id" = "issue_id_p"; 1.17 + FROM "initiative" 1.18 + WHERE "issue_id" = "issue_id_p" AND "admitted"; 1.19 END LOOP; 1.20 PERFORM "add_vote_delegations"("issue_id_p"); 1.21 UPDATE "issue" SET 1.22 @@ -4019,7 +4020,8 @@ 1.23 FOR UPDATE; 1.24 IF "issue_row"."cleaned" ISNULL THEN 1.25 UPDATE "issue" SET 1.26 - "closed" = NULL, 1.27 + "state" = 'voting', 1.28 + "closed" = NULL, 1.29 "ranks_available" = FALSE 1.30 WHERE "id" = "issue_id_p"; 1.31 DELETE FROM "delegating_voter" 1.32 @@ -4041,6 +4043,7 @@ 1.33 DELETE FROM "supporter" 1.34 WHERE "issue_id" = "issue_id_p"; 1.35 UPDATE "issue" SET 1.36 + "state" = "issue_row"."state", 1.37 "closed" = "issue_row"."closed", 1.38 "ranks_available" = "issue_row"."ranks_available", 1.39 "cleaned" = now()