On Aug 19, 2008, at 1:59 PM, Gerrat wrote:

>
> Is there a way to easily hook into the table creation mechanism so
> that whenever a Sequence was specified as part of a Column definition,
> a similiar trigger could be inserted (substituting some names
> obviously)?  I know I can manually issue the DDL after-the-fact for
> each table create, but would prefer it be more implicit.
>

I'm assuming that you mean you're already familiar with the DDL()  
construct, which is documented at:

http://www.sqlalchemy.org/docs/05/sqlalchemy_schema.html#docstrings_sqlalchemy.schema_DDL

So the next step is to create your own Table function along the lines  
of:

from sqlalchemy.schema import Table as _Table, Sequence, DDL

def Table(name, meta, *args, **kw):
        t = _Table(name, meta, *args, **kw)
        for c in t.c:
                if c.default and isinstance(c.default, Sequence):
                        DDL("your per-sequence DDL 
here").execute_at('after-create', t)
        return t




--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to