1.1 --- a/db/demodata.lua	Fri Dec 30 04:04:06 2011 +0100
     1.2 +++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.3 @@ -1,102 +0,0 @@
     1.4 -#!/usr/bin/env lua
     1.5 -
     1.6 -member_count = 10000
     1.7 -area_count = 24
     1.8 -issue_count = 1000
     1.9 -policy_count = 3  -- do not change
    1.10 -
    1.11 -function write(...)
    1.12 -  io.stdout:write(...)
    1.13 -end
    1.14 -function writeln(...)
    1.15 -  write(...)
    1.16 -  write("\n")
    1.17 -end
    1.18 -
    1.19 -math.randomseed(os.time())
    1.20 -
    1.21 -writeln('BEGIN;')
    1.22 -
    1.23 -for i = 2, member_count do
    1.24 -  writeln('INSERT INTO "member" ("login", "name", "ident_number") VALUES (', "'testuser", i, "', 'Benutzer #", i, "', 'TEST", i, "');")
    1.25 -end
    1.26 -
    1.27 -for i = 1, member_count do
    1.28 -  local is_linked = {}
    1.29 -  while math.random(4) > 1 do
    1.30 -    local k = math.random(member_count)
    1.31 -    if not is_linked[k] then
    1.32 -      local public = math.random(2) == 1 and "TRUE" or "FALSE"
    1.33 -      writeln('INSERT INTO "contact" ("member_id", "other_member_id", "public") VALUES (', i, ", ", k, ", ", public, ");")
    1.34 -      is_linked[k] = true
    1.35 -    end
    1.36 -  end
    1.37 -end
    1.38 -
    1.39 -for i = 2, area_count do
    1.40 -  writeln('INSERT INTO "area" ("name") VALUES (', "'Area #", i, "');")
    1.41 -end
    1.42 -
    1.43 -local memberships = {}
    1.44 -
    1.45 -for i = 1, area_count do
    1.46 -  memberships[i] = {}
    1.47 -  for j = 1, member_count do
    1.48 -    if math.random(4) == 1 then
    1.49 -      memberships[i][j] = true
    1.50 -      local autoreject = math.random(2) == 1 and "TRUE" or "FALSE"
    1.51 -      writeln('INSERT INTO "membership" ("member_id", "area_id", "autoreject") VALUES (', j, ", ", i, ", ", autoreject, ");")
    1.52 -    end
    1.53 -  end
    1.54 -end
    1.55 -
    1.56 -do
    1.57 -  local issue_initiative_count = {}
    1.58 -  local initiative_draft_count = {}
    1.59 -  local initiative_idx = 1
    1.60 -  local draft_count = 0
    1.61 -  for i = 1, issue_count do
    1.62 -    local area = math.random(area_count)
    1.63 -    writeln('INSERT INTO "issue" ("area_id", "policy_id") VALUES (', area, ", ", math.random(policy_count), ");")
    1.64 -    issue_initiative_count[i] = 1
    1.65 -    while math.random(3) > 1 do
    1.66 -      issue_initiative_count[i] = issue_initiative_count[i] + 1
    1.67 -    end
    1.68 -    for j = 1, issue_initiative_count[i] do
    1.69 -      writeln('INSERT INTO "initiative" ("issue_id", "name") VALUES (', i, ", 'Initiative #", initiative_idx, "');")
    1.70 -      initiative_draft_count[i] = 1
    1.71 -      while math.random(4) > 1 do
    1.72 -        initiative_draft_count[i] = initiative_draft_count[i] + 1
    1.73 -      end
    1.74 -      local initiators = {}
    1.75 -      local is_used = {}
    1.76 -      repeat
    1.77 -        local member = math.random(member_count)
    1.78 -        if not is_used[member] then
    1.79 -          initiators[#initiators+1] = member
    1.80 -          is_used[member] = true
    1.81 -        end
    1.82 -      until math.random(2) == 1
    1.83 -      for k = 1, initiative_draft_count[i] do
    1.84 -        draft_count = draft_count + 1
    1.85 -        writeln('INSERT INTO "draft" ("initiative_id", "author_id", "content") VALUES (', initiative_idx, ", ", initiators[math.random(#initiators)], ", 'Lorem ipsum... (#", draft_count, ")');")
    1.86 -      end
    1.87 -      for k = 1, #initiators do
    1.88 -        local member = math.random(member_count)
    1.89 -        writeln('INSERT INTO "initiator" ("member_id", "initiative_id") VALUES (', initiators[k], ", ", initiative_idx, ");")
    1.90 -        if math.random(50) > 1 then
    1.91 -          writeln('INSERT INTO "supporter" ("member_id", "initiative_id", "draft_id") VALUES (', initiators[k], ", ", initiative_idx, ", ", draft_count - math.random(initiative_draft_count[i]) + 1, ");")
    1.92 -        end
    1.93 -      end
    1.94 -      local probability = math.random(99) + 1
    1.95 -      for k = 1, member_count do
    1.96 -        if not is_used[k] and (memberships[area][k] and math.random(probability) <= 4 or math.random(probability) == 1) then
    1.97 -          writeln('INSERT INTO "supporter" ("member_id", "initiative_id", "draft_id") VALUES (', k, ", ", initiative_idx, ", ", draft_count - math.random(initiative_draft_count[i]) + 1, ");")
    1.98 -        end
    1.99 -      end
   1.100 -      initiative_idx = initiative_idx + 1
   1.101 -    end
   1.102 -  end
   1.103 -end
   1.104 -
   1.105 -writeln('END;')

     2.1 --- a/db/vote-test.sql	Fri Dec 30 04:04:06 2011 +0100
     2.2 +++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
     2.3 @@ -1,134 +0,0 @@
     2.4 -BEGIN;
     2.5 -
     2.6 -INSERT INTO "member" ("login", "name", "ident_number") VALUES
     2.7 -  ('bernd',    'Bernd',    '002'),
     2.8 -  ('cesar',    'Cesar',    '003'),
     2.9 -  ('doris',    'Doris',    '004'),
    2.10 -  ('emil',     'Emil',     '005'),
    2.11 -  ('frank',    'Frank',    '006'),
    2.12 -  ('gerhard',  'Gerhard',  '007'),
    2.13 -  ('hugo',     'Hugo',     '008'),
    2.14 -  ('ines',     'Ines',     '009'),
    2.15 -  ('johann',   'Johann',   '010'),
    2.16 -  ('klaus',    'Klaus',    '011'),
    2.17 -  ('lisa',     'Lisa',     '012'),
    2.18 -  ('monika',   'Monika',   '013'),
    2.19 -  ('norbert',  'Norbert',  '014'),
    2.20 -  ('olaf',     'Olaf',     '015'),
    2.21 -  ('peter',    'Peter',    '016'),
    2.22 -  ('quinn',    'Quinn',    '017'),
    2.23 -  ('ralf',     'Ralf',     '018'),
    2.24 -  ('sabine',   'Sabine',   '019'),
    2.25 -  ('tobias',   'Tobias',   '020'),
    2.26 -  ('ulla',     'Ulla',     '021'),
    2.27 -  ('vincent',  'Vincent',  '022'),
    2.28 -  ('wolfgang', 'Wolfgang', '023'),
    2.29 -  ('xavier',   'Xavier',   '024'),
    2.30 -  ('yoko',     'Yoko',     '025'),
    2.31 -  ('zareb',    'Zareb',    '026');
    2.32 -
    2.33 -INSERT INTO "issue" ("area_id", "policy_id") VALUES (1, 3);
    2.34 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #1');
    2.35 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #2');
    2.36 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #3');
    2.37 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #4');
    2.38 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #5');
    2.39 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #6');
    2.40 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #7');
    2.41 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #8');
    2.42 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #9');
    2.43 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #10');
    2.44 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #11');
    2.45 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #12');
    2.46 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #13');
    2.47 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #14');
    2.48 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #15');
    2.49 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #16');
    2.50 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #17');
    2.51 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #18');
    2.52 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #19');
    2.53 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #20');
    2.54 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #21');
    2.55 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #22');
    2.56 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #23');
    2.57 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #24');
    2.58 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #25');
    2.59 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #26');
    2.60 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #27');
    2.61 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #28');
    2.62 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #29');
    2.63 -INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #30');
    2.64 -
    2.65 -INSERT INTO "draft" ("initiative_id", "content") SELECT "id", 'Lorem ipsum ...' FROM "initiative";
    2.66 -INSERT INTO "initiator" ("member_id", "initiative_id") SELECT 1, "id" FROM "initiative";
    2.67 -INSERT INTO "supporter" ("member_id", "initiative_id", "draft_id") SELECT "member"."id", "initiative"."id", "initiative"."id" FROM "member", "initiative";
    2.68 -
    2.69 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 1, 1);
    2.70 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 2, 2);
    2.71 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 3, 3);
    2.72 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 4, 4);
    2.73 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 5, 5);
    2.74 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 6, 6);
    2.75 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 7, 7);
    2.76 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 8, 8);
    2.77 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 9, 9);
    2.78 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 10, 10);
    2.79 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 11, 11);
    2.80 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 12, 12);
    2.81 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 13, 13);
    2.82 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 14, 14);
    2.83 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 15, 15);
    2.84 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 16, 16);
    2.85 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 17, 17);
    2.86 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 18, 18);
    2.87 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 19, 19);
    2.88 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 20, 20);
    2.89 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 21, 21);
    2.90 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 22, 22);
    2.91 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 23, 23);
    2.92 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 24, 24);
    2.93 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 25, 25);
    2.94 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 26, 26);
    2.95 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 27, 27);
    2.96 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 28, 28);
    2.97 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 29, 29);
    2.98 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 30, 30);
    2.99 -
   2.100 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 1, 2);
   2.101 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 2, 1);
   2.102 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 3, 3);
   2.103 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 4, 4);
   2.104 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 5, 5);
   2.105 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 6, 6);
   2.106 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 7, 7);
   2.107 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 8, 8);
   2.108 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 9, 9);
   2.109 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 10, 10);
   2.110 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 11, 11);
   2.111 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 12, 12);
   2.112 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 13, 13);
   2.113 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 14, 14);
   2.114 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 15, 15);
   2.115 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 16, 16);
   2.116 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 17, 17);
   2.117 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 18, 18);
   2.118 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 19, 19);
   2.119 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 20, 20);
   2.120 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 21, 21);
   2.121 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 22, 22);
   2.122 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 23, 23);
   2.123 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 24, 24);
   2.124 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 25, 25);
   2.125 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 26, 26);
   2.126 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 27, 27);
   2.127 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 28, 28);
   2.128 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 29, 29);
   2.129 -INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 30, 30);
   2.130 -
   2.131 -
   2.132 -SELECT check_issues();
   2.133 -UPDATE issue SET frozen = now();
   2.134 -
   2.135 -END;
   2.136 -
   2.137 --- UPDATE issue SET closed = now();