changeset 3225:5bd7a4caba0d maint-0.8

use backend datatype for journal timestamps. this fixes DateTime parsing errors raised by sqlite if mx.DateTime is installed
author Alexander Smishlajev <a1s@users.sourceforge.net>
date Wed, 02 Mar 2005 14:09:30 +0000
parents bf47b7905ff7
children 227ac5a716e0
files roundup/backends/rdbms_common.py
diffstat 1 files changed, 4 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/roundup/backends/rdbms_common.py	Tue Mar 01 14:47:11 2005 +0000
+++ b/roundup/backends/rdbms_common.py	Wed Mar 02 14:09:30 2005 +0000
@@ -1,4 +1,4 @@
-# $Id: rdbms_common.py,v 1.142.2.5 2005-02-14 02:55:31 richard Exp $
+# $Id: rdbms_common.py,v 1.142.2.6 2005-03-02 14:09:30 a1s Exp $
 ''' Relational database (SQL) backend common code.
 
 Basics:
@@ -526,8 +526,9 @@
         cols = ','.join(['%s varchar'%x
             for x in 'nodeid date tag action params'.split()])
         sql = '''create table %s__journal (
-            nodeid integer, date timestamp, tag varchar(255),
-            action varchar(255), params text)'''%spec.classname
+            nodeid integer, date %s, tag varchar(255),
+            action varchar(255), params text)''' % (spec.classname,
+            self.hyperdb_to_sql_datatypes[hyperdb.Date])
         self.sql(sql)
         self.create_journal_table_indexes(spec)
 

Roundup Issue Tracker: http://roundup-tracker.org/