Re: [sqlalchemy] Fetching last insert id from MySQL.

2010-09-15 Thread Michael Bayer
"SELECT LAST_INSERT_ID()" is ultimately where the value comes from - the raw .lastrowid is present on the ResultProxy for those DBAPIs which support it, so try using that. Perhaps you're getting "0" because the transaction is going away, in which case .lastrowid should solve that issue. On S

[sqlalchemy] Fetching last insert id from MySQL.

2010-09-15 Thread phasma
I've got database with auto increment column called `id` and INSERT query, whom I need to execute without model declaration in project. meta.Session.execute() returns ResultProxy, but last_inserted_ids() doesn't work with execute() and "SELECT LAST_INSERT_ID()" statement sometimes return 0. Is ther