annotate database/schema/TODO @ 44:812c956dd0e9

Add another admin queue type for comments on nonexistent PRs. Also, correct stupid spelling mistake. Need to get the test harness running again.
author David A. Holland
date Mon, 16 Jun 2014 01:27:45 -0400
parents ae420ef170e4
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 --