[schema] Use TZDatetime for creation_date and modification_date
No work has been done for form fields/widgets since creation_date /
modification_date are by default not editable through the default UI. One may
want to add such feature at some point.
Time will be displayed as UTC, let the end-application decide otherwise by
customizing the tzdatetime printer if desired.
Closes #4848923
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")