306:edefddec933d
Anton Shestakov <av6@dwimlabs.net>, Sun, 24 Sep 2017 12:25:05 +0800
viewer: use subqueries to get data on index page Before, there were bare columns in the aggregate query, their values were undefined (but it somehow worked), as SQLite docs say. Good news is that now this bigger query uses (project_id, ordinal) index and is really fast.

previous change 150:498f984cd1ef

candolint/utils.py

Permissions: -rw-r--r--

Other formats: Feeds:
from __future__ import absolute_import
from datetime import datetime
from os.path import abspath, dirname, join
def rel(*parts):
return abspath(join(dirname(dirname(__file__)), *parts))
def timestamp():
return datetime.utcnow().strftime('%Y-%m-%dT%H:%M:%S+00:00')
def parse_timestamp(value):
return datetime.strptime(value, '%Y-%m-%dT%H:%M:%S+00:00')
def lookup_option(key, args, config, default=None):
argskey = key.replace('-', '_')
if hasattr(args, argskey):
return getattr(args, argskey)
return config.get(key, default)