{"action":"closed","number":16,"pull_request":{"url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/pulls/16","id":83263219,"html_url":"https://github.com/TachyonRSA/PokemonGo-Map/pull/16","diff_url":"https://github.com/TachyonRSA/PokemonGo-Map/pull/16.diff","patch_url":"https://github.com/TachyonRSA/PokemonGo-Map/pull/16.patch","issue_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/issues/16","number":16,"state":"closed","locked":false,"title":"Database update","user":{"login":"TachyonRSA","id":15329326,"avatar_url":"https://avatars.githubusercontent.com/u/15329326?v=3","gravatar_id":"","url":"https://api.github.com/users/TachyonRSA","html_url":"https://github.com/TachyonRSA","followers_url":"https://api.github.com/users/TachyonRSA/followers","following_url":"https://api.github.com/users/TachyonRSA/following{/other_user}","gists_url":"https://api.github.com/users/TachyonRSA/gists{/gist_id}","starred_url":"https://api.github.com/users/TachyonRSA/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TachyonRSA/subscriptions","organizations_url":"https://api.github.com/users/TachyonRSA/orgs","repos_url":"https://api.github.com/users/TachyonRSA/repos","events_url":"https://api.github.com/users/TachyonRSA/events{/privacy}","received_events_url":"https://api.github.com/users/TachyonRSA/received_events","type":"User","site_admin":false},"body":"<!--- Provide a general summary of your changes in the Title above -->\r\n\r\n## Description\r\n<!--- Describe your changes in detail -->\r\nUpdated map to move expired Pokemon over to secondary table.\r\n## Motivation and Context\r\n<!--- Why is this change required? What problem does it solve? -->\r\n<!--- If it fixes an open issue, please link to the issue here. -->\r\nRemoves the load off of the live map to keep query times low.\r\n## How Has This Been Tested?\r\n<!--- Please describe in detail how you tested your changes. -->\r\n<!--- Include details of your testing environment, and the tests you ran to -->\r\n<!--- see how your change affects other areas of the code, etc. -->\r\nTested in staging for a few hours with no apparent issues.\r\n## Screenshots (if appropriate):\r\n\r\n## Types of changes\r\n<!--- What types of changes does your code introduce? Put an `x` in all the boxes that apply: -->\r\n- [ ] Bug fix (non-breaking change which fixes an issue)\r\n- [x] New feature (non-breaking change which adds functionality)\r\n- [ ] Breaking change (fix or feature that would cause existing functionality to change)\r\n\r\n## Checklist:\r\n<!--- Go over all the following points, and put an `x` in all the boxes that apply. -->\r\n<!--- If you're unsure about any of these, don't hesitate to ask. We're here to help! -->\r\n- [x] My code follows the code style of this project.\r\n- [ ] My change requires a change to the documentation.\r\n- [ ] I have updated the documentation accordingly.\r\n","created_at":"2016-08-30T12:38:55Z","updated_at":"2016-08-30T16:58:52Z","closed_at":"2016-08-30T16:58:52Z","merged_at":"2016-08-30T16:58:51Z","merge_commit_sha":"f98335a4f75ad80b0177f1112921c98121f4b724","assignee":{"login":"TachyonRSA","id":15329326,"avatar_url":"https://avatars.githubusercontent.com/u/15329326?v=3","gravatar_id":"","url":"https://api.github.com/users/TachyonRSA","html_url":"https://github.com/TachyonRSA","followers_url":"https://api.github.com/users/TachyonRSA/followers","following_url":"https://api.github.com/users/TachyonRSA/following{/other_user}","gists_url":"https://api.github.com/users/TachyonRSA/gists{/gist_id}","starred_url":"https://api.github.com/users/TachyonRSA/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TachyonRSA/subscriptions","organizations_url":"https://api.github.com/users/TachyonRSA/orgs","repos_url":"https://api.github.com/users/TachyonRSA/repos","events_url":"https://api.github.com/users/TachyonRSA/events{/privacy}","received_events_url":"https://api.github.com/users/TachyonRSA/received_events","type":"User","site_admin":false},"assignees":[{"login":"TachyonRSA","id":15329326,"avatar_url":"https://avatars.githubusercontent.com/u/15329326?v=3","gravatar_id":"","url":"https://api.github.com/users/TachyonRSA","html_url":"https://github.com/TachyonRSA","followers_url":"https://api.github.com/users/TachyonRSA/followers","following_url":"https://api.github.com/users/TachyonRSA/following{/other_user}","gists_url":"https://api.github.com/users/TachyonRSA/gists{/gist_id}","starred_url":"https://api.github.com/users/TachyonRSA/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TachyonRSA/subscriptions","organizations_url":"https://api.github.com/users/TachyonRSA/orgs","repos_url":"https://api.github.com/users/TachyonRSA/repos","events_url":"https://api.github.com/users/TachyonRSA/events{/privacy}","received_events_url":"https://api.github.com/users/TachyonRSA/received_events","type":"User","site_admin":false}],"milestone":null,"commits_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/pulls/16/commits","review_comments_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/pulls/16/comments","review_comment_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/pulls/comments{/number}","comments_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/issues/16/comments","statuses_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/statuses/35f5253929211f094ca6c831c76cc508a5370eba","head":{"label":"TachyonRSA:databaseUpdate","ref":"databaseUpdate","sha":"35f5253929211f094ca6c831c76cc508a5370eba","user":{"login":"TachyonRSA","id":15329326,"avatar_url":"https://avatars.githubusercontent.com/u/15329326?v=3","gravatar_id":"","url":"https://api.github.com/users/TachyonRSA","html_url":"https://github.com/TachyonRSA","followers_url":"https://api.github.com/users/TachyonRSA/followers","following_url":"https://api.github.com/users/TachyonRSA/following{/other_user}","gists_url":"https://api.github.com/users/TachyonRSA/gists{/gist_id}","starred_url":"https://api.github.com/users/TachyonRSA/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TachyonRSA/subscriptions","organizations_url":"https://api.github.com/users/TachyonRSA/orgs","repos_url":"https://api.github.com/users/TachyonRSA/repos","events_url":"https://api.github.com/users/TachyonRSA/events{/privacy}","received_events_url":"https://api.github.com/users/TachyonRSA/received_events","type":"User","site_admin":false},"repo":{"id":66707196,"name":"PokemonGo-Map","full_name":"TachyonRSA/PokemonGo-Map","owner":{"login":"TachyonRSA","id":15329326,"avatar_url":"https://avatars.githubusercontent.com/u/15329326?v=3","gravatar_id":"","url":"https://api.github.com/users/TachyonRSA","html_url":"https://github.com/TachyonRSA","followers_url":"https://api.github.com/users/TachyonRSA/followers","following_url":"https://api.github.com/users/TachyonRSA/following{/other_user}","gists_url":"https://api.github.com/users/TachyonRSA/gists{/gist_id}","starred_url":"https://api.github.com/users/TachyonRSA/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TachyonRSA/subscriptions","organizations_url":"https://api.github.com/users/TachyonRSA/orgs","repos_url":"https://api.github.com/users/TachyonRSA/repos","events_url":"https://api.github.com/users/TachyonRSA/events{/privacy}","received_events_url":"https://api.github.com/users/TachyonRSA/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/TachyonRSA/PokemonGo-Map","description":"🌏 Live visualization of all the pokemon in your area... and more!","fork":true,"url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map","forks_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/forks","keys_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/keys{/key_id}","collaborators_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/teams","hooks_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/hooks","issue_events_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/issues/events{/number}","events_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/events","assignees_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/assignees{/user}","branches_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/branches{/branch}","tags_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/tags","blobs_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/git/refs{/sha}","trees_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/git/trees{/sha}","statuses_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/statuses/{sha}","languages_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/languages","stargazers_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/stargazers","contributors_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/contributors","subscribers_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/subscribers","subscription_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/subscription","commits_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/commits{/sha}","git_commits_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/git/commits{/sha}","comments_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/comments{/number}","issue_comment_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/issues/comments{/number}","contents_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/contents/{+path}","compare_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/compare/{base}...{head}","merges_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/merges","archive_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/downloads","issues_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/issues{/number}","pulls_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/pulls{/number}","milestones_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/milestones{/number}","notifications_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/labels{/name}","releases_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/releases{/id}","deployments_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/deployments","created_at":"2016-08-27T09:39:41Z","updated_at":"2016-08-27T09:39:42Z","pushed_at":"2016-08-30T16:58:51Z","git_url":"git://github.com/TachyonRSA/PokemonGo-Map.git","ssh_url":"git@github.com:TachyonRSA/PokemonGo-Map.git","clone_url":"https://github.com/TachyonRSA/PokemonGo-Map.git","svn_url":"https://github.com/TachyonRSA/PokemonGo-Map","homepage":"","size":23756,"stargazers_count":0,"watchers_count":0,"language":"Python","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":2,"forks":0,"open_issues":2,"watchers":0,"default_branch":"develop"}},"base":{"label":"TachyonRSA:develop","ref":"develop","sha":"7724c29dff157f78ced343ed20c454eab9ab0747","user":{"login":"TachyonRSA","id":15329326,"avatar_url":"https://avatars.githubusercontent.com/u/15329326?v=3","gravatar_id":"","url":"https://api.github.com/users/TachyonRSA","html_url":"https://github.com/TachyonRSA","followers_url":"https://api.github.com/users/TachyonRSA/followers","following_url":"https://api.github.com/users/TachyonRSA/following{/other_user}","gists_url":"https://api.github.com/users/TachyonRSA/gists{/gist_id}","starred_url":"https://api.github.com/users/TachyonRSA/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TachyonRSA/subscriptions","organizations_url":"https://api.github.com/users/TachyonRSA/orgs","repos_url":"https://api.github.com/users/TachyonRSA/repos","events_url":"https://api.github.com/users/TachyonRSA/events{/privacy}","received_events_url":"https://api.github.com/users/TachyonRSA/received_events","type":"User","site_admin":false},"repo":{"id":66707196,"name":"PokemonGo-Map","full_name":"TachyonRSA/PokemonGo-Map","owner":{"login":"TachyonRSA","id":15329326,"avatar_url":"https://avatars.githubusercontent.com/u/15329326?v=3","gravatar_id":"","url":"https://api.github.com/users/TachyonRSA","html_url":"https://github.com/TachyonRSA","followers_url":"https://api.github.com/users/TachyonRSA/followers","following_url":"https://api.github.com/users/TachyonRSA/following{/other_user}","gists_url":"https://api.github.com/users/TachyonRSA/gists{/gist_id}","starred_url":"https://api.github.com/users/TachyonRSA/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TachyonRSA/subscriptions","organizations_url":"https://api.github.com/users/TachyonRSA/orgs","repos_url":"https://api.github.com/users/TachyonRSA/repos","events_url":"https://api.github.com/users/TachyonRSA/events{/privacy}","received_events_url":"https://api.github.com/users/TachyonRSA/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/TachyonRSA/PokemonGo-Map","description":"🌏 Live visualization of all the pokemon in your area... and more!","fork":true,"url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map","forks_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/forks","keys_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/keys{/key_id}","collaborators_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/teams","hooks_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/hooks","issue_events_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/issues/events{/number}","events_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/events","assignees_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/assignees{/user}","branches_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/branches{/branch}","tags_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/tags","blobs_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/git/refs{/sha}","trees_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/git/trees{/sha}","statuses_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/statuses/{sha}","languages_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/languages","stargazers_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/stargazers","contributors_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/contributors","subscribers_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/subscribers","subscription_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/subscription","commits_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/commits{/sha}","git_commits_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/git/commits{/sha}","comments_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/comments{/number}","issue_comment_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/issues/comments{/number}","contents_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/contents/{+path}","compare_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/compare/{base}...{head}","merges_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/merges","archive_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/downloads","issues_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/issues{/number}","pulls_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/pulls{/number}","milestones_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/milestones{/number}","notifications_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/labels{/name}","releases_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/releases{/id}","deployments_url":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/deployments","created_at":"2016-08-27T09:39:41Z","updated_at":"2016-08-27T09:39:42Z","pushed_at":"2016-08-30T16:58:51Z","git_url":"git://github.com/TachyonRSA/PokemonGo-Map.git","ssh_url":"git@github.com:TachyonRSA/PokemonGo-Map.git","clone_url":"https://github.com/TachyonRSA/PokemonGo-Map.git","svn_url":"https://github.com/TachyonRSA/PokemonGo-Map","homepage":"","size":23756,"stargazers_count":0,"watchers_count":0,"language":"Python","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":2,"forks":0,"open_issues":2,"watchers":0,"default_branch":"develop"}},"_links":{"self":{"href":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/pulls/16"},"html":{"href":"https://github.com/TachyonRSA/PokemonGo-Map/pull/16"},"issue":{"href":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/issues/16"},"comments":{"href":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/issues/16/comments"},"review_comments":{"href":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/pulls/16/comments"},"review_comment":{"href":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/pulls/16/commits"},"statuses":{"href":"https://api.github.com/repos/TachyonRSA/PokemonGo-Map/statuses/35f5253929211f094ca6c831c76cc508a5370eba"}},"merged":true,"mergeable":null,"mergeable_state":"unknown","merged_by":{"login":"TachyonRSA","id":15329326,"avatar_url":"https://avatars.githubusercontent.com/u/15329326?v=3","gravatar_id":"","url":"https://api.github.com/users/TachyonRSA","html_url":"https://github.com/TachyonRSA","followers_url":"https://api.github.com/users/TachyonRSA/followers","following_url":"https://api.github.com/users/TachyonRSA/following{/other_user}","gists_url":"https://api.github.com/users/TachyonRSA/gists{/gist_id}","starred_url":"https://api.github.com/users/TachyonRSA/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TachyonRSA/subscriptions","organizations_url":"https://api.github.com/users/TachyonRSA/orgs","repos_url":"https://api.github.com/users/TachyonRSA/repos","events_url":"https://api.github.com/users/TachyonRSA/events{/privacy}","received_events_url":"https://api.github.com/users/TachyonRSA/received_events","type":"User","site_admin":false},"comments":0,"review_comments":0,"commits":20,"additions":94,"deletions":68,"changed_files":2}}
{"actor":{"display_login":"TachyonRSA"}}