comparison database/schema/TODO @ 45:233dcc4d80e1

update
author David A. Holland
date Mon, 16 Jun 2014 01:27:54 -0400
parents ae420ef170e4
children
comparison
equal deleted inserted replaced
44:812c956dd0e9 45:233dcc4d80e1
1 -- Does not handle: 1 ############################################################
2 -- 2 # states
3 -- * The Description, How-To-Repeat, and Fix fields from gnats are 3
4 -- supposed to just be the initial entries in the message log, but 4 If we want feedback PRs with no respondents to go to "stuck" we need
5 -- they're currently also in the bugs table. Also "unformatted". 5 to store the string "stuck" somewhere. (And, what about non-feedback
6 -- 6 PRs with no responsible people?)
7 -- * There is no administrative queue yet. 7
8 -- - comments on locked PRs 8 ############################################################
9 -- - comments on nonexistent PRs 9 # hooks and custom stuff
10 -- - bounced mail from feedback requests 10
11 -- - other bounced mail 11 "Category" is just a classification scheme, but we need to know (based
12 -- - unreocgnized/junk/malformed mail? 12 on the category) what default subscriptions to create. There's
13 -- - action requests in commit messages like Christos wants 13 currently no way to do this. Since the script for accepting incoming
14 -- 14 PRs needs to know about the gnats schema anyway, perhaps there should
15 -- * "Category" is just a classification scheme, but we need to know 15 just be a table in the database to tell it what to do. That table
16 -- (based on the category) what default subscriptions to create. 16 doesn't exist yet.
17 -- There's currently no way to do this. Since the script for 17
18 -- accepting incoming PRs needs to know about the gnats schema
19 -- anyway, perhaps there should just be a table in the database to
20 -- tell it what to do.
21 --
22 -- * There also needs to be a hook to deduce the package name for 18 -- * There also needs to be a hook to deduce the package name for
23 -- pkgsrc PRs by scanning the synopsis. This is going to be netbsd- 19 -- pkgsrc PRs by scanning the synopsis. This is going to be netbsd-
24 -- specific; making it table-driven isn't feasible and probably it's 20 -- specific; making it table-driven isn't feasible and probably it's
25 -- not worth (at least at first) setting up a whole scheme for 21 -- not worth (at least at first) setting up a whole scheme for
26 -- site-specific extensions. So probably it'll be hard-coded in at 22 -- site-specific extensions. So probably it'll be hard-coded in at
27 -- least to begin with. 23 -- least to begin with.
28 -- 24
25 ############################################################
26 # administrative queue
27
28 The administrative queue should probably also have a queue for actions
29 requested by commit messages. (Christos wants to be able to put
30 something like "PR 12345: close" in commit mails, which is probably a
31 good feature, but these need to be scanned by somebody to avoid
32 accidents.)
33
29 -- * There should be an incoming queue for stuff submitted via the web 34 -- * There should be an incoming queue for stuff submitted via the web
30 -- interface, because a lot of it will be spam. 35 -- interface, because a lot of it will be spam.
31 -- 36 --
32 -- * There should be a whitelist/blacklist for that queue, by IP 37 -- * There should be a whitelist/blacklist for that queue, by IP
33 -- address or netblock. 38 -- address or netblock.
34 -- 39
35 -- * Should support automatic feedback timeout. 40 ############################################################
36 -- 41 # other stuff
42
37 -- (the stuff below this point probably isn't getting done before the 43 -- (the stuff below this point probably isn't getting done before the
38 -- initial deployment) 44 -- initial deployment)
39 -- 45 --
40 -- * Should be able to merge duplicates. 46 -- * Should be able to merge duplicates.
41 -- * Should allow recording dependencies between bugs. 47 -- * Should allow recording dependencies between bugs.
42 -- * Should store pullup numbers 48 -- * Should store pullup numbers
43 -- 49