* src/schema.sql: Put all indexes together.

* doc/cuirass.texi (Database schema): Document the BuildDependencies table.

* src/cuirass/database.scm (db-get-build-percentages): Do not consider
failed-dependency builds that have zero build durations.

* src/cuirass/scripts/remote-worker.scm (remote-worker): Create the GC root directory.

* TODO: Remove items that have been implemented.

* src/cuirass/http.scm (url-handler): Turn the "/jobset/spec/badge" route into
"/jobet/spec/badge.svg" route.
* doc/cuirass.texi (Badges): Adapt it.

* src/static/images/badge-per.svg: Rename it ...
* src/static/images/badge-percentage.svg: ... into this.
* src/static/images/badge-spec-percentage.svg: New file.
* Makefile.am (dist_images_DATA): Adapt it.
* src/cuirass/http.scm (url-handler): Add badge type support.
* src/cuirass/templates.scm (badge-svg): Add type parameter.
* doc/cuirass.texi (Badges): Document it.

* src/cuirass/templates.scm (badge-svg): Add a spec argument.
* src/cuirass/http.scm (url-handler): Pass it.
* src/static/images/badge-per.svg: Update it.

* src/cuirass/scripts/remote-server.scm (run-fetch): Print a message if the
fetch call took more than 60 seconds to complete.

* src/cuirass/scripts/remote-server.scm (%fetch-queue-size): New variable.
(atomic-box-fetch-and-update!, atomic-box-fetch-and-inc!,
atomic-box-fetch-and-dec!): New procedures.
(zmq-start-proxy): Increment the fetch queue size.
(start-fetch-worker): Decrement it.
(start-periodic-updates-thread): Display it.

* src/cuirass/base.scm (call-with-time-display): Remove it.

* src/cuirass/base.scm (call-with-time): Move it to ...
* src/cuirass/utils.scm: ... here.

* src/cuirass/scripts/remote-server.scm (%fetch-workers): New variable.
(cuirass-remote-server): Start 8 fetch workers.

* tests/database.scm ("dependencies trigger"): Call db-update-failed-builds!
procedure.

The build_dependencies trigger scales really poorly when there is a large
number of pending builds. Remove this trigger and replace it with a
periodical update thread.

* src/sql/upgrade-12.sql: New file.
* Makefile.am (dist_sql_DATA): Add it.
* src/schema.sql (update_build_dependencies, build_dependencies): Remove them.
* src/cuirass/database.scm (db-update-resumable-builds!): New procedure.
* src/cuirass/scripts/remote-server.scm (start-periodic-updates-thread): New
procedure.
(remote-server): Call it.

* src/cuirass/database.scm (db-get-latest-evaluation): Return false when no
evaluation is found.
* src/cuirass/http.scm (url-handler): Adapt it.

* src/static/images/badge-running.svg: Remove it.
* Makefile.am (dist_images_DATA): Ditto.
* src/cuirass/database.scm (db-get-latest-evaluation,
db-get-evaluation-absolute-summary): New procedures.
* src/cuirass/http.scm (url-handler): Fix badge display.
* src/cuirass/templates.scm (badge-svg): Adapt it.
* tests/database.scm ("db-get-evaluation-absolute-summary",
"db-get-latest-evaluation"): New tests.
* doc/cuirass.texi (Badges): Adapt it.

* src/cuirass/templates.scm (build-details): Fix dependencies display.

* src/cuirass/base.scm (default-gc-root-directory): New procedure.
(%gc-root-directory): Use it.
* src/cuirass/scripts/remote-server.scm (remote-server): Reset the GC root
directory once the user privileges have been gathered.

* src/static/images/badge-error.svg: New file.
* src/static/images/badge-per.svg: New file.
* src/static/images/badge-running.svg: New file.
* Makefile.am (dist_images_DATA): Add them.
* src/cuirass/templates.scm (badge-svg): New procedure.
* src/cuirass/http.scm (badge-string): New procedure.
(url-handler): Add a new "/jobset/spec/badge" route.
* doc/cuirass.texi (Badges): New section.

* src/cuirass/database.scm (db-get-evaluations): Add an optional spec
parameter an honor it.
* src/cuirass/http.scm (url-handler): Add an optional spec parameter to the
/api/evaluations route and pass it to the db-get-evaluations procedure.
* doc/cuirass.texi (Web API): Document it.

* src/cuirass/templates.scm (build-details): Print an underscore when there
are no dependencies.

* src/cuirass/base.scm (register-gc-roots): Add a mode argument to register
the derivation outputs or the derivation itself as GC roots.
(build-packages): Register a GC root for each new derivation.

* src/cuirass/scripts/remote-worker.scm (%default-options): Lower the default
TTL to 1d.

Add a TTL argument and use it to register GC roots for the successfully built
items.

* src/cuirass/scripts/remote-server.scm (show-help): Add a TTL argument.
(%options): Ditto.
(%default-options): Ditto.
(run-fetch): Register GC roots for the successfully built derivation outputs.
(remote-server): Add a TTL argument.

* src/sql/upgrade-11.sql: Add missing table.

* src/cuirass/database.scm (db-register-builds): Return true.

* src/schema.sql (BuildDependencies): New table.
* src/sql/upgrade-11.sql: New file.
* Makefile.am (dist_sql_DATA): Add it.
* src/cuirass/database.scm (db-add-build-dependencies,
db-get-build-dependencies,
db-update-failed-builds): New procedures.
* src/cuirass/http.scm (http-handler): Pass the build dependencies to the
build-details procedure.
* src/cuirass/scripts/remote-server.scm (pop-build): Select a build with no
dependencies.
(read-worker-exp): Remove the scheduled builds with failed dependencies.
* src/cuirass/templates.scm (build-details): Add a dependencies argument and
use it to display the build dependencies and their status.
* src/static/js/cuirass.js: Animate the dependencies collapse button.
* tests/database.scm ("db-add-build-dependencies",
"db-get-build-dependencies", "dependencies trigger"): New tests.

* src/cuirass/remote.scm (publish-server): Set the publish negative TTL to zero.

Add a TTL argument and use it to register GC roots for the successfully built
items.

* src/cuirass/scripts/remote-worker.scm (show-help): Add a TTL argument.
(%options): Ditto.
(%default-options): Ditto.
(run-build): Register GC roots for the successfully built derivation outputs.
(remote-worker): Add a TTL argument.

Factorize GC root creation in a new register-gc-roots procedure.

* src/cuirass/base.scm (gc-roots): Move it out of handle-build-event
procedure.
(register-gc-roots): New procedure.
(handle-build-event): Use it.

* doc/accessibility-report.pdf: New file.

* src/cuirass/scripts/evaluate.scm (cuirass-evaluate): Fix typo.

* src/cuirass/base.scm (process-specs): Update the specification to include
possible channel dependencies.

* src/cuirass/database.scm (read-sql-file): Return the given SQL file as a
single string.
(db-load): Adapt it.

* src/cuirass/http.scm (body->specification): Fix custom build type
edition.
* src/cuirass/templates.scm (specification-edit): Ditto.
* src/static/js/cuirass.js: Ditto.

* src/cuirass/http.scm (uri-handler): Remove the old doctype.
* src/cuirass/templates.scm (specification-edit): Fix label element
without end tag.

* src/cuirass/database.scm (db-update-build-status!): Remove the Jobs status
update that is now done using a trigger.

* src/sql/upgrade-10.sql: New file.
* Makefile.am (dist_sql_DATA): Update it.
* src/schema.sql (update_job_status): New function,
(build_status): new trigger.

* src/cuirass/database.scm (db-cancel-pending-builds!): Fix query.