iterbetter object is True even if it is empty when use sqlite3

[realazy]

when using sqlite3 as db, the iterbetter object, which is web.query returned, is True even if it is empty.

please fix this, I don't want to list(ib) all the time, many thanks!

[Anand Chitipothu (anandology)]

On Jan 1, 2008 12:12 PM, realazy <email address hidden> wrote:
> Public bug reported:
>
> when using sqlite3 as db, the iterbetter object, which is web.query
> returned, is True even if it is empty.

Unfortunately, sqlite doesn't provide the number of rows in resultset,
so it is impossible to find the length without converting it to list.

But, i guess, it is misleading to return True always. Probably it
should raise an exception, when it can not determine the length.

[Anand Chitipothu (anandology)]

Fixed.

http://github.com/webpy/webpy/commit/3cdaa14b0414721d79311622830b60ca02a0a6f7

[Emyr Thomas (emzo)]

For SQLite, couldn't we at least allow people to check to see if an IterBetter instance is empty or not by doing something like this?
http://chimezie.posterous.com/lazy-test-and-consumption-of-generators

[Anand Chitipothu (anandology)]

On Wed, Nov 4, 2009 at 5:01 PM, Emyr Thomas <email address hidden> wrote:
> For SQLite, couldn't we at least allow people to check to see if an IterBetter instance is empty or not by doing something like this?
> http://chimezie.posterous.com/lazy-test-and-consumption-of-generators

Thats a good idea. I haven't thought about it. We already use that
patten in application.py.

[Anand Chitipothu (anandology)]

On Wed, Nov 4, 2009 at 6:42 PM, Anand Chitipothu <email address hidden> wrote:
> On Wed, Nov 4, 2009 at 5:01 PM, Emyr Thomas <email address hidden> wrote:
>> For SQLite, couldn't we at least allow people to check to see if an IterBetter instance is empty or not by doing something like this?
>> http://chimezie.posterous.com/lazy-test-and-consumption-of-generators
>
> Thats a good idea. I haven't thought about it. We already use that
> patten in application.py.

Fixed. Can you try it out and let me know if it looks alright?

http://github.com/webpy/webpy/commit/fa655ca9c1adc2fa3140564cf4d075e2910f6667
http://github.com/webpy/webpy/commit/9e5e40492f6e141df977a93def73423702038bcd