7 o heidi should use transactions
9 o heidi should read from stdin, then process
11 o katie needs a stable_reject() which a) removes the package from
12 p-u, b) doesn't remove the file from the pool, and c) (optionally, I
13 guess) uses a template mail.
15 o katie/jenna/rhona/whatever needs to clear out .changes
16 files from p-u when removing stuff superseded by newer versions.
18 o experimental needs to auto clean (relative to unstable)
20 SELECT s.source, s.version AS experimental, s2.version AS unstable
21 FROM src_associations sa, source s, source s2, src_associations sa2
22 WHERE sa.suite = 1 AND sa2.suite = 5 AND sa.source = s.id
23 AND sa2.source = s2.id AND s.source = s2.source
24 AND versioncmp(s.version, s2.version) < 0;
26 [ but, needs to hook into melanie ... ]
27 [ and, err, fix the gay hardcoding of suites in rene ... ]
29 o jenna doesn't handle arch: any -> arch: all transitions
30 [aj worked around; need to revisit]
32 o direport misreports things as section 'devel'
34 o rewrite shania to a) be sane, b) clean REJECT properly
35 (i.e. ignore the fact that stuff is in a valid .changes file and
38 o maintainers file needs overrides
40 [ change override.maintainer to override.maintainer-from +
41 override.maintainer-to and have them reference the maintainers
42 table. Then fix charisma to use them and write some scripting
43 to handle the Santiago situation. ]
45 o Add urgency + installed date to the DB for aj/testing (? still needed ?)
47 o Enforce NMU and bin-only NMU versioning schemes
49 o Revisit linking of binary->source in install() in katie.
51 o debian/* assumes arch: all but sql-aptvc.o isn't arch: all.
53 o jt's web stuff, matt's changelog stuff (overlap)
58 o doogie's binary -> source index
60 o ANIAS should be done in katie ?
62 o natalie doesn't warn when lisitng invalid components!
64 o run apt-ftparchive clean <conf file> weekly [culus sucks]
66 o purge older stuff from non-free/contrib so that testing and stuff works
68 o when dinstall is run in install mode but not as a cron job, it
69 should probably run jenna to avoid madison originated user confusion
71 o check for empty debs; check for empty (or small (<1k ?)) .tar.gz's.
73 o validate email addresses ? harsh to reject tho [errge]
75 o validate source consistency, i.e. .dsc and .tar.gz as minimum
77 o Rene doesn't look at debian-installer but should.
79 o Rene also doesn't seem to warn about missing binary packages?
81 o cron.daily* should change umask (aj sucks)
83 o override checks sucks; it needs to track changes made by the
84 maintainer and pass them onto ftpmaster instead of warning the
87 o Don't do override checks for stable only uploads
89 o katie should validate multi-suite uploads; only possible valid one
90 is "stable unstable" [but see d-policy@l.d.o]
92 o need to have process_it run a big try: loop so that individual
93 package screws up don't kill the daily cron run.
95 o Add an 'add' ability to melanie (? separate prog maybe)
96 o [Hard] Need to merge non-non-US and non-US DBs.
97 o [Easy] Need to vacuum daily
98 o [Easy] remove empty directories in the pool in cron.weekly or so
100 o need to do proper rfc822 escaping of from lines (as opposed to s/\.//g)
102 o Fix dinstall to remove != stable on stable install, not just f + u
103 o Fix 'mixed' component handling (?)
104 o Fix component handling in overrides (aj)
105 o Fix lack of entires in source overrides (aj)
106 o Fix rhona to unconditionally read override file on startup
107 o Fix dinstall to warn if not in incoming or p-u
108 o db_access' get_files needs to use exceptions not this None, > 0, < 0 return val BS (?)
109 o check errors on apt_pkg calls (?)
110 o The untouchable flag doesn't stop adding new packages
111 o jenna needs to validate arguments (?)
112 o jenna is too damn slow
114 ===================================================================================================
122 o Install python libraries (db_access and utils)
123 o Install config file
124 o Fix stuff to look in sensible places for libs and config file in debian package (?)
125 o man pages and/or documentation
130 o Secure incoming handling
131 o [Hard] dependency checking
132 o Need log files for jenna, rhona and katie.
137 o Do a checkpc(1)-a-like which sanitizes a config files.
138 o fix parse_changes()/build_file_list() to sanity check filenames
139 o saftey check and/or rename debs so they match what they should be
141 o Enable catherine (when daily mirror hit drops down below 300Mb maybe..)
143 o Need to optimize all the queries by using EXAMINE and building some INDEXs.
144 o Need to enclose all the setting SQL stuff in transactions (mostly done).
145 o Need to finish alyson (a way to sync katie.conf and the DB)
146 o Need the ability to rebuild all other tables from dists _or_ pools (in the event of disaster) (?)
147 o Make the --help and --version options do stuff for all scripts
148 o Need to check for .dsc when source is mentioned
150 o charisma can't handle whitespace-only lines (for the moment, this is feature)
151 o Should use $EDITOR, not hardcode vi
152 o Should reject packages with bad timestamps
153 o Replicate old dinstall report stuff (? needed ?)
154 o Handle the case of 1:1.1 which would overwrite 1.1 (?)
155 o aj's binary-all stuff (foo-doc depending on foo) (?)
156 o heidi should report suite name not ID [aj]
158 o fubar and warn/error wrappers like in C (?)
159 o generic way of saying isabinary and isadsc. (?)
160 o substitution stuff (cf. userdir-ldap) for announce, reject etc.
162 o s/distribution/suite/g
164 ===================================================================================================
166 23:12|<aj> I will not hush!
168 23:12|<aj> Where there is injustice in the world, I shall be there!
169 23:13|<aj> I shall not be silenced!
170 23:13|<aj> The world shall know!
171 23:13|<aj> The world *must* know!
172 23:13|<elmo> oh dear, he's gone back to powerpuff girls... ;-)
173 23:13|<aj> yay powerpuff girls!!
174 23:13|<aj> buttercup's my favourite, who's yours?
175 23:14|<aj> you're backing away from the keyboard right now aren't you?
176 23:14|<aj> *AREN'T YOU*?!
177 23:15|<aj> I will not be treated like this.
178 23:15|<aj> I shall have my revenge.
179 23:15|<aj> I SHALL!!!