liquid_feedback_core

annotate test.sql @ 302:548cec6b7a79

find changesets by author, revision, files, or words in the commit message
Better tie-breaking
author jbe
date Sat Sep 29 23:41:37 2012 +0200 (2012-09-29)
parents 44e489d77306
children e403f47525ce
rev   line source
jbe@0 1 -- NOTE: This file requires that sequence generators have not been used.
jbe@0 2 -- (All new rows need to start with id '1'.)
jbe@0 3
jbe@0 4 BEGIN;
jbe@0 5
jbe@184 6 INSERT INTO "member" ("activated", "last_activity", "active", "login", "name") VALUES
jbe@184 7 ('now', 'now', TRUE, 'user1', 'User #1'), -- id 1
jbe@184 8 ('now', 'now', TRUE, 'user2', 'User #2'), -- id 2
jbe@184 9 ('now', 'now', TRUE, 'user3', 'User #3'), -- id 3
jbe@184 10 ('now', 'now', TRUE, 'user4', 'User #4'), -- id 4
jbe@184 11 ('now', 'now', TRUE, 'user5', 'User #5'), -- id 5
jbe@184 12 ('now', 'now', TRUE, 'user6', 'User #6'), -- id 6
jbe@184 13 ('now', 'now', TRUE, 'user7', 'User #7'), -- id 7
jbe@184 14 ('now', 'now', TRUE, 'user8', 'User #8'), -- id 8
jbe@184 15 ('now', 'now', TRUE, 'user9', 'User #9'), -- id 9
jbe@184 16 ('now', 'now', TRUE, 'user10', 'User #10'), -- id 10
jbe@184 17 ('now', 'now', TRUE, 'user11', 'User #11'), -- id 11
jbe@184 18 ('now', 'now', TRUE, 'user12', 'User #12'), -- id 12
jbe@184 19 ('now', 'now', TRUE, 'user13', 'User #13'), -- id 13
jbe@184 20 ('now', 'now', TRUE, 'user14', 'User #14'), -- id 14
jbe@184 21 ('now', 'now', TRUE, 'user15', 'User #15'), -- id 15
jbe@184 22 ('now', 'now', TRUE, 'user16', 'User #16'), -- id 16
jbe@184 23 ('now', 'now', TRUE, 'user17', 'User #17'), -- id 17
jbe@184 24 ('now', 'now', TRUE, 'user18', 'User #18'), -- id 18
jbe@184 25 ('now', 'now', TRUE, 'user19', 'User #19'), -- id 19
jbe@184 26 ('now', 'now', TRUE, 'user20', 'User #20'), -- id 20
jbe@184 27 ('now', 'now', TRUE, 'user21', 'User #21'), -- id 21
jbe@184 28 ('now', 'now', TRUE, 'user22', 'User #22'), -- id 22
jbe@184 29 ('now', 'now', TRUE, 'user23', 'User #23'); -- id 23
jbe@0 30
poelzi@77 31 -- set password to "login"
poelzi@77 32 UPDATE "member" SET "password" = '$1$PcI6b1Bg$2SHjAZH2nMLFp0fxHis.Q0';
jbe@0 33
jbe@0 34 INSERT INTO "policy" (
jbe@155 35 "index",
jbe@155 36 "name",
jbe@155 37 "admission_time",
jbe@155 38 "discussion_time",
jbe@155 39 "verification_time",
jbe@155 40 "voting_time",
jbe@155 41 "issue_quorum_num", "issue_quorum_den",
jbe@155 42 "initiative_quorum_num", "initiative_quorum_den",
jbe@167 43 "direct_majority_num", "direct_majority_den", "direct_majority_strict",
jbe@302 44 "no_reverse_beat_path", "no_multistage_majority",
jbe@302 45 "schulze_variant"
jbe@155 46 ) VALUES (
jbe@155 47 1,
jbe@155 48 'Default policy',
jbe@155 49 '1 hour', '1 hour', '1 hour', '1 hour',
jbe@155 50 25, 100,
jbe@155 51 20, 100,
jbe@155 52 1, 2, TRUE,
jbe@302 53 TRUE, FALSE,
jbe@302 54 'tie_breaking_with_negative_strength'::"schulze_variant" );
jbe@0 55
jbe@3 56 CREATE FUNCTION "time_warp"() RETURNS VOID
jbe@3 57 LANGUAGE 'plpgsql' VOLATILE AS $$
jbe@3 58 BEGIN
jbe@3 59 UPDATE "issue" SET
jbe@3 60 "snapshot" = "snapshot" - '1 hour 1 minute'::INTERVAL,
jbe@3 61 "created" = "created" - '1 hour 1 minute'::INTERVAL,
jbe@3 62 "accepted" = "accepted" - '1 hour 1 minute'::INTERVAL,
jbe@3 63 "half_frozen" = "half_frozen" - '1 hour 1 minute'::INTERVAL,
jbe@3 64 "fully_frozen" = "fully_frozen" - '1 hour 1 minute'::INTERVAL;
jbe@3 65 PERFORM "check_everything"();
jbe@3 66 RETURN;
jbe@3 67 END;
jbe@3 68 $$;
jbe@3 69
jbe@97 70 INSERT INTO "unit" ("name") VALUES ('Main');
jbe@97 71
jbe@97 72 INSERT INTO "privilege" ("unit_id", "member_id", "voting_right")
jbe@97 73 SELECT 1 AS "unit_id", "id" AS "member_id", TRUE AS "voting_right"
jbe@97 74 FROM "member";
jbe@97 75
jbe@97 76 INSERT INTO "area" ("unit_id", "name") VALUES
jbe@97 77 (1, 'Area #1'), -- id 1
jbe@97 78 (1, 'Area #2'), -- id 2
jbe@97 79 (1, 'Area #3'), -- id 3
jbe@97 80 (1, 'Area #4'); -- id 4
jbe@0 81
jbe@9 82 INSERT INTO "allowed_policy" ("area_id", "policy_id", "default_policy")
jbe@9 83 VALUES (1, 1, TRUE), (2, 1, TRUE), (3, 1, TRUE), (4, 1, TRUE);
jbe@9 84
jbe@169 85 INSERT INTO "membership" ("area_id", "member_id") VALUES
jbe@169 86 (1, 9),
jbe@169 87 (1, 19),
jbe@169 88 (2, 9),
jbe@169 89 (2, 10),
jbe@169 90 (2, 17),
jbe@169 91 (3, 9),
jbe@169 92 (3, 11),
jbe@169 93 (3, 12),
jbe@169 94 (3, 14),
jbe@169 95 (3, 20),
jbe@169 96 (3, 21),
jbe@169 97 (3, 22),
jbe@169 98 (4, 6),
jbe@169 99 (4, 9),
jbe@169 100 (4, 13),
jbe@169 101 (4, 22);
jbe@0 102
jbe@0 103 -- global delegations
jbe@0 104 INSERT INTO "delegation"
jbe@97 105 ("truster_id", "scope", "unit_id", "trustee_id") VALUES
jbe@97 106 ( 1, 'unit', 1, 9),
jbe@97 107 ( 2, 'unit', 1, 11),
jbe@97 108 ( 3, 'unit', 1, 12),
jbe@97 109 ( 4, 'unit', 1, 13),
jbe@97 110 ( 5, 'unit', 1, 14),
jbe@97 111 ( 6, 'unit', 1, 7),
jbe@97 112 ( 7, 'unit', 1, 8),
jbe@97 113 ( 8, 'unit', 1, 6),
jbe@97 114 (10, 'unit', 1, 9),
jbe@97 115 (11, 'unit', 1, 9),
jbe@97 116 (12, 'unit', 1, 21),
jbe@97 117 (15, 'unit', 1, 10),
jbe@97 118 (16, 'unit', 1, 17),
jbe@97 119 (17, 'unit', 1, 19),
jbe@97 120 (18, 'unit', 1, 19),
jbe@97 121 (23, 'unit', 1, 22);
jbe@0 122
jbe@302 123 -- no delegations in area #1
jbe@302 124 INSERT INTO "delegation"
jbe@302 125 ("truster_id", "scope", "area_id", "trustee_id") VALUES
jbe@302 126 ( 1, 'area', 1, NULL),
jbe@302 127 ( 2, 'area', 1, NULL),
jbe@302 128 ( 3, 'area', 1, NULL),
jbe@302 129 ( 4, 'area', 1, NULL),
jbe@302 130 ( 5, 'area', 1, NULL),
jbe@302 131 ( 6, 'area', 1, NULL),
jbe@302 132 ( 7, 'area', 1, NULL),
jbe@302 133 ( 8, 'area', 1, NULL),
jbe@302 134 ( 9, 'area', 1, NULL),
jbe@302 135 (10, 'area', 1, NULL),
jbe@302 136 (11, 'area', 1, NULL),
jbe@302 137 (12, 'area', 1, NULL),
jbe@302 138 (13, 'area', 1, NULL),
jbe@302 139 (14, 'area', 1, NULL),
jbe@302 140 (15, 'area', 1, NULL),
jbe@302 141 (16, 'area', 1, NULL),
jbe@302 142 (17, 'area', 1, NULL),
jbe@302 143 (18, 'area', 1, NULL),
jbe@302 144 (19, 'area', 1, NULL),
jbe@302 145 (20, 'area', 1, NULL),
jbe@302 146 (21, 'area', 1, NULL),
jbe@302 147 (22, 'area', 1, NULL),
jbe@302 148 (23, 'area', 1, NULL);
jbe@302 149
jbe@0 150 -- delegations for topics
jbe@0 151 INSERT INTO "delegation"
jbe@10 152 ("area_id", "truster_id", "scope", "trustee_id") VALUES
jbe@302 153 --(1, 3, 'area', 17),
jbe@10 154 (2, 5, 'area', 10),
jbe@10 155 (2, 9, 'area', 10),
jbe@10 156 (3, 4, 'area', 14),
jbe@10 157 (3, 16, 'area', 20),
jbe@10 158 (3, 19, 'area', 20),
jbe@10 159 (4, 5, 'area', 13),
jbe@10 160 (4, 12, 'area', 22);
jbe@0 161
jbe@0 162 INSERT INTO "issue" ("area_id", "policy_id") VALUES
jbe@0 163 (3, 1); -- id 1
jbe@0 164
jbe@0 165 INSERT INTO "initiative" ("issue_id", "name") VALUES
jbe@0 166 (1, 'Initiative #1'), -- id 1
jbe@0 167 (1, 'Initiative #2'), -- id 2
jbe@0 168 (1, 'Initiative #3'), -- id 3
jbe@0 169 (1, 'Initiative #4'), -- id 4
jbe@0 170 (1, 'Initiative #5'), -- id 5
jbe@0 171 (1, 'Initiative #6'), -- id 6
jbe@0 172 (1, 'Initiative #7'); -- id 7
jbe@0 173
jbe@0 174 INSERT INTO "draft" ("initiative_id", "author_id", "content") VALUES
jbe@0 175 (1, 17, 'Lorem ipsum...'), -- id 1
jbe@0 176 (2, 20, 'Lorem ipsum...'), -- id 2
jbe@0 177 (3, 20, 'Lorem ipsum...'), -- id 3
jbe@0 178 (4, 20, 'Lorem ipsum...'), -- id 4
jbe@0 179 (5, 14, 'Lorem ipsum...'), -- id 5
jbe@0 180 (6, 11, 'Lorem ipsum...'), -- id 6
jbe@0 181 (7, 12, 'Lorem ipsum...'); -- id 7
jbe@0 182
jbe@0 183 INSERT INTO "initiator" ("initiative_id", "member_id") VALUES
jbe@0 184 (1, 17),
jbe@0 185 (1, 19),
jbe@0 186 (2, 20),
jbe@0 187 (3, 20),
jbe@0 188 (4, 20),
jbe@0 189 (5, 14),
jbe@0 190 (6, 11),
jbe@0 191 (7, 12);
jbe@0 192
jbe@0 193 INSERT INTO "supporter" ("member_id", "initiative_id", "draft_id") VALUES
jbe@0 194 ( 7, 4, 4),
jbe@0 195 ( 8, 2, 2),
jbe@0 196 (11, 6, 6),
jbe@0 197 (12, 7, 7),
jbe@0 198 (14, 1, 1),
jbe@0 199 (14, 2, 2),
jbe@0 200 (14, 3, 3),
jbe@0 201 (14, 4, 4),
jbe@0 202 (14, 5, 5),
jbe@0 203 (14, 6, 6),
jbe@0 204 (14, 7, 7),
jbe@0 205 (17, 1, 1),
jbe@0 206 (17, 3, 3),
jbe@0 207 (19, 1, 1),
jbe@0 208 (19, 2, 2),
jbe@0 209 (20, 1, 1),
jbe@0 210 (20, 2, 2),
jbe@0 211 (20, 3, 3),
jbe@0 212 (20, 4, 4),
jbe@0 213 (20, 5, 5);
jbe@0 214
jbe@159 215 INSERT INTO "suggestion" ("initiative_id", "author_id", "name", "content") VALUES
jbe@0 216 (1, 19, 'Suggestion #1', 'Lorem ipsum...'); -- id 1
jbe@0 217 INSERT INTO "opinion" ("member_id", "suggestion_id", "degree", "fulfilled") VALUES
jbe@0 218 (14, 1, 2, FALSE);
jbe@0 219 INSERT INTO "opinion" ("member_id", "suggestion_id", "degree", "fulfilled") VALUES
jbe@0 220 (19, 1, 2, FALSE);
jbe@0 221
jbe@134 222 INSERT INTO "issue" ("area_id", "policy_id") VALUES
jbe@134 223 (4, 1); -- id 2
jbe@134 224
jbe@134 225 INSERT INTO "initiative" ("issue_id", "name") VALUES
jbe@139 226 (2, 'Initiative A'), -- id 8
jbe@139 227 (2, 'Initiative B'), -- id 9
jbe@139 228 (2, 'Initiative C'), -- id 10
jbe@139 229 (2, 'Initiative D'); -- id 11
jbe@134 230
jbe@134 231 INSERT INTO "draft" ("initiative_id", "author_id", "content") VALUES
jbe@139 232 ( 8, 1, 'Lorem ipsum...'), -- id 8
jbe@139 233 ( 9, 2, 'Lorem ipsum...'), -- id 9
jbe@139 234 (10, 3, 'Lorem ipsum...'), -- id 10
jbe@139 235 (11, 4, 'Lorem ipsum...'); -- id 11
jbe@134 236
jbe@134 237 INSERT INTO "initiator" ("initiative_id", "member_id") VALUES
jbe@139 238 ( 8, 1),
jbe@139 239 ( 9, 2),
jbe@139 240 (10, 3),
jbe@139 241 (11, 4);
jbe@134 242
jbe@134 243 INSERT INTO "supporter" ("member_id", "initiative_id", "draft_id") VALUES
jbe@139 244 (1, 8, 8),
jbe@139 245 (1, 9, 9),
jbe@139 246 (1, 10, 10),
jbe@139 247 (1, 11, 11),
jbe@139 248 (2, 8, 8),
jbe@139 249 (2, 9, 9),
jbe@139 250 (2, 10, 10),
jbe@139 251 (2, 11, 11),
jbe@139 252 (3, 8, 8),
jbe@139 253 (3, 9, 9),
jbe@139 254 (3, 10, 10),
jbe@139 255 (3, 11, 11),
jbe@139 256 (4, 8, 8),
jbe@139 257 (4, 9, 9),
jbe@139 258 (4, 10, 10),
jbe@139 259 (4, 11, 11),
jbe@139 260 (5, 8, 8),
jbe@139 261 (5, 9, 9),
jbe@139 262 (5, 10, 10),
jbe@139 263 (5, 11, 11),
jbe@139 264 (6, 8, 8),
jbe@139 265 (6, 9, 9),
jbe@139 266 (6, 10, 10),
jbe@139 267 (6, 11, 11);
jbe@302 268
jbe@302 269 INSERT INTO "issue" ("area_id", "policy_id") VALUES
jbe@302 270 (1, 1); -- id 3
jbe@302 271
jbe@302 272 INSERT INTO "initiative" ("issue_id", "name") VALUES
jbe@302 273 (3, 'First initiative'), -- id 12
jbe@302 274 (3, 'Second initiative'); -- id 13
jbe@302 275
jbe@302 276 INSERT INTO "draft" ("initiative_id", "author_id", "content") VALUES
jbe@302 277 (12, 1, 'Lorem ipsum...'), -- id 12
jbe@302 278 (13, 2, 'Lorem ipsum...'); -- id 13
jbe@302 279
jbe@302 280 INSERT INTO "initiator" ("initiative_id", "member_id") VALUES
jbe@302 281 (12, 1),
jbe@302 282 (13, 2);
jbe@302 283
jbe@302 284 INSERT INTO "supporter" ("initiative_id", "member_id") VALUES
jbe@302 285 (12, 1),
jbe@302 286 (13, 2);
jbe@139 287
jbe@3 288 SELECT "time_warp"();
jbe@3 289 SELECT "time_warp"();
jbe@3 290 SELECT "time_warp"();
jbe@0 291
jbe@0 292 INSERT INTO "direct_voter" ("member_id", "issue_id") VALUES
jbe@0 293 ( 8, 1),
jbe@0 294 ( 9, 1),
jbe@0 295 (11, 1),
jbe@0 296 (12, 1),
jbe@0 297 (14, 1),
jbe@0 298 (19, 1),
jbe@0 299 (20, 1),
jbe@0 300 (21, 1);
jbe@0 301
jbe@0 302 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES
jbe@0 303 ( 8, 1, 1, 1),
jbe@0 304 ( 8, 1, 2, 1),
jbe@0 305 ( 8, 1, 3, 1),
jbe@0 306 ( 8, 1, 4, 1),
jbe@0 307 ( 8, 1, 5, 1),
jbe@0 308 ( 8, 1, 6, -1),
jbe@0 309 ( 8, 1, 7, -1),
jbe@0 310 ( 9, 1, 1, -2),
jbe@0 311 ( 9, 1, 2, -3),
jbe@0 312 ( 9, 1, 3, -2),
jbe@0 313 ( 9, 1, 4, -2),
jbe@0 314 ( 9, 1, 5, -2),
jbe@0 315 ( 9, 1, 6, -1),
jbe@0 316 (11, 1, 1, -1),
jbe@0 317 (11, 1, 2, -1),
jbe@0 318 (11, 1, 3, -1),
jbe@0 319 (11, 1, 4, -1),
jbe@0 320 (11, 1, 5, -1),
jbe@0 321 (11, 1, 6, 2),
jbe@0 322 (11, 1, 7, 1),
jbe@0 323 (12, 1, 1, -1),
jbe@0 324 (12, 1, 3, -1),
jbe@0 325 (12, 1, 4, -1),
jbe@0 326 (12, 1, 5, -1),
jbe@0 327 (12, 1, 6, -2),
jbe@0 328 (12, 1, 7, 1),
jbe@0 329 (14, 1, 1, 1),
jbe@0 330 (14, 1, 2, 3),
jbe@0 331 (14, 1, 3, 1),
jbe@0 332 (14, 1, 4, 2),
jbe@0 333 (14, 1, 5, 1),
jbe@0 334 (14, 1, 6, 1),
jbe@0 335 (14, 1, 7, 1),
jbe@0 336 (19, 1, 1, 3),
jbe@0 337 (19, 1, 2, 4),
jbe@0 338 (19, 1, 3, 2),
jbe@0 339 (19, 1, 4, 2),
jbe@0 340 (19, 1, 5, 2),
jbe@0 341 (19, 1, 7, 1),
jbe@0 342 (20, 1, 1, 1),
jbe@0 343 (20, 1, 2, 2),
jbe@0 344 (20, 1, 3, 1),
jbe@0 345 (20, 1, 4, 1),
jbe@0 346 (20, 1, 5, 1),
jbe@0 347 (21, 1, 5, -1);
jbe@0 348
jbe@134 349 INSERT INTO "direct_voter" ("member_id", "issue_id") VALUES
jbe@134 350 ( 1, 2),
jbe@134 351 ( 2, 2),
jbe@134 352 ( 3, 2),
jbe@134 353 ( 4, 2),
jbe@134 354 ( 5, 2),
jbe@134 355 ( 6, 2),
jbe@134 356 ( 7, 2),
jbe@134 357 ( 8, 2),
jbe@134 358 ( 9, 2),
jbe@134 359 (10, 2),
jbe@134 360 (11, 2),
jbe@134 361 (12, 2),
jbe@134 362 (13, 2),
jbe@134 363 (14, 2),
jbe@134 364 (15, 2),
jbe@134 365 (16, 2),
jbe@134 366 (17, 2),
jbe@134 367 (18, 2),
jbe@134 368 (19, 2),
jbe@134 369 (20, 2);
jbe@134 370
jbe@134 371 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES
jbe@139 372 ( 1, 2, 8, 3),
jbe@139 373 ( 1, 2, 9, 4),
jbe@139 374 ( 1, 2, 10, 2),
jbe@139 375 ( 1, 2, 11, 1),
jbe@139 376 ( 2, 2, 8, 3),
jbe@139 377 ( 2, 2, 9, 4),
jbe@139 378 ( 2, 2, 10, 2),
jbe@139 379 ( 2, 2, 11, 1),
jbe@139 380 ( 3, 2, 8, 4),
jbe@139 381 ( 3, 2, 9, 3),
jbe@139 382 ( 3, 2, 10, 2),
jbe@139 383 ( 3, 2, 11, 1),
jbe@139 384 ( 4, 2, 8, 4),
jbe@139 385 ( 4, 2, 9, 3),
jbe@139 386 ( 4, 2, 10, 2),
jbe@139 387 ( 4, 2, 11, 1),
jbe@139 388 ( 5, 2, 8, 4),
jbe@139 389 ( 5, 2, 9, 3),
jbe@139 390 ( 5, 2, 10, 2),
jbe@139 391 ( 5, 2, 11, 1),
jbe@139 392 ( 6, 2, 8, 4),
jbe@139 393 ( 6, 2, 9, 3),
jbe@139 394 ( 6, 2, 10, 2),
jbe@139 395 ( 6, 2, 11, 1),
jbe@139 396 ( 7, 2, 8, 4),
jbe@139 397 ( 7, 2, 9, 3),
jbe@139 398 ( 7, 2, 10, 2),
jbe@139 399 ( 7, 2, 11, 1),
jbe@139 400 ( 8, 2, 8, 4),
jbe@139 401 ( 8, 2, 9, 3),
jbe@139 402 ( 8, 2, 10, 2),
jbe@139 403 ( 8, 2, 11, 1),
jbe@139 404 ( 9, 2, 8, -1),
jbe@139 405 ( 9, 2, 9, 1),
jbe@139 406 ( 9, 2, 10, 3),
jbe@139 407 ( 9, 2, 11, 2),
jbe@139 408 (10, 2, 8, -1),
jbe@139 409 (10, 2, 9, 1),
jbe@139 410 (10, 2, 10, 3),
jbe@139 411 (10, 2, 11, 2),
jbe@139 412 (11, 2, 8, -1),
jbe@139 413 (11, 2, 9, 1),
jbe@139 414 (11, 2, 10, 3),
jbe@139 415 (11, 2, 11, 2),
jbe@139 416 (12, 2, 8, -1),
jbe@139 417 (12, 2, 9, 1),
jbe@139 418 (12, 2, 10, 3),
jbe@139 419 (12, 2, 11, 2),
jbe@139 420 (13, 2, 8, -1),
jbe@139 421 (13, 2, 9, 1),
jbe@139 422 (13, 2, 10, 3),
jbe@139 423 (13, 2, 11, 2),
jbe@139 424 (14, 2, 8, -1),
jbe@139 425 (14, 2, 9, 1),
jbe@139 426 (14, 2, 10, 3),
jbe@139 427 (14, 2, 11, 2),
jbe@139 428 (15, 2, 8, -1),
jbe@139 429 (15, 2, 9, -3),
jbe@139 430 (15, 2, 10, -4),
jbe@139 431 (15, 2, 11, -2),
jbe@139 432 (16, 2, 8, -1),
jbe@139 433 (16, 2, 9, -3),
jbe@139 434 (16, 2, 10, -4),
jbe@139 435 (16, 2, 11, -2),
jbe@139 436 (17, 2, 8, -1),
jbe@139 437 (17, 2, 9, -3),
jbe@139 438 (17, 2, 10, -4),
jbe@139 439 (17, 2, 11, -2),
jbe@139 440 (18, 2, 8, -1),
jbe@139 441 (18, 2, 9, 1),
jbe@139 442 (18, 2, 10, -2),
jbe@139 443 (18, 2, 11, 2),
jbe@139 444 (19, 2, 8, -1),
jbe@139 445 (19, 2, 9, 1),
jbe@139 446 (19, 2, 10, -2),
jbe@139 447 (19, 2, 11, 2),
jbe@139 448 (20, 2, 8, 1),
jbe@139 449 (20, 2, 9, 2),
jbe@139 450 (20, 2, 10, -1),
jbe@139 451 (20, 2, 11, 3);
jbe@134 452
jbe@302 453 INSERT INTO "direct_voter" ("member_id", "issue_id") VALUES
jbe@302 454 ( 1, 3),
jbe@302 455 ( 2, 3),
jbe@302 456 ( 3, 3),
jbe@302 457 ( 4, 3),
jbe@302 458 ( 5, 3);
jbe@302 459
jbe@302 460 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES
jbe@302 461 (1, 3, 12, 1),
jbe@302 462 (1, 3, 13, 1),
jbe@302 463 (2, 3, 12, 1),
jbe@302 464 (2, 3, 13, 1),
jbe@302 465 (3, 3, 12, 0),
jbe@302 466 (3, 3, 13, 1),
jbe@302 467 (4, 3, 12, 0),
jbe@302 468 (4, 3, 13, -1),
jbe@302 469 (5, 3, 12, -1),
jbe@302 470 (5, 3, 13, -1);
jbe@302 471
jbe@3 472 SELECT "time_warp"();
jbe@3 473
jbe@3 474 DROP FUNCTION "time_warp"();
jbe@0 475
poelzi@78 476 -- Test policies that help with testing specific frontend parts
poelzi@78 477
poelzi@78 478 INSERT INTO "policy" (
poelzi@78 479 "index",
poelzi@78 480 "active",
poelzi@78 481 "name",
poelzi@78 482 "description",
poelzi@78 483 "admission_time",
poelzi@78 484 "discussion_time",
poelzi@78 485 "verification_time",
poelzi@78 486 "voting_time",
poelzi@78 487 "issue_quorum_num",
poelzi@78 488 "issue_quorum_den",
poelzi@78 489 "initiative_quorum_num",
poelzi@78 490 "initiative_quorum_den"
poelzi@78 491 ) VALUES (
poelzi@78 492 1,
poelzi@78 493 TRUE,
poelzi@78 494 'Test New',
poelzi@78 495 DEFAULT,
poelzi@78 496 '2 days',
poelzi@78 497 '1 second',
poelzi@78 498 '1 second',
poelzi@78 499 '1 second',
poelzi@82 500 0, 100,
poelzi@82 501 0, 100
poelzi@78 502 ), (
poelzi@78 503 1,
poelzi@78 504 TRUE,
poelzi@78 505 'Test Accept',
poelzi@78 506 DEFAULT,
poelzi@78 507 '1 second',
poelzi@78 508 '2 days',
poelzi@78 509 '1 second',
poelzi@78 510 '1 second',
poelzi@82 511 0, 100,
poelzi@82 512 0, 100
poelzi@78 513 ), (
poelzi@78 514 1,
poelzi@78 515 TRUE,
poelzi@78 516 'Test Frozen',
poelzi@78 517 DEFAULT,
poelzi@78 518 '1 second',
poelzi@78 519 '5 minutes',
poelzi@78 520 '2 days',
poelzi@78 521 '1 second',
poelzi@82 522 0, 100,
poelzi@82 523 0, 100
poelzi@78 524 ), (
poelzi@78 525 1,
poelzi@78 526 TRUE,
poelzi@78 527 'Test Voting',
poelzi@78 528 DEFAULT,
poelzi@78 529 '1 second',
poelzi@78 530 '5 minutes',
poelzi@78 531 '1 second',
poelzi@78 532 '2 days',
poelzi@82 533 0, 100,
poelzi@82 534 0, 100
poelzi@78 535 );
jbe@0 536 END;
jbe@0 537

Impressum / About Us