sqlobject-discuss

[SQLObject] How to insert a boolean into PostgreSQL

[CLIFFORD I. <cli...@di...>]

Hi,

I was able to create a PostgreSQL table with a boolean column by doing 
myClass.createTable but I cannot insert into it without SQLObject raising 
the following error:

ValueError: Unknown SQL builtin type: <type 'instance'> for TRUE

I am attempting to insert as follows:

p = person.new(firstName="Donald", lastName="Duck" , amtPaid="10.26", 
isParticipant=True)

I tried assigning "", "T", 1 to isParticipant but all behaved the same way. 
NULLs are allowed for the boolean column. How can I insert into this table?

Also, how would I specify a default value for a boolean column? I tried:

isParticipant=BoolCol(default=True)

and when I created the table, there was no default for the column.

Regards,

Clifford Ilkay
Dinamis Corporation
3266 Yonge Street, Suite 1419
Toronto, Ontario
Canada M4N 3P6

Tel: 416-410-3326 

Re: [SQLObject] How to insert a boolean into PostgreSQL

[Ian B. <ia...@co...>]

On Feb 20, 2004, at 1:29 AM, CLIFFORD ILKAY wrote:
> I was able to create a PostgreSQL table with a boolean column by doing 
> myClass.createTable but I cannot insert into it without SQLObject 
> raising the following error:
>
> ValueError: Unknown SQL builtin type: <type 'instance'> for TRUE

Hmm... are you using an early version of Python 2.2?  I think there was 
a problem related to that version (before True and False were defined)

> I am attempting to insert as follows:
>
> p = person.new(firstName="Donald", lastName="Duck" , amtPaid="10.26", 
> isParticipant=True)
>
> I tried assigning "", "T", 1 to isParticipant but all behaved the same 
> way. NULLs are allowed for the boolean column. How can I insert into 
> this table?
>
> Also, how would I specify a default value for a boolean column? I 
> tried:
>
> isParticipant=BoolCol(default=True)
>
> and when I created the table, there was no default for the column.

The default only applies to the object, not the table.  When you add a 
row through SQLObject the default is used.

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

Re: [SQLObject] How to insert a boolean into PostgreSQL

[Luke O. <lu...@me...>]

>> ValueError: Unknown SQL builtin type: <type 'instance'> for TRUE
>
> Hmm... are you using an early version of Python 2.2?  I think there was
> a problem related to that version (before True and False were defined)

Actually, as I recall this is a combination of using an older version of 2.2
and a slight bug in the workaround class in SQLObject. Take a look in
Converters.py, the definition for class BOOL. It should be defined as a
new-style class - class BOOL(object). But at least in some versions of
SQLObject this was missing, leading to the error above.

- Luke