{"action":"opened","issue":{"url":"https://api.github.com/repos/fac-13/ToVaHayGi/issues/33","repository_url":"https://api.github.com/repos/fac-13/ToVaHayGi","labels_url":"https://api.github.com/repos/fac-13/ToVaHayGi/issues/33/labels{/name}","comments_url":"https://api.github.com/repos/fac-13/ToVaHayGi/issues/33/comments","events_url":"https://api.github.com/repos/fac-13/ToVaHayGi/issues/33/events","html_url":"https://github.com/fac-13/ToVaHayGi/issues/33","id":312249282,"number":33,"title":"Add new user query to DB should also add user skills","user":{"login":"haydnba","id":22300973,"avatar_url":"https://avatars2.githubusercontent.com/u/22300973?v=4","gravatar_id":"","url":"https://api.github.com/users/haydnba","html_url":"https://github.com/haydnba","followers_url":"https://api.github.com/users/haydnba/followers","following_url":"https://api.github.com/users/haydnba/following{/other_user}","gists_url":"https://api.github.com/users/haydnba/gists{/gist_id}","starred_url":"https://api.github.com/users/haydnba/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/haydnba/subscriptions","organizations_url":"https://api.github.com/users/haydnba/orgs","repos_url":"https://api.github.com/users/haydnba/repos","events_url":"https://api.github.com/users/haydnba/events{/privacy}","received_events_url":"https://api.github.com/users/haydnba/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-04-07T22:35:50Z","updated_at":"2018-04-07T22:35:50Z","closed_at":null,"author_association":"COLLABORATOR","body":"The add new user query should 1. add to both user table and skills table and 2. automatically retrieve the generated user id and skill id and use these to create the links in the linking user_skills table\r\n\r\n(perhaps like this ?)[https://stackoverflow.com/questions/5967494/postgresql-nested-insert#5967671]\r\n```\r\nwith\r\nids as (\r\ninsert ...\r\nreturning id\r\n)\r\ninsert ...\r\nfrom ids;\r\n```"}}
{"actor":{"display_login":"haydnba"}}