[SQL-CVS] SQLObject/SQLObject Converters.py,1.2,1.3

[<ian...@us...>]

Update of /cvsroot/sqlobject/SQLObject/SQLObject
In directory sc8-pr-cvs1:/tmp/cvs-serv28122/SQLObject

Modified Files:
	Converters.py 
Log Message:
Added struct_time and datetime converter support


Index: Converters.py
===================================================================
RCS file: /cvsroot/sqlobject/SQLObject/SQLObject/Converters.py,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** Converters.py	1 Aug 2003 01:30:09 -0000	1.2
--- Converters.py	23 Aug 2003 18:12:43 -0000	1.3
***************
*** 11,15 ****
          origISOStr = None
          DateTimeType = None
! 
  from types import InstanceType, ClassType, TypeType
  
--- 11,19 ----
          origISOStr = None
          DateTimeType = None
! import time
! try:
!     import datetime
! except ImportError:
!     datetime = None
  from types import InstanceType, ClassType, TypeType
  
***************
*** 93,96 ****
--- 97,122 ----
  registerConverter(type(()), SequenceConverter)
  registerConverter(type([]), SequenceConverter)
+ 
+ if hasattr(time, 'struct_time'):
+     def StructTimeConverter(value):
+         return time.strftime("'%Y-%m-%d %H:%M:%S'", value)
+ 
+     registerConverter(time.struct_time, StructTimeConverter)
+ 
+ if datetime:
+     def DateTimeConverter(value):
+         return value.strftime("'%Y-%m-%d %H:%M:%s'")
+ 
+     registerConverter(datetime.datetime, DateTimeConverter)
+ 
+     def TimeConverter(value):
+         return value.strftime("'%H:%M:%s'")
+ 
+     registerConverter(datetime.time, TimeConverter)
+ 
+     def DateConverter(value):
+         return value.strftime("'%Y-%m-%d'")
+ 
+     registerConverter(datetime.date, DateConverter)
  
  def sqlRepr(obj):