[schema] restore constraint checking when running on old sqlite
Old sqlite3 doesn't provide CHECK constraint names in error messages,
preventing us from translating a backend integrity error into a
ValidationError. This was added in 2012, but the sqlite3 version in
RHEL6 is older; so if we run on old sqlite, keep checking the
constraints in python rather than only in SQL.
Closes #10927494
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 or entity.type not in fsschema:
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")