Changeset 2953 for pykota/trunk/pykota

Timestamp:

06/20/06 23:01:00 (18 years ago)

Author:

jerome

Message:

Fixed date formatting problems with MySQL.

Location:

pykota/trunk/pykota

Files:

• storage.py (modified) (1 diff)
• storages/ldapstorage.py (modified) (2 diffs)

pykota/trunk/pykota/storage.py

@@ -745 +745 @@
         if start and end and (start > end) :
             (start, end) = (end, start)
+        try :    
+            if len(start) == 17 :
+                start = "%s-%s-%s %s" % (start[0:4], start[4:6], start[6:8], start[9:])
+        except TypeError :        
+            pass
+            
+        try :    
+            if len(end) == 17 :
+                end = "%s-%s-%s %s" % (end[0:4], end[4:6], end[6:8], end[9:])
+        except TypeError :        
+            pass
+            
         return (start, end)    
         

pykota/trunk/pykota/storages/ldapstorage.py

@@ -621 +621 @@
                 date = fields.get("createTimestamp", ["19700101000000Z"])[0] # It's in UTC !
                 mxtime = DateTime.strptime(date[:14], "%Y%m%d%H%M%S").localtime()
-                lastjob.JobDate = mxtime.strftime("%Y%m%d %H:%M:%S")
+                lastjob.JobDate = mxtime.strftime("%Y-%m-%d %H:%M:%S")
                 lastjob.Exists = True
         return lastjob
@@ -1376 +1376 @@
                 date = fields.get("createTimestamp", ["19700101000000Z"])[0] # It's in UTC !
                 mxtime = DateTime.strptime(date[:14], "%Y%m%d%H%M%S").localtime()
-                job.JobDate = mxtime.strftime("%Y%m%d %H:%M:%S")
+                job.JobDate = mxtime.strftime("%Y-%m-%d %H:%M:%S")
                 if ((start is None) and (end is None)) or \
                    ((start is None) and (job.JobDate <= end)) or \