From: Florian S. <flo...@gm...> - 2004-07-13 14:10:32
|
I get an error when I try to get an element from a select. result = Klassname.select(<statements>) result[0] <---- here I get TypeError: Iteration over non-sequence It seems like the Iteration object returns None in dbconnection.iterSelect and the list(Iteration(...)) fails because of that. I use svn checkout from a few hours ago. I would stay with 0.5.2, but there are no cleanup functions and I get leaking connections because of that. Regards, Florian Schulze |
From: Karl C. <qu...@no...> - 2004-07-13 14:30:24
|
This only happens when the select returns empty. You can do either a try/except or do a count first. >>>>> "Florian" == Florian Schulze <flo...@gm...> writes: Florian> Florian> I get an error when I try to get an element from a Florian> select. result = Klassname.select(<statements>) Florian> result[0] <---- here Florian> Florian> I get TypeError: Iteration over non-sequence Florian> Florian> It seems like the Iteration object returns None in Florian> dbconnection.iterSelect and the list(Iteration(...)) Florian> fails because of that. -- Karl 2004-07-13 07:29 |
From: Florian S. <flo...@gm...> - 2004-07-13 14:37:24
|
On Tue, 13 Jul 2004 07:30:14 -0700, Karl Chen <qu...@no...> wrote: > > > This only happens when the select returns empty. You can do > either a try/except or do a count first. Then it should return an empty list and raise an IndexError, the current behaviour is wrong. And as far as I can see in the next function of Iteration it checks for an empty select and immediatly raises StopIteration, so this can't be the problem. Florian Schulze |
From: Karl C. <qu...@no...> - 2004-07-13 14:56:17
|
>>>>> "Florian" == Florian Schulze <flo...@gm...> writes: Florian> Then it should return an empty list and raise an Florian> IndexError, the current behaviour is wrong. And as Florian> far as I can see in the next function of Iteration it Florian> checks for an empty select and immediatly raises Florian> StopIteration, so this can't be the problem. Ok never mind. Try the sqlobject branch from here: http://svn.quarl.org/repos/coursesurvey/trunk/coursesurvey/scripts/sqlobject Does it have the same problem? (I fixed some bugs regarding returning None a long time ago; there is a lot of stuff to merge into the sqlobject trunk) -- Karl 2004-07-13 07:53 |
From: Florian S. <flo...@gm...> - 2004-07-14 06:27:54
|
On Tue, 13 Jul 2004 07:56:12 -0700, Karl Chen <qu...@no...> wrote: >>>>>> "Florian" == Florian Schulze <flo...@gm...> writes: > Florian> Then it should return an empty list and raise an > Florian> IndexError, the current behaviour is wrong. And as > Florian> far as I can see in the next function of Iteration it > Florian> checks for an empty select and immediatly raises > Florian> StopIteration, so this can't be the problem. > > Ok never mind. Try the sqlobject branch from here: > > http://svn.quarl.org/repos/coursesurvey/trunk/coursesurvey/scripts/sqlobject I can't check it out, http://svn.quarl.org/repos_html/coursesurvey/trunk/coursesurvey/scripts/sqlobject/ also doesn't work. Regards, Florian Schulze |
From: Florian S. <flo...@gm...> - 2004-07-14 06:30:38
|
On Wed, 14 Jul 2004 08:30:48 +0200, Florian Schulze <flo...@gm...> wrote: > On Tue, 13 Jul 2004 07:56:12 -0700, Karl Chen <qu...@no...> > wrote: > >>>>>>> "Florian" == Florian Schulze <flo...@gm...> >>>>>>> writes: >> Florian> Then it should return an empty list and raise an >> Florian> IndexError, the current behaviour is wrong. And as >> Florian> far as I can see in the next function of Iteration it >> Florian> checks for an empty select and immediatly raises >> Florian> StopIteration, so this can't be the problem. >> >> Ok never mind. Try the sqlobject branch from here: >> >> http://svn.quarl.org/repos/coursesurvey/trunk/coursesurvey/scripts/sqlobject > > I can't check it out, > http://svn.quarl.org/repos_html/coursesurvey/trunk/coursesurvey/scripts/sqlobject/ > also doesn't work. Ups, forgot to post the error message: svn: REPORT request failed on '/repos_html/coursesurvey/!svn/vcc/default' svn: REPORT of '/repos_html/coursesurvey/!svn/vcc/default': 400 Bad Request (http://svn.quarl.org) The same for the other URL. Regards, Florian Schulze |
From: Ivo v. d. W. <vla...@gm...> - 2004-07-14 09:18:46
|
On Tue, 13 Jul 2004 16:08:45 +0200, Florian Schulze <flo...@gm...> wrote: > I get an error when I try to get an element from a select. > > result = Klassname.select(<statements>) > result[0] <---- here > > I get TypeError: Iteration over non-sequence > > It seems like the Iteration object returns None in dbconnection.iterSelect > and the list(Iteration(...)) fails because of that. > Are you sure your SQL statement is correct? If you enable debug (debug=1 in your connection), will the generated SQL work from a standard sql client? Cheers Ivo -- Drs. I.R. van der Wijk -=- Korte Leidsedwarsstraat 12 Amaze 1017 RC Amsterdam, NL -=- T +31-20-4688336 F +31-20-4688337 Zope/Plone/Content Management W http://www.amaze.nl E in...@am... Open Source Solutions W http://vanderwijk.info E iv...@am... Consultancy PGP http://vanderwijk.info/pgp |
From: Florian S. <flo...@gm...> - 2004-07-19 11:20:23
|
On Wed, 14 Jul 2004 11:18:38 +0200, Ivo van der Wijk <vla...@gm...> wrote: > Are you sure your SQL statement is correct? If you enable debug > (debug=1 in your connection), will the generated SQL work from a > standard sql client? I have checked and the SQL is correct. Regards, Florian Schulze |