Thanks for looking at this. I've submitted some tests for the default styles in the tracker. http://sourceforge.net/tracker/index.php?func=detail&aid=2007233&group_i d=74338&atid=540674
--Buck -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oleg Broytmann Sent: Monday, June 30, 2008 2:20 PM To: sqlobject-discuss@lists.sourceforge.net Subject: Re: [SQLObject] SO test results Hello! Please bear in mind that I use Postgres and SQLite; I stopped using MySQL long time ago, so I cannot fix MySQL-related problems. I have to rely on other people's patches. On Mon, Jun 30, 2008 at 01:21:16PM -0700, Golemon, Buck wrote: > Here are my test results for the SO test suite. Some sources of errors: > > * Many of the asserts use a string where the MySQLdb cursor returns and > integer. Do you mean this one? > assert IntAccumulator.select().min(IntAccumulator.q.value) == 1 > E assert IntAccumulator.select().avg(IntAccumulator.q.value) == 2 > > assert '2.0000' == 2 > + where '2.0000' = <SelectResults at > 2a9ae10b10>.avg(int_accumulator.value) > + where <SelectResults at 2a9ae10b10> = IntAccumulator.select() > + and int_accumulator = IntAccumulator.q > [/home/bgolemon/SQLObject/sqlobject/tests/test_aggregates.py:22] I interpret this the other way around - MySQLdb returns strings where it have to return integers. > * col.py does not allow for the cursor returning a datetime.timedelta > object. (I > didn't know this ever happened either.) In DateTime column? > * There are a few instances where a column is typed as 'text' and then > used as a > key, but mysql doesn't allow this unless you specify a prefix. The > blob/text > types shouldn't be used for simple fields like 'name'. Limit the length of the fields: StringCol(length=255). > * A couple asserts compare the row return value to a list, but the row > is a > tuple and will never compare equal with a list. Don't hesitate to convert returned values to lists (or tuples). > I'd try to fix them myself, but I'd probably break more than I fixed... Please post a patch or submit it to the SF tracker so we can discuss and improve it. Oleg. -- Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN. ------------------------------------------------------------------------ - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
