Hi Shane,
On Thu, 2010-06-17 at 23:09 -0700, Shane wrote:
> def upgrade():
> try:
> session.begin() # Start transaction, but tables are always
> committed
> (See below)
>
> DeclarativeBase.metadata.tables[Account.__tablename__].create(migrate_engine)
Hmm, that looks overly complicated to me. I am using the create method
on the Table as well to do this, but it works fine without a session
just using a plain connection:
engine = create_engine(...)
conn = engine.connect()
with conn.begin():
Account.create(conn)
# for testing...
conn.rollback()
I did not create an ORM session before updating the tables as the schema
might not match the mapped classes before updating.
Greetings, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:[email protected]
http://www.dynamore.de
Registration court: Mannheim, HRB: 109659, based in Karlsruhe,
Managing director: Prof. Dr. K. Schweizerhof, Dipl.-Math. U. Franz
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
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.
