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