MySQL and Postgresql use BOOL/BOOLEAN for Boolean types

git-svn-id: http://svn.roundup-tracker.org/svnroot/roundup/trunk@2236 57a73879-2fb5-44c3-a270-3262357dd7e2

diff --git a/CHANGES.txt b/CHANGES.txt
index 3dbe83b2bf22f1e00d585dba745efe606e9a0a1a..78650846be614f647042a379cd019f1c4f2e138a 100644 (file)
--- a/CHANGES.txt
+++ b/CHANGES.txt
@@ -6,6 +6,7 @@ Fixed:
 - CSV export was busted (as was any action returning a result)
 - MultiMapping deviated from the Zope C implementation in a number of
   places (thanks Toby Sargeant)
+- MySQL and Postgresql use BOOL/BOOLEAN for Boolean types
 
 
 2004-03-27 0.7.0b2

diff --git a/doc/whatsnew-0.7.txt b/doc/whatsnew-0.7.txt
index db409dbe5e8530ad76a0ee1f385d62bfccb1d3eb..499618a9acb21da56249e42c80090e170656b43a 100644 (file)
--- a/doc/whatsnew-0.7.txt
+++ b/doc/whatsnew-0.7.txt
@@ -309,9 +309,8 @@ New configuration options
 Typed columns in RDBMS backends
 -------------------------------
 
-The MySQL (and Postgresql for that matter) backend now creates tables with
-appropriate column datatypes (not just varchar). Sqlite got the typing
-too, but it ignores the datatypes :)
+The SQLite, MySQL and Postgresql backends now create tables with
+appropriate column datatypes (not just varchar).
 
 Your database will be automatically migrated to use the new schemas, but
 it will take time. It's probably a good idea to make sure you do this as
@@ -363,7 +362,7 @@ New auditor fixes Outlook bug
 The new optional auditor ``detectors/emailauditor.py`` fires whenever a
 new file entity is created.
 
-If the file is of type message/rfc822, we tack onthe extension .eml.
+If the file is of type message/rfc822, we tack on the extension .mht.
 
 The reason for this is that Microsoft Internet Explorer will not open
 things with a .eml attachment, as they deem it 'unsafe'. Worse yet,

diff --git a/roundup/backends/back_mysql.py b/roundup/backends/back_mysql.py
index 2efd853784463f084240068de362d1a3f8543255..be07b8706158fc4c6f854f90ea158c1fb469682f 100644 (file)
--- a/roundup/backends/back_mysql.py
+++ b/roundup/backends/back_mysql.py
@@ -117,7 +117,7 @@ class Database(Database):
         hyperdb.Link   : 'INTEGER',
         hyperdb.Interval  : 'VARCHAR(255)',
         hyperdb.Password  : 'VARCHAR(255)',
-        hyperdb.Boolean   : 'INTEGER',
+        hyperdb.Boolean   : 'BOOL',
         hyperdb.Number    : 'REAL',
     }
 

diff --git a/roundup/backends/rdbms_common.py b/roundup/backends/rdbms_common.py
index 435b99ce55301532d2050a31f5945219d336a3e3..684a04c8be8032af53e008f688a0a1227a7462f8 100644 (file)
--- a/roundup/backends/rdbms_common.py
+++ b/roundup/backends/rdbms_common.py
@@ -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 @@ class Database(FileStorage, hyperdb.Database, roundupdb.Database):
         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 @@ class Database(FileStorage, hyperdb.Database, roundupdb.Database):
         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):