What is the preferred method to have metadata.create_all() create
sequences? I tried to find something in the wiki but could not find
anything. For indexes you can do this:
schema.Index("public_event_idx", Event.workflow, Event.deleted)
but a similar statement for a sequence:
schema.Sequence("invoice_number", metadata=meta.metadata)
does not do anything. From what I gather from the source Sequence is not
derived from SchemaItem, so it is not picked up automatically. I could
do a DDL construct like this (untested, but basic idea should work):
from sqlalchemy.schema import DDL
def sequenceSupported(event, schema_item, connection):
return connection.dialect.sequence_supported:
DDL("CREATE SEQUENCE invoice_number", on=sequenceSupported)\
.execute_at("after-create", metadata)
but I would rather not have to hardcode the SQL statement, especially
since SQLAlchemy is capable of generating the statement as well.
Wichert.
--
Wichert Akkerman <wich...@wiggy.net> It is simple to make things.
http://www.wiggy.net/ It is hard to make things simple.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.