GitHub PullRequestReviewCommentEvent at 2014-10-20 15:43:50
Repository: transmart-data
Actor: cataphract
Payload: {"action":"created","comment":{"url":"https://api.github.com/repos/transmart/transmart-data/pulls/comments/19092897","id":19092897,"diff_hunk":"@@ -875,18 +886,22 @@ BEGIN\n           , patient_id\n           , trial_name\n           , readcount\n+          , trial_source\n         )\n         select  region_id\n               , assay_id\n               , patient_id\n               , trial_name\n               , readcount\n+\t      , TrialId || ':' || sourceCd\n         from tm_wz.wt_subject_rnaseq_region;\n \n   stepCt := stepCt + 1;\n-  cz_write_audit(jobId,databaseName,procedureName,'Insert into DEAPP wt_subject_mrna_probeset',SQL%ROWCOUNT,stepCt,'Done');\n+  cz_write_audit(jobId,databaseName,procedureName,'Insert into DEAPP wt_subject_rnasq_region',SQL%ROWCOUNT,stepCt,'Done');\n   commit;\n \n+  p_exists := SQL%ROWCOUNT;","path":"ddl/oracle/tm_cz/procedures/i2b2_process_rnaseq_data.sql","position":64,"original_position":64,"commit_id":"f486f4bc8013b85106921117c9a543025cfa99e2","original_commit_id":"f486f4bc8013b85106921117c9a543025cfa99e2","user":{"login":"cataphract","id":496394,"avatar_url":"https://avatars.githubusercontent.com/u/496394?v=2","gravatar_id":"","url":"https://api.github.com/users/cataphract","html_url":"https://github.com/cataphract","followers_url":"https://api.github.com/users/cataphract/followers","following_url":"https://api.github.com/users/cataphract/following{/other_user}","gists_url":"https://api.github.com/users/cataphract/gists{/gist_id}","starred_url":"https://api.github.com/users/cataphract/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cataphract/subscriptions","organizations_url":"https://api.github.com/users/cataphract/orgs","repos_url":"https://api.github.com/users/cataphract/repos","events_url":"https://api.github.com/users/cataphract/events{/privacy}","received_events_url":"https://api.github.com/users/cataphract/received_events","type":"User","site_admin":false},"body":"Compile error error. `pExists`?","created_at":"2014-10-20T15:43:50Z","updated_at":"2014-10-20T15:43:50Z","html_url":"https://github.com/transmart/transmart-data/pull/42#discussion_r19092897","pull_request_url":"https://api.github.com/repos/transmart/transmart-data/pulls/42","_links":{"self":{"href":"https://api.github.com/repos/transmart/transmart-data/pulls/comments/19092897"},"html":{"href":"https://github.com/transmart/transmart-data/pull/42#discussion_r19092897"},"pull_request":{"href":"https://api.github.com/repos/transmart/transmart-data/pulls/42"}}},"pull_request":{"url":"https://api.github.com/repos/transmart/transmart-data/pulls/42","id":23016231,"html_url":"https://github.com/transmart/transmart-data/pull/42","diff_url":"https://github.com/transmart/transmart-data/pull/42.diff","patch_url":"https://github.com/transmart/transmart-data/pull/42.patch","issue_url":"https://api.github.com/repos/transmart/transmart-data/issues/42","number":42,"state":"open","locked":false,"title":"Bug fixes acgh and rnaseq upload pipeline (TMART-188)","user":{"login":"cdejonge","id":1689918,"avatar_url":"https://avatars.githubusercontent.com/u/1689918?v=2","gravatar_id":"","url":"https://api.github.com/users/cdejonge","html_url":"https://github.com/cdejonge","followers_url":"https://api.github.com/users/cdejonge/followers","following_url":"https://api.github.com/users/cdejonge/following{/other_user}","gists_url":"https://api.github.com/users/cdejonge/gists{/gist_id}","starred_url":"https://api.github.com/users/cdejonge/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cdejonge/subscriptions","organizations_url":"https://api.github.com/users/cdejonge/orgs","repos_url":"https://api.github.com/users/cdejonge/repos","events_url":"https://api.github.com/users/cdejonge/events{/privacy}","received_events_url":"https://api.github.com/users/cdejonge/received_events","type":"User","site_admin":false},"body":"","created_at":"2014-10-20T13:59:49Z","updated_at":"2014-10-20T15:43:50Z","closed_at":null,"merged_at":null,"merge_commit_sha":"8c51fbcf5b7f4c5d9462ae8b4b0dae87174e98c5","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/transmart/transmart-data/pulls/42/commits","review_comments_url":"https://api.github.com/repos/transmart/transmart-data/pulls/42/comments","review_comment_url":"https://api.github.com/repos/transmart/transmart-data/pulls/comments/{number}","comments_url":"https://api.github.com/repos/transmart/transmart-data/issues/42/comments","statuses_url":"https://api.github.com/repos/transmart/transmart-data/statuses/f486f4bc8013b85106921117c9a543025cfa99e2","head":{"label":"cdejonge:master","ref":"master","sha":"f486f4bc8013b85106921117c9a543025cfa99e2","user":{"login":"cdejonge","id":1689918,"avatar_url":"https://avatars.githubusercontent.com/u/1689918?v=2","gravatar_id":"","url":"https://api.github.com/users/cdejonge","html_url":"https://github.com/cdejonge","followers_url":"https://api.github.com/users/cdejonge/followers","following_url":"https://api.github.com/users/cdejonge/following{/other_user}","gists_url":"https://api.github.com/users/cdejonge/gists{/gist_id}","starred_url":"https://api.github.com/users/cdejonge/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cdejonge/subscriptions","organizations_url":"https://api.github.com/users/cdejonge/orgs","repos_url":"https://api.github.com/users/cdejonge/repos","events_url":"https://api.github.com/users/cdejonge/events{/privacy}","received_events_url":"https://api.github.com/users/cdejonge/received_events","type":"User","site_admin":false},"repo":{"id":25467924,"name":"transmart-data","full_name":"cdejonge/transmart-data","owner":{"login":"cdejonge","id":1689918,"avatar_url":"https://avatars.githubusercontent.com/u/1689918?v=2","gravatar_id":"","url":"https://api.github.com/users/cdejonge","html_url":"https://github.com/cdejonge","followers_url":"https://api.github.com/users/cdejonge/followers","following_url":"https://api.github.com/users/cdejonge/following{/other_user}","gists_url":"https://api.github.com/users/cdejonge/gists{/gist_id}","starred_url":"https://api.github.com/users/cdejonge/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cdejonge/subscriptions","organizations_url":"https://api.github.com/users/cdejonge/orgs","repos_url":"https://api.github.com/users/cdejonge/repos","events_url":"https://api.github.com/users/cdejonge/events{/privacy}","received_events_url":"https://api.github.com/users/cdejonge/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/cdejonge/transmart-data","description":"Tools for managing tranSMART's database","fork":true,"url":"https://api.github.com/repos/cdejonge/transmart-data","forks_url":"https://api.github.com/repos/cdejonge/transmart-data/forks","keys_url":"https://api.github.com/repos/cdejonge/transmart-data/keys{/key_id}","collaborators_url":"https://api.github.com/repos/cdejonge/transmart-data/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/cdejonge/transmart-data/teams","hooks_url":"https://api.github.com/repos/cdejonge/transmart-data/hooks","issue_events_url":"https://api.github.com/repos/cdejonge/transmart-data/issues/events{/number}","events_url":"https://api.github.com/repos/cdejonge/transmart-data/events","assignees_url":"https://api.github.com/repos/cdejonge/transmart-data/assignees{/user}","branches_url":"https://api.github.com/repos/cdejonge/transmart-data/branches{/branch}","tags_url":"https://api.github.com/repos/cdejonge/transmart-data/tags","blobs_url":"https://api.github.com/repos/cdejonge/transmart-data/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/cdejonge/transmart-data/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/cdejonge/transmart-data/git/refs{/sha}","trees_url":"https://api.github.com/repos/cdejonge/transmart-data/git/trees{/sha}","statuses_url":"https://api.github.com/repos/cdejonge/transmart-data/statuses/{sha}","languages_url":"https://api.github.com/repos/cdejonge/transmart-data/languages","stargazers_url":"https://api.github.com/repos/cdejonge/transmart-data/stargazers","contributors_url":"https://api.github.com/repos/cdejonge/transmart-data/contributors","subscribers_url":"https://api.github.com/repos/cdejonge/transmart-data/subscribers","subscription_url":"https://api.github.com/repos/cdejonge/transmart-data/subscription","commits_url":"https://api.github.com/repos/cdejonge/transmart-data/commits{/sha}","git_commits_url":"https://api.github.com/repos/cdejonge/transmart-data/git/commits{/sha}","comments_url":"https://api.github.com/repos/cdejonge/transmart-data/comments{/number}","issue_comment_url":"https://api.github.com/repos/cdejonge/transmart-data/issues/comments/{number}","contents_url":"https://api.github.com/repos/cdejonge/transmart-data/contents/{+path}","compare_url":"https://api.github.com/repos/cdejonge/transmart-data/compare/{base}...{head}","merges_url":"https://api.github.com/repos/cdejonge/transmart-data/merges","archive_url":"https://api.github.com/repos/cdejonge/transmart-data/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/cdejonge/transmart-data/downloads","issues_url":"https://api.github.com/repos/cdejonge/transmart-data/issues{/number}","pulls_url":"https://api.github.com/repos/cdejonge/transmart-data/pulls{/number}","milestones_url":"https://api.github.com/repos/cdejonge/transmart-data/milestones{/number}","notifications_url":"https://api.github.com/repos/cdejonge/transmart-data/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/cdejonge/transmart-data/labels{/name}","releases_url":"https://api.github.com/repos/cdejonge/transmart-data/releases{/id}","created_at":"2014-10-20T13:35:17Z","updated_at":"2014-10-20T13:56:19Z","pushed_at":"2014-10-20T13:56:16Z","git_url":"git://github.com/cdejonge/transmart-data.git","ssh_url":"git@github.com:cdejonge/transmart-data.git","clone_url":"https://github.com/cdejonge/transmart-data.git","svn_url":"https://github.com/cdejonge/transmart-data","homepage":null,"size":15335,"stargazers_count":0,"watchers_count":0,"language":"Groovy","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"transmart:master","ref":"master","sha":"1944afb49e14afe54c67117a8a33b9dfce85eab8","user":{"login":"transmart","id":1469765,"avatar_url":"https://avatars.githubusercontent.com/u/1469765?v=2","gravatar_id":"","url":"https://api.github.com/users/transmart","html_url":"https://github.com/transmart","followers_url":"https://api.github.com/users/transmart/followers","following_url":"https://api.github.com/users/transmart/following{/other_user}","gists_url":"https://api.github.com/users/transmart/gists{/gist_id}","starred_url":"https://api.github.com/users/transmart/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/transmart/subscriptions","organizations_url":"https://api.github.com/users/transmart/orgs","repos_url":"https://api.github.com/users/transmart/repos","events_url":"https://api.github.com/users/transmart/events{/privacy}","received_events_url":"https://api.github.com/users/transmart/received_events","type":"Organization","site_admin":false},"repo":{"id":17950809,"name":"transmart-data","full_name":"transmart/transmart-data","owner":{"login":"transmart","id":1469765,"avatar_url":"https://avatars.githubusercontent.com/u/1469765?v=2","gravatar_id":"","url":"https://api.github.com/users/transmart","html_url":"https://github.com/transmart","followers_url":"https://api.github.com/users/transmart/followers","following_url":"https://api.github.com/users/transmart/following{/other_user}","gists_url":"https://api.github.com/users/transmart/gists{/gist_id}","starred_url":"https://api.github.com/users/transmart/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/transmart/subscriptions","organizations_url":"https://api.github.com/users/transmart/orgs","repos_url":"https://api.github.com/users/transmart/repos","events_url":"https://api.github.com/users/transmart/events{/privacy}","received_events_url":"https://api.github.com/users/transmart/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/transmart/transmart-data","description":"Tools for managing tranSMART's database","fork":true,"url":"https://api.github.com/repos/transmart/transmart-data","forks_url":"https://api.github.com/repos/transmart/transmart-data/forks","keys_url":"https://api.github.com/repos/transmart/transmart-data/keys{/key_id}","collaborators_url":"https://api.github.com/repos/transmart/transmart-data/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/transmart/transmart-data/teams","hooks_url":"https://api.github.com/repos/transmart/transmart-data/hooks","issue_events_url":"https://api.github.com/repos/transmart/transmart-data/issues/events{/number}","events_url":"https://api.github.com/repos/transmart/transmart-data/events","assignees_url":"https://api.github.com/repos/transmart/transmart-data/assignees{/user}","branches_url":"https://api.github.com/repos/transmart/transmart-data/branches{/branch}","tags_url":"https://api.github.com/repos/transmart/transmart-data/tags","blobs_url":"https://api.github.com/repos/transmart/transmart-data/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/transmart/transmart-data/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/transmart/transmart-data/git/refs{/sha}","trees_url":"https://api.github.com/repos/transmart/transmart-data/git/trees{/sha}","statuses_url":"https://api.github.com/repos/transmart/transmart-data/statuses/{sha}","languages_url":"https://api.github.com/repos/transmart/transmart-data/languages","stargazers_url":"https://api.github.com/repos/transmart/transmart-data/stargazers","contributors_url":"https://api.github.com/repos/transmart/transmart-data/contributors","subscribers_url":"https://api.github.com/repos/transmart/transmart-data/subscribers","subscription_url":"https://api.github.com/repos/transmart/transmart-data/subscription","commits_url":"https://api.github.com/repos/transmart/transmart-data/commits{/sha}","git_commits_url":"https://api.github.com/repos/transmart/transmart-data/git/commits{/sha}","comments_url":"https://api.github.com/repos/transmart/transmart-data/comments{/number}","issue_comment_url":"https://api.github.com/repos/transmart/transmart-data/issues/comments/{number}","contents_url":"https://api.github.com/repos/transmart/transmart-data/contents/{+path}","compare_url":"https://api.github.com/repos/transmart/transmart-data/compare/{base}...{head}","merges_url":"https://api.github.com/repos/transmart/transmart-data/merges","archive_url":"https://api.github.com/repos/transmart/transmart-data/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/transmart/transmart-data/downloads","issues_url":"https://api.github.com/repos/transmart/transmart-data/issues{/number}","pulls_url":"https://api.github.com/repos/transmart/transmart-data/pulls{/number}","milestones_url":"https://api.github.com/repos/transmart/transmart-data/milestones{/number}","notifications_url":"https://api.github.com/repos/transmart/transmart-data/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/transmart/transmart-data/labels{/name}","releases_url":"https://api.github.com/repos/transmart/transmart-data/releases{/id}","created_at":"2014-03-20T16:59:04Z","updated_at":"2014-08-05T18:12:42Z","pushed_at":"2014-10-16T04:16:10Z","git_url":"git://github.com/transmart/transmart-data.git","ssh_url":"git@github.com:transmart/transmart-data.git","clone_url":"https://github.com/transmart/transmart-data.git","svn_url":"https://github.com/transmart/transmart-data","homepage":null,"size":15335,"stargazers_count":0,"watchers_count":0,"language":"Groovy","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":5,"mirror_url":null,"open_issues_count":2,"forks":5,"open_issues":2,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/transmart/transmart-data/pulls/42"},"html":{"href":"https://github.com/transmart/transmart-data/pull/42"},"issue":{"href":"https://api.github.com/repos/transmart/transmart-data/issues/42"},"comments":{"href":"https://api.github.com/repos/transmart/transmart-data/issues/42/comments"},"review_comments":{"href":"https://api.github.com/repos/transmart/transmart-data/pulls/42/comments"},"review_comment":{"href":"https://api.github.com/repos/transmart/transmart-data/pulls/comments/{number}"},"commits":{"href":"https://api.github.com/repos/transmart/transmart-data/pulls/42/commits"},"statuses":{"href":"https://api.github.com/repos/transmart/transmart-data/statuses/f486f4bc8013b85106921117c9a543025cfa99e2"}}}}