{"action":"created","issue":{"url":"https://api.github.com/repos/scottwainstock/pbm/issues/967","repository_url":"https://api.github.com/repos/scottwainstock/pbm","labels_url":"https://api.github.com/repos/scottwainstock/pbm/issues/967/labels{/name}","comments_url":"https://api.github.com/repos/scottwainstock/pbm/issues/967/comments","events_url":"https://api.github.com/repos/scottwainstock/pbm/issues/967/events","html_url":"https://github.com/scottwainstock/pbm/issues/967","id":326679898,"number":967,"title":"Country field","user":{"login":"RyanTG","id":632682,"avatar_url":"https://avatars3.githubusercontent.com/u/632682?v=4","gravatar_id":"","url":"https://api.github.com/users/RyanTG","html_url":"https://github.com/RyanTG","followers_url":"https://api.github.com/users/RyanTG/followers","following_url":"https://api.github.com/users/RyanTG/following{/other_user}","gists_url":"https://api.github.com/users/RyanTG/gists{/gist_id}","starred_url":"https://api.github.com/users/RyanTG/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RyanTG/subscriptions","organizations_url":"https://api.github.com/users/RyanTG/orgs","repos_url":"https://api.github.com/users/RyanTG/repos","events_url":"https://api.github.com/users/RyanTG/events{/privacy}","received_events_url":"https://api.github.com/users/RyanTG/received_events","type":"User","site_admin":false},"labels":[{"id":526244502,"url":"https://api.github.com/repos/scottwainstock/pbm/labels/pending%20review","name":"pending review","color":"5319e7","default":false}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-05-25T22:26:10Z","updated_at":"2018-05-29T17:49:59Z","closed_at":"2018-05-29T17:49:59Z","author_association":"COLLABORATOR","body":"And hopefully we can autopopulate existing locations by going through the regions.\r\n\r\nCanada:\r\nbc\r\ntoronto\r\nmanitoba\r\ncalgary\r\nmontreal\r\nottawa\r\n\r\nand location id: 10173 (regionless)\r\n\r\nAustralia:\r\nbrisbane\r\n\r\nEverything else (including regionless) is United States."},"comment":{"url":"https://api.github.com/repos/scottwainstock/pbm/issues/comments/392873178","html_url":"https://github.com/scottwainstock/pbm/issues/967#issuecomment-392873178","issue_url":"https://api.github.com/repos/scottwainstock/pbm/issues/967","id":392873178,"user":{"login":"RyanTG","id":632682,"avatar_url":"https://avatars3.githubusercontent.com/u/632682?v=4","gravatar_id":"","url":"https://api.github.com/users/RyanTG","html_url":"https://github.com/RyanTG","followers_url":"https://api.github.com/users/RyanTG/followers","following_url":"https://api.github.com/users/RyanTG/following{/other_user}","gists_url":"https://api.github.com/users/RyanTG/gists{/gist_id}","starred_url":"https://api.github.com/users/RyanTG/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RyanTG/subscriptions","organizations_url":"https://api.github.com/users/RyanTG/orgs","repos_url":"https://api.github.com/users/RyanTG/repos","events_url":"https://api.github.com/users/RyanTG/events{/privacy}","received_events_url":"https://api.github.com/users/RyanTG/received_events","type":"User","site_admin":false},"created_at":"2018-05-29T17:49:59Z","updated_at":"2018-05-29T17:49:59Z","author_association":"COLLABORATOR","body":"````\r\nupdate locations set country='AU' where region_id in (select id from regions where name='brisbane');\r\nUPDATE 61\r\n update locations set country='CA' where region_id in (select id from regions where name in ('bc', 'toronto', 'manitoba', 'calgary', 'montreal', 'ottawa'));\r\nUPDATE 264\r\nupdate locations set country='CA' where id= 10173;\r\nUPDATE 1\r\nupdate locations set country='US' where country is null;\r\nUPDATE 4977\r\n````\r\n\r\nAnd manually changed the others."}}
{"actor":{"display_login":"RyanTG"}}