[sqlalchemy] Re: Getting the mysql_insert_id() for multiple inserts

2009-08-07 Thread abhi
Or may be I can generate the ids myself and insert them since using a db specific api is something I want to avoid. Thanks a lot anyways for that information. Regards, Abhi On Aug 8, 5:42 am, Michael Bayer wrote: > DBAPI's executemany() doesn't return cursor.lastrowid for the multiple   > inse

[sqlalchemy] Re: Getting the mysql_insert_id() for multiple inserts

2009-08-07 Thread Michael Bayer
DBAPI's executemany() doesn't return cursor.lastrowid for the multiple inserts so you'd have to use a lower level MySQL API. On Aug 7, 2009, at 8:31 PM, abhi wrote: > > Hi, > > Using a scoped_session object, I am able to insert a row and get its > new auto incremented value using object.id met