{"action":"created","comment":{"url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/pulls/comments/35472711","id":35472711,"diff_hunk":"@@ -0,0 +1,13 @@\n+BEGIN;\n+\n+UPDATE users\n+SET language = concat(users.language, '-', users.country);","path":"migrations/1_join_language_country.sql","position":4,"original_position":4,"commit_id":"ed9b0d4f8065aa5888f6a3028d96e1050797a16f","original_commit_id":"ed9b0d4f8065aa5888f6a3028d96e1050797a16f","user":{"login":"secretrobotron","id":403231,"avatar_url":"https://avatars.githubusercontent.com/u/403231?v=3","gravatar_id":"","url":"https://api.github.com/users/secretrobotron","html_url":"https://github.com/secretrobotron","followers_url":"https://api.github.com/users/secretrobotron/followers","following_url":"https://api.github.com/users/secretrobotron/following{/other_user}","gists_url":"https://api.github.com/users/secretrobotron/gists{/gist_id}","starred_url":"https://api.github.com/users/secretrobotron/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/secretrobotron/subscriptions","organizations_url":"https://api.github.com/users/secretrobotron/orgs","repos_url":"https://api.github.com/users/secretrobotron/repos","events_url":"https://api.github.com/users/secretrobotron/events{/privacy}","received_events_url":"https://api.github.com/users/secretrobotron/received_events","type":"User","site_admin":false},"body":"does this explode if you've already migrated?","created_at":"2015-07-24T22:45:40Z","updated_at":"2015-07-24T22:45:40Z","html_url":"https://github.com/secretrobotron/api.webmaker.org/pull/1#discussion_r35472711","pull_request_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/pulls/1","_links":{"self":{"href":"https://api.github.com/repos/secretrobotron/api.webmaker.org/pulls/comments/35472711"},"html":{"href":"https://github.com/secretrobotron/api.webmaker.org/pull/1#discussion_r35472711"},"pull_request":{"href":"https://api.github.com/repos/secretrobotron/api.webmaker.org/pulls/1"}}},"pull_request":{"url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/pulls/1","id":40822633,"html_url":"https://github.com/secretrobotron/api.webmaker.org/pull/1","diff_url":"https://github.com/secretrobotron/api.webmaker.org/pull/1.diff","patch_url":"https://github.com/secretrobotron/api.webmaker.org/pull/1.patch","issue_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/issues/1","number":1,"state":"open","locked":false,"title":"Discovery filter - migration scripts","user":{"login":"cadecairos","id":438003,"avatar_url":"https://avatars.githubusercontent.com/u/438003?v=3","gravatar_id":"","url":"https://api.github.com/users/cadecairos","html_url":"https://github.com/cadecairos","followers_url":"https://api.github.com/users/cadecairos/followers","following_url":"https://api.github.com/users/cadecairos/following{/other_user}","gists_url":"https://api.github.com/users/cadecairos/gists{/gist_id}","starred_url":"https://api.github.com/users/cadecairos/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cadecairos/subscriptions","organizations_url":"https://api.github.com/users/cadecairos/orgs","repos_url":"https://api.github.com/users/cadecairos/repos","events_url":"https://api.github.com/users/cadecairos/events{/privacy}","received_events_url":"https://api.github.com/users/cadecairos/received_events","type":"User","site_admin":false},"body":"","created_at":"2015-07-24T22:43:40Z","updated_at":"2015-07-24T22:45:40Z","closed_at":null,"merged_at":null,"merge_commit_sha":"2bd9b81e812418f78c9c2c03745c9fd4d5dbc705","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/pulls/1/commits","review_comments_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/pulls/1/comments","review_comment_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/pulls/comments{/number}","comments_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/issues/1/comments","statuses_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/statuses/ed9b0d4f8065aa5888f6a3028d96e1050797a16f","head":{"label":"cadecairos:discovery-filter","ref":"discovery-filter","sha":"ed9b0d4f8065aa5888f6a3028d96e1050797a16f","user":{"login":"cadecairos","id":438003,"avatar_url":"https://avatars.githubusercontent.com/u/438003?v=3","gravatar_id":"","url":"https://api.github.com/users/cadecairos","html_url":"https://github.com/cadecairos","followers_url":"https://api.github.com/users/cadecairos/followers","following_url":"https://api.github.com/users/cadecairos/following{/other_user}","gists_url":"https://api.github.com/users/cadecairos/gists{/gist_id}","starred_url":"https://api.github.com/users/cadecairos/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cadecairos/subscriptions","organizations_url":"https://api.github.com/users/cadecairos/orgs","repos_url":"https://api.github.com/users/cadecairos/repos","events_url":"https://api.github.com/users/cadecairos/events{/privacy}","received_events_url":"https://api.github.com/users/cadecairos/received_events","type":"User","site_admin":false},"repo":{"id":34396339,"name":"api.webmaker.org","full_name":"cadecairos/api.webmaker.org","owner":{"login":"cadecairos","id":438003,"avatar_url":"https://avatars.githubusercontent.com/u/438003?v=3","gravatar_id":"","url":"https://api.github.com/users/cadecairos","html_url":"https://github.com/cadecairos","followers_url":"https://api.github.com/users/cadecairos/followers","following_url":"https://api.github.com/users/cadecairos/following{/other_user}","gists_url":"https://api.github.com/users/cadecairos/gists{/gist_id}","starred_url":"https://api.github.com/users/cadecairos/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cadecairos/subscriptions","organizations_url":"https://api.github.com/users/cadecairos/orgs","repos_url":"https://api.github.com/users/cadecairos/repos","events_url":"https://api.github.com/users/cadecairos/events{/privacy}","received_events_url":"https://api.github.com/users/cadecairos/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/cadecairos/api.webmaker.org","description":"Services for Webmaker","fork":true,"url":"https://api.github.com/repos/cadecairos/api.webmaker.org","forks_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/forks","keys_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/keys{/key_id}","collaborators_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/teams","hooks_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/hooks","issue_events_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/issues/events{/number}","events_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/events","assignees_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/assignees{/user}","branches_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/branches{/branch}","tags_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/tags","blobs_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/git/refs{/sha}","trees_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/git/trees{/sha}","statuses_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/statuses/{sha}","languages_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/languages","stargazers_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/stargazers","contributors_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/contributors","subscribers_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/subscribers","subscription_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/subscription","commits_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/commits{/sha}","git_commits_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/git/commits{/sha}","comments_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/comments{/number}","issue_comment_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/issues/comments{/number}","contents_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/contents/{+path}","compare_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/compare/{base}...{head}","merges_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/merges","archive_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/downloads","issues_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/issues{/number}","pulls_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/pulls{/number}","milestones_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/milestones{/number}","notifications_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/labels{/name}","releases_url":"https://api.github.com/repos/cadecairos/api.webmaker.org/releases{/id}","created_at":"2015-04-22T14:49:01Z","updated_at":"2015-06-11T16:45:20Z","pushed_at":"2015-07-24T22:42:50Z","git_url":"git://github.com/cadecairos/api.webmaker.org.git","ssh_url":"git@github.com:cadecairos/api.webmaker.org.git","clone_url":"https://github.com/cadecairos/api.webmaker.org.git","svn_url":"https://github.com/cadecairos/api.webmaker.org","homepage":null,"size":834,"stargazers_count":0,"watchers_count":0,"language":"JavaScript","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"secretrobotron:discovery-filter","ref":"discovery-filter","sha":"8506dfe6711bdb0175f38597220532d98b423073","user":{"login":"secretrobotron","id":403231,"avatar_url":"https://avatars.githubusercontent.com/u/403231?v=3","gravatar_id":"","url":"https://api.github.com/users/secretrobotron","html_url":"https://github.com/secretrobotron","followers_url":"https://api.github.com/users/secretrobotron/followers","following_url":"https://api.github.com/users/secretrobotron/following{/other_user}","gists_url":"https://api.github.com/users/secretrobotron/gists{/gist_id}","starred_url":"https://api.github.com/users/secretrobotron/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/secretrobotron/subscriptions","organizations_url":"https://api.github.com/users/secretrobotron/orgs","repos_url":"https://api.github.com/users/secretrobotron/repos","events_url":"https://api.github.com/users/secretrobotron/events{/privacy}","received_events_url":"https://api.github.com/users/secretrobotron/received_events","type":"User","site_admin":false},"repo":{"id":36372836,"name":"api.webmaker.org","full_name":"secretrobotron/api.webmaker.org","owner":{"login":"secretrobotron","id":403231,"avatar_url":"https://avatars.githubusercontent.com/u/403231?v=3","gravatar_id":"","url":"https://api.github.com/users/secretrobotron","html_url":"https://github.com/secretrobotron","followers_url":"https://api.github.com/users/secretrobotron/followers","following_url":"https://api.github.com/users/secretrobotron/following{/other_user}","gists_url":"https://api.github.com/users/secretrobotron/gists{/gist_id}","starred_url":"https://api.github.com/users/secretrobotron/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/secretrobotron/subscriptions","organizations_url":"https://api.github.com/users/secretrobotron/orgs","repos_url":"https://api.github.com/users/secretrobotron/repos","events_url":"https://api.github.com/users/secretrobotron/events{/privacy}","received_events_url":"https://api.github.com/users/secretrobotron/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/secretrobotron/api.webmaker.org","description":"Services for Webmaker","fork":true,"url":"https://api.github.com/repos/secretrobotron/api.webmaker.org","forks_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/forks","keys_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/keys{/key_id}","collaborators_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/teams","hooks_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/hooks","issue_events_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/issues/events{/number}","events_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/events","assignees_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/assignees{/user}","branches_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/branches{/branch}","tags_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/tags","blobs_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/git/refs{/sha}","trees_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/git/trees{/sha}","statuses_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/statuses/{sha}","languages_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/languages","stargazers_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/stargazers","contributors_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/contributors","subscribers_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/subscribers","subscription_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/subscription","commits_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/commits{/sha}","git_commits_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/git/commits{/sha}","comments_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/comments{/number}","issue_comment_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/issues/comments{/number}","contents_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/contents/{+path}","compare_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/compare/{base}...{head}","merges_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/merges","archive_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/downloads","issues_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/issues{/number}","pulls_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/pulls{/number}","milestones_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/milestones{/number}","notifications_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/labels{/name}","releases_url":"https://api.github.com/repos/secretrobotron/api.webmaker.org/releases{/id}","created_at":"2015-05-27T14:34:09Z","updated_at":"2015-05-27T14:34:10Z","pushed_at":"2015-07-24T22:43:40Z","git_url":"git://github.com/secretrobotron/api.webmaker.org.git","ssh_url":"git@github.com:secretrobotron/api.webmaker.org.git","clone_url":"https://github.com/secretrobotron/api.webmaker.org.git","svn_url":"https://github.com/secretrobotron/api.webmaker.org","homepage":null,"size":291,"stargazers_count":0,"watchers_count":0,"language":"JavaScript","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":1,"forks":0,"open_issues":1,"watchers":0,"default_branch":"develop"}},"_links":{"self":{"href":"https://api.github.com/repos/secretrobotron/api.webmaker.org/pulls/1"},"html":{"href":"https://github.com/secretrobotron/api.webmaker.org/pull/1"},"issue":{"href":"https://api.github.com/repos/secretrobotron/api.webmaker.org/issues/1"},"comments":{"href":"https://api.github.com/repos/secretrobotron/api.webmaker.org/issues/1/comments"},"review_comments":{"href":"https://api.github.com/repos/secretrobotron/api.webmaker.org/pulls/1/comments"},"review_comment":{"href":"https://api.github.com/repos/secretrobotron/api.webmaker.org/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/secretrobotron/api.webmaker.org/pulls/1/commits"},"statuses":{"href":"https://api.github.com/repos/secretrobotron/api.webmaker.org/statuses/ed9b0d4f8065aa5888f6a3028d96e1050797a16f"}}}}