Thread: [SQLObject] BoolCol with SQLite

SQLObject is a Python ORM.

Brought to you by: ianbicking, phd

sqlobject-discuss

[SQLObject] BoolCol with SQLite

From: Javier R. <jav...@Ho...> - 2003-12-30 15:45:19

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all,
	I've been away for a while but I see that BoolCol has been added. I
have been unable to use it with SQLite. After looking the code and the
tests, I think it is not supported for SQLite. Am I right? It would be
really useful to me so if I can help with it, count on me.

Thanks,
	Javier
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQE/7zBj8XQC840MeeoRApcZAJ9l03/UKlyOnP2n5KjCwhF/wt11nACdGgyS
MdDEMa0cIRwud5NFFmBBnH4=
=nHHJ
-----END PGP SIGNATURE-----

Re: [SQLObject] BoolCol with SQLite

From: Ian B. <ia...@co...> - 2004-01-08 22:37:16

On Dec 28, 2003, at 1:35 PM, Javier Ruere wrote:
> 	I've been away for a while but I see that BoolCol has been added. I
> have been unable to use it with SQLite. After looking the code and the
> tests, I think it is not supported for SQLite. Am I right? It would be
> really useful to me so if I can help with it, count on me.

It should be working -- at least, I thought it was, but I don't have 
the code in front of me at the moment (SF CVS and my laptop are 
uncooperative).  Non-Boolean-supporting databases (everything but 
Postgres) just use integers (1/0).  There's other details to how 
BoolCol works, but those are database-agnostic.

--
Ian Bicking | ia...@co... | http://blog.ianbicking.org

Re: [SQLObject] BoolCol with SQLite

From: Javier R. <jav...@Ho...> - 2004-01-09 04:14:16

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Ian Bicking wrote:
> On Dec 28, 2003, at 1:35 PM, Javier Ruere wrote:
>
>>     I've been away for a while but I see that BoolCol has been added. I
>> have been unable to use it with SQLite. After looking the code and the
>> tests, I think it is not supported for SQLite. Am I right? It would be
>> really useful to me so if I can help with it, count on me.
>
> It should be working -- at least, I thought it was, but I don't have the
> code in front of me at the moment (SF CVS and my laptop are
> uncooperative).  Non-Boolean-supporting databases (everything but
> Postgres) just use integers (1/0).  There's other details to how BoolCol
> works, but those are database-agnostic.

  I was asking because in test_converters.ConvertersTest.test_bool,
PostgreSQL and MySQL are tested but bot SQLite (besides my code not
working :). Also there is special code in BoolCol for the first two DBs
but not for the last one, IIRC.
  Has anyone used this type with SQLite successfully?

Javier

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQE//i8g8XQC840MeeoRAgeJAKCFoy18b6oGvhjxORpQrPDGsuRPKQCfeefT
gdO7gGezukq/kp3CTc8rxzI=
=XCsl
-----END PGP SIGNATURE-----

Re: [SQLObject] BoolCol with SQLite

From: Ian B. <ia...@co...> - 2004-01-09 13:24:21

On Jan 8, 2004, at 10:33 PM, Javier Ruere wrote:
>   I was asking because in test_converters.ConvertersTest.test_bool,
> PostgreSQL and MySQL are tested but bot SQLite (besides my code not
> working :). Also there is special code in BoolCol for the first two DBs
> but not for the last one, IIRC.
>   Has anyone used this type with SQLite successfully?

An oversight then.  SQLite should work just like MySQL.  I thought 
there were unit tests that would have caught that, but apparently not.

--
Ian Bicking | ia...@co... | http://blog.ianbicking.org