Add CouchDB view to list slots including a MR

In order to display a MR-centric overview of what is being tested in which slot, we need a way to get the slots that include a given MR.

We can use a simple view like this

function (doc) {
  if (doc.type === 'slot-info' && doc.config.projects && Array.isArray(doc.config.projects)) {
    doc.config.projects.forEach(function (project) {
      if (project.checkout_opts && project.checkout_opts.merges && Array.isArray(project.checkout_opts.merges)) {
        project.checkout_opts.merges.forEach(function (merge) {
          emit([project.name, merge[0]], merge);
        });
      }
    });
  }
}

with which we can obtain the slots including a given MR with ?key=["LHCb",2255] and e.g. the slots that include any MR of a project with ?startkey=['Moore',0]&endkey=['Moore',{}])

That gives something like the following. We can think of extending the value if that's useful

assigned to @clemenci and unassigned @rmatev

changed milestone to %2.2.3

I like this a lot.

I'm just worried that a web page showing where all active MRs are tested would be slow due to the many GET requests (one per MR).

I think we can make a single query giving multiple keys, so we can at least get the view values in one go. If we put all we need there it will be fast. Let me think a bit

I can think of these:

• the slot/build (already in the id)
• whether it's completed
• if completed, the time of completion
• if not completed, the time of starting (and maybe some progress)
• if ci-test, the ref build (so we can directly link to the comparison)

badges with results would also be nice but that's probably too much to generate in the view :)

mentioned in merge request !272 (merged)

mentioned in commit 260056f2

closed via merge request !272 (merged)