# HG changeset patch # User bsw # Date 1328631903 -3600 # Node ID 878526479494db5a23a0cd98b3c5d21aef68f5a2 # Parent 524b46066028737cb7e15cddbd3b61bf2d4c1dbf Removed old test scripts diff -r 524b46066028 -r 878526479494 db/demodata.lua --- a/db/demodata.lua Fri Dec 30 04:04:06 2011 +0100 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,102 +0,0 @@ -#!/usr/bin/env lua - -member_count = 10000 -area_count = 24 -issue_count = 1000 -policy_count = 3 -- do not change - -function write(...) - io.stdout:write(...) -end -function writeln(...) - write(...) - write("\n") -end - -math.randomseed(os.time()) - -writeln('BEGIN;') - -for i = 2, member_count do - writeln('INSERT INTO "member" ("login", "name", "ident_number") VALUES (', "'testuser", i, "', 'Benutzer #", i, "', 'TEST", i, "');") -end - -for i = 1, member_count do - local is_linked = {} - while math.random(4) > 1 do - local k = math.random(member_count) - if not is_linked[k] then - local public = math.random(2) == 1 and "TRUE" or "FALSE" - writeln('INSERT INTO "contact" ("member_id", "other_member_id", "public") VALUES (', i, ", ", k, ", ", public, ");") - is_linked[k] = true - end - end -end - -for i = 2, area_count do - writeln('INSERT INTO "area" ("name") VALUES (', "'Area #", i, "');") -end - -local memberships = {} - -for i = 1, area_count do - memberships[i] = {} - for j = 1, member_count do - if math.random(4) == 1 then - memberships[i][j] = true - local autoreject = math.random(2) == 1 and "TRUE" or "FALSE" - writeln('INSERT INTO "membership" ("member_id", "area_id", "autoreject") VALUES (', j, ", ", i, ", ", autoreject, ");") - end - end -end - -do - local issue_initiative_count = {} - local initiative_draft_count = {} - local initiative_idx = 1 - local draft_count = 0 - for i = 1, issue_count do - local area = math.random(area_count) - writeln('INSERT INTO "issue" ("area_id", "policy_id") VALUES (', area, ", ", math.random(policy_count), ");") - issue_initiative_count[i] = 1 - while math.random(3) > 1 do - issue_initiative_count[i] = issue_initiative_count[i] + 1 - end - for j = 1, issue_initiative_count[i] do - writeln('INSERT INTO "initiative" ("issue_id", "name") VALUES (', i, ", 'Initiative #", initiative_idx, "');") - initiative_draft_count[i] = 1 - while math.random(4) > 1 do - initiative_draft_count[i] = initiative_draft_count[i] + 1 - end - local initiators = {} - local is_used = {} - repeat - local member = math.random(member_count) - if not is_used[member] then - initiators[#initiators+1] = member - is_used[member] = true - end - until math.random(2) == 1 - for k = 1, initiative_draft_count[i] do - draft_count = draft_count + 1 - writeln('INSERT INTO "draft" ("initiative_id", "author_id", "content") VALUES (', initiative_idx, ", ", initiators[math.random(#initiators)], ", 'Lorem ipsum... (#", draft_count, ")');") - end - for k = 1, #initiators do - local member = math.random(member_count) - writeln('INSERT INTO "initiator" ("member_id", "initiative_id") VALUES (', initiators[k], ", ", initiative_idx, ");") - if math.random(50) > 1 then - writeln('INSERT INTO "supporter" ("member_id", "initiative_id", "draft_id") VALUES (', initiators[k], ", ", initiative_idx, ", ", draft_count - math.random(initiative_draft_count[i]) + 1, ");") - end - end - local probability = math.random(99) + 1 - for k = 1, member_count do - if not is_used[k] and (memberships[area][k] and math.random(probability) <= 4 or math.random(probability) == 1) then - writeln('INSERT INTO "supporter" ("member_id", "initiative_id", "draft_id") VALUES (', k, ", ", initiative_idx, ", ", draft_count - math.random(initiative_draft_count[i]) + 1, ");") - end - end - initiative_idx = initiative_idx + 1 - end - end -end - -writeln('END;') diff -r 524b46066028 -r 878526479494 db/vote-test.sql --- a/db/vote-test.sql Fri Dec 30 04:04:06 2011 +0100 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,134 +0,0 @@ -BEGIN; - -INSERT INTO "member" ("login", "name", "ident_number") VALUES - ('bernd', 'Bernd', '002'), - ('cesar', 'Cesar', '003'), - ('doris', 'Doris', '004'), - ('emil', 'Emil', '005'), - ('frank', 'Frank', '006'), - ('gerhard', 'Gerhard', '007'), - ('hugo', 'Hugo', '008'), - ('ines', 'Ines', '009'), - ('johann', 'Johann', '010'), - ('klaus', 'Klaus', '011'), - ('lisa', 'Lisa', '012'), - ('monika', 'Monika', '013'), - ('norbert', 'Norbert', '014'), - ('olaf', 'Olaf', '015'), - ('peter', 'Peter', '016'), - ('quinn', 'Quinn', '017'), - ('ralf', 'Ralf', '018'), - ('sabine', 'Sabine', '019'), - ('tobias', 'Tobias', '020'), - ('ulla', 'Ulla', '021'), - ('vincent', 'Vincent', '022'), - ('wolfgang', 'Wolfgang', '023'), - ('xavier', 'Xavier', '024'), - ('yoko', 'Yoko', '025'), - ('zareb', 'Zareb', '026'); - -INSERT INTO "issue" ("area_id", "policy_id") VALUES (1, 3); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #1'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #2'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #3'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #4'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #5'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #6'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #7'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #8'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #9'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #10'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #11'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #12'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #13'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #14'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #15'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #16'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #17'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #18'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #19'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #20'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #21'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #22'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #23'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #24'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #25'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #26'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #27'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #28'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #29'); -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #30'); - -INSERT INTO "draft" ("initiative_id", "content") SELECT "id", 'Lorem ipsum ...' FROM "initiative"; -INSERT INTO "initiator" ("member_id", "initiative_id") SELECT 1, "id" FROM "initiative"; -INSERT INTO "supporter" ("member_id", "initiative_id", "draft_id") SELECT "member"."id", "initiative"."id", "initiative"."id" FROM "member", "initiative"; - -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 1, 1); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 2, 2); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 3, 3); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 4, 4); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 5, 5); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 6, 6); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 7, 7); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 8, 8); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 9, 9); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 10, 10); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 11, 11); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 12, 12); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 13, 13); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 14, 14); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 15, 15); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 16, 16); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 17, 17); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 18, 18); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 19, 19); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 20, 20); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 21, 21); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 22, 22); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 23, 23); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 24, 24); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 25, 25); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 26, 26); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 27, 27); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 28, 28); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 29, 29); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 30, 30); - -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 1, 2); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 2, 1); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 3, 3); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 4, 4); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 5, 5); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 6, 6); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 7, 7); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 8, 8); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 9, 9); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 10, 10); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 11, 11); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 12, 12); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 13, 13); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 14, 14); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 15, 15); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 16, 16); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 17, 17); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 18, 18); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 19, 19); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 20, 20); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 21, 21); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 22, 22); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 23, 23); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 24, 24); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 25, 25); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 26, 26); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 27, 27); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 28, 28); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 29, 29); -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 30, 30); - - -SELECT check_issues(); -UPDATE issue SET frozen = now(); - -END; - --- UPDATE issue SET closed = now();