[SQL-CVS] r4691 - SQLObject/trunk/sqlobject

[<sub...@co...>]

Author: phd
Date: Tue Dec 24 05:31:56 2013
New Revision: 4691

Log:
Fixed a bug: zero-pad microseconds at the left to exactly 6 chars

Modified:
   SQLObject/trunk/sqlobject/col.py

Modified: SQLObject/trunk/sqlobject/col.py
==============================================================================
--- SQLObject/trunk/sqlobject/col.py	Fri Dec 20 06:45:19 2013	(r4690)
+++ SQLObject/trunk/sqlobject/col.py	Tue Dec 24 05:31:56 2013	(r4691)
@@ -1104,8 +1104,12 @@
                 if '.' in value:
                     _value = value.split('.')
                     microseconds = _value[-1]
-                    if len(microseconds) > 6:
+                    _l = len(microseconds)
+                    if _l < 6:
+                        _value[-1] = '%06d' % int(microseconds)
+                    if _l > 6:
                         _value[-1] = microseconds[:6]
+                    if _l != 6:
                         value = '.'.join(_value)
                 else:
                     value += '.0'
@@ -1147,8 +1151,12 @@
                     if '.' in value:
                         _value = value.split('.')
                         microseconds = _value[-1]
-                        if len(microseconds) > 6:
+                        _l = len(microseconds)
+                        if _l < 6:
+                            _value[-1] = '%06d' % int(microseconds)
+                        if _l > 6:
                             _value[-1] = microseconds[:6]
+                        if _l != 6:
                             value = '.'.join(_value)
                     else:
                         value += '.0'