Thread: [SQLObject] BoolCol with SQLite
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Javier R. <javier_ruere@HotPOP.com> - 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----- |
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 |
From: Javier R. <javier_ruere@HotPOP.com> - 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----- |
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 |