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 +

Impressum / About Us