diff roundup/backends/back_mysql.py @ 5067:e424987d294a

Add support for an integer type to join the existing number type. Commit patch supplied for issue2550886. This can be used for properties used for ordering, counts etc. where a decimal point isn't needed. Developed by Anthony (antmail). Doc updates written by John Rouillard.
author John Rouillard <rouilj@ieee.org>
date Sun, 05 Jun 2016 00:17:26 -0400
parents 05c857e5dbed
children 04a8022ae0de
line wrap: on
line diff
--- a/roundup/backends/back_mysql.py	Tue May 31 09:16:09 2016 +0200
+++ b/roundup/backends/back_mysql.py	Sun Jun 05 00:17:26 2016 -0400
@@ -129,6 +129,7 @@
         hyperdb.Password  : 'VARCHAR(255)',
         hyperdb.Boolean   : 'BOOL',
         hyperdb.Number    : 'REAL',
+        hyperdb.Integer   : 'INTEGER',
     }
 
     hyperdb_to_sql_value = {
@@ -140,6 +141,7 @@
         hyperdb.Password  : str,
         hyperdb.Boolean   : int,
         hyperdb.Number    : lambda x: x,
+        hyperdb.Integer   : int,
         hyperdb.Multilink : lambda x: x,    # used in journal marshalling
     }
 
@@ -299,6 +301,8 @@
                         v = date.Interval(v)
                     elif isinstance(prop, Password) and v is not None:
                         v = password.Password(encrypted=v)
+                    elif isinstance(prop, Integer) and v is not None:
+                        v = int(v)
                     elif (isinstance(prop, Boolean) or
                             isinstance(prop, Number)) and v is not None:
                         v = float(v)

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