• Home
  • Features
  • Pricing
  • Docs
  • Announcements
  • Sign In

kobotoolbox / kpi / 23344806450
82%
master: 76%

Build:
Build:
LAST BUILD BRANCH: dev-1525-update-environment-endpoint
DEFAULT BRANCH: master
Ran 20 Mar 2026 01:28PM UTC
Jobs 10
Files 885
Run time 2min
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst

20 Mar 2026 01:24PM UTC coverage: 81.783% (+0.01%) from 81.773%
23344806450

push

github

web-flow
perf(openrosa): reduce SQL queries on formList and manifest endpoints DEV-1841 (#6844)

### Summary

The formList, manifest, and related OpenRosa endpoints were making
unnecessary and repeated database queries on every request from a mobile
data collection device.

### Description

Each time a mobile device (e.g. KoboCollect) requested the list of
available forms, the server was doing far more work than needed: loading
massive amounts of data it did not use, repeating the same lookups once
per form, and running extra sort operations that served no purpose.

This fix makes the server load only what it strictly needs and avoids
repeating the same lookups in a loop. On large deployments with many
forms or media files, this translates into noticeably faster responses.

7432 of 11542 branches covered (64.39%)

22 of 57 new or added lines in 5 files covered. (38.6%)

2 existing lines in 2 files now uncovered.

28543 of 34901 relevant lines covered (81.78%)

5.81 hits per line

New Missed Lines in Diff

Lines Coverage ∆ File
1
75.39
-0.27% kobo/apps/openrosa/apps/logger/models/xform.py
1
69.57
5.57% kobo/apps/openrosa/libs/permissions.py
4
59.72
-0.57% kpi/utils/xml.py
5
54.92
-0.92% kobo/apps/openrosa/libs/serializers/xform_serializer.py
24
41.49
-3.1% kobo/apps/openrosa/apps/api/viewsets/xform_list_api.py

Uncovered Existing Lines

Lines Coverage ∆ File
1
41.49
-3.1% kobo/apps/openrosa/apps/api/viewsets/xform_list_api.py
1
69.57
5.57% kobo/apps/openrosa/libs/permissions.py
Jobs
ID Job ID Ran Files Coverage
1 23344806450.1 20 Mar 2026 01:28PM UTC 881
53.26
2 23344806450.2 20 Mar 2026 01:29PM UTC 881
54.75
3 23344806450.3 20 Mar 2026 01:29PM UTC 883
54.52
4 23344806450.4 20 Mar 2026 01:29PM UTC 883
56.04
5 23344806450.5 20 Mar 2026 01:30PM UTC 881
53.58
6 23344806450.6 20 Mar 2026 01:30PM UTC 883
65.41
7 23344806450.7 20 Mar 2026 01:30PM UTC 881
60.5
8 23344806450.8 20 Mar 2026 01:31PM UTC 883
54.97
9 23344806450.9 20 Mar 2026 01:31PM UTC 885
67.71
10 23344806450.10 20 Mar 2026 01:32PM UTC 883
61.66
Source Files on build 23344806450
  • Tree
  • List 885
  • Changed 5
  • Source Changed 0
  • Coverage Changed 5
Coverage ∆ File Lines Relevant Covered Missed Hits/Line Branch Hits Branch Misses
  • Back to Repo
  • caccaef0 on github
  • Prev Build on release/2.026.07 (#23298073259)
  • Next Build on release/2.026.07 (#23346086976)
STATUS · Troubleshooting · Open an Issue · Sales · Support · CAREERS · ENTERPRISE · START FREE · SCHEDULE DEMO
ANNOUNCEMENTS · TWITTER · TOS & SLA · Supported CI Services · What's a CI service? · Automated Testing

© 2026 Coveralls, Inc