SP/web2py/gluon/packages/dal/pydal/representers/informix.py

25 lines
881 B
Python
Raw Permalink Normal View History

2018-10-25 15:33:07 +00:00
import datetime
from ..adapters.informix import Informix
from .base import SQLRepresenter
from . import representers
@representers.register_for(Informix)
class InformixRepresenter(SQLRepresenter):
def exceptions(self, obj, field_type):
if field_type == 'date':
if isinstance(obj, (datetime.date, datetime.datetime)):
obj = obj.isoformat()[:10]
else:
obj = str(obj)
return "to_date('%s','%%Y-%%m-%%d')" % obj
elif field_type == 'datetime':
if isinstance(obj, datetime.datetime):
obj = obj.isoformat()[:19].replace('T', ' ')
elif isinstance(obj, datetime.date):
obj = obj.isoformat()[:10]+' 00:00:00'
else:
obj = str(obj)
return "to_date('%s','%%Y-%%m-%%d %%H:%%M:%%S')" % obj
return None