I've written a little Python module to generate sqlite schemas. Why? My initial reason was that I wanted to have some metadata for my application, and the easiest way to do that was to encapsulate the data into some objects and then use those to generate the needed SQL (this was after I gave up trying to parse the SQL in sqlite_master). But when I was doing that I realized that I could also generate any triggers needed to enforce referential integrity (I just generate triggers for ON CASCADE DELETE behavior right now) and any indexes for foreign keys (greatly speeds up joins).
The module is here http://members.cox.net/davecook/pythonstuff/tablegenerator.py It's the product of a couple of days of hacking, and hasn't had much in the way of testing yet. The next thing I'd like to add to it is auto-generation of "INSTEAD OF" type triggers for views to make them "updateable". Dave Cook --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
