Mercurial > p > roundup > code
diff roundup/backends/rdbms_common.py @ 2166:cd42c3c7173a
MySQL and Postgresql use BOOL/BOOLEAN for Boolean types
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Wed, 31 Mar 2004 07:25:14 +0000 |
| parents | 666402433998 |
| children | 723098a10677 |
line wrap: on
line diff
--- a/roundup/backends/rdbms_common.py Tue Mar 30 23:01:41 2004 +0000 +++ b/roundup/backends/rdbms_common.py Wed Mar 31 07:25:14 2004 +0000 @@ -1,4 +1,4 @@ -# $Id: rdbms_common.py,v 1.86 2004-03-24 04:57:25 richard Exp $ +# $Id: rdbms_common.py,v 1.87 2004-03-31 07:25:14 richard Exp $ ''' Relational database (SQL) backend common code. Basics: @@ -231,7 +231,7 @@ hyperdb.Link : 'INTEGER', hyperdb.Interval : 'VARCHAR(255)', hyperdb.Password : 'VARCHAR(255)', - hyperdb.Boolean : 'INTEGER', + hyperdb.Boolean : 'BOOLEAN', hyperdb.Number : 'REAL', } def determine_columns(self, properties): @@ -611,7 +611,7 @@ hyperdb.Link : int, hyperdb.Interval : lambda x: x.serialise(), hyperdb.Password : str, - hyperdb.Boolean : int, + hyperdb.Boolean : lambda x: x and 'TRUE' or 'FALSE', hyperdb.Number : lambda x: x, } def addnode(self, classname, nodeid, node):