[sqlalchemy] Re: A "after flush before commit" event

2017-09-18 Thread mike
Followup question -- this the following order of events guaranteed? before_commit --> after_flush --> after_flush_post_exec i.e., is an after_flush_post_exec guaranteed to run after the before_commit preceding a commit? -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http

Re: [sqlalchemy] Re: Postgres Composite Columns

2017-09-18 Thread Tolstov Sergey
> > Thanks for answer. I don't think so. pg_composite haven't updates 1-3 > years. I already use another table for store data, that's more comfortable and > cross-pratform понедельник, 18 сентября 2017 г., 17:12:13 UTC+3 пользователь Mike Bayer написал: > > On Mon, Sep 18, 2017 at 2:30 AM, T

Re: [sqlalchemy] Re: Sqlalchemy unable to work with azure SQL server ( The rest aws local all works)

2017-09-18 Thread Mike Bayer
On Mon, Sep 18, 2017 at 2:44 PM, suman deb wrote: > It does connect > > root@DNDSaltMaster:~# tsql -S testservercri.database.windows.net -U criuser > Password: > locale is "en_US.UTF-8" > locale charset is "UTF-8" > using default charset "UTF-8" > 1> r > > [testservercri] > host = testserv

[sqlalchemy] Re: Sqlalchemy unable to work with azure SQL server ( The rest aws local all works)

2017-09-18 Thread suman deb
It does connect root@DNDSaltMaster:~# tsql -S testservercri.database.windows.net -U criuser Password: locale is "en_US.UTF-8" locale charset is "UTF-8" using default charset "UTF-8" 1> r [testservercri] host = testservercri.database.windows.net port = 1433 tds version = 7.

Re: [sqlalchemy] after_commit and failure

2017-09-18 Thread Mike Bayer
On Mon, Sep 18, 2017 at 10:41 AM, cecemel wrote: > Hi, > > will the after_commit event get fired if the commit failed? > > Don't see anything in the doc about that. it wont. > > thx > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > T

[sqlalchemy] after_commit and failure

2017-09-18 Thread cecemel
Hi, will the after_commit event get fired if the commit failed? Don't see anything in the doc about that. thx -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Exa

Re: [sqlalchemy] Re: Postgres Composite Columns

2017-09-18 Thread Mike Bayer
On Mon, Sep 18, 2017 at 2:30 AM, Tolstov Sergey wrote: >> Hi, i have some issue. I tried to replace namedtuple to dict and list >> items (with adding hast function to them). But SQLAlchemy types returns list >> ordereddict, when i change items, session didn't see changes. Do you found >> solution?

Re: [sqlalchemy] Sqlalchemy unable to work with azure SQL server ( The rest aws local all works)

2017-09-18 Thread Mike Bayer
On Mon, Sep 18, 2017 at 5:54 AM, suman deb wrote: > Hi I have followed the sqlalchemy connection strings docs for mssql > > This is my connection string that works for mssql in other platforms ( > aws-rds, vm) > > i am trying to use pymssql . > > > db_url = '{}+pymssql://{}:{}@{}:{}/{}'.format("m

[sqlalchemy] Sqlalchemy unable to work with azure SQL server ( The rest aws local all works)

2017-09-18 Thread suman deb
Hi I have followed the sqlalchemy connection strings docs for mssql This is my connection string that works for mssql in other platforms ( aws-rds, vm) i am trying to use pymssql . db_url = '{}+pymssql://{}:{}@{}:{}/{}'.format("mssql", user, password, host, port, dbname) engine = create_en