liquid_feedback_frontend
view db/vote-test.sql @ 157:24e47baf5f9b
strip html from fallback title
if the slot is used for title, make sure the html is stripped from it
if the slot is used for title, make sure the html is stripped from it
author | Daniel Poelzleithner <poelzi@poelzi.org> |
---|---|
date | Fri Oct 08 20:31:09 2010 +0200 (2010-10-08) |
parents | 3bfb2fcf7ab9 |
children |
line source
1 BEGIN;
3 INSERT INTO "member" ("login", "name", "ident_number") VALUES
4 ('bernd', 'Bernd', '002'),
5 ('cesar', 'Cesar', '003'),
6 ('doris', 'Doris', '004'),
7 ('emil', 'Emil', '005'),
8 ('frank', 'Frank', '006'),
9 ('gerhard', 'Gerhard', '007'),
10 ('hugo', 'Hugo', '008'),
11 ('ines', 'Ines', '009'),
12 ('johann', 'Johann', '010'),
13 ('klaus', 'Klaus', '011'),
14 ('lisa', 'Lisa', '012'),
15 ('monika', 'Monika', '013'),
16 ('norbert', 'Norbert', '014'),
17 ('olaf', 'Olaf', '015'),
18 ('peter', 'Peter', '016'),
19 ('quinn', 'Quinn', '017'),
20 ('ralf', 'Ralf', '018'),
21 ('sabine', 'Sabine', '019'),
22 ('tobias', 'Tobias', '020'),
23 ('ulla', 'Ulla', '021'),
24 ('vincent', 'Vincent', '022'),
25 ('wolfgang', 'Wolfgang', '023'),
26 ('xavier', 'Xavier', '024'),
27 ('yoko', 'Yoko', '025'),
28 ('zareb', 'Zareb', '026');
30 INSERT INTO "issue" ("area_id", "policy_id") VALUES (1, 3);
31 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #1');
32 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #2');
33 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #3');
34 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #4');
35 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #5');
36 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #6');
37 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #7');
38 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #8');
39 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #9');
40 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #10');
41 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #11');
42 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #12');
43 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #13');
44 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #14');
45 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #15');
46 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #16');
47 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #17');
48 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #18');
49 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #19');
50 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #20');
51 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #21');
52 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #22');
53 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #23');
54 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #24');
55 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #25');
56 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #26');
57 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #27');
58 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #28');
59 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #29');
60 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #30');
62 INSERT INTO "draft" ("initiative_id", "content") SELECT "id", 'Lorem ipsum ...' FROM "initiative";
63 INSERT INTO "initiator" ("member_id", "initiative_id") SELECT 1, "id" FROM "initiative";
64 INSERT INTO "supporter" ("member_id", "initiative_id", "draft_id") SELECT "member"."id", "initiative"."id", "initiative"."id" FROM "member", "initiative";
66 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 1, 1);
67 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 2, 2);
68 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 3, 3);
69 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 4, 4);
70 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 5, 5);
71 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 6, 6);
72 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 7, 7);
73 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 8, 8);
74 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 9, 9);
75 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 10, 10);
76 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 11, 11);
77 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 12, 12);
78 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 13, 13);
79 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 14, 14);
80 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 15, 15);
81 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 16, 16);
82 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 17, 17);
83 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 18, 18);
84 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 19, 19);
85 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 20, 20);
86 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 21, 21);
87 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 22, 22);
88 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 23, 23);
89 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 24, 24);
90 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 25, 25);
91 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 26, 26);
92 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 27, 27);
93 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 28, 28);
94 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 29, 29);
95 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 30, 30);
97 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 1, 2);
98 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 2, 1);
99 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 3, 3);
100 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 4, 4);
101 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 5, 5);
102 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 6, 6);
103 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 7, 7);
104 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 8, 8);
105 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 9, 9);
106 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 10, 10);
107 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 11, 11);
108 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 12, 12);
109 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 13, 13);
110 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 14, 14);
111 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 15, 15);
112 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 16, 16);
113 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 17, 17);
114 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 18, 18);
115 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 19, 19);
116 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 20, 20);
117 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 21, 21);
118 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 22, 22);
119 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 23, 23);
120 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 24, 24);
121 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 25, 25);
122 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 26, 26);
123 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 27, 27);
124 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 28, 28);
125 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 29, 29);
126 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 30, 30);
129 SELECT check_issues();
130 UPDATE issue SET frozen = now();
132 END;
134 -- UPDATE issue SET closed = now();