liquid_feedback_core
changeset 151:dca335a33e0b
Bugfix in function "clean_issue": Temporarily update "issue"."state" to avoid constraint violation
author | jbe |
---|---|
date | Thu Jun 02 02:33:10 2011 +0200 (2011-06-02) |
parents | a426ce0124a2 |
children | c7dbb24108de |
files | core.sql |
line diff
1.1 --- a/core.sql Thu Jun 02 02:16:11 2011 +0200 1.2 +++ b/core.sql Thu Jun 02 02:33:10 2011 +0200 1.3 @@ -4035,9 +4035,9 @@ 1.4 FROM "issue" WHERE "id" = "issue_id_p" 1.5 FOR UPDATE; 1.6 IF "issue_row"."cleaned" ISNULL THEN 1.7 - -- TODO: might be broken due to new constraints! 1.8 UPDATE "issue" SET 1.9 - "closed" = NULL, 1.10 + "state" = 'voting', 1.11 + "closed" = NULL, 1.12 "ranks_available" = FALSE 1.13 WHERE "id" = "issue_id_p"; 1.14 DELETE FROM "delegating_voter" 1.15 @@ -4059,6 +4059,7 @@ 1.16 DELETE FROM "supporter" 1.17 WHERE "issue_id" = "issue_id_p"; 1.18 UPDATE "issue" SET 1.19 + "state" = "issue_row"."state", 1.20 "closed" = "issue_row"."closed", 1.21 "ranks_available" = "issue_row"."ranks_available", 1.22 "cleaned" = now()