liquid_feedback_core
diff demo.sql @ 134:bd0cd909189d
Added new column "promising" to table "initiative"; Simplified tie-breaking
Also added example to demo.sql, which results in a promising initiative.
Also added example to demo.sql, which results in a promising initiative.
author | jbe |
---|---|
date | Tue May 24 23:35:29 2011 +0200 (2011-05-24) |
parents | 72792038f7f0 |
children | e3bfa2d7954c |
line diff
1.1 --- a/demo.sql Tue May 24 23:33:29 2011 +0200 1.2 +++ b/demo.sql Tue May 24 23:35:29 2011 +0200 1.3 @@ -186,6 +186,35 @@ 1.4 INSERT INTO "opinion" ("member_id", "suggestion_id", "degree", "fulfilled") VALUES 1.5 (19, 1, 2, FALSE); 1.6 1.7 +INSERT INTO "issue" ("area_id", "policy_id") VALUES 1.8 + (4, 1); -- id 2 1.9 + 1.10 +INSERT INTO "initiative" ("issue_id", "name") VALUES 1.11 + (2, 'Initiative A'), -- id 8 1.12 + (2, 'Initiative B'); -- id 9 1.13 + 1.14 +INSERT INTO "draft" ("initiative_id", "author_id", "content") VALUES 1.15 + (8, 1, 'Lorem ipsum...'), -- id 8 1.16 + (9, 2, 'Lorem ipsum...'); -- id 9 1.17 + 1.18 +INSERT INTO "initiator" ("initiative_id", "member_id") VALUES 1.19 + (8, 1), 1.20 + (9, 2); 1.21 + 1.22 +INSERT INTO "supporter" ("member_id", "initiative_id", "draft_id") VALUES 1.23 + (1, 8, 8), 1.24 + (1, 9, 9), 1.25 + (2, 8, 8), 1.26 + (2, 9, 9), 1.27 + (3, 8, 8), 1.28 + (3, 9, 9), 1.29 + (4, 8, 8), 1.30 + (4, 9, 9), 1.31 + (5, 8, 8), 1.32 + (5, 9, 9), 1.33 + (6, 8, 8), 1.34 + (6, 9, 9); 1.35 + 1.36 SELECT "time_warp"(); 1.37 SELECT "time_warp"(); 1.38 SELECT "time_warp"(); 1.39 @@ -247,6 +276,70 @@ 1.40 (20, 1, 5, 1), 1.41 (21, 1, 5, -1); 1.42 1.43 +INSERT INTO "direct_voter" ("member_id", "issue_id") VALUES 1.44 + ( 1, 2), 1.45 + ( 2, 2), 1.46 + ( 3, 2), 1.47 + ( 4, 2), 1.48 + ( 5, 2), 1.49 + ( 6, 2), 1.50 + ( 7, 2), 1.51 + ( 8, 2), 1.52 + ( 9, 2), 1.53 + (10, 2), 1.54 + (11, 2), 1.55 + (12, 2), 1.56 + (13, 2), 1.57 + (14, 2), 1.58 + (15, 2), 1.59 + (16, 2), 1.60 + (17, 2), 1.61 + (18, 2), 1.62 + (19, 2), 1.63 + (20, 2); 1.64 + 1.65 +INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES 1.66 + ( 1, 2, 8, 2), 1.67 + ( 1, 2, 9, 1), 1.68 + ( 2, 2, 8, 2), 1.69 + ( 2, 2, 9, 1), 1.70 + ( 3, 2, 8, 2), 1.71 + ( 3, 2, 9, 1), 1.72 + ( 4, 2, 8, 2), 1.73 + ( 4, 2, 9, 1), 1.74 + ( 5, 2, 8, 2), 1.75 + ( 5, 2, 9, 1), 1.76 + ( 6, 2, 8, 2), 1.77 + ( 6, 2, 9, 1), 1.78 + ( 7, 2, 8, 2), 1.79 + ( 7, 2, 9, 1), 1.80 + ( 8, 2, 8, 2), 1.81 + ( 8, 2, 9, 1), 1.82 + ( 9, 2, 8, 2), 1.83 + ( 9, 2, 9, 1), 1.84 + (10, 2, 8, -1), 1.85 + (10, 2, 9, 1), 1.86 + (11, 2, 8, -1), 1.87 + (11, 2, 9, 1), 1.88 + (12, 2, 8, -1), 1.89 + (12, 2, 9, 1), 1.90 + (13, 2, 8, -1), 1.91 + (13, 2, 9, 1), 1.92 + (14, 2, 8, -1), 1.93 + (14, 2, 9, 1), 1.94 + (15, 2, 8, -1), 1.95 + (15, 2, 9, 1), 1.96 + (16, 2, 8, -1), 1.97 + (16, 2, 9, 1), 1.98 + (17, 2, 8, -1), 1.99 + (17, 2, 9, -2), 1.100 + (18, 2, 8, -1), 1.101 + (18, 2, 9, -2), 1.102 + (19, 2, 8, -1), 1.103 + (19, 2, 9, -2), 1.104 + (20, 2, 8, -1), 1.105 + (20, 2, 9, -2); 1.106 + 1.107 SELECT "time_warp"(); 1.108 1.109 DROP FUNCTION "time_warp"();