From: <Ale...@di...> - 2002-08-03 17:50:10
|
Thanks Brian. I probably should have looked at the source myself. Anyway, I was doing "dir(dbcursor)" and "dir(dbcursor.__class__)", but I didn't see a public attribute "updatecount" there, and the rowcount was not giving me the right answers . Thanks for your help and your quick and accurate response ! , Alex Kotchnev Diversified Information Technologies |---------+----------------------------> | | "brian zimmer" | | | <bzimmer@ziclix.c| | | om> | | | | | | 08/03/2002 10:31 | | | AM | | | | |---------+----------------------------> >------------------------------------------------------------------------------------------------------------------------------| | | | To: <Ale...@di...>, <jyt...@li...> | | cc: | | Subject: RE: [Jython-users] Verifying update with zxJDBC | >------------------------------------------------------------------------------------------------------------------------------| Alex, There's a public attribute on cursor called 'updatecount' which you can use to determine how many rows where affected for insert/update/delete calls. It uses the underlying statement's getUpdateCount() [http://java.sun.com/j2se/1.3/docs/api/java/sql/Statement.html#getUpdate Count()]. Watch out for some drivers (such as MySQL) which behave differently than might be expected, for example MySQL will only give the number of rows deleted if there is a where clause, otherwise it's undefined. In Jython 2.2 'updatecount' will be deprecated in favor of using 'rowcount' for both select and for insert/update/delete as per the spec [http://www.python.org/peps/pep-0249.html] Let me know if you have any problems/comments. thanks, brian > -----Original Message----- > From: jyt...@li... > [mailto:jyt...@li...] On Behalf > Of Ale...@di... > Sent: Friday, August 02, 2002 8:01 PM > To: jyt...@li... > Subject: [Jython-users] Verifying update with zxJDBC > Importance: High > > > I was wondering if there is a neat way to confirm that an > update query ran successfully with zxJDBC. I mean that > normally the dbcursor.execute() method returns None if is > successful. So, if I am updating 0, 1 or more rows in the > database, I don't have any way to know. > > E.g. if I run a select query on , I can check the number of > rows that I get, but how about update queries ? > > Thanks, > > Alex Kotchnev > Diversified Information Technologies > > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > Jython-users mailing list > Jyt...@li... > https://lists.sourceforge.net/lists/listinfo/jython-users > |
From: Robert H. <fin...@ya...> - 2002-08-04 15:12:54
|
Hi, Is there any way to use the exec statement with the semantics of execfile(code, global_dict, local_dict)? I'd like to have this control over exec's glob & local vars, but it doesn't seem to let me. Another data point: CPython currently lets me use exec() with execfile()'s syntax, but it's undocumented, and Jython doesn't support it either. FYI, I'm writing an IDLE replacement. The main thing I wish were different is that IDLE would give me a choice to start with a new environment when I need to. In other words, I'm sorta copying Dr. Scheme's UI. Thanks for any help! Robert __________________________________________________ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com |