{"action":"created","issue":{"url":"https://api.github.com/repos/seemack/healthy-hearts-northwest-dev/issues/45","repository_url":"https://api.github.com/repos/seemack/healthy-hearts-northwest-dev","labels_url":"https://api.github.com/repos/seemack/healthy-hearts-northwest-dev/issues/45/labels{/name}","comments_url":"https://api.github.com/repos/seemack/healthy-hearts-northwest-dev/issues/45/comments","events_url":"https://api.github.com/repos/seemack/healthy-hearts-northwest-dev/issues/45/events","html_url":"https://github.com/seemack/healthy-hearts-northwest-dev/issues/45","id":128912481,"number":45,"title":" Design & test sections to document intervention arms","user":{"login":"kuoxes1","id":16787091,"avatar_url":"https://avatars.githubusercontent.com/u/16787091?v=3","gravatar_id":"","url":"https://api.github.com/users/kuoxes1","html_url":"https://github.com/kuoxes1","followers_url":"https://api.github.com/users/kuoxes1/followers","following_url":"https://api.github.com/users/kuoxes1/following{/other_user}","gists_url":"https://api.github.com/users/kuoxes1/gists{/gist_id}","starred_url":"https://api.github.com/users/kuoxes1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kuoxes1/subscriptions","organizations_url":"https://api.github.com/users/kuoxes1/orgs","repos_url":"https://api.github.com/users/kuoxes1/repos","events_url":"https://api.github.com/users/kuoxes1/events{/privacy}","received_events_url":"https://api.github.com/users/kuoxes1/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/seemack/healthy-hearts-northwest-dev/labels/priority%201","name":"priority 1","color":"e11d21"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":8,"created_at":"2016-01-26T19:03:57Z","updated_at":"2016-06-21T00:23:38Z","closed_at":null,"body":"place holder... They are still trying to figure this out.....\r\n4/1/2016\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/seemack/healthy-hearts-northwest-dev/issues/comments/227308158","html_url":"https://github.com/seemack/healthy-hearts-northwest-dev/issues/45#issuecomment-227308158","issue_url":"https://api.github.com/repos/seemack/healthy-hearts-northwest-dev/issues/45","id":227308158,"user":{"login":"seemack","id":355833,"avatar_url":"https://avatars.githubusercontent.com/u/355833?v=3","gravatar_id":"","url":"https://api.github.com/users/seemack","html_url":"https://github.com/seemack","followers_url":"https://api.github.com/users/seemack/followers","following_url":"https://api.github.com/users/seemack/following{/other_user}","gists_url":"https://api.github.com/users/seemack/gists{/gist_id}","starred_url":"https://api.github.com/users/seemack/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/seemack/subscriptions","organizations_url":"https://api.github.com/users/seemack/orgs","repos_url":"https://api.github.com/users/seemack/repos","events_url":"https://api.github.com/users/seemack/events{/privacy}","received_events_url":"https://api.github.com/users/seemack/received_events","type":"User","site_admin":false},"created_at":"2016-06-21T00:23:38Z","updated_at":"2016-06-21T00:23:38Z","body":"Here's the basics for connection:\r\n\r\n1. Run migration that creates Practice.group_assignment (if not yet done).\r\n\r\n2. Get credentials from Heroku:\r\nheroku pg:credentials DATABASE_URL --app healthy-hearts-northwest-dev\r\nYou'll need the location at AWS, user name, database name & password.\r\nThese are also available from Heroku Dashboard/PostgreSQL\r\n\r\n3. Connect to Heroku:\r\npsql -h [AWS location above] -p 5432 -U [user above] -W -d [database above]\r\npassword: [password above]\r\n\r\n4. Create new table\r\ncreate table random_upload\r\n(study_id char(5) PRIMARY KEY,\r\n group_assignment integer NOT NULL\r\n);\r\n\r\n5. Upload data\r\n\\copy random_upload from 'E:\\Dropbox\\GHRI\\H2N-random.csv' (HEADER, FORMAT csv);\r\n\r\n6. Update data\r\nupdate practices\r\nset group_assignment = random_upload.group_assignment\r\nfrom random_upload\r\nwhere practices.study_id = random_upload.study_id;\r\n\r\n7. Drop temporary table\r\ndrop table random_upload;"}}
{"actor":{"display_login":"seemack"}}