annotate database/schema/TODO @ 45:233dcc4d80e1

update
author David A. Holland
date Mon, 16 Jun 2014 01:27:54 -0400
parents ae420ef170e4
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
45
David A. Holland
parents: 24
diff changeset
1 ############################################################
David A. Holland
parents: 24
diff changeset
2 # states
David A. Holland
parents: 24
diff changeset
3
David A. Holland
parents: 24
diff changeset
4 If we want feedback PRs with no respondents to go to "stuck" we need
David A. Holland
parents: 24
diff changeset
5 to store the string "stuck" somewhere. (And, what about non-feedback
David A. Holland
parents: 24
diff changeset
6 PRs with no responsible people?)
David A. Holland
parents: 24
diff changeset
7
David A. Holland
parents: 24
diff changeset
8 ############################################################
David A. Holland
parents: 24
diff changeset
9 # hooks and custom stuff
David A. Holland
parents: 24
diff changeset
10
David A. Holland
parents: 24
diff changeset
11 "Category" is just a classification scheme, but we need to know (based
David A. Holland
parents: 24
diff changeset
12 on the category) what default subscriptions to create. There's
David A. Holland
parents: 24
diff changeset
13 currently no way to do this. Since the script for accepting incoming
David A. Holland
parents: 24
diff changeset
14 PRs needs to know about the gnats schema anyway, perhaps there should
David A. Holland
parents: 24
diff changeset
15 just be a table in the database to tell it what to do. That table
David A. Holland
parents: 24
diff changeset
16 doesn't exist yet.
David A. Holland
parents: 24
diff changeset
17
24
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
18 -- * There also needs to be a hook to deduce the package name for
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
19 -- pkgsrc PRs by scanning the synopsis. This is going to be netbsd-
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
20 -- specific; making it table-driven isn't feasible and probably it's
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
21 -- not worth (at least at first) setting up a whole scheme for
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
22 -- site-specific extensions. So probably it'll be hard-coded in at
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
23 -- least to begin with.
45
David A. Holland
parents: 24
diff changeset
24
David A. Holland
parents: 24
diff changeset
25 ############################################################
David A. Holland
parents: 24
diff changeset
26 # administrative queue
David A. Holland
parents: 24
diff changeset
27
David A. Holland
parents: 24
diff changeset
28 The administrative queue should probably also have a queue for actions
David A. Holland
parents: 24
diff changeset
29 requested by commit messages. (Christos wants to be able to put
David A. Holland
parents: 24
diff changeset
30 something like "PR 12345: close" in commit mails, which is probably a
David A. Holland
parents: 24
diff changeset
31 good feature, but these need to be scanned by somebody to avoid
David A. Holland
parents: 24
diff changeset
32 accidents.)
David A. Holland
parents: 24
diff changeset
33
24
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
34 -- * There should be an incoming queue for stuff submitted via the web
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
35 -- interface, because a lot of it will be spam.
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
36 --
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
37 -- * There should be a whitelist/blacklist for that queue, by IP
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
38 -- address or netblock.
45
David A. Holland
parents: 24
diff changeset
39
David A. Holland
parents: 24
diff changeset
40 ############################################################
David A. Holland
parents: 24
diff changeset
41 # other stuff
David A. Holland
parents: 24
diff changeset
42
24
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
43 -- (the stuff below this point probably isn't getting done before the
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
44 -- initial deployment)
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
45 --
8
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
46 -- * Should be able to merge duplicates.
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
47 -- * Should allow recording dependencies between bugs.
24
ae420ef170e4 Update.
David A. Holland
parents: 8
diff changeset
48 -- * Should store pullup numbers
45
David A. Holland
parents: 24
diff changeset
49