[PyCS-devel] pycs database crash

[Phillip P. <pp...@my...>]

Hey guys,

I've had a bit of a disaster on pycs.net; the main database has become corrupted.  That means weblogs are visible on pycs.net, but comments don't work and nobody can upstream or use any of the dynamic functions.

I'm pretty busy right now so if anyone wants to help me debug my DB scripts, please check out pycs from CVS:

        cvs -d:pserver:ano...@cv...:/cvsroot/pycs login

        cvs -z3 -d:pserver:ano...@cv...:/cvsroot/pycs co pycs

and take a look at rescue_data.py and rescue_return_data.py.  They're almost working; rescue_data.py will dump your database out as Python code (to regenerate it) and rescue_return_data.py will *almost* turn a dumped database back into a real one.  The comments aren't coming out right at the moment.  I'll finish debugging that tonight, and hopefully get pycs.net going once more.

Also, for the future, check out mymetakit/mymetakit.py.  It's a Metakit-like wrapper for MySQL.  So far it's not very far along: it parses MK table definitions, I think, but doesn't do any DB stuff.  Anyone interested in DB abstraction please take a look at this.

Also, I've started a Wiki.  Nothing much there yet.  Dean might be interested in this ;)

	http://www.myelin.co.nz/cgi-bin/pycswiki.pl

Cheers,
Phil :)