Skip to content

Feature - include/exclude objects and schemas by regex #1186

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
jgebal merged 20 commits into from
Mar 2, 2022
Merged

Feature - include/exclude objects and schemas by regex #1186

Show file tree
Hide file tree
Changes from 1 commit
Commits
Show all changes
20 commits
Select commit Hold shift + click to select a range
0c57a9c
Initial checkin for exclude objects regex.
lwasylow Feb 9, 2022
8370aa9
commit changes
lwasylow Feb 22, 2022
fc7bee9
Merge branch 'develop' of https://github.com/utPLSQL/utPLSQL into fea…
lwasylow Feb 23, 2022
7b9e085
Making more changes
lwasylow Feb 25, 2022
4eec03e
Update to code to address sql injection concerns.
lwasylow Feb 25, 2022
e7d59b4
Splitting skipped framework objects and excluded objects into separat…
lwasylow Feb 25, 2022
6f5b2dc
Update of coverage documentation
jgebal Feb 25, 2022
b430b43
Fixed typo in documentation
jgebal Feb 25, 2022
efa78a3
Merge remote-tracking branch 'origin/develop' into feature/1053_exclu…
jgebal Feb 26, 2022
4ab0f58
Added ability to publish coverage generated by test jobs running utPL…
jgebal Feb 26, 2022
5201f2a
Merge remote-tracking branch 'origin/develop' into feature/1053_exclu…
jgebal Feb 26, 2022
a84246b
Adding extra tests for code coverage
lwasylow Feb 27, 2022
090207c
Added extra coverage for file mapping.
lwasylow Feb 27, 2022
df31fba
g_coverage_run_id is now reset after coverage collection is stopped.
jgebal Feb 27, 2022
0a2f478
Improved coverage collection scope and stability on self-tests for ut…
jgebal Feb 27, 2022
bd05e4c
Coverage documentation improvements.
jgebal Mar 1, 2022
3b9b626
Coverage documentation improvements.
jgebal Mar 1, 2022
3bdb9d0
Fixing flaky test
jgebal Mar 2, 2022
7cca6b4
Update of coverage.md
jgebal Mar 2, 2022
2533638
Update coverage.md
jgebal Mar 2, 2022
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
Improved coverage collection scope and stability on self-tests for ut… 
…PLSQL
  • Loading branch information
@jgebal
jgebal committed Feb 27, 2022
commit 0a2f478aa0c68753be358db0c9a4857a25c1361b
22 changes: 15 additions & 7 deletions test/ut3_tester_helper/coverage_helper.pkb
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -341,7 +341,7 @@ create or replace package body coverage_helper is
e_exists exception;
pragma exception_init ( e_exists, -955 );
begin
execute immediate 'create table test_results (text varchar2(4000))';
execute immediate 'create table test_results (id integer, text varchar2(4000))';
exception
when e_exists then
null;
Expand All @@ -368,9 +368,10 @@ create or replace package body coverage_helper is
declare
l_results ut3_develop.ut_varchar2_list;
begin
select *
select text
bulk collect into l_results
from test_results;
from test_results
order by id;
delete from test_results;
commit;
:clob_results := ut3_tester_helper.main_helper.table_to_clob(l_results);
Expand Down Expand Up @@ -453,7 +454,7 @@ create or replace package body coverage_helper is
l_result := ut3_develop.ut_coverage.get_coverage_data(l_coverage_options);
ut3_develop.ut_coverage.set_develop_mode(a_develop_mode => false);
ut3_develop.ut_runner.coverage_stop();
insert into test_results select owner||'.'||name from ut3_develop.ut_coverage_sources_tmp;
insert into test_results select rownum, owner||'.'||name from ut3_develop.ut_coverage_sources_tmp;
commit;
end;]';
l_plsql_block := replace(l_plsql_block,'{a_cov_options}',a_cov_options);
Expand All @@ -462,9 +463,10 @@ create or replace package body coverage_helper is
declare
l_results ut3_develop.ut_varchar2_list;
begin
select *
select text
bulk collect into l_results
from test_results;
from test_results
order by id;
delete from test_results;
commit;
:clob_results := ut3_tester_helper.main_helper.table_to_clob(l_results);
Expand All @@ -483,7 +485,13 @@ create or replace package body coverage_helper is
l_plsql_block := q'[
begin
ut3_develop.ut_runner.coverage_start(']'||rawtohex(l_coverage_id)||q'[');
insert into test_results select * from table( {a_run_command} );
ut3_develop.ut_coverage.set_develop_mode(a_develop_mode => true);
--gather coverage on the command executed
begin {a_run_command}; end;
ut3_develop.ut_coverage.set_develop_mode(a_develop_mode => false);
ut3_develop.ut_runner.coverage_stop();
--get the actual results of the command gathering the coverage
insert into test_results select rownum as id, x.* from table( {a_run_command} ) x;
commit;
end;]';
l_plsql_block := replace(l_plsql_block,'{a_run_command}',a_run_command);
Expand Down
4 changes: 2 additions & 2 deletions test/ut3_user/reporters/test_coverage/test_proftab_coverage.pkb
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -137,14 +137,14 @@ create or replace package body test_proftab_coverage is

--Act
insert into test_results
select *
select rownum, x.*
from table(
ut3_develop.ut.run(
a_path => 'ut3_develop:coverage_testing',
a_reporter=> ut3_develop.ut_coverage_sonar_reporter( ),
a_include_objects => ut3_develop.ut_varchar2_list( 'ut3_develop.{p}' )
)
);
) x;
commit;
end;
]';
Expand Down