thats just result.rowcount, which is taken directly from "rowcount" off the underlying Cursor. youll get that in all cases. note that for an executemany(), DBAPI unfortunately does not aggregate the total rowcount across individual executions so its somewhat useless for an executemany.
On Sep 23, 2006, at 8:43 PM, Samuel Abels wrote: > Thanks for the information. > > I have also been trying to find a way to retrieve the number of > affected > rows after a DELETE operation. The docs mention that this can be done > using the ResultProxy, but I have not found any method that might > provide this kind of information. Any hints? > > Thanks, > -Samuel > > On Sat, 2006-09-23 at 18:06 -0400, Michael Bayer wrote: >> ah, sorry, I just committed to SVN a more descriptive error message >> for what that is. the extra functions like last_inserted_ids etc. >> drive off of an ExecutionContext object which is not created when >> executing literal SQL strings. youd have to use a metadata-generated >> SQL clause to get the extra functionality. >> >> the new error message when you try to call off a nonexistent >> execution context is: >> >> This ResultProxy does not have an execution context with which to >> complete this operation. Execution contexts are not generated for >> literal SQL execution. > > > ---------------------------------------------------------------------- > --- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to > share your > opinions on IT & business topics through brief surveys -- and earn > cash > http://www.techsay.com/default.php? > page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Sqlalchemy-users mailing list > Sqlalchemy-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
