Mercurial > p > roundup > code
view website/issues/extensions/timezone.py @ 6917:fba76e0bba98
set journal mode to wal when creating db.
Trying to work around sqlite3.OperationalError: disk I/O error
errors in CI that I can't reproduce locally.
Also this allows reads to happen while writes are occurring.
This should permit using the web interface for browsing while
a large write load (e.g. bulk data loading from another tracker)
is happening. Right now autogenerating issues locks up the tracker
for reading with an error that the database is locked.
| author | John Rouillard <rouilj@ieee.org> |
|---|---|
| date | Tue, 06 Sep 2022 11:32:13 -0400 |
| parents | 7d8e0dbb0852 |
| children |
line wrap: on
line source
# Utility for replacing the simple input field for the timezone with # a select-field that lists the available values. import cgi try: import pytz except ImportError: pytz = None def tzfield(prop, name, default): if pytz: value = prop.plain() if '' == value: value = default else: try: value = "Etc/GMT%+d" % int(value) except ValueError: pass l = ['<select name="%s">' % name] for zone in pytz.all_timezones: s = ' ' if zone == value: s = 'selected=selected ' z = cgi.escape(zone) l.append('<option %svalue="%s">%s</option>' % (s, z, z)) l.append('</select>') return '\n'.join(l) else: return prop.field() def init(instance): instance.registerUtil('tzfield', tzfield)
