[GHP] Include GitHub events linked to references

[elanzini]

Example

GH issue: issue
PR that mentions it: pr

Problem

The output of API v3 cannot point to the PR.
One possible alternative would be to check if it is possible to perform this using the API v4.

To note: it is important to verify that the PR that mentions it is merged

[elanzini]

This GraphQL query allows to do so:

query {
  repository(owner: "uclouvain", name: "openjpeg") {
    issue(number: 1044) {
      timelineItems(first: 100) {
        nodes {
          ... on ClosedEvent {
            closer {
              ... on PullRequest {
                number
                title
              }
            }
          }
        }
      }
    }
  }
}

Output is:

{
  "data": {
    "repository": {
      "issue": {
        "timelineItems": {
          "nodes": [
            {},
            {},
            {},
            {},
            {},
            {
              "closer": {
                "number": 1160,
                "title": "jp3d/jpwl convert: fix write stack buffer overflow"
              }
            },
            {},
            {}
          ]
        }
      }
    }
  }
}

[elanzini]

It is also possible that the PR is mentioned in the issue as a comment and is not linked to it.
Example: NVD
Issue: 11803

Check here

[elanzini]

We might also want to include the commit where the issue was closed.
Example: hapijs/subtext#72
Commit: hapijs/subtext@1e2aed6

Query:

query {
  repository(owner: "hapijs", name: "subtext") {
    issue(number: 72) {
      timelineItems(first: 100) {
        nodes {
          ... on ClosedEvent {
            closer {
              ... on Commit {
                commitUrl
              }
            }
          }
        }
      }
    }
  }
}

Returns:

{
  "data": {
    "repository": {
      "issue": {
        "timelineItems": {
          "nodes": [
            {},
            {},
            {},
            {
              "closer": {
                "commitUrl": "https://github.com/hapijs/subtext/commit/1e2aed64b7154e1786d866a3b5bdd4f36e9f492d"
              }
            },
            {},
            {}
          ]
        }
      }
    }
  }
}

[elanzini]

Add commits that reference issues:
Example: expressjs/serve-static#26

Query:

query {
  repository(owner: "expressjs", name: "serve-static") {
    issue(number: 26) {
      timelineItems(first: 100) {
        nodes {
          ... on ReferencedEvent {
            commit {
              commitUrl
            }
          }
        }
      }
    }
  }
}

Result:

{
  "data": {
    "repository": {
      "issue": {
        "timelineItems": {
          "nodes": [
            {},
            {},
            {},
            {},
            {},
            {},
            {},
            {},
            {},
            {},
            {},
            {},
            {},
            {},
            {},
            {
              "commit": {
                "commitUrl": "https://github.com/expressjs/serve-static/commit/1bb77964849f82bd9276de30259e9546c6f84e8f"
              }
            },
            {
              "commit": {
                "commitUrl": "https://github.com/expressjs/serve-static/commit/512a4f48e432052998d5165918c50c2cdafade5f"
              }
            },
            {
              "commit": {
                "commitUrl": "https://github.com/hakatashi/kaerema-10/commit/be0135f42aeaafaaea38798a53dec2fbe344f81b"
              }
            },
            {},
            {}
          ]
        }
      }
    }
  }
}

[elanzini]

Add commits referenced in the comments of the issue:
Example: uclouvain/openjpeg#1126

Possible ugly solution is to retrieve all comments and checks for links to commits and/or prs into the content of each:

query {
  repository(owner: "uclouvain", name: "openjpeg") {
    issue(number: 1126) {
      timelineItems(first: 100) {
        nodes {
          ... on IssueComment {
            author {
              login
            }
            body
          }
        }
      }
    }
  }
}