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
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()

Impressum / About Us