Mercurial > p > roundup > code
comparison roundup/backends/rdbms_common.py @ 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 | e1da7b5b04ab |
| children | ed97e2a85576 |
comparison
equal
deleted
inserted
replaced
| 3223:bf47b7905ff7 | 3225:5bd7a4caba0d |
|---|---|
| 1 # $Id: rdbms_common.py,v 1.142.2.5 2005-02-14 02:55:31 richard Exp $ | 1 # $Id: rdbms_common.py,v 1.142.2.6 2005-03-02 14:09:30 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 |
| 524 ''' | 524 ''' |
| 525 # journal table | 525 # journal table |
| 526 cols = ','.join(['%s varchar'%x | 526 cols = ','.join(['%s varchar'%x |
| 527 for x in 'nodeid date tag action params'.split()]) | 527 for x in 'nodeid date tag action params'.split()]) |
| 528 sql = '''create table %s__journal ( | 528 sql = '''create table %s__journal ( |
| 529 nodeid integer, date timestamp, tag varchar(255), | 529 nodeid integer, date %s, tag varchar(255), |
| 530 action varchar(255), params text)'''%spec.classname | 530 action varchar(255), params text)''' % (spec.classname, |
| 531 self.hyperdb_to_sql_datatypes[hyperdb.Date]) | |
| 531 self.sql(sql) | 532 self.sql(sql) |
| 532 self.create_journal_table_indexes(spec) | 533 self.create_journal_table_indexes(spec) |
| 533 | 534 |
| 534 def create_journal_table_indexes(self, spec): | 535 def create_journal_table_indexes(self, spec): |
| 535 # index on nodeid | 536 # index on nodeid |