[server] improve TZDatetime support
by depending on logilab-database 1.15.0 including
https://www.logilab.org/ticket/1485893, we can now keep the tzinfo
attribute on datetime objects for TZDatetime attributes, so one knows
that this is a tz-aware datetime.
To easily make it work with backends that have no tz support, we keep
converting tz-aware datetime objects into utc naive datetime objects
before sending them to the database.
if confirm('use Europe/Paris as timezone?'):
timezone = 'Europe/Paris'
else:
import pytz
while True:
timezone = raw_input('enter your timezone')
if timezone in pytz.common_timezones:
break
dbdriver = repo.system_source.dbdriver
if dbdriver == 'postgres':
sql("SET TIME ZONE '%s'" % timezone)
for entity in schema.entities():
if entity.final:
continue
change_attribute_type(entity.type, 'creation_date', 'TZDatetime', ask_confirm=False)
change_attribute_type(entity.type, 'modification_date', 'TZDatetime', ask_confirm=False)
if dbdriver == 'postgres':
sql("SET TIME ZONE UTC")