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.

/

candolint/ drwxr-xr-x files
dockerfiles/ drwxr-xr-x files
linters/ drwxr-xr-x files
static/ drwxr-xr-x files
templates/ drwxr-xr-x files
tests/ drwxr-xr-x files
.hgignore 56 -rw-r--r-- file | revisions | annotate
LICENSE 1064 -rw-r--r-- file | revisions | annotate
README.rst 4781 -rw-r--r-- file | revisions | annotate
bitbucket-pipelines.yml 402 -rw-r--r-- file | revisions | annotate
candolint.yml 207 -rw-r--r-- file | revisions | annotate
check-in-docker.sh 227 -rwxr-xr-x file | revisions | annotate
check-in-firejail.sh 119 -rwxr-xr-x file | revisions | annotate
checker.profile 551 -rw-r--r-- file | revisions | annotate
checker.py 10118 -rwxr-xr-x file | revisions | annotate
dev-requirements.txt 44 -rw-r--r-- file | revisions | annotate
hooks-queue.py 5441 -rwxr-xr-x file | revisions | annotate
incoming-queue.py 2394 -rwxr-xr-x file | revisions | annotate
incoming.py 5888 -rwxr-xr-x file | revisions | annotate
poller-queue.py 6057 -rwxr-xr-x file | revisions | annotate
requirements.txt 57 -rw-r--r-- file | revisions | annotate
run-tests.py 442 -rwxr-xr-x file | revisions | annotate
setup.cfg 23 -rw-r--r-- file | revisions | annotate
viewer.py 2056 -rwxr-xr-x file | revisions | annotate
worker-queue.py 3128 -rwxr-xr-x file | revisions | annotate