{"action":"created","comment":{"url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/pulls/comments/215039217","pull_request_review_id":152219014,"id":215039217,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDIxNTAzOTIxNw==","diff_hunk":"@@ -386,6 +386,174 @@ function Publish-TerminologyDacpac() {\n     Publish-DosDacPac -TargetSqlInstance $Config.sqlAddress -DacPacFilePath $Dacpac -TargetDb \"Terminology\" -PublishOptionsFilePath $PublishProfile\n }\n \n+function Get-RoleId {\n+    param(\n+        [string] $role = $(throw \"Please specify a role name\")\n+    )\n+\n+    $roleBaseQuery = \"SELECT TOP (1) [RoleID] FROM [$metadataDatabase].[CatalystAdmin].[RoleBASE] WHERE RoleNM = '$role'\"\n+    $roleQueryResult = Invoke-Sql -sqlCommand $roleBaseQuery\n+    $roleId = $roleQueryResult.Table.RoleID\n+\n+    if ($roleId) {\n+        Write-Host \"RoleID for $role`: $roleId\"\n+    }\n+    else {\n+        throw \"No RoleID found for role '$role'\"\n+    }\n+\n+    return $roleId\n+}\n+\n+\n+function Post-ToMds {\n+    param(\n+        [ValidateNotNullOrEmpty()][string] $name,\n+        [ValidateNotNullOrEmpty()][string] $path,\n+        [ValidateNotNullOrEmpty()][string] $discoveryServiceUrl\n+    )\n+\n+\n+    #$authToken = Read-Host \"Log into Atlas was a DosAdmin, and copy the access token from one of the auth headers to MDS and copy it here. This is a temporary workaround\"\n+    # TODO THIS NEEDS TO CHANGE AFTER THE FABRIC UPDATES!!!!!!!!!!!!!!!!!!!!!!!!!!!!","path":"Fabric.Terminology.API/Scripts/Terminology-Install-Utilities.psm1","position":33,"original_position":33,"commit_id":"d14634d5e285ef12055a85ea2977f88ff71aa9ee","original_commit_id":"d14634d5e285ef12055a85ea2977f88ff71aa9ee","user":{"login":"petermcclanahan","id":20196383,"node_id":"MDQ6VXNlcjIwMTk2Mzgz","avatar_url":"https://avatars1.githubusercontent.com/u/20196383?v=4","gravatar_id":"","url":"https://api.github.com/users/petermcclanahan","html_url":"https://github.com/petermcclanahan","followers_url":"https://api.github.com/users/petermcclanahan/followers","following_url":"https://api.github.com/users/petermcclanahan/following{/other_user}","gists_url":"https://api.github.com/users/petermcclanahan/gists{/gist_id}","starred_url":"https://api.github.com/users/petermcclanahan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/petermcclanahan/subscriptions","organizations_url":"https://api.github.com/users/petermcclanahan/orgs","repos_url":"https://api.github.com/users/petermcclanahan/repos","events_url":"https://api.github.com/users/petermcclanahan/events{/privacy}","received_events_url":"https://api.github.com/users/petermcclanahan/received_events","type":"User","site_admin":false},"body":"Definitely needs to be fixed once service-to-service comes into play","created_at":"2018-09-04T19:30:05Z","updated_at":"2018-09-04T19:31:18Z","html_url":"https://github.com/HealthCatalyst/Fabric.Terminology/pull/149#discussion_r215039217","pull_request_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/pulls/149","author_association":"COLLABORATOR","_links":{"self":{"href":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/pulls/comments/215039217"},"html":{"href":"https://github.com/HealthCatalyst/Fabric.Terminology/pull/149#discussion_r215039217"},"pull_request":{"href":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/pulls/149"}}},"pull_request":{"url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/pulls/149","id":213079825,"node_id":"MDExOlB1bGxSZXF1ZXN0MjEzMDc5ODI1","html_url":"https://github.com/HealthCatalyst/Fabric.Terminology/pull/149","diff_url":"https://github.com/HealthCatalyst/Fabric.Terminology/pull/149.diff","patch_url":"https://github.com/HealthCatalyst/Fabric.Terminology/pull/149.patch","issue_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/issues/149","number":149,"state":"open","locked":false,"title":"Adding MDS/DPS parts into terminology install","user":{"login":"petermcclanahan","id":20196383,"node_id":"MDQ6VXNlcjIwMTk2Mzgz","avatar_url":"https://avatars1.githubusercontent.com/u/20196383?v=4","gravatar_id":"","url":"https://api.github.com/users/petermcclanahan","html_url":"https://github.com/petermcclanahan","followers_url":"https://api.github.com/users/petermcclanahan/followers","following_url":"https://api.github.com/users/petermcclanahan/following{/other_user}","gists_url":"https://api.github.com/users/petermcclanahan/gists{/gist_id}","starred_url":"https://api.github.com/users/petermcclanahan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/petermcclanahan/subscriptions","organizations_url":"https://api.github.com/users/petermcclanahan/orgs","repos_url":"https://api.github.com/users/petermcclanahan/repos","events_url":"https://api.github.com/users/petermcclanahan/events{/privacy}","received_events_url":"https://api.github.com/users/petermcclanahan/received_events","type":"User","site_admin":false},"body":"There are a number of things we need to change still (after MDS makes the two updates we're working on), and potentially some untested bugs, but this is to give you guys a chance to look through it before waiting for that.","created_at":"2018-09-04T19:29:32Z","updated_at":"2018-09-04T19:31:18Z","closed_at":null,"merged_at":null,"merge_commit_sha":"fb70e542c5cf4aaf20f09abd0f5772ba07649032","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/pulls/149/commits","review_comments_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/pulls/149/comments","review_comment_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/pulls/comments{/number}","comments_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/issues/149/comments","statuses_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/statuses/d14634d5e285ef12055a85ea2977f88ff71aa9ee","head":{"label":"HealthCatalyst:user/peterm/mds-dps","ref":"user/peterm/mds-dps","sha":"d14634d5e285ef12055a85ea2977f88ff71aa9ee","user":{"login":"HealthCatalyst","id":27259917,"node_id":"MDEyOk9yZ2FuaXphdGlvbjI3MjU5OTE3","avatar_url":"https://avatars3.githubusercontent.com/u/27259917?v=4","gravatar_id":"","url":"https://api.github.com/users/HealthCatalyst","html_url":"https://github.com/HealthCatalyst","followers_url":"https://api.github.com/users/HealthCatalyst/followers","following_url":"https://api.github.com/users/HealthCatalyst/following{/other_user}","gists_url":"https://api.github.com/users/HealthCatalyst/gists{/gist_id}","starred_url":"https://api.github.com/users/HealthCatalyst/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/HealthCatalyst/subscriptions","organizations_url":"https://api.github.com/users/HealthCatalyst/orgs","repos_url":"https://api.github.com/users/HealthCatalyst/repos","events_url":"https://api.github.com/users/HealthCatalyst/events{/privacy}","received_events_url":"https://api.github.com/users/HealthCatalyst/received_events","type":"Organization","site_admin":false},"repo":{"id":97139921,"node_id":"MDEwOlJlcG9zaXRvcnk5NzEzOTkyMQ==","name":"Fabric.Terminology","full_name":"HealthCatalyst/Fabric.Terminology","owner":{"login":"HealthCatalyst","id":27259917,"node_id":"MDEyOk9yZ2FuaXphdGlvbjI3MjU5OTE3","avatar_url":"https://avatars3.githubusercontent.com/u/27259917?v=4","gravatar_id":"","url":"https://api.github.com/users/HealthCatalyst","html_url":"https://github.com/HealthCatalyst","followers_url":"https://api.github.com/users/HealthCatalyst/followers","following_url":"https://api.github.com/users/HealthCatalyst/following{/other_user}","gists_url":"https://api.github.com/users/HealthCatalyst/gists{/gist_id}","starred_url":"https://api.github.com/users/HealthCatalyst/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/HealthCatalyst/subscriptions","organizations_url":"https://api.github.com/users/HealthCatalyst/orgs","repos_url":"https://api.github.com/users/HealthCatalyst/repos","events_url":"https://api.github.com/users/HealthCatalyst/events{/privacy}","received_events_url":"https://api.github.com/users/HealthCatalyst/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/HealthCatalyst/Fabric.Terminology","description":"Service to provide shared healthcare terminology data","fork":false,"url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology","forks_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/forks","keys_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/keys{/key_id}","collaborators_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/teams","hooks_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/hooks","issue_events_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/issues/events{/number}","events_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/events","assignees_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/assignees{/user}","branches_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/branches{/branch}","tags_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/tags","blobs_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/git/refs{/sha}","trees_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/git/trees{/sha}","statuses_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/statuses/{sha}","languages_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/languages","stargazers_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/stargazers","contributors_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/contributors","subscribers_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/subscribers","subscription_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/subscription","commits_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/commits{/sha}","git_commits_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/git/commits{/sha}","comments_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/comments{/number}","issue_comment_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/issues/comments{/number}","contents_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/contents/{+path}","compare_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/compare/{base}...{head}","merges_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/merges","archive_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/downloads","issues_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/issues{/number}","pulls_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/pulls{/number}","milestones_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/milestones{/number}","notifications_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/labels{/name}","releases_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/releases{/id}","deployments_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/deployments","created_at":"2017-07-13T15:44:28Z","updated_at":"2018-09-04T17:34:46Z","pushed_at":"2018-09-04T19:29:33Z","git_url":"git://github.com/HealthCatalyst/Fabric.Terminology.git","ssh_url":"git@github.com:HealthCatalyst/Fabric.Terminology.git","clone_url":"https://github.com/HealthCatalyst/Fabric.Terminology.git","svn_url":"https://github.com/HealthCatalyst/Fabric.Terminology","homepage":"","size":2043,"stargazers_count":2,"watchers_count":2,"language":"C#","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":3,"mirror_url":null,"archived":false,"open_issues_count":21,"license":{"key":"apache-2.0","name":"Apache License 2.0","spdx_id":"Apache-2.0","url":"https://api.github.com/licenses/apache-2.0","node_id":"MDc6TGljZW5zZTI="},"forks":3,"open_issues":21,"watchers":2,"default_branch":"develop"}},"base":{"label":"HealthCatalyst:develop","ref":"develop","sha":"807293c70d2d562fb3becdcf3551708244b45b67","user":{"login":"HealthCatalyst","id":27259917,"node_id":"MDEyOk9yZ2FuaXphdGlvbjI3MjU5OTE3","avatar_url":"https://avatars3.githubusercontent.com/u/27259917?v=4","gravatar_id":"","url":"https://api.github.com/users/HealthCatalyst","html_url":"https://github.com/HealthCatalyst","followers_url":"https://api.github.com/users/HealthCatalyst/followers","following_url":"https://api.github.com/users/HealthCatalyst/following{/other_user}","gists_url":"https://api.github.com/users/HealthCatalyst/gists{/gist_id}","starred_url":"https://api.github.com/users/HealthCatalyst/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/HealthCatalyst/subscriptions","organizations_url":"https://api.github.com/users/HealthCatalyst/orgs","repos_url":"https://api.github.com/users/HealthCatalyst/repos","events_url":"https://api.github.com/users/HealthCatalyst/events{/privacy}","received_events_url":"https://api.github.com/users/HealthCatalyst/received_events","type":"Organization","site_admin":false},"repo":{"id":97139921,"node_id":"MDEwOlJlcG9zaXRvcnk5NzEzOTkyMQ==","name":"Fabric.Terminology","full_name":"HealthCatalyst/Fabric.Terminology","owner":{"login":"HealthCatalyst","id":27259917,"node_id":"MDEyOk9yZ2FuaXphdGlvbjI3MjU5OTE3","avatar_url":"https://avatars3.githubusercontent.com/u/27259917?v=4","gravatar_id":"","url":"https://api.github.com/users/HealthCatalyst","html_url":"https://github.com/HealthCatalyst","followers_url":"https://api.github.com/users/HealthCatalyst/followers","following_url":"https://api.github.com/users/HealthCatalyst/following{/other_user}","gists_url":"https://api.github.com/users/HealthCatalyst/gists{/gist_id}","starred_url":"https://api.github.com/users/HealthCatalyst/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/HealthCatalyst/subscriptions","organizations_url":"https://api.github.com/users/HealthCatalyst/orgs","repos_url":"https://api.github.com/users/HealthCatalyst/repos","events_url":"https://api.github.com/users/HealthCatalyst/events{/privacy}","received_events_url":"https://api.github.com/users/HealthCatalyst/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/HealthCatalyst/Fabric.Terminology","description":"Service to provide shared healthcare terminology data","fork":false,"url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology","forks_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/forks","keys_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/keys{/key_id}","collaborators_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/teams","hooks_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/hooks","issue_events_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/issues/events{/number}","events_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/events","assignees_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/assignees{/user}","branches_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/branches{/branch}","tags_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/tags","blobs_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/git/refs{/sha}","trees_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/git/trees{/sha}","statuses_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/statuses/{sha}","languages_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/languages","stargazers_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/stargazers","contributors_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/contributors","subscribers_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/subscribers","subscription_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/subscription","commits_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/commits{/sha}","git_commits_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/git/commits{/sha}","comments_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/comments{/number}","issue_comment_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/issues/comments{/number}","contents_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/contents/{+path}","compare_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/compare/{base}...{head}","merges_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/merges","archive_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/downloads","issues_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/issues{/number}","pulls_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/pulls{/number}","milestones_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/milestones{/number}","notifications_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/labels{/name}","releases_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/releases{/id}","deployments_url":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/deployments","created_at":"2017-07-13T15:44:28Z","updated_at":"2018-09-04T17:34:46Z","pushed_at":"2018-09-04T19:29:33Z","git_url":"git://github.com/HealthCatalyst/Fabric.Terminology.git","ssh_url":"git@github.com:HealthCatalyst/Fabric.Terminology.git","clone_url":"https://github.com/HealthCatalyst/Fabric.Terminology.git","svn_url":"https://github.com/HealthCatalyst/Fabric.Terminology","homepage":"","size":2043,"stargazers_count":2,"watchers_count":2,"language":"C#","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":3,"mirror_url":null,"archived":false,"open_issues_count":21,"license":{"key":"apache-2.0","name":"Apache License 2.0","spdx_id":"Apache-2.0","url":"https://api.github.com/licenses/apache-2.0","node_id":"MDc6TGljZW5zZTI="},"forks":3,"open_issues":21,"watchers":2,"default_branch":"develop"}},"_links":{"self":{"href":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/pulls/149"},"html":{"href":"https://github.com/HealthCatalyst/Fabric.Terminology/pull/149"},"issue":{"href":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/issues/149"},"comments":{"href":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/issues/149/comments"},"review_comments":{"href":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/pulls/149/comments"},"review_comment":{"href":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/pulls/149/commits"},"statuses":{"href":"https://api.github.com/repos/HealthCatalyst/Fabric.Terminology/statuses/d14634d5e285ef12055a85ea2977f88ff71aa9ee"}},"author_association":"COLLABORATOR"}}
{"actor":{"display_login":"petermcclanahan"}}