I added some stuff to CVS for adding and removing columns on the fly
(including doing an ALTER), as well as crude support for creating a
class from the schema directly. It only works for MySQL, I'll have to
look up the Postgres ALTER (probably easy), and my understanding is that
database introspection in Postgres is a lot harder than MySQL. I have
to figure out how to do tableExists in Postgres too...
Anyway, this is all part of a larger plan to integrate FunFormKit with
SQLObject, and create a generic through-the-web database interface,
including database building (for Access-like functionality). Integrated
with a simple permission model, you could phrase all sorts of
applications this way -- surveys, registration, mailing lists, etc.
Still a bunch of steps left, though...
Ian
|