Code for GCC patch tracking
Tuesday, August 30th, 2005I’ve gotten a couple requests for the code for the patch tracking queue that I wrote for GCC. The grabber works because it knows how to fetch raw messages from the web archive. The rest is just nice formatting for the database.
The code is all mysql + mod_python + SQLObjects + Cheetah template engine. It used to be just plain python db api, but SQLobjects ended up being a lot nicer. You can see how the code has evolved over the year in the repo. It actually has an RSS feed and simple XMLRPC support, one of which is used by a Wiki, and the other, by an IRC bot :).
Here is the SQL file for the database.
None of the searches that are done were worth indexing yet.
The code for the web app and grabber can be found in the SVN repo.
It would require a bit of modification to use elsewhere, but not much. The XMLRPC code still uses the Python DB API, mainly because we transfer pickles, and transferring pickles of SQLObjects doesn’t work. It seemed pointless to grab it from SQLObjects then convert it, then pickle it, when we could directly pickle the results of the DB API queries.
If you need a tarball or something let me know.