TODO List
=========

Priorities:
- high: It should be done before the end of the GSOC project
- medium: It would be great if it would be done
- low: not so urgent. We could get someone else to work on that ;-)

General
-------
Main objective: get UDD into a state where it can be used for QA purposes.
That's the first step towards world domination! (Universe is next! CvE)
- (prio: high) user documentation, on the Debian wiki.
  - tables structure, in a relatively friendly format
  - some example queries
- (prio: medium) primary key for tables which have none yet
- (prio: high) merge udd-update.py into udd-dispatch.py, rename udd-dispatch.py to udd.py
- (prio: high) make udd.py use a default config file, which can be overriden by "-f configfile".
- (prio: high) merge doc/generate_db_schema.pl into udd-dispatch.py (or udd.py)

packages/sources
----------------
- (prio: medium) Add support for keeping history of Packages and Sources in
  separate tables. (zack wants that, but shouldn't we use snapshot.d.o for that
  instead?)
- (prio: low, not sure if it's a good idea) Incremental updates, not full
  imports (use that to trigger incremental bugs.d.o imports (for affects_*
  updates)
- (prio: low) Add a pkg composite type (text version, text name). The
   operator '=' used with type text should only check the package name,
   with another pkg should check both pkg and version. Should be pretty
   DWIM.
- (prio: high) Add Uploaders (zack want them to export that data to the BTS)

bugs.debian.org
---------------
- (prio: medium) compare rt_affects_* with bts.tz.net
- (prio: medium) generate output using bts2ldap format, and check that the
  result matches a fresh bts2ldap run done by Lucas
- (prio: medium) Optimize bugs importing (again)

Other data sources
------------------
- (prio: medium) DEHS
- (prio: low) MIA
- (prio: low) debtags
- (prio: low) wanna-build
- (prio: low) packages-arch-specific
- (prio: low) edos.debian.net
- (prio: low) version numbers, diffs and bugs for each package for each
  derivative distro 
- (prio: low) import data about Ubuntu bugs on launchpad. Lucas already
  has a script importing this data to an SQLite DB (running on merkel).