From ecca590cb8c634f4ba529b6aa0270eda800c1d44 Mon Sep 17 00:00:00 2001 From: richard Date: Tue, 23 Mar 2004 08:39:44 +0000 Subject: [PATCH] *** empty log message *** git-svn-id: http://svn.roundup-tracker.org/svnroot/roundup/trunk@2167 57a73879-2fb5-44c3-a270-3262357dd7e2 --- TODO.txt | 9 +++++---- roundup/backends/back_mysql.py | 10 ++++++++++ 2 files changed, 15 insertions(+), 4 deletions(-) diff --git a/TODO.txt b/TODO.txt index a962ce7..218f88e 100644 --- a/TODO.txt +++ b/TODO.txt @@ -1,9 +1,10 @@ This file has been re-purposed to contain specifically the items that need doing before the next release: -- have rdbms backends look up the journal for actor if it's not set -- migrate rdbms backends to use typed columns -- migrate to numeric ID values (fixes bug 817217) - +- finish mysql version 1 -> version 2 migration code - ensure index creation is triggered by the version 1->2 update (and other upgrade tests) + +Optionally: +- have rdbms backends look up the journal for actor if it's not set +- migrate to numeric ID values (fixes bug 817217) diff --git a/roundup/backends/back_mysql.py b/roundup/backends/back_mysql.py index d5e5edc..6aa3a63 100644 --- a/roundup/backends/back_mysql.py +++ b/roundup/backends/back_mysql.py @@ -111,6 +111,16 @@ class Database(Database): mysql_backend = 'InnoDB' #mysql_backend = 'BDB' + hyperdb_to_sql_datatypes = { + hyperdb.String : 'VARCHAR(255)', + hyperdb.Date : 'DATETIME', + hyperdb.Link : 'INTEGER', + hyperdb.Interval : 'VARCHAR(255)', + hyperdb.Password : 'VARCHAR(255)', + hyperdb.Boolean : 'INTEGER', + hyperdb.Number : 'REAL', + } + hyperdb_to_sql_value = { hyperdb.String : str, # no fractional seconds for MySQL -- 2.30.2