Re: [sqlalchemy] dynamic schema with postgresql

2013-09-15 Thread Joe Martin
Thank you for your kind help; it was really helpful. On Fri, Sep 13, 2013 at 2:40 AM, Michael Bayer wrote: > > On Sep 11, 2013, at 10:36 PM, Joe Martin wrote: > > Thank you for your reply. Then I thought the following would work: > > company_schema = 'c' + str(company_id) >

Re: [sqlalchemy] session.execute() versus connection.execute()

2013-09-15 Thread Michael Bayer
On Sep 15, 2013, at 6:46 AM, Felix Zumstein wrote: > All samples for the ORM part use a session to connect to the database, > whereas all samples in the Core part use a connection. If I use both > approaches in my app, does it make sense to execute the SQL Expression > Language (Core) through

[sqlalchemy] session.execute() versus connection.execute()

2013-09-15 Thread Felix Zumstein
All samples for the ORM part use a session to connect to the database, whereas all samples in the Core part use a connection. If I use both approaches in my app, does it make sense to execute the SQL Expression Language (Core) through session.execute() or is there a reason I should use connecti