liquid_feedback_core
changeset 117:a5d39efbfe5b
Code cleanup in update script: Include INSERT into "invite_code_unit" in transaction, Grouped UPDATE "issue" statements
author | jbe |
---|---|
date | Mon Mar 07 11:42:46 2011 +0100 (2011-03-07) |
parents | 1cec513e27ac |
children | 7d6c5032262f |
files | update/core-update.v1.3.1-v1.4.0_rc1.sql |
line diff
1.1 --- a/update/core-update.v1.3.1-v1.4.0_rc1.sql Mon Mar 07 03:50:00 2011 +0100 1.2 +++ b/update/core-update.v1.3.1-v1.4.0_rc1.sql Mon Mar 07 11:42:46 2011 +0100 1.3 @@ -135,7 +135,9 @@ 1.4 1.5 COMMENT ON TABLE "invite_code_unit" IS 'Units where accounts created with a given invite codes get voting rights'; 1.6 1.7 --- TODO: Table is filled after this transaction (see below) 1.8 +INSERT INTO "invite_code_unit" ("invite_code_id", "unit_id") 1.9 + SELECT "id" AS "invite_code_id", 1 AS "unit_id" 1.10 + FROM "invite_code" WHERE "used" ISNULL; 1.11 1.12 1.13 -- New table "privilege": 1.14 @@ -2010,6 +2012,16 @@ 1.15 ELSE 1.16 'canceled_revoked_before_accepted'::"issue_state" -- NOTE: corrected later 1.17 END; 1.18 +UPDATE "issue" SET "state" = 'finished_with_winner' 1.19 + FROM "initiative" 1.20 + WHERE "issue"."id" = "initiative"."issue_id" 1.21 + AND "issue"."state" = 'finished_without_winner' 1.22 + AND "initiative"."agreed"; 1.23 +UPDATE "issue" SET "state" = 'canceled_issue_not_accepted' 1.24 + FROM "initiative" 1.25 + WHERE "issue"."id" = "initiative"."issue_id" 1.26 + AND "issue"."state" = 'canceled_revoked_before_accepted' 1.27 + AND "initiative"."revoked" ISNULL; 1.28 1.29 ALTER TABLE "issue" ALTER "state" SET NOT NULL; 1.30 1.31 @@ -2039,17 +2051,6 @@ 1.32 ("state" = 'finished_with_winner' AND "closed" NOTNULL AND "fully_frozen" NOTNULL AND "ranks_available" = TRUE) 1.33 )); 1.34 1.35 -UPDATE "issue" SET "state" = 'finished_with_winner' 1.36 - FROM "initiative" 1.37 - WHERE "issue"."id" = "initiative"."issue_id" 1.38 - AND "issue"."state" = 'finished_without_winner' 1.39 - AND "initiative"."agreed"; 1.40 -UPDATE "issue" SET "state" = 'canceled_issue_not_accepted' 1.41 - FROM "initiative" 1.42 - WHERE "issue"."id" = "initiative"."issue_id" 1.43 - AND "issue"."state" = 'canceled_revoked_before_accepted' 1.44 - AND "initiative"."revoked" ISNULL; 1.45 - 1.46 1.47 -- Guess "revoked_by_member_id" values based on author of current draft: 1.48 1.49 @@ -2063,13 +2064,6 @@ 1.50 CHECK ("revoked" NOTNULL = "revoked_by_member_id" NOTNULL); 1.51 1.52 1.53 --- Attach existing and unused invite codes with unit id 1: 1.54 - 1.55 -INSERT INTO "invite_code_unit" ("invite_code_id", "unit_id") 1.56 - SELECT "id" AS "invite_code_id", 1 AS "unit_id" 1.57 - FROM "invite_code" WHERE "used" ISNULL; 1.58 - 1.59 - 1.60 -- Fill "unit_id" column with default value where neccessary: 1.61 1.62 UPDATE "delegation" SET "unit_id" = 1 WHERE "scope" = 'unit'; 1.63 @@ -2079,3 +2073,5 @@ 1.64 ("scope" = 'unit' AND "unit_id" NOTNULL AND "area_id" ISNULL AND "issue_id" ISNULL ) OR 1.65 ("scope" = 'area' AND "unit_id" ISNULL AND "area_id" NOTNULL AND "issue_id" ISNULL ) OR 1.66 ("scope" = 'issue' AND "unit_id" ISNULL AND "area_id" ISNULL AND "issue_id" NOTNULL) ); 1.67 + 1.68 +