[DB-SIG] None and BOOLEAN columns

[M.-A. Lemburg]

"Dittmar, Daniel" wrote:
> 
> What is the expected behaviour with regard to NULL, TRUE, FALSE and BOOLEAN
> columns?
> 
> In the SAP DB driver, I translate None (or any other value interpreted as
> false) to a SQL False value, so there is currently no possibility to insert
> a real NULL value.
> 
> On SELECT, I translate both NULL and FALSE to None.
> 
> Admittedly, this comes from my own Python + SQL style, where I use None as
> false on the Python side and try to stay away from three valued logic on the
> SQL side.
> 
> What do other drivers do?

I'd suggest to use PyObject_IsTrue() on the input side and
to return Py_True/Py_False on the output side.

None should always map to NULL on input.

-- 
Marc-Andre Lemburg
CEO eGenix.com Software GmbH
______________________________________________________________________
Company & Consulting:                           http://www.egenix.com/
Python Software:                   http://www.egenix.com/files/python/