Re: [sqlalchemy] SQLAlchemy ResultProxy.rowcount not zero when UPDATE has no affected rows

2012-06-12 Thread Francis
Well, my reply doesn't really make sense as the note is there. I mean that it should be accessible from the "rowcount" description. That would be nice if "affected row" was an hyperlink to it's definition in the context of SQLAlchemy. -- You received this message because you are subscribed

Re: [sqlalchemy] SQLAlchemy ResultProxy.rowcount not zero when UPDATE has no affected rows

2012-06-12 Thread Francis
On Tuesday, June 12, 2012 10:49:53 AM UTC-4, Michael Bayer wrote: > > > On Jun 12, 2012, at 7:07 AM, Francis wrote: > > I posted this on StackOverflow: > > We have a MySQL database and we're switching from DB API to SQLAlchemy. >> From the documentation, the ResultPr

[sqlalchemy] SQLAlchemy ResultProxy.rowcount not zero when UPDATE has no affected rows

2012-06-12 Thread Francis
I posted this on StackOverflow: We have a MySQL database and we're switching from DB API to SQLAlchemy. > From the documentation, the ResultProxy.rowcount is supposed to report the > number of affected rows by an UPDATE statement. > If I execute this query with SQLAlchemy: > UPDATE table > SET f

[sqlalchemy] Re: Mapping an existing database

2009-03-29 Thread John Francis Lee
rative > mappings) that correspond to the existing schema. You can even leave out > columns or tables you aren't concerned about. Thanks again. It sounds like there's no problem dealing with an existing database. -- John Francis Lee 1025/37 Thanon Jet Yod Mueang Chiangrai 5700

[sqlalchemy] Re: Mapping an existing database

2009-03-29 Thread John Francis Lee
ese woods? >> > > 'autoload' support is your friend. > > - -aj > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.4.9 (Darwin) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ > > iEYEARECAAYFAknPnWgACgkQCJIWIbr9KYyH4gCeKuRKLTKhrRUF5UgkaBPKz

[sqlalchemy] Re: Mapping an existing database

2009-03-29 Thread John Francis Lee
te the database from python object >> definitions, but I want to create the python object definitions >> from the database. Am I on my own, or is there a well-worn path >> through these woods? >> >> Thanks for any advice you may have for me. >> >