{"action":"created","issue":{"url":"https://api.github.com/repos/duckduckgo/community-platform/issues/1249","repository_url":"https://api.github.com/repos/duckduckgo/community-platform","labels_url":"https://api.github.com/repos/duckduckgo/community-platform/issues/1249/labels{/name}","comments_url":"https://api.github.com/repos/duckduckgo/community-platform/issues/1249/comments","events_url":"https://api.github.com/repos/duckduckgo/community-platform/issues/1249/events","html_url":"https://github.com/duckduckgo/community-platform/pull/1249","id":136879546,"number":1249,"title":"Contributor Database for Engagement Testing","user":{"login":"alohaas","id":4480279,"avatar_url":"https://avatars.githubusercontent.com/u/4480279?v=3","gravatar_id":"","url":"https://api.github.com/users/alohaas","html_url":"https://github.com/alohaas","followers_url":"https://api.github.com/users/alohaas/followers","following_url":"https://api.github.com/users/alohaas/following{/other_user}","gists_url":"https://api.github.com/users/alohaas/gists{/gist_id}","starred_url":"https://api.github.com/users/alohaas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alohaas/subscriptions","organizations_url":"https://api.github.com/users/alohaas/orgs","repos_url":"https://api.github.com/users/alohaas/repos","events_url":"https://api.github.com/users/alohaas/events{/privacy}","received_events_url":"https://api.github.com/users/alohaas/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"kablamo","id":104742,"avatar_url":"https://avatars.githubusercontent.com/u/104742?v=3","gravatar_id":"","url":"https://api.github.com/users/kablamo","html_url":"https://github.com/kablamo","followers_url":"https://api.github.com/users/kablamo/followers","following_url":"https://api.github.com/users/kablamo/following{/other_user}","gists_url":"https://api.github.com/users/kablamo/gists{/gist_id}","starred_url":"https://api.github.com/users/kablamo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kablamo/subscriptions","organizations_url":"https://api.github.com/users/kablamo/orgs","repos_url":"https://api.github.com/users/kablamo/repos","events_url":"https://api.github.com/users/kablamo/events{/privacy}","received_events_url":"https://api.github.com/users/kablamo/received_events","type":"User","site_admin":false},"milestone":null,"comments":13,"created_at":"2016-02-27T05:00:41Z","updated_at":"2016-03-22T15:32:21Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/duckduckgo/community-platform/pulls/1249","html_url":"https://github.com/duckduckgo/community-platform/pull/1249","diff_url":"https://github.com/duckduckgo/community-platform/pull/1249.diff","patch_url":"https://github.com/duckduckgo/community-platform/pull/1249.patch"},"body":"### Overview: \r\nThis PR is a first pass at consolidating engagement-test-relevant (sorry for that elaborate compound word :v:) data from GitHub commits, pull requests, issues, and comments into the `github_event` table.\r\n\r\n### Notes:\r\n- I've added the `update_github_event_from_data` subroutine to the `GitHub.pm` module in DDGC. It selectively inserts data from it's parent sub into the `github_event` table.\r\n- GitHub commits have SHAs as unique identifiers, which are alpha-numeric strings; other GitHub events have unique integer ids. Because the event's user and date are the most important for our tests now, I've chosen to consolidate the unique identifies as `text` values for the `github_id` key, accommodating both SHAs and numeric ids.\r\n\r\n### Issues, Considerations, and Next Steps:\r\n- This implementation does not account for events prior to the last repo events already in the database. \r\n- I'm recording one date for each event now – the creation date. Should non-creation dates be recorded ( PR merges, issue assignments, and issue closures) as individual events?\r\n- Please excuse my perl etc. :grin: \r\n\r\ncc: @russellholt @zachthompson @kablamo @zekiel "},"comment":{"url":"https://api.github.com/repos/duckduckgo/community-platform/issues/comments/199868075","html_url":"https://github.com/duckduckgo/community-platform/pull/1249#issuecomment-199868075","issue_url":"https://api.github.com/repos/duckduckgo/community-platform/issues/1249","id":199868075,"user":{"login":"zachthompson","id":1467466,"avatar_url":"https://avatars.githubusercontent.com/u/1467466?v=3","gravatar_id":"","url":"https://api.github.com/users/zachthompson","html_url":"https://github.com/zachthompson","followers_url":"https://api.github.com/users/zachthompson/followers","following_url":"https://api.github.com/users/zachthompson/following{/other_user}","gists_url":"https://api.github.com/users/zachthompson/gists{/gist_id}","starred_url":"https://api.github.com/users/zachthompson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zachthompson/subscriptions","organizations_url":"https://api.github.com/users/zachthompson/orgs","repos_url":"https://api.github.com/users/zachthompson/repos","events_url":"https://api.github.com/users/zachthompson/events{/privacy}","received_events_url":"https://api.github.com/users/zachthompson/received_events","type":"User","site_admin":false},"created_at":"2016-03-22T15:32:21Z","updated_at":"2016-03-22T15:32:21Z","body":"Were [access_token and users_id](https://github.com/duckduckgo/community-platform/blob/alohaas/contrib_data/lib/DDGC/DB/Result/GitHub/User.pm#L27-L28) recently removed from `github_user`?  I don't see them in master and they cause failures when trying to run this."}}