liquid_feedback_core

changeset 17:1cba764373d6 beta18

Version beta18

Bug fixed, which caused issue_voting_started events in timeline to be shown only after an issue had been closed
author jbe
date Sat Jan 23 12:00:00 2010 +0100 (2010-01-23)
parents 359d2b311f2c
children ec83b47a9929
files core-update.beta17-beta18.sql core.sql
line diff
     1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/core-update.beta17-beta18.sql	Sat Jan 23 12:00:00 2010 +0100
     1.3 @@ -0,0 +1,50 @@
     1.4 +BEGIN;
     1.5 +
     1.6 +CREATE OR REPLACE VIEW "liquid_feedback_version" AS
     1.7 +  SELECT * FROM (VALUES ('beta18', NULL, NULL, NULL))
     1.8 +  AS "subquery"("string", "major", "minor", "revision");
     1.9 +
    1.10 +CREATE OR REPLACE VIEW "timeline_issue" AS
    1.11 +    SELECT
    1.12 +      "created" AS "occurrence",
    1.13 +      'issue_created'::"timeline_event" AS "event",
    1.14 +      "id" AS "issue_id"
    1.15 +    FROM "issue"
    1.16 +  UNION ALL
    1.17 +    SELECT
    1.18 +      "closed" AS "occurrence",
    1.19 +      'issue_canceled'::"timeline_event" AS "event",
    1.20 +      "id" AS "issue_id"
    1.21 +    FROM "issue" WHERE "closed" NOTNULL AND "fully_frozen" ISNULL
    1.22 +  UNION ALL
    1.23 +    SELECT
    1.24 +      "accepted" AS "occurrence",
    1.25 +      'issue_accepted'::"timeline_event" AS "event",
    1.26 +      "id" AS "issue_id"
    1.27 +    FROM "issue" WHERE "accepted" NOTNULL
    1.28 +  UNION ALL
    1.29 +    SELECT
    1.30 +      "half_frozen" AS "occurrence",
    1.31 +      'issue_half_frozen'::"timeline_event" AS "event",
    1.32 +      "id" AS "issue_id"
    1.33 +    FROM "issue" WHERE "half_frozen" NOTNULL
    1.34 +  UNION ALL
    1.35 +    SELECT
    1.36 +      "fully_frozen" AS "occurrence",
    1.37 +      'issue_voting_started'::"timeline_event" AS "event",
    1.38 +      "id" AS "issue_id"
    1.39 +    FROM "issue"
    1.40 +    WHERE "fully_frozen" NOTNULL
    1.41 +    AND ("closed" ISNULL OR "closed" != "fully_frozen")
    1.42 +  UNION ALL
    1.43 +    SELECT
    1.44 +      "closed" AS "occurrence",
    1.45 +      CASE WHEN "fully_frozen" = "closed" THEN
    1.46 +        'issue_finished_without_voting'::"timeline_event"
    1.47 +      ELSE
    1.48 +        'issue_finished_after_voting'::"timeline_event"
    1.49 +      END AS "event",
    1.50 +      "id" AS "issue_id"
    1.51 +    FROM "issue" WHERE "closed" NOTNULL AND "fully_frozen" NOTNULL;
    1.52 +
    1.53 +COMMIT;
     2.1 --- a/core.sql	Fri Jan 22 12:00:00 2010 +0100
     2.2 +++ b/core.sql	Sat Jan 23 12:00:00 2010 +0100
     2.3 @@ -6,7 +6,7 @@
     2.4  BEGIN;
     2.5  
     2.6  CREATE VIEW "liquid_feedback_version" AS
     2.7 -  SELECT * FROM (VALUES ('beta17', NULL, NULL, NULL))
     2.8 +  SELECT * FROM (VALUES ('beta18', NULL, NULL, NULL))
     2.9    AS "subquery"("string", "major", "minor", "revision");
    2.10  
    2.11  
    2.12 @@ -1416,7 +1416,8 @@
    2.13        'issue_voting_started'::"timeline_event" AS "event",
    2.14        "id" AS "issue_id"
    2.15      FROM "issue"
    2.16 -    WHERE "fully_frozen" NOTNULL AND "closed" != "fully_frozen"
    2.17 +    WHERE "fully_frozen" NOTNULL
    2.18 +    AND ("closed" ISNULL OR "closed" != "fully_frozen")
    2.19    UNION ALL
    2.20      SELECT
    2.21        "closed" AS "occurrence",

Impressum / About Us