Re: [web2py] Re: sqlite strange behaviour with boolean

2013-10-18 Thread Derek
I'm just giving Tim some options... facetious as they may be... On Friday, October 18, 2013 12:34:04 PM UTC-7, Tim Richardson wrote: > > "he" won't be overriding or redefining booleans ... I can't see that as a > step forward for humanity. > > The decision by web2py to use T or F for booleans in

Re: [web2py] Re: sqlite strange behaviour with boolean

2013-10-18 Thread Niphlod
it's because historically boolean support with 1 and 0 was inserted in sqlite3. sqlite2 has no notion of a specific type for it. Even now, SQLite still use dynamic datatyping, so it really doesn't matter what you choose, as long as it's consistent. The more interesting (i.e. debatable) choice is

Re: [web2py] Re: sqlite strange behaviour with boolean

2013-10-18 Thread Tim Richardson
"he" won't be overriding or redefining booleans ... I can't see that as a step forward for humanity. The decision by web2py to use T or F for booleans in SQLite is interesting ... I wonder why. On Sat, Oct 19, 2013 at 5:55 AM, Derek wrote: > Yea, he should probably override the equality opera

[web2py] Re: sqlite strange behaviour with boolean

2013-10-18 Thread Derek
Yea, he should probably override the equality operator to allow F (not just 0 or False). :D On Thursday, October 17, 2013 11:53:24 AM UTC-7, Niphlod wrote: > > don't do that, please. If you're annoyed with web2py's defaults, you can > easily sublass the adapter and make your own adjustments. > >

[web2py] Re: sqlite strange behaviour with boolean

2013-10-17 Thread Niphlod
don't do that, please. If you're annoyed with web2py's defaults, you can easily sublass the adapter and make your own adjustments. On Thursday, October 17, 2013 7:29:10 PM UTC+2, Derek wrote: > > Since you are using Python 2.x you can redefine 'False' to be 'F' if you > wish, although I'm sure y

[web2py] Re: sqlite strange behaviour with boolean

2013-10-17 Thread Derek
Since you are using Python 2.x you can redefine 'False' to be 'F' if you wish, although I'm sure you'd have some side effects somewhere else in the system. In Python 3.x you can't do that. On Wednesday, October 16, 2013 8:49:26 PM UTC-7, Tim Richardson wrote: > > > > On Thursday, 17 October 2013

[web2py] Re: sqlite strange behaviour with boolean

2013-10-16 Thread Tim Richardson
On Thursday, 17 October 2013 14:29:17 UTC+11, Tim Richardson wrote: > > This is web2py 2.7.4, on Windows, python 2.7.5 > > I have rows in an sqlite table with a boolean field. Currently all rows > have this field set to 0 (via an update query in an sqlite console) > > When the table is defined i