Mercurial > p > roundup > code
diff roundup/backends/rdbms_common.py @ 3224:1fd11a9803bb
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:03:44 +0000 |
| parents | 57b60bda9473 |
| children | 440f0a6a2e3c |
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:03:44 2005 +0000 @@ -1,4 +1,4 @@ -# $Id: rdbms_common.py,v 1.149 2005-02-14 02:48:11 richard Exp $ +# $Id: rdbms_common.py,v 1.150 2005-03-02 14:03:44 a1s Exp $ ''' Relational database (SQL) backend common code. Basics: @@ -532,8 +532,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)