1 Judd: A supybot plugin to view into the Ultimate Debian Database
2 ===============================================================
6 * Ultimate Debian Database -- packages, sources, bugs
7 Running on same host with permanent db connection from bot to db.
8 Data is updated from cron:
9 - packages and sources information loaded into the db by the gatherers
10 - bugs data loaded from SQL snapshot of udd.debian.org
12 Files from mirror searched using zgrep.
13 Data is updated by udd cron jobs.
15 Snapshot generated periodically by Jakub Wilk.
16 - wget http://people.debian.org/~jwilk/alternatives/Contents -O- |
17 gzip -c > supybot/data/judd/debian-sid/main/Contents-alt.gz
20 Maintenance notes for UDD
21 =========================
23 udd oldstable removal actions:
24 * update cron job (~/bin/udd-update-stable)
25 * stop importing oldstable (config-judd/Makefile)
26 * delete oldoldstable data from database:
28 => SELECT count(*) FROM packages WHERE release LIKE 'lenny%';
29 num archs * num packages (200k?)
30 => DELETE FROM packages WHERE release LIKE 'lenny%';
31 => SELECT count(*) FROM sources WHERE release LIKE 'lenny%';
32 num src packages (15k?)
33 => DELETE FROM sources WHERE release LIKE 'lenny%';
34 * delete oldoldstable data from disk cache
35 /srv/mirrors/debian/dists/lenny /srv/mirrors/debian-backports/dists/lenny-backports /srv/mirrors/debian-backports/dists/lenny-backports-sloppy /srv/mirrors/debian-security/lenny /srv/mirrors/debian-multimedia.org/dists/lenny /srv/mirrors/debian-volatile
36 * add oldoldstable to the list of old timestamps to ignore in udd-check-updates
39 * update cron jobs (~/bin/udd-update-{stable,changing})
40 * update archs with release architectures (config-judd/archlist)
41 * check components (volatile vs updates, backports-sloppy etc:
42 config-judd/config-generic-release.yaml)
44 udd new testing actions:
45 * add new testing (config-judd/Makefile)
46 * update cron jobs (~/bin/udd-update-changing)
47 * update archs (config-judd/archlist)
50 * remove the architecture from config-judd/archlist; make; review changes
51 * delete packages from database:
52 DELETE FROM packages WHERE release='jessie' AND architecture='ia64';
53 * if removed completely, also update udd-cache/data.py's archs list
56 Maintenance notes for Judd
57 ==========================
59 judd oldstable removal:
60 * shift/remove oldstable alias in uddcache/data.py
61 * fix tests that no longer work :(
62 * delete unneeded contents links from supybot/data/judd
65 * add new -backports, -backports-sloppy, -updates etc in uddcache/data.py
66 * shift stable alias in uddcache/data.py
67 * update list of release and mapping in uddcache/data.py
69 judd new testing actions
70 * add new (testing) release to uddcache/data.py
75 Miscellaneous configuration options for the bot
76 ===============================================
78 The following commands are highly recommended for the bot:
81 defaultcapability add -Alias.add
82 defaultcapability add -Alias.remove
83 alias add whatprovides rprovides $*
84 alias add source src $*
85 alias add maintainer maint $*
86 alias add uploader maint $*
87 alias add changer maint $*
88 alias add arches archs $*
89 alias add version versions $*
90 alias add v versions $*
93 alias add find file $*
94 alias add alternatives alternative $*
96 alias add rfs bug rfs $*
97 alias add wnpp bug wnpp $*
99 defaultplugin source Alias
100 defaultplugin version Alias
102 alias add bot echo No, I'm not a bot, I'm a frontend to a database.
106 config channel supybot.plugins.Judd.default_release testing
110 config channel supybot.plugins.Judd.default_release sid