{"action":"created","comment":{"url":"https://api.github.com/repos/transcom/mymove/pulls/comments/172001538","pull_request_review_id":100959449,"id":172001538,"diff_hunk":"@@ -0,0 +1,7 @@\n+create_table(\"users\", func(t) {\n+\tt.Column(\"id\", \"uuid\", {\"primary\": true})\n+\tt.Column(\"login_gov_uuid\", \"uuid\", {})\n+\tt.Column(\"login_gov_email\", \"text\", {})\n+})\n+\n+raw(\"ALTER TABLE users ADD CONSTRAINT constraint_name UNIQUE (login_gov_uuid);\")","path":"migrations/20180227224236_create_users.up.fizz","position":7,"original_position":7,"commit_id":"57917afb13c300c206b61ae95555713f4b98f5b6","original_commit_id":"57917afb13c300c206b61ae95555713f4b98f5b6","user":{"login":"amitch23","id":8170735,"avatar_url":"https://avatars1.githubusercontent.com/u/8170735?v=4","gravatar_id":"","url":"https://api.github.com/users/amitch23","html_url":"https://github.com/amitch23","followers_url":"https://api.github.com/users/amitch23/followers","following_url":"https://api.github.com/users/amitch23/following{/other_user}","gists_url":"https://api.github.com/users/amitch23/gists{/gist_id}","starred_url":"https://api.github.com/users/amitch23/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/amitch23/subscriptions","organizations_url":"https://api.github.com/users/amitch23/orgs","repos_url":"https://api.github.com/users/amitch23/repos","events_url":"https://api.github.com/users/amitch23/events{/privacy}","received_events_url":"https://api.github.com/users/amitch23/received_events","type":"User","site_admin":false},"body":"I know! I tried and it didn't work. Fizz has an option for indices, but it doesn't seem like for other column fields.","created_at":"2018-03-03T01:52:22Z","updated_at":"2018-03-03T01:52:22Z","html_url":"https://github.com/transcom/mymove/pull/201#discussion_r172001538","pull_request_url":"https://api.github.com/repos/transcom/mymove/pulls/201","author_association":"CONTRIBUTOR","_links":{"self":{"href":"https://api.github.com/repos/transcom/mymove/pulls/comments/172001538"},"html":{"href":"https://github.com/transcom/mymove/pull/201#discussion_r172001538"},"pull_request":{"href":"https://api.github.com/repos/transcom/mymove/pulls/201"}},"in_reply_to_id":171996788},"pull_request":{"url":"https://api.github.com/repos/transcom/mymove/pulls/201","id":172394303,"html_url":"https://github.com/transcom/mymove/pull/201","diff_url":"https://github.com/transcom/mymove/pull/201.diff","patch_url":"https://github.com/transcom/mymove/pull/201.patch","issue_url":"https://api.github.com/repos/transcom/mymove/issues/201","number":201,"state":"open","locked":false,"title":"Add user table ","user":{"login":"amitch23","id":8170735,"avatar_url":"https://avatars1.githubusercontent.com/u/8170735?v=4","gravatar_id":"","url":"https://api.github.com/users/amitch23","html_url":"https://github.com/amitch23","followers_url":"https://api.github.com/users/amitch23/followers","following_url":"https://api.github.com/users/amitch23/following{/other_user}","gists_url":"https://api.github.com/users/amitch23/gists{/gist_id}","starred_url":"https://api.github.com/users/amitch23/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/amitch23/subscriptions","organizations_url":"https://api.github.com/users/amitch23/orgs","repos_url":"https://api.github.com/users/amitch23/repos","events_url":"https://api.github.com/users/amitch23/events{/privacy}","received_events_url":"https://api.github.com/users/amitch23/received_events","type":"User","site_admin":false},"body":"## Description\r\n\r\nAdds a user model and migrations with 2 fields returned from a successful login to login.gov: `login_gov_uuid` and `login_gov_email`. Enforce that the logingov UUID is unique in the table to prevent multiple user creation with the same UUID at the DB level.\r\n\r\n\r\n## Verification Steps\r\n\r\n* [x] All tests pass.\r\n* [x] The requirements listed in [Querying the Database Safely](https://github.com/transcom/mymove/blob/master/docs/backend.md#querying-the-database-safely) have been satisfied.\r\n* [x] There are no [aXe](https://www.deque.com/products/aXe/) warnings for UI. n/a\r\n* [ ] This works in IE.\r\n\r\n## References\r\n\r\n* [Pivotal story]https://www.pivotaltracker.com/story/show/155131585\r\n\r\n","created_at":"2018-03-02T00:42:50Z","updated_at":"2018-03-03T01:52:22Z","closed_at":null,"merged_at":null,"merge_commit_sha":"fcf33008f886e0177750f4e9f8231395e017b13d","assignee":null,"assignees":[],"requested_reviewers":[{"login":"macrael","id":55759,"avatar_url":"https://avatars1.githubusercontent.com/u/55759?v=4","gravatar_id":"","url":"https://api.github.com/users/macrael","html_url":"https://github.com/macrael","followers_url":"https://api.github.com/users/macrael/followers","following_url":"https://api.github.com/users/macrael/following{/other_user}","gists_url":"https://api.github.com/users/macrael/gists{/gist_id}","starred_url":"https://api.github.com/users/macrael/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/macrael/subscriptions","organizations_url":"https://api.github.com/users/macrael/orgs","repos_url":"https://api.github.com/users/macrael/repos","events_url":"https://api.github.com/users/macrael/events{/privacy}","received_events_url":"https://api.github.com/users/macrael/received_events","type":"User","site_admin":false},{"login":"tinyels","id":3142631,"avatar_url":"https://avatars1.githubusercontent.com/u/3142631?v=4","gravatar_id":"","url":"https://api.github.com/users/tinyels","html_url":"https://github.com/tinyels","followers_url":"https://api.github.com/users/tinyels/followers","following_url":"https://api.github.com/users/tinyels/following{/other_user}","gists_url":"https://api.github.com/users/tinyels/gists{/gist_id}","starred_url":"https://api.github.com/users/tinyels/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tinyels/subscriptions","organizations_url":"https://api.github.com/users/tinyels/orgs","repos_url":"https://api.github.com/users/tinyels/repos","events_url":"https://api.github.com/users/tinyels/events{/privacy}","received_events_url":"https://api.github.com/users/tinyels/received_events","type":"User","site_admin":false},{"login":"stangah","id":5151804,"avatar_url":"https://avatars1.githubusercontent.com/u/5151804?v=4","gravatar_id":"","url":"https://api.github.com/users/stangah","html_url":"https://github.com/stangah","followers_url":"https://api.github.com/users/stangah/followers","following_url":"https://api.github.com/users/stangah/following{/other_user}","gists_url":"https://api.github.com/users/stangah/gists{/gist_id}","starred_url":"https://api.github.com/users/stangah/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stangah/subscriptions","organizations_url":"https://api.github.com/users/stangah/orgs","repos_url":"https://api.github.com/users/stangah/repos","events_url":"https://api.github.com/users/stangah/events{/privacy}","received_events_url":"https://api.github.com/users/stangah/received_events","type":"User","site_admin":false}],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/transcom/mymove/pulls/201/commits","review_comments_url":"https://api.github.com/repos/transcom/mymove/pulls/201/comments","review_comment_url":"https://api.github.com/repos/transcom/mymove/pulls/comments{/number}","comments_url":"https://api.github.com/repos/transcom/mymove/issues/201/comments","statuses_url":"https://api.github.com/repos/transcom/mymove/statuses/57917afb13c300c206b61ae95555713f4b98f5b6","head":{"label":"transcom:AM-add-user-table","ref":"AM-add-user-table","sha":"57917afb13c300c206b61ae95555713f4b98f5b6","user":{"login":"transcom","id":34352343,"avatar_url":"https://avatars0.githubusercontent.com/u/34352343?v=4","gravatar_id":"","url":"https://api.github.com/users/transcom","html_url":"https://github.com/transcom","followers_url":"https://api.github.com/users/transcom/followers","following_url":"https://api.github.com/users/transcom/following{/other_user}","gists_url":"https://api.github.com/users/transcom/gists{/gist_id}","starred_url":"https://api.github.com/users/transcom/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/transcom/subscriptions","organizations_url":"https://api.github.com/users/transcom/orgs","repos_url":"https://api.github.com/users/transcom/repos","events_url":"https://api.github.com/users/transcom/events{/privacy}","received_events_url":"https://api.github.com/users/transcom/received_events","type":"Organization","site_admin":false},"repo":{"id":114694829,"name":"mymove","full_name":"transcom/mymove","owner":{"login":"transcom","id":34352343,"avatar_url":"https://avatars0.githubusercontent.com/u/34352343?v=4","gravatar_id":"","url":"https://api.github.com/users/transcom","html_url":"https://github.com/transcom","followers_url":"https://api.github.com/users/transcom/followers","following_url":"https://api.github.com/users/transcom/following{/other_user}","gists_url":"https://api.github.com/users/transcom/gists{/gist_id}","starred_url":"https://api.github.com/users/transcom/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/transcom/subscriptions","organizations_url":"https://api.github.com/users/transcom/orgs","repos_url":"https://api.github.com/users/transcom/repos","events_url":"https://api.github.com/users/transcom/events{/privacy}","received_events_url":"https://api.github.com/users/transcom/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/transcom/mymove","description":"Personal Property Prototype","fork":false,"url":"https://api.github.com/repos/transcom/mymove","forks_url":"https://api.github.com/repos/transcom/mymove/forks","keys_url":"https://api.github.com/repos/transcom/mymove/keys{/key_id}","collaborators_url":"https://api.github.com/repos/transcom/mymove/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/transcom/mymove/teams","hooks_url":"https://api.github.com/repos/transcom/mymove/hooks","issue_events_url":"https://api.github.com/repos/transcom/mymove/issues/events{/number}","events_url":"https://api.github.com/repos/transcom/mymove/events","assignees_url":"https://api.github.com/repos/transcom/mymove/assignees{/user}","branches_url":"https://api.github.com/repos/transcom/mymove/branches{/branch}","tags_url":"https://api.github.com/repos/transcom/mymove/tags","blobs_url":"https://api.github.com/repos/transcom/mymove/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/transcom/mymove/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/transcom/mymove/git/refs{/sha}","trees_url":"https://api.github.com/repos/transcom/mymove/git/trees{/sha}","statuses_url":"https://api.github.com/repos/transcom/mymove/statuses/{sha}","languages_url":"https://api.github.com/repos/transcom/mymove/languages","stargazers_url":"https://api.github.com/repos/transcom/mymove/stargazers","contributors_url":"https://api.github.com/repos/transcom/mymove/contributors","subscribers_url":"https://api.github.com/repos/transcom/mymove/subscribers","subscription_url":"https://api.github.com/repos/transcom/mymove/subscription","commits_url":"https://api.github.com/repos/transcom/mymove/commits{/sha}","git_commits_url":"https://api.github.com/repos/transcom/mymove/git/commits{/sha}","comments_url":"https://api.github.com/repos/transcom/mymove/comments{/number}","issue_comment_url":"https://api.github.com/repos/transcom/mymove/issues/comments{/number}","contents_url":"https://api.github.com/repos/transcom/mymove/contents/{+path}","compare_url":"https://api.github.com/repos/transcom/mymove/compare/{base}...{head}","merges_url":"https://api.github.com/repos/transcom/mymove/merges","archive_url":"https://api.github.com/repos/transcom/mymove/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/transcom/mymove/downloads","issues_url":"https://api.github.com/repos/transcom/mymove/issues{/number}","pulls_url":"https://api.github.com/repos/transcom/mymove/pulls{/number}","milestones_url":"https://api.github.com/repos/transcom/mymove/milestones{/number}","notifications_url":"https://api.github.com/repos/transcom/mymove/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/transcom/mymove/labels{/name}","releases_url":"https://api.github.com/repos/transcom/mymove/releases{/id}","deployments_url":"https://api.github.com/repos/transcom/mymove/deployments","created_at":"2017-12-18T22:41:12Z","updated_at":"2018-02-14T19:42:15Z","pushed_at":"2018-03-03T01:22:42Z","git_url":"git://github.com/transcom/mymove.git","ssh_url":"git@github.com:transcom/mymove.git","clone_url":"https://github.com/transcom/mymove.git","svn_url":"https://github.com/transcom/mymove","homepage":null,"size":2411,"stargazers_count":4,"watchers_count":4,"language":"Go","has_issues":true,"has_projects":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":2,"mirror_url":null,"archived":false,"open_issues_count":7,"license":{"key":"other","name":"Other","spdx_id":null,"url":null},"forks":2,"open_issues":7,"watchers":4,"default_branch":"master"}},"base":{"label":"transcom:master","ref":"master","sha":"ac1458caaaa884dce06926cbd76600ce0b4668ca","user":{"login":"transcom","id":34352343,"avatar_url":"https://avatars0.githubusercontent.com/u/34352343?v=4","gravatar_id":"","url":"https://api.github.com/users/transcom","html_url":"https://github.com/transcom","followers_url":"https://api.github.com/users/transcom/followers","following_url":"https://api.github.com/users/transcom/following{/other_user}","gists_url":"https://api.github.com/users/transcom/gists{/gist_id}","starred_url":"https://api.github.com/users/transcom/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/transcom/subscriptions","organizations_url":"https://api.github.com/users/transcom/orgs","repos_url":"https://api.github.com/users/transcom/repos","events_url":"https://api.github.com/users/transcom/events{/privacy}","received_events_url":"https://api.github.com/users/transcom/received_events","type":"Organization","site_admin":false},"repo":{"id":114694829,"name":"mymove","full_name":"transcom/mymove","owner":{"login":"transcom","id":34352343,"avatar_url":"https://avatars0.githubusercontent.com/u/34352343?v=4","gravatar_id":"","url":"https://api.github.com/users/transcom","html_url":"https://github.com/transcom","followers_url":"https://api.github.com/users/transcom/followers","following_url":"https://api.github.com/users/transcom/following{/other_user}","gists_url":"https://api.github.com/users/transcom/gists{/gist_id}","starred_url":"https://api.github.com/users/transcom/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/transcom/subscriptions","organizations_url":"https://api.github.com/users/transcom/orgs","repos_url":"https://api.github.com/users/transcom/repos","events_url":"https://api.github.com/users/transcom/events{/privacy}","received_events_url":"https://api.github.com/users/transcom/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/transcom/mymove","description":"Personal Property Prototype","fork":false,"url":"https://api.github.com/repos/transcom/mymove","forks_url":"https://api.github.com/repos/transcom/mymove/forks","keys_url":"https://api.github.com/repos/transcom/mymove/keys{/key_id}","collaborators_url":"https://api.github.com/repos/transcom/mymove/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/transcom/mymove/teams","hooks_url":"https://api.github.com/repos/transcom/mymove/hooks","issue_events_url":"https://api.github.com/repos/transcom/mymove/issues/events{/number}","events_url":"https://api.github.com/repos/transcom/mymove/events","assignees_url":"https://api.github.com/repos/transcom/mymove/assignees{/user}","branches_url":"https://api.github.com/repos/transcom/mymove/branches{/branch}","tags_url":"https://api.github.com/repos/transcom/mymove/tags","blobs_url":"https://api.github.com/repos/transcom/mymove/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/transcom/mymove/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/transcom/mymove/git/refs{/sha}","trees_url":"https://api.github.com/repos/transcom/mymove/git/trees{/sha}","statuses_url":"https://api.github.com/repos/transcom/mymove/statuses/{sha}","languages_url":"https://api.github.com/repos/transcom/mymove/languages","stargazers_url":"https://api.github.com/repos/transcom/mymove/stargazers","contributors_url":"https://api.github.com/repos/transcom/mymove/contributors","subscribers_url":"https://api.github.com/repos/transcom/mymove/subscribers","subscription_url":"https://api.github.com/repos/transcom/mymove/subscription","commits_url":"https://api.github.com/repos/transcom/mymove/commits{/sha}","git_commits_url":"https://api.github.com/repos/transcom/mymove/git/commits{/sha}","comments_url":"https://api.github.com/repos/transcom/mymove/comments{/number}","issue_comment_url":"https://api.github.com/repos/transcom/mymove/issues/comments{/number}","contents_url":"https://api.github.com/repos/transcom/mymove/contents/{+path}","compare_url":"https://api.github.com/repos/transcom/mymove/compare/{base}...{head}","merges_url":"https://api.github.com/repos/transcom/mymove/merges","archive_url":"https://api.github.com/repos/transcom/mymove/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/transcom/mymove/downloads","issues_url":"https://api.github.com/repos/transcom/mymove/issues{/number}","pulls_url":"https://api.github.com/repos/transcom/mymove/pulls{/number}","milestones_url":"https://api.github.com/repos/transcom/mymove/milestones{/number}","notifications_url":"https://api.github.com/repos/transcom/mymove/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/transcom/mymove/labels{/name}","releases_url":"https://api.github.com/repos/transcom/mymove/releases{/id}","deployments_url":"https://api.github.com/repos/transcom/mymove/deployments","created_at":"2017-12-18T22:41:12Z","updated_at":"2018-02-14T19:42:15Z","pushed_at":"2018-03-03T01:22:42Z","git_url":"git://github.com/transcom/mymove.git","ssh_url":"git@github.com:transcom/mymove.git","clone_url":"https://github.com/transcom/mymove.git","svn_url":"https://github.com/transcom/mymove","homepage":null,"size":2411,"stargazers_count":4,"watchers_count":4,"language":"Go","has_issues":true,"has_projects":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":2,"mirror_url":null,"archived":false,"open_issues_count":7,"license":{"key":"other","name":"Other","spdx_id":null,"url":null},"forks":2,"open_issues":7,"watchers":4,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/transcom/mymove/pulls/201"},"html":{"href":"https://github.com/transcom/mymove/pull/201"},"issue":{"href":"https://api.github.com/repos/transcom/mymove/issues/201"},"comments":{"href":"https://api.github.com/repos/transcom/mymove/issues/201/comments"},"review_comments":{"href":"https://api.github.com/repos/transcom/mymove/pulls/201/comments"},"review_comment":{"href":"https://api.github.com/repos/transcom/mymove/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/transcom/mymove/pulls/201/commits"},"statuses":{"href":"https://api.github.com/repos/transcom/mymove/statuses/57917afb13c300c206b61ae95555713f4b98f5b6"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"amitch23"}}