annotate database/schema/TODO @ 24:ae420ef170e4

Update.
author David A. Holland
date Sun, 26 May 2013 18:33:11 -0400
parents 68cc276ac118
children 233dcc4d80e1
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
8
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
1 -- Does not handle:
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
2 --
24
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
3 -- * The Description, How-To-Repeat, and Fix fields from gnats are
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
4 -- supposed to just be the initial entries in the message log, but
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
5 -- they're currently also in the bugs table. Also "unformatted".
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
6 --
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
7 -- * There is no administrative queue yet.
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
8 -- - comments on locked PRs
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
9 -- - comments on nonexistent PRs
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
10 -- - bounced mail from feedback requests
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
11 -- - other bounced mail
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
12 -- - unreocgnized/junk/malformed mail?
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
13 -- - action requests in commit messages like Christos wants
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
14 --
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
15 -- * "Category" is just a classification scheme, but we need to know
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
16 -- (based on the category) what default subscriptions to create.
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
17 -- There's currently no way to do this. Since the script for
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
18 -- accepting incoming PRs needs to know about the gnats schema
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
19 -- anyway, perhaps there should just be a table in the database to
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
20 -- tell it what to do.
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
21 --
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
22 -- * There also needs to be a hook to deduce the package name for
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
23 -- pkgsrc PRs by scanning the synopsis. This is going to be netbsd-
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
24 -- specific; making it table-driven isn't feasible and probably it's
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
25 -- not worth (at least at first) setting up a whole scheme for
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
26 -- site-specific extensions. So probably it'll be hard-coded in at
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
27 -- least to begin with.
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
28 --
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
29 -- * There should be an incoming queue for stuff submitted via the web
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
30 -- interface, because a lot of it will be spam.
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
31 --
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
32 -- * There should be a whitelist/blacklist for that queue, by IP
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
33 -- address or netblock.
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
34 --
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
35 -- * Should support automatic feedback timeout.
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
36 --
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
37 -- (the stuff below this point probably isn't getting done before the
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
38 -- initial deployment)
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
39 --
8
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
40 -- * Should be able to merge duplicates.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
41 -- * Should allow recording dependencies between bugs.
24
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
42 -- * Should store pullup numbers
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
43 --