~launchpad-pqm/launchpad/devel

1102 by Canonical.com Patch Queue Manager
Lucille had some XXXs which should have been NOTEs
1
/*
2
   MALONE SAMPLE DATA
3
8687.15.9 by Karl Fogel
Add the copyright header block to more files (everything under database/).
4
   Copyright 2009 Canonical Ltd.  This software is licensed under the
5
   GNU Affero General Public License version 3 (see the file LICENSE).
6
1102 by Canonical.com Patch Queue Manager
Lucille had some XXXs which should have been NOTEs
7
   This is some sample data for Malone.  This requires the default
8
   data to be inserted first.
9
*/
10
11
INSERT INTO BugSystemType (name, title, description, homepage, owner)
12
VALUES ('bugzilla', 'BugZilla', 'Dave Miller\'s Labour of Love, '
13
|| 'the Godfather of Open Source project issue tracking.',
14
'http://www.bugzilla.org/',
15
(SELECT id FROM Person WHERE displayname='Sample Person')
16
);
17
18
INSERT INTO Manifest (datecreated, owner)
19
VALUES (
20
timestamp '2004-06-29 00:00',
21
(SELECT id FROM Person WHERE displayname='Sample Person')
22
);
23
24
INSERT INTO CodeRelease (sourcepackagerelease, manifest)
25
VALUES (
26
(SELECT id FROM SourcePackage WHERE sourcepackagename =
27
	(SELECT id FROM SourcePackagename WHERE name = 'mozilla-firefox')),
28
(SELECT max(id) FROM Manifest)
29
);
30
31
-- Mozilla Thunderbird
32
INSERT INTO Product (project, owner, name, displayname,  title, shortdesc,
33
description)
34
VALUES (
35
(SELECT id FROM Project WHERE name='mozilla'),
36
(SELECT id FROM Person WHERE displayname='Sample Person'),
37
'thunderbird', 'Mozilla Thunderbird', 'Mozilla Thunderbird',
38
'The Mozilla Thunderbird email client',
39
'The Mozilla Thunderbird email client'
40
);
41
INSERT INTO ProductRelease (product, datereleased, version, owner)
42
VALUES (
43
(SELECT id FROM Product WHERE name='thunderbird'),
44
timestamp '2004-06-28 00:00', 'mozilla-thunderbird-0.8.0',
45
(SELECT id FROM Person WHERE displayname='Sample Person')
46
);
47
48
/*
49
INSERT INTO SourcePackageRelease (sourcepackage, srcpackageformat, creator,
50
version, dateuploaded, urgency)
51
VALUES (
52
(SELECT id FROM SourcePackage WHERE sourcepackagename =
53
	(SELECT id FROM SourcePackagename WHERE name = 'mozilla-thunderbird')),
54
1, (SELECT id FROM Person WHERE displayname='Sample Person'),
55
'0.8.0-1', timestamp '2004-06-29 00:00', 1
56
);
57
*/
58
59
INSERT INTO Manifest (datecreated, owner)
60
VALUES (
61
timestamp '2004-06-29 00:00',
62
(SELECT id FROM Person WHERE displayname='Sample Person')
63
);
64
65
INSERT INTO CodeRelease (sourcepackagerelease, manifest)
66
VALUES (
67
(SELECT id FROM SourcePackage WHERE sourcepackagename =
68
	(SELECT id FROM SourcePackagename WHERE name = 'mozilla-thunderbird')),
69
(SELECT max(id) FROM Manifest)
70
);
71
72
73
INSERT INTO Bug (name, title, shortdesc, description, owner, communityscore,
74
communitytimestamp, activityscore, activitytimestamp, hits,
75
hitstimestamp)
76
VALUES ('bob', 'Firefox does not support SVG', 'Firefox needs to support embedded SVG images, now that the standard has been finalised.',
77
'The SVG standard 1.0 is complete, and draft implementations for Firefox exist. One of these implementations needs to be integrated with the base install of Firefox. Ideally, the implementation needs to include support for the manipulation of SVG objects from JavaScript to enable interactive and dynamic SVG drawings.',
78
(SELECT id FROM Person WHERE displayname='Sample Person'),
79
0, CURRENT_DATE, 0, CURRENT_DATE, 0, CURRENT_DATE
80
);
81
82
INSERT INTO Bug (name, title, shortdesc, description, owner, communityscore,
83
communitytimestamp, activityscore, activitytimestamp, hits, hitstimestamp)
84
VALUES ('blackhole', 'Blackhole Trash folder',
85
'Everything put into the folder "Trash" disappears!', 'The Trash folder seems to have significant problems! At the moment, dragging an item to the trash results in immediate deletion. The item does not appear in the Trash, it is just deleted from my hard disk. There is no undo or ability to recover the deleted file. Help!',
86
(SELECT id FROM Person WHERE displayname='Sample Person'),
87
0, CURRENT_DATE, 0, CURRENT_DATE, 0, CURRENT_DATE
88
);
89
90
INSERT INTO BugActivity (bug, datechanged, person, whatchanged, oldvalue,
91
newvalue, message)
92
VALUES (
93
(SELECT id FROM Bug WHERE name='bob'),
94
CURRENT_DATE, 1, 'title', 'A silly problem',
95
'An odd problem', 'Decided problem wasn\'t silly after all'
96
);
97
98
-- Assign bug 'bob' to the firefox product (NEW, HIGH, MAJOR)
99
INSERT INTO ProductBugAssignment (
100
    bug, product, bugstatus, priority, severity, assignee
101
    )
102
VALUES (
103
    (SELECT id FROM Bug WHERE name='bob'),
104
    (SELECT id FROM Product WHERE name='firefox'),
105
    1, 2, 2,
106
    (SELECT id FROM Person WHERE displayname='Sample Person')
107
);
108
109
-- Assign bug 'bob' to the mozilla-firefox sourcepackage and firefox-0.81
110
-- binary package (OPEN, WONTFIX, 2)
111
INSERT INTO SourcePackageBugAssignment (
112
    bug, sourcepackage, bugstatus, priority, severity, binarypackage, assignee
113
    )
114
VALUES (
115
    (SELECT id FROM Bug WHERE name='bob'),
116
    (SELECT id FROM SourcePackage WHERE sourcepackagename =
117
	(SELECT id FROM SourcePackagename WHERE name = 'mozilla-firefox')),
118
    20, 4, 2,
119
    (SELECT id FROM BinaryPackage WHERE version='0.8' AND binarypackagename = (
120
        SELECT id FROM BinaryPackageName WHERE name='mozilla-firefox'
121
        )),
122
    (SELECT id FROM Person WHERE displayname='Sample Person')
123
);
124
125
-- Remove the nickname 'bob', so we have an unnamed bug
126
UPDATE Bug SET name=NULL WHERE name='bob';
127
128
/*
129
INSERT INTO SourcePackageBugAssignment
130
    (bug, sourcepackage, bugstatus, priority, severity, binarypackage)
131
VALUES (
132
    (SELECT id FROM Bug WHERE name='blackhole'),
133
    (SELECT id FROM SourcePackage WHERE name='mozilla-thunderbird'),
134
    2, 4, 2, NULL
135
    );
136
*/
137
INSERT INTO ProductBugAssignment (
138
    bug, product, bugstatus, priority, severity, assignee
139
    )
140
VALUES (
141
    (SELECT id FROM Bug WHERE name='blackhole'),
142
    (SELECT id FROM Product WHERE name='thunderbird'),
143
    10, 2, 2,
144
    (SELECT id FROM Person WHERE displayname='Sample Person')
145
);
146
147
INSERT INTO SourcePackageRelease (
148
    sourcepackage, srcpackageformat, creator, version, urgency, "section")
149
VALUES (
150
    (SELECT id FROM SourcePackage WHERE shortdesc = 'Mozilla Firefox Web Browser'),
151
    1,
152
    1,
153
    'mozilla-firefox-0.9.1',
154
    1,
155
    (SELECT id FROM "section" WHERE name = 'default_section'));
156
157
INSERT INTO SourcePackageRelease (
158
    sourcepackage, srcpackageformat, creator, version, urgency, "section")
159
VALUES (
160
    (SELECT id FROM SourcePackage WHERE shortdesc = 'Mozilla Firefox Web Browser'),
161
    1,
162
    1,
163
    'mozilla-thunderbird-0.9.0',
164
    1,
165
    (SELECT id FROM "section" WHERE name = 'default_section'));
166
167
INSERT INTO BugMessage (bug, title, contents, rfc822msgid) VALUES (
168
    (SELECT id FROM Bug WHERE name='blackhole'),
169
    'PEBCAK',
170
    'Problem exists between chair and keyboard',
171
    'foo@example.com-332342--1231'
172
    );
173
174
INSERT INTO BugExternalRef (bug, bugreftype, data, description, owner) VALUES (
175
    (SELECT id FROM Bug WHERE name='blackhole'),
176
    1,
177
    45,
178
    'Some junk has to go here because the field is NOT NULL',
179
    (SELECT id FROM Person WHERE displayname='Sample Person')
180
    );
181
INSERT INTO BugExternalRef (bug, bugreftype, data, description, owner) VALUES (
182
    (SELECT id FROM Bug WHERE name='blackhole'),
183
    2,
184
    'http://www.mozilla.org',
185
    'The homepage of the project this bug is on, for no particular reason',
186
    (SELECT id FROM Person WHERE displayname='Sample Person')
187
    );
188
189
INSERT INTO BugSystem (bugsystemtype, name, title, shortdesc, baseurl, owner,
190
    contactdetails) VALUES (
191
    (SELECT id FROM BugSystemType WHERE name='bugzilla'),
192
    'mozilla.org',
193
    'The Mozilla.org Bug Tracker',
194
    'The Mozilla.org bug tracker',
195
    'http://www.example.com/bugtracker',
196
    (SELECT id FROM Person WHERE displayname='Sample Person'),
197
    'Carrier pidgeon only'
198
    );
11304.1.9 by Bryce Harrington
Add values for priority and severity to sample data in various places
199
INSERT INTO BugWatch (bug, bugsystem, remotebug, remotestatus, remote_importance, owner) VALUES (
1102 by Canonical.com Patch Queue Manager
Lucille had some XXXs which should have been NOTEs
200
    (SELECT id FROM Bug WHERE name='blackhole'),
201
    (SELECT id FROM BugSystem WHERE name='mozilla.org'),
202
    '42',
203
    'FUBAR',
11304.1.9 by Bryce Harrington
Add values for priority and severity to sample data in various places
204
    'BAZBAZ',
1102 by Canonical.com Patch Queue Manager
Lucille had some XXXs which should have been NOTEs
205
    (SELECT id FROM Person WHERE displayname='Sample Person')
206
    );