liquid_feedback_core
view demo.sql @ 0:8d021cb5eaf4
Version beta1
author | jbe |
---|---|
date | Tue Oct 27 12:00:00 2009 +0100 (2009-10-27) |
parents | |
children | 3da35844c874 |
line source
1 -- NOTE: This file requires that sequence generators have not been used.
2 -- (All new rows need to start with id '1'.)
4 BEGIN;
6 INSERT INTO "member" ("login", "name") VALUES
7 ('user1', 'User #1'), -- id 1
8 ('user2', 'User #2'), -- id 2
9 ('user3', 'User #3'), -- id 3
10 ('user4', 'User #4'), -- id 4
11 ('user5', 'User #5'), -- id 5
12 ('user6', 'User #6'), -- id 6
13 ('user7', 'User #7'), -- id 7
14 ('user8', 'User #8'), -- id 8
15 ('user9', 'User #9'), -- id 9
16 ('user10', 'User #10'), -- id 10
17 ('user11', 'User #11'), -- id 11
18 ('user12', 'User #12'), -- id 12
19 ('user13', 'User #13'), -- id 13
20 ('user14', 'User #14'), -- id 14
21 ('user15', 'User #15'), -- id 15
22 ('user16', 'User #16'), -- id 16
23 ('user17', 'User #17'), -- id 17
24 ('user18', 'User #18'), -- id 18
25 ('user19', 'User #19'), -- id 19
26 ('user20', 'User #20'), -- id 20
27 ('user21', 'User #21'), -- id 21
28 ('user22', 'User #22'), -- id 22
29 ('user23', 'User #23'); -- id 23
31 UPDATE "member" SET "password" = "login";
33 INSERT INTO "policy" (
34 "name",
35 "admission_time", "discussion_time", "voting_time",
36 "issue_quorum_num", "issue_quorum_den",
37 "initiative_quorum_num", "initiative_quorum_den"
38 ) VALUES (
39 'Default policy',
40 '1 hour', '1 hour', '1 hour',
41 25, 100,
42 20, 100 );
44 INSERT INTO "area" ("name") VALUES
45 ('Area #1'), -- id 1
46 ('Area #2'), -- id 2
47 ('Area #3'), -- id 3
48 ('Area #4'); -- id 4
50 INSERT INTO "membership" ("area_id", "member_id", "autoreject") VALUES
51 (1, 9, FALSE),
52 (1, 19, FALSE),
53 (2, 9, TRUE),
54 (2, 10, TRUE),
55 (2, 17, TRUE),
56 (3, 9, FALSE),
57 (3, 11, FALSE),
58 (3, 12, TRUE),
59 (3, 14, FALSE),
60 (3, 20, FALSE),
61 (3, 21, TRUE),
62 (3, 22, TRUE),
63 (4, 6, FALSE),
64 (4, 9, FALSE),
65 (4, 13, FALSE),
66 (4, 22, TRUE);
68 -- global delegations
69 INSERT INTO "delegation"
70 ("truster_id", "trustee_id") VALUES
71 ( 1, 9),
72 ( 2, 11),
73 ( 3, 12),
74 ( 4, 13),
75 ( 5, 14),
76 ( 6, 7),
77 ( 7, 8),
78 ( 8, 6),
79 (10, 9),
80 (11, 9),
81 (12, 21),
82 (15, 10),
83 (16, 17),
84 (17, 19),
85 (18, 19),
86 (23, 22);
88 -- delegations for topics
89 INSERT INTO "delegation"
90 ("area_id", "truster_id", "trustee_id") VALUES
91 (1, 3, 17),
92 (2, 5, 10),
93 (2, 9, 10),
94 (3, 4, 14),
95 (3, 16, 20),
96 (3, 19, 20),
97 (4, 5, 13),
98 (4, 12, 22);
100 INSERT INTO "issue" ("area_id", "policy_id") VALUES
101 (3, 1); -- id 1
103 INSERT INTO "initiative" ("issue_id", "name") VALUES
104 (1, 'Initiative #1'), -- id 1
105 (1, 'Initiative #2'), -- id 2
106 (1, 'Initiative #3'), -- id 3
107 (1, 'Initiative #4'), -- id 4
108 (1, 'Initiative #5'), -- id 5
109 (1, 'Initiative #6'), -- id 6
110 (1, 'Initiative #7'); -- id 7
112 INSERT INTO "draft" ("initiative_id", "author_id", "content") VALUES
113 (1, 17, 'Lorem ipsum...'), -- id 1
114 (2, 20, 'Lorem ipsum...'), -- id 2
115 (3, 20, 'Lorem ipsum...'), -- id 3
116 (4, 20, 'Lorem ipsum...'), -- id 4
117 (5, 14, 'Lorem ipsum...'), -- id 5
118 (6, 11, 'Lorem ipsum...'), -- id 6
119 (7, 12, 'Lorem ipsum...'); -- id 7
121 INSERT INTO "initiator" ("initiative_id", "member_id") VALUES
122 (1, 17),
123 (1, 19),
124 (2, 20),
125 (3, 20),
126 (4, 20),
127 (5, 14),
128 (6, 11),
129 (7, 12);
131 INSERT INTO "supporter" ("member_id", "initiative_id", "draft_id") VALUES
132 ( 7, 4, 4),
133 ( 8, 2, 2),
134 (11, 6, 6),
135 (12, 7, 7),
136 (14, 1, 1),
137 (14, 2, 2),
138 (14, 3, 3),
139 (14, 4, 4),
140 (14, 5, 5),
141 (14, 6, 6),
142 (14, 7, 7),
143 (17, 1, 1),
144 (17, 3, 3),
145 (19, 1, 1),
146 (19, 2, 2),
147 (20, 1, 1),
148 (20, 2, 2),
149 (20, 3, 3),
150 (20, 4, 4),
151 (20, 5, 5);
153 INSERT INTO "suggestion" ("initiative_id", "author_id", "name", "description") VALUES
154 (1, 19, 'Suggestion #1', 'Lorem ipsum...'); -- id 1
155 INSERT INTO "opinion" ("member_id", "suggestion_id", "degree", "fulfilled") VALUES
156 (14, 1, 2, FALSE);
157 INSERT INTO "opinion" ("member_id", "suggestion_id", "degree", "fulfilled") VALUES
158 (19, 1, 2, FALSE);
160 UPDATE "issue" SET "created" = "created" - '3 hour 3 minute'::INTERVAL;
161 SELECT check_everything();
162 UPDATE "issue" SET "accepted" = "accepted" - '2 hour 2 minute'::INTERVAL;
163 SELECT check_everything();
165 INSERT INTO "direct_voter" ("member_id", "issue_id") VALUES
166 ( 8, 1),
167 ( 9, 1),
168 (11, 1),
169 (12, 1),
170 (14, 1),
171 (19, 1),
172 (20, 1),
173 (21, 1);
175 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES
176 ( 8, 1, 1, 1),
177 ( 8, 1, 2, 1),
178 ( 8, 1, 3, 1),
179 ( 8, 1, 4, 1),
180 ( 8, 1, 5, 1),
181 ( 8, 1, 6, -1),
182 ( 8, 1, 7, -1),
183 ( 9, 1, 1, -2),
184 ( 9, 1, 2, -3),
185 ( 9, 1, 3, -2),
186 ( 9, 1, 4, -2),
187 ( 9, 1, 5, -2),
188 ( 9, 1, 6, -1),
189 (11, 1, 1, -1),
190 (11, 1, 2, -1),
191 (11, 1, 3, -1),
192 (11, 1, 4, -1),
193 (11, 1, 5, -1),
194 (11, 1, 6, 2),
195 (11, 1, 7, 1),
196 (12, 1, 1, -1),
197 (12, 1, 3, -1),
198 (12, 1, 4, -1),
199 (12, 1, 5, -1),
200 (12, 1, 6, -2),
201 (12, 1, 7, 1),
202 (14, 1, 1, 1),
203 (14, 1, 2, 3),
204 (14, 1, 3, 1),
205 (14, 1, 4, 2),
206 (14, 1, 5, 1),
207 (14, 1, 6, 1),
208 (14, 1, 7, 1),
209 (19, 1, 1, 3),
210 (19, 1, 2, 4),
211 (19, 1, 3, 2),
212 (19, 1, 4, 2),
213 (19, 1, 5, 2),
214 (19, 1, 7, 1),
215 (20, 1, 1, 1),
216 (20, 1, 2, 2),
217 (20, 1, 3, 1),
218 (20, 1, 4, 1),
219 (20, 1, 5, 1),
220 (21, 1, 5, -1);
222 UPDATE "issue" SET
223 "snapshot" = "snapshot" - '1 hour 1 minute'::INTERVAL,
224 "frozen" = "frozen" - '1 hour 1 minute'::INTERVAL;
225 SELECT check_everything();
227 END;