Comment 2 for bug 1904880

Getting the results in bulk by dowloading autopkgtest.db and working from that seem to be viable.

autopkgtest.db seem to be refreshed in every ~15 minutes. Can we make it every 5 minutes maybe in per-release filtered scheme?

$ while curl -s -v -X HEAD http://autopkgtest.ubuntu.com/static/autopkgtest.db 2>&1 | grep -m 1 '^< Last-Modified:' ; do sleep 30; done
< Last-Modified: Thu, 28 Jan 2021 14:06:42 GMT
< Last-Modified: Thu, 28 Jan 2021 14:06:42 GMT
< Last-Modified: Thu, 28 Jan 2021 14:20:21 GMT

The data in the .db is a few minutes old:

$ sqlite3 autopkgtest.db
SQLite version 3.31.1 2020-01-27 19:55:54
Enter ".help" for usage hints.
sqlite> select run_id FROM result WHERE run_id > '20210127' ORDER BY run_id DESC LIMIT 1;
20210128_141721_baa3a@

A few minutes should be enough to do the rest of the processin, so if autopkgtest.db can be exported in every ~5 minutes the Britney run can finish in ~10 minutes after the last test affecting the run finished.

I'm proceeding with implementing using autopkgtest.db in Britney.