{"action":"created","comment":{"url":"https://api.github.com/repos/utPLSQL/utPLSQL/pulls/comments/178215414","pull_request_review_id":108243163,"id":178215414,"diff_hunk":"@@ -0,0 +1,178 @@\n+create or replace package body ut_coverage_proftab is\n+  /*\n+  utPLSQL - Version 3\n+  Copyright 2016 - 2017 utPLSQL Project\n+\n+  Licensed under the Apache License, Version 2.0 (the \"License\"):\n+  you may not use this file except in compliance with the License.\n+  You may obtain a copy of the License at\n+\n+      http://www.apache.org/licenses/LICENSE-2.0\n+\n+  Unless required by applicable law or agreed to in writing, software\n+  distributed under the License is distributed on an \"AS IS\" BASIS,\n+  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\n+  See the License for the specific language governing permissions and\n+  limitations under the License.\n+  */\n+\n+  -- The source query has two important transformations done in it.\n+  -- the flag: to_be_skipped ='Y' is set for a line of code that is badly reported by DBMS_PROFILER as executed 0 times.\n+  -- This includes lines that are:\n+  --   - PACKAGE, PROCEDURE, FUNCTION definition line,\n+  --   - BEGIN, END  of a block\n+  -- Another transformation is adjustment of line number for TRIGGER body.\n+  -- DBMS_PROFILER is reporting line numbers for triggers not as defined in DBA_SOURCE, its usign line numbers as defined in DBA_TRIGGERS\n+  -- the DBA_TRIGGERS does not contain the trigger specification lines, only lines that define the trigger body.\n+  -- the query adjusts the line numbers for triggers by finding first occurrence of begin|declare|compound in the trigger body line.\n+  -- The subquery is optimized by:\n+  -- - COALESCE function -> it will execute only for TRIGGERS\n+  -- - scalar subquery cache -> it will only execute once for one trigger source code.\n+  function get_cov_sources_sql(a_coverage_options ut_coverage_options) return varchar2 is","path":"source/core/coverage/ut_coverage_proftab.pkb","position":31,"original_position":31,"commit_id":"e968f76ec800af2cefbb1d10f768bbb2d216bd5c","original_commit_id":"e968f76ec800af2cefbb1d10f768bbb2d216bd5c","user":{"login":"jgebal","id":1398171,"avatar_url":"https://avatars2.githubusercontent.com/u/1398171?v=4","gravatar_id":"","url":"https://api.github.com/users/jgebal","html_url":"https://github.com/jgebal","followers_url":"https://api.github.com/users/jgebal/followers","following_url":"https://api.github.com/users/jgebal/following{/other_user}","gists_url":"https://api.github.com/users/jgebal/gists{/gist_id}","starred_url":"https://api.github.com/users/jgebal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jgebal/subscriptions","organizations_url":"https://api.github.com/users/jgebal/orgs","repos_url":"https://api.github.com/users/jgebal/repos","events_url":"https://api.github.com/users/jgebal/events{/privacy}","received_events_url":"https://api.github.com/users/jgebal/received_events","type":"User","site_admin":false},"body":"Isn't that function duplicated in two packages now?","created_at":"2018-03-30T01:00:35Z","updated_at":"2018-03-30T01:01:06Z","html_url":"https://github.com/utPLSQL/utPLSQL/pull/604#discussion_r178215414","pull_request_url":"https://api.github.com/repos/utPLSQL/utPLSQL/pulls/604","author_association":"OWNER","_links":{"self":{"href":"https://api.github.com/repos/utPLSQL/utPLSQL/pulls/comments/178215414"},"html":{"href":"https://github.com/utPLSQL/utPLSQL/pull/604#discussion_r178215414"},"pull_request":{"href":"https://api.github.com/repos/utPLSQL/utPLSQL/pulls/604"}}},"pull_request":{"url":"https://api.github.com/repos/utPLSQL/utPLSQL/pulls/604","id":175186443,"html_url":"https://github.com/utPLSQL/utPLSQL/pull/604","diff_url":"https://github.com/utPLSQL/utPLSQL/pull/604.diff","patch_url":"https://github.com/utPLSQL/utPLSQL/pull/604.patch","issue_url":"https://api.github.com/repos/utPLSQL/utPLSQL/issues/604","number":604,"state":"open","locked":false,"title":"12.2 Oracle Native Block Coverage","user":{"login":"lwasylow","id":7831112,"avatar_url":"https://avatars2.githubusercontent.com/u/7831112?v=4","gravatar_id":"","url":"https://api.github.com/users/lwasylow","html_url":"https://github.com/lwasylow","followers_url":"https://api.github.com/users/lwasylow/followers","following_url":"https://api.github.com/users/lwasylow/following{/other_user}","gists_url":"https://api.github.com/users/lwasylow/gists{/gist_id}","starred_url":"https://api.github.com/users/lwasylow/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lwasylow/subscriptions","organizations_url":"https://api.github.com/users/lwasylow/orgs","repos_url":"https://api.github.com/users/lwasylow/repos","events_url":"https://api.github.com/users/lwasylow/events{/privacy}","received_events_url":"https://api.github.com/users/lwasylow/received_events","type":"User","site_admin":false},"body":"Added a support for running cover coverage from Oracle Block Coverage.\r\nChanges includes,update to html reporter for presentation of data,update to core types to support new coverage type option as well as few minor changes.\r\nDefault option remains profiler. The queries are in sys refcursors to avoid a compilation issues on older version of databases.","created_at":"2018-03-15T09:10:55Z","updated_at":"2018-03-30T01:01:06Z","closed_at":null,"merged_at":null,"merge_commit_sha":"d39cd9dd8312380ac429363269073d15a2bd650f","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/utPLSQL/utPLSQL/pulls/604/commits","review_comments_url":"https://api.github.com/repos/utPLSQL/utPLSQL/pulls/604/comments","review_comment_url":"https://api.github.com/repos/utPLSQL/utPLSQL/pulls/comments{/number}","comments_url":"https://api.github.com/repos/utPLSQL/utPLSQL/issues/604/comments","statuses_url":"https://api.github.com/repos/utPLSQL/utPLSQL/statuses/e968f76ec800af2cefbb1d10f768bbb2d216bd5c","head":{"label":"utPLSQL:feature/12cblockcoverage","ref":"feature/12cblockcoverage","sha":"e968f76ec800af2cefbb1d10f768bbb2d216bd5c","user":{"login":"utPLSQL","id":15661281,"avatar_url":"https://avatars2.githubusercontent.com/u/15661281?v=4","gravatar_id":"","url":"https://api.github.com/users/utPLSQL","html_url":"https://github.com/utPLSQL","followers_url":"https://api.github.com/users/utPLSQL/followers","following_url":"https://api.github.com/users/utPLSQL/following{/other_user}","gists_url":"https://api.github.com/users/utPLSQL/gists{/gist_id}","starred_url":"https://api.github.com/users/utPLSQL/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/utPLSQL/subscriptions","organizations_url":"https://api.github.com/users/utPLSQL/orgs","repos_url":"https://api.github.com/users/utPLSQL/repos","events_url":"https://api.github.com/users/utPLSQL/events{/privacy}","received_events_url":"https://api.github.com/users/utPLSQL/received_events","type":"Organization","site_admin":false},"repo":{"id":50728220,"name":"utPLSQL","full_name":"utPLSQL/utPLSQL","owner":{"login":"utPLSQL","id":15661281,"avatar_url":"https://avatars2.githubusercontent.com/u/15661281?v=4","gravatar_id":"","url":"https://api.github.com/users/utPLSQL","html_url":"https://github.com/utPLSQL","followers_url":"https://api.github.com/users/utPLSQL/followers","following_url":"https://api.github.com/users/utPLSQL/following{/other_user}","gists_url":"https://api.github.com/users/utPLSQL/gists{/gist_id}","starred_url":"https://api.github.com/users/utPLSQL/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/utPLSQL/subscriptions","organizations_url":"https://api.github.com/users/utPLSQL/orgs","repos_url":"https://api.github.com/users/utPLSQL/repos","events_url":"https://api.github.com/users/utPLSQL/events{/privacy}","received_events_url":"https://api.github.com/users/utPLSQL/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/utPLSQL/utPLSQL","description":"Ultimate PL/SQL Unit Testing Framework for Oracle","fork":false,"url":"https://api.github.com/repos/utPLSQL/utPLSQL","forks_url":"https://api.github.com/repos/utPLSQL/utPLSQL/forks","keys_url":"https://api.github.com/repos/utPLSQL/utPLSQL/keys{/key_id}","collaborators_url":"https://api.github.com/repos/utPLSQL/utPLSQL/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/utPLSQL/utPLSQL/teams","hooks_url":"https://api.github.com/repos/utPLSQL/utPLSQL/hooks","issue_events_url":"https://api.github.com/repos/utPLSQL/utPLSQL/issues/events{/number}","events_url":"https://api.github.com/repos/utPLSQL/utPLSQL/events","assignees_url":"https://api.github.com/repos/utPLSQL/utPLSQL/assignees{/user}","branches_url":"https://api.github.com/repos/utPLSQL/utPLSQL/branches{/branch}","tags_url":"https://api.github.com/repos/utPLSQL/utPLSQL/tags","blobs_url":"https://api.github.com/repos/utPLSQL/utPLSQL/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/utPLSQL/utPLSQL/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/utPLSQL/utPLSQL/git/refs{/sha}","trees_url":"https://api.github.com/repos/utPLSQL/utPLSQL/git/trees{/sha}","statuses_url":"https://api.github.com/repos/utPLSQL/utPLSQL/statuses/{sha}","languages_url":"https://api.github.com/repos/utPLSQL/utPLSQL/languages","stargazers_url":"https://api.github.com/repos/utPLSQL/utPLSQL/stargazers","contributors_url":"https://api.github.com/repos/utPLSQL/utPLSQL/contributors","subscribers_url":"https://api.github.com/repos/utPLSQL/utPLSQL/subscribers","subscription_url":"https://api.github.com/repos/utPLSQL/utPLSQL/subscription","commits_url":"https://api.github.com/repos/utPLSQL/utPLSQL/commits{/sha}","git_commits_url":"https://api.github.com/repos/utPLSQL/utPLSQL/git/commits{/sha}","comments_url":"https://api.github.com/repos/utPLSQL/utPLSQL/comments{/number}","issue_comment_url":"https://api.github.com/repos/utPLSQL/utPLSQL/issues/comments{/number}","contents_url":"https://api.github.com/repos/utPLSQL/utPLSQL/contents/{+path}","compare_url":"https://api.github.com/repos/utPLSQL/utPLSQL/compare/{base}...{head}","merges_url":"https://api.github.com/repos/utPLSQL/utPLSQL/merges","archive_url":"https://api.github.com/repos/utPLSQL/utPLSQL/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/utPLSQL/utPLSQL/downloads","issues_url":"https://api.github.com/repos/utPLSQL/utPLSQL/issues{/number}","pulls_url":"https://api.github.com/repos/utPLSQL/utPLSQL/pulls{/number}","milestones_url":"https://api.github.com/repos/utPLSQL/utPLSQL/milestones{/number}","notifications_url":"https://api.github.com/repos/utPLSQL/utPLSQL/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/utPLSQL/utPLSQL/labels{/name}","releases_url":"https://api.github.com/repos/utPLSQL/utPLSQL/releases{/id}","deployments_url":"https://api.github.com/repos/utPLSQL/utPLSQL/deployments","created_at":"2016-01-30T14:31:52Z","updated_at":"2018-03-30T00:31:53Z","pushed_at":"2018-03-30T00:31:56Z","git_url":"git://github.com/utPLSQL/utPLSQL.git","ssh_url":"git@github.com:utPLSQL/utPLSQL.git","clone_url":"https://github.com/utPLSQL/utPLSQL.git","svn_url":"https://github.com/utPLSQL/utPLSQL","homepage":"https://utplsql.org/","size":9149,"stargazers_count":177,"watchers_count":177,"language":"PLSQL","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":70,"mirror_url":null,"archived":false,"open_issues_count":38,"license":{"key":"apache-2.0","name":"Apache License 2.0","spdx_id":"Apache-2.0","url":"https://api.github.com/licenses/apache-2.0"},"forks":70,"open_issues":38,"watchers":177,"default_branch":"develop"}},"base":{"label":"utPLSQL:develop","ref":"develop","sha":"a62c9ced69f23a5fd7491bf5c12f5e80473c2ca3","user":{"login":"utPLSQL","id":15661281,"avatar_url":"https://avatars2.githubusercontent.com/u/15661281?v=4","gravatar_id":"","url":"https://api.github.com/users/utPLSQL","html_url":"https://github.com/utPLSQL","followers_url":"https://api.github.com/users/utPLSQL/followers","following_url":"https://api.github.com/users/utPLSQL/following{/other_user}","gists_url":"https://api.github.com/users/utPLSQL/gists{/gist_id}","starred_url":"https://api.github.com/users/utPLSQL/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/utPLSQL/subscriptions","organizations_url":"https://api.github.com/users/utPLSQL/orgs","repos_url":"https://api.github.com/users/utPLSQL/repos","events_url":"https://api.github.com/users/utPLSQL/events{/privacy}","received_events_url":"https://api.github.com/users/utPLSQL/received_events","type":"Organization","site_admin":false},"repo":{"id":50728220,"name":"utPLSQL","full_name":"utPLSQL/utPLSQL","owner":{"login":"utPLSQL","id":15661281,"avatar_url":"https://avatars2.githubusercontent.com/u/15661281?v=4","gravatar_id":"","url":"https://api.github.com/users/utPLSQL","html_url":"https://github.com/utPLSQL","followers_url":"https://api.github.com/users/utPLSQL/followers","following_url":"https://api.github.com/users/utPLSQL/following{/other_user}","gists_url":"https://api.github.com/users/utPLSQL/gists{/gist_id}","starred_url":"https://api.github.com/users/utPLSQL/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/utPLSQL/subscriptions","organizations_url":"https://api.github.com/users/utPLSQL/orgs","repos_url":"https://api.github.com/users/utPLSQL/repos","events_url":"https://api.github.com/users/utPLSQL/events{/privacy}","received_events_url":"https://api.github.com/users/utPLSQL/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/utPLSQL/utPLSQL","description":"Ultimate PL/SQL Unit Testing Framework for Oracle","fork":false,"url":"https://api.github.com/repos/utPLSQL/utPLSQL","forks_url":"https://api.github.com/repos/utPLSQL/utPLSQL/forks","keys_url":"https://api.github.com/repos/utPLSQL/utPLSQL/keys{/key_id}","collaborators_url":"https://api.github.com/repos/utPLSQL/utPLSQL/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/utPLSQL/utPLSQL/teams","hooks_url":"https://api.github.com/repos/utPLSQL/utPLSQL/hooks","issue_events_url":"https://api.github.com/repos/utPLSQL/utPLSQL/issues/events{/number}","events_url":"https://api.github.com/repos/utPLSQL/utPLSQL/events","assignees_url":"https://api.github.com/repos/utPLSQL/utPLSQL/assignees{/user}","branches_url":"https://api.github.com/repos/utPLSQL/utPLSQL/branches{/branch}","tags_url":"https://api.github.com/repos/utPLSQL/utPLSQL/tags","blobs_url":"https://api.github.com/repos/utPLSQL/utPLSQL/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/utPLSQL/utPLSQL/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/utPLSQL/utPLSQL/git/refs{/sha}","trees_url":"https://api.github.com/repos/utPLSQL/utPLSQL/git/trees{/sha}","statuses_url":"https://api.github.com/repos/utPLSQL/utPLSQL/statuses/{sha}","languages_url":"https://api.github.com/repos/utPLSQL/utPLSQL/languages","stargazers_url":"https://api.github.com/repos/utPLSQL/utPLSQL/stargazers","contributors_url":"https://api.github.com/repos/utPLSQL/utPLSQL/contributors","subscribers_url":"https://api.github.com/repos/utPLSQL/utPLSQL/subscribers","subscription_url":"https://api.github.com/repos/utPLSQL/utPLSQL/subscription","commits_url":"https://api.github.com/repos/utPLSQL/utPLSQL/commits{/sha}","git_commits_url":"https://api.github.com/repos/utPLSQL/utPLSQL/git/commits{/sha}","comments_url":"https://api.github.com/repos/utPLSQL/utPLSQL/comments{/number}","issue_comment_url":"https://api.github.com/repos/utPLSQL/utPLSQL/issues/comments{/number}","contents_url":"https://api.github.com/repos/utPLSQL/utPLSQL/contents/{+path}","compare_url":"https://api.github.com/repos/utPLSQL/utPLSQL/compare/{base}...{head}","merges_url":"https://api.github.com/repos/utPLSQL/utPLSQL/merges","archive_url":"https://api.github.com/repos/utPLSQL/utPLSQL/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/utPLSQL/utPLSQL/downloads","issues_url":"https://api.github.com/repos/utPLSQL/utPLSQL/issues{/number}","pulls_url":"https://api.github.com/repos/utPLSQL/utPLSQL/pulls{/number}","milestones_url":"https://api.github.com/repos/utPLSQL/utPLSQL/milestones{/number}","notifications_url":"https://api.github.com/repos/utPLSQL/utPLSQL/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/utPLSQL/utPLSQL/labels{/name}","releases_url":"https://api.github.com/repos/utPLSQL/utPLSQL/releases{/id}","deployments_url":"https://api.github.com/repos/utPLSQL/utPLSQL/deployments","created_at":"2016-01-30T14:31:52Z","updated_at":"2018-03-30T00:31:53Z","pushed_at":"2018-03-30T00:31:56Z","git_url":"git://github.com/utPLSQL/utPLSQL.git","ssh_url":"git@github.com:utPLSQL/utPLSQL.git","clone_url":"https://github.com/utPLSQL/utPLSQL.git","svn_url":"https://github.com/utPLSQL/utPLSQL","homepage":"https://utplsql.org/","size":9149,"stargazers_count":177,"watchers_count":177,"language":"PLSQL","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":70,"mirror_url":null,"archived":false,"open_issues_count":38,"license":{"key":"apache-2.0","name":"Apache License 2.0","spdx_id":"Apache-2.0","url":"https://api.github.com/licenses/apache-2.0"},"forks":70,"open_issues":38,"watchers":177,"default_branch":"develop"}},"_links":{"self":{"href":"https://api.github.com/repos/utPLSQL/utPLSQL/pulls/604"},"html":{"href":"https://github.com/utPLSQL/utPLSQL/pull/604"},"issue":{"href":"https://api.github.com/repos/utPLSQL/utPLSQL/issues/604"},"comments":{"href":"https://api.github.com/repos/utPLSQL/utPLSQL/issues/604/comments"},"review_comments":{"href":"https://api.github.com/repos/utPLSQL/utPLSQL/pulls/604/comments"},"review_comment":{"href":"https://api.github.com/repos/utPLSQL/utPLSQL/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/utPLSQL/utPLSQL/pulls/604/commits"},"statuses":{"href":"https://api.github.com/repos/utPLSQL/utPLSQL/statuses/e968f76ec800af2cefbb1d10f768bbb2d216bd5c"}},"author_association":"COLLABORATOR"}}
{"actor":{"display_login":"jgebal"}}