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
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",