[SQL-CVS] r2011 - SQLObject/trunk/sqlobject/sqlite

[<sub...@co...>]

Author: phd
Date: 2006-10-11 14:02:23 -0600 (Wed, 11 Oct 2006)
New Revision: 2011

Modified:
   SQLObject/trunk/sqlobject/sqlite/sqliteconnection.py
Log:
Stop PySQLite2 converting date/time columns - the conversion causes troubles,
and our conversion is more flexible.


Modified: SQLObject/trunk/sqlobject/sqlite/sqliteconnection.py
===================================================================
--- SQLObject/trunk/sqlobject/sqlite/sqliteconnection.py	2006-10-11 20:02:00 UTC (rev 2010)
+++ SQLObject/trunk/sqlobject/sqlite/sqliteconnection.py	2006-10-11 20:02:23 UTC (rev 2011)
@@ -51,9 +51,9 @@
                 import warnings
                 warnings.warn(DeprecationWarning("pysqlite2 does not support the encoding option"))
             opts["detect_types"] = sqlite.PARSE_DECLTYPES
-            for col_type in "text", "char", "varchar":
-                sqlite.register_converter(col_type, stop_pysqlite2_converting_strings_to_unicode)
-                sqlite.register_converter(col_type.upper(), stop_pysqlite2_converting_strings_to_unicode)
+            for col_type in "text", "char", "varchar", "date", "time", "datetime", "timestamp":
+                sqlite.register_converter(col_type, stop_pysqlite2_converting_strings)
+                sqlite.register_converter(col_type.upper(), stop_pysqlite2_converting_strings)
             try:
                 from sqlite import encode, decode
             except ImportError:
@@ -265,5 +265,5 @@
     def delColumn(self, tableName, column):
         pass # Oops! There is no DROP COLUMN in SQLite
 
-def stop_pysqlite2_converting_strings_to_unicode(s):
+def stop_pysqlite2_converting_strings(s):
     return s