Mercurial > p > roundup > code
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 3222:aca931e6dcac | 3224:1fd11a9803bb |
|---|---|
| 1 # $Id: rdbms_common.py,v 1.149 2005-02-14 02:48:11 richard Exp $ | 1 # $Id: rdbms_common.py,v 1.150 2005-03-02 14:03:44 a1s Exp $ |
| 2 ''' Relational database (SQL) backend common code. | 2 ''' Relational database (SQL) backend common code. |
| 3 | 3 |
| 4 Basics: | 4 Basics: |
| 5 | 5 |
| 6 - map roundup classes to relational tables | 6 - map roundup classes to relational tables |
| 530 ''' | 530 ''' |
| 531 # journal table | 531 # journal table |
| 532 cols = ','.join(['%s varchar'%x | 532 cols = ','.join(['%s varchar'%x |
| 533 for x in 'nodeid date tag action params'.split()]) | 533 for x in 'nodeid date tag action params'.split()]) |
| 534 sql = '''create table %s__journal ( | 534 sql = '''create table %s__journal ( |
| 535 nodeid integer, date timestamp, tag varchar(255), | 535 nodeid integer, date %s, tag varchar(255), |
| 536 action varchar(255), params text)'''%spec.classname | 536 action varchar(255), params text)''' % (spec.classname, |
| 537 self.hyperdb_to_sql_datatypes[hyperdb.Date]) | |
| 537 self.sql(sql) | 538 self.sql(sql) |
| 538 self.create_journal_table_indexes(spec) | 539 self.create_journal_table_indexes(spec) |
| 539 | 540 |
| 540 def create_journal_table_indexes(self, spec): | 541 def create_journal_table_indexes(self, spec): |
| 541 # index on nodeid | 542 # index on nodeid |