On Mar 7, 2006, at 12:46 AM, Kapil Thangavelu wrote:
i've been playing around with this and have generation of some
kinds of change objects. what would be the best way to generate
the sql ddl for these changesets? i'd like to take advantage of the
sql generation and abstraction capabilities already in sa.
i'm thinking some sort of AlterClause subclassed from
ClauseElement, and a Changeset that accepts a schema visitor to the
contained alterclauses. and then modify the schema generator to
process them.
yah that, or provide your own schema generator object that decorates
the existing one. it would be nice to keep ALTER stuff out of the
core, and also to develop patterns for building external syntax
modules (since there are bazillions of potential syntax modules that
might want to be added on...)
i.e. i like the idea of all the myriad SQL features that are either
specialized, advanced, environment specific, sketchy etc. to be
loadable:
from sqlalchemy import *
import sqlalchemy.ext.savepoint
import sqlalchemy.ext.changeset
import sqlalchemy.ext.trigger
import sqlalchemy.ext.plpython
the core: simple, fast, light ! pluggable !
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
