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