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 all commits
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
151 changes: 130 additions & 21 deletions docs/userguide/coverage.md
View file
Open in desktop

Large diffs are not rendered by default.

175 changes: 146 additions & 29 deletions source/api/ut.pkb
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -131,7 +131,11 @@ create or replace package body ut is
a_client_character_set varchar2,
a_random_test_order integer,
a_random_test_order_seed positive,
a_tags varchar2 := null
a_tags varchar2 := null,
a_include_schema_expr varchar2 := null,
a_include_object_expr varchar2 := null,
a_exclude_schema_expr varchar2 := null,
a_exclude_object_expr varchar2 := null
) is
pragma autonomous_transaction;
begin
Expand All @@ -150,7 +154,11 @@ create or replace package body ut is
false,
ut_utils.int_to_boolean(a_random_test_order),
a_random_test_order_seed,
a_tags
a_tags,
a_include_schema_expr,
a_include_object_expr,
a_exclude_schema_expr,
a_exclude_object_expr
);
rollback;
end;
Expand All @@ -167,10 +175,15 @@ create or replace package body ut is
a_client_character_set varchar2,
a_random_test_order integer,
a_random_test_order_seed positive,
a_tags varchar2 := null
a_tags varchar2 := null,
a_include_schema_expr varchar2 := null,
a_include_object_expr varchar2 := null,
a_exclude_schema_expr varchar2 := null,
a_exclude_object_expr varchar2 := null
) is
pragma autonomous_transaction;
begin

a_reporter := coalesce(a_reporter,ut_documentation_reporter());
ut_runner.run(
a_paths,
Expand All @@ -186,7 +199,11 @@ create or replace package body ut is
false,
ut_utils.int_to_boolean(a_random_test_order),
a_random_test_order_seed,
a_tags
a_tags,
a_include_schema_expr,
a_include_object_expr,
a_exclude_schema_expr,
a_exclude_object_expr
);
rollback;
end;
Expand Down Expand Up @@ -227,7 +244,11 @@ create or replace package body ut is
a_client_character_set varchar2 := null,
a_random_test_order integer := 0,
a_random_test_order_seed positive := null,
a_tags varchar2 := null
a_tags varchar2 := null,
a_include_schema_expr varchar2 := null,
a_include_object_expr varchar2 := null,
a_exclude_schema_expr varchar2 := null,
a_exclude_object_expr varchar2 := null
) return ut_varchar2_rows pipelined is
l_reporter ut_reporter_base := a_reporter;
l_results sys_refcursor;
Expand All @@ -244,7 +265,11 @@ create or replace package body ut is
a_client_character_set,
a_random_test_order,
a_random_test_order_seed,
a_tags
a_tags,
a_include_schema_expr,
a_include_object_expr,
a_exclude_schema_expr,
a_exclude_object_expr
);
if l_reporter is of (ut_output_reporter_base) then
l_results := treat(l_reporter as ut_output_reporter_base).get_lines_cursor();
Expand All @@ -266,7 +291,11 @@ create or replace package body ut is
a_client_character_set varchar2 := null,
a_random_test_order integer := 0,
a_random_test_order_seed positive := null,
a_tags varchar2 := null
a_tags varchar2 := null,
a_include_schema_expr varchar2 := null,
a_include_object_expr varchar2 := null,
a_exclude_schema_expr varchar2 := null,
a_exclude_object_expr varchar2 := null
) return ut_varchar2_rows pipelined is
l_reporter ut_reporter_base := a_reporter;
l_results sys_refcursor;
Expand All @@ -283,7 +312,11 @@ create or replace package body ut is
a_client_character_set,
a_random_test_order,
a_random_test_order_seed,
a_tags
a_tags,
a_include_schema_expr,
a_include_object_expr,
a_exclude_schema_expr,
a_exclude_object_expr
);
if l_reporter is of (ut_output_reporter_base) then
l_results := treat(l_reporter as ut_output_reporter_base).get_lines_cursor();
Expand All @@ -306,7 +339,11 @@ create or replace package body ut is
a_client_character_set varchar2 := null,
a_random_test_order integer := 0,
a_random_test_order_seed positive := null,
a_tags varchar2 := null
a_tags varchar2 := null,
a_include_schema_expr varchar2 := null,
a_include_object_expr varchar2 := null,
a_exclude_schema_expr varchar2 := null,
a_exclude_object_expr varchar2 := null
) return ut_varchar2_rows pipelined is
l_reporter ut_reporter_base := a_reporter;
l_results sys_refcursor;
Expand All @@ -323,7 +360,11 @@ create or replace package body ut is
a_client_character_set,
a_random_test_order,
a_random_test_order_seed,
a_tags
a_tags,
a_include_schema_expr,
a_include_object_expr,
a_exclude_schema_expr,
a_exclude_object_expr
);
if l_reporter is of (ut_output_reporter_base) then
l_results := treat(l_reporter as ut_output_reporter_base).get_lines_cursor();
Expand All @@ -346,7 +387,11 @@ create or replace package body ut is
a_client_character_set varchar2 := null,
a_random_test_order integer := 0,
a_random_test_order_seed positive := null,
a_tags varchar2 := null
a_tags varchar2 := null,
a_include_schema_expr varchar2 := null,
a_include_object_expr varchar2 := null,
a_exclude_schema_expr varchar2 := null,
a_exclude_object_expr varchar2 := null
) return ut_varchar2_rows pipelined is
l_reporter ut_reporter_base := a_reporter;
l_results sys_refcursor;
Expand All @@ -363,7 +408,11 @@ create or replace package body ut is
a_client_character_set,
a_random_test_order,
a_random_test_order_seed,
a_tags
a_tags,
a_include_schema_expr,
a_include_object_expr,
a_exclude_schema_expr,
a_exclude_object_expr
);
if l_reporter is of (ut_output_reporter_base) then
l_results := treat(l_reporter as ut_output_reporter_base).get_lines_cursor();
Expand All @@ -386,7 +435,11 @@ create or replace package body ut is
a_client_character_set varchar2 := null,
a_random_test_order integer := 0,
a_random_test_order_seed positive := null,
a_tags varchar2 := null
a_tags varchar2 := null,
a_include_schema_expr varchar2 := null,
a_include_object_expr varchar2 := null,
a_exclude_schema_expr varchar2 := null,
a_exclude_object_expr varchar2 := null
) return ut_varchar2_rows pipelined is
l_reporter ut_reporter_base := a_reporter;
l_results sys_refcursor;
Expand All @@ -403,7 +456,11 @@ create or replace package body ut is
a_client_character_set,
a_random_test_order,
a_random_test_order_seed,
a_tags
a_tags,
a_include_schema_expr,
a_include_object_expr,
a_exclude_schema_expr,
a_exclude_object_expr
);
if l_reporter is of (ut_output_reporter_base) then
l_results := treat(l_reporter as ut_output_reporter_base).get_lines_cursor();
Expand All @@ -426,7 +483,11 @@ create or replace package body ut is
a_client_character_set varchar2 := null,
a_random_test_order integer := 0,
a_random_test_order_seed positive := null,
a_tags varchar2 := null
a_tags varchar2 := null,
a_include_schema_expr varchar2 := null,
a_include_object_expr varchar2 := null,
a_exclude_schema_expr varchar2 := null,
a_exclude_object_expr varchar2 := null
) return ut_varchar2_rows pipelined is
l_reporter ut_reporter_base := a_reporter;
l_results sys_refcursor;
Expand All @@ -443,7 +504,11 @@ create or replace package body ut is
a_client_character_set,
a_random_test_order,
a_random_test_order_seed,
a_tags
a_tags,
a_include_schema_expr,
a_include_object_expr,
a_exclude_schema_expr,
a_exclude_object_expr
);
if l_reporter is of (ut_output_reporter_base) then
l_results := treat(l_reporter as ut_output_reporter_base).get_lines_cursor();
Expand All @@ -467,7 +532,11 @@ create or replace package body ut is
a_force_manual_rollback boolean := false,
a_random_test_order boolean := false,
a_random_test_order_seed positive := null,
a_tags varchar2 := null
a_tags varchar2 := null,
a_include_schema_expr varchar2 := null,
a_include_object_expr varchar2 := null,
a_exclude_schema_expr varchar2 := null,
a_exclude_object_expr varchar2 := null
) is
l_reporter ut_reporter_base := a_reporter;
begin
Expand All @@ -487,7 +556,11 @@ create or replace package body ut is
a_force_manual_rollback,
a_random_test_order,
a_random_test_order_seed,
a_tags
a_tags,
a_include_schema_expr,
a_include_object_expr,
a_exclude_schema_expr,
a_exclude_object_expr
);
else
run_autonomous(
Expand All @@ -502,7 +575,11 @@ create or replace package body ut is
a_client_character_set,
ut_utils.boolean_to_int(a_random_test_order),
a_random_test_order_seed,
a_tags
a_tags,
a_include_schema_expr,
a_include_object_expr,
a_exclude_schema_expr,
a_exclude_object_expr
);
end if;
if l_reporter is of (ut_output_reporter_base) then
Expand All @@ -524,7 +601,11 @@ create or replace package body ut is
a_force_manual_rollback boolean := false,
a_random_test_order boolean := false,
a_random_test_order_seed positive := null,
a_tags varchar2 := null
a_tags varchar2 := null,
a_include_schema_expr varchar2 := null,
a_include_object_expr varchar2 := null,
a_exclude_schema_expr varchar2 := null,
a_exclude_object_expr varchar2 := null
) is
l_reporter ut_reporter_base := a_reporter;
begin
Expand All @@ -541,7 +622,11 @@ create or replace package body ut is
a_force_manual_rollback,
a_random_test_order,
a_random_test_order_seed,
a_tags
a_tags,
a_include_schema_expr,
a_include_object_expr,
a_exclude_schema_expr,
a_exclude_object_expr
);
end;

Expand All @@ -557,7 +642,11 @@ create or replace package body ut is
a_force_manual_rollback boolean := false,
a_random_test_order boolean := false,
a_random_test_order_seed positive := null,
a_tags varchar2 := null
a_tags varchar2 := null,
a_include_schema_expr varchar2 := null,
a_include_object_expr varchar2 := null,
a_exclude_schema_expr varchar2 := null,
a_exclude_object_expr varchar2 := null
) is
begin
ut.run(
Expand All @@ -573,7 +662,11 @@ create or replace package body ut is
a_force_manual_rollback,
a_random_test_order,
a_random_test_order_seed,
a_tags
a_tags,
a_include_schema_expr,
a_include_object_expr,
a_exclude_schema_expr,
a_exclude_object_expr
);
end;

Expand All @@ -589,7 +682,11 @@ create or replace package body ut is
a_force_manual_rollback boolean := false,
a_random_test_order boolean := false,
a_random_test_order_seed positive := null,
a_tags varchar2 := null
a_tags varchar2 := null,
a_include_schema_expr varchar2 := null,
a_include_object_expr varchar2 := null,
a_exclude_schema_expr varchar2 := null,
a_exclude_object_expr varchar2 := null
) is
begin
ut.run(
Expand All @@ -605,7 +702,11 @@ create or replace package body ut is
a_force_manual_rollback,
a_random_test_order,
a_random_test_order_seed,
a_tags
a_tags,
a_include_schema_expr,
a_include_object_expr,
a_exclude_schema_expr,
a_exclude_object_expr
);
end;

Expand All @@ -622,7 +723,11 @@ create or replace package body ut is
a_force_manual_rollback boolean := false,
a_random_test_order boolean := false,
a_random_test_order_seed positive := null,
a_tags varchar2 := null
a_tags varchar2 := null,
a_include_schema_expr varchar2 := null,
a_include_object_expr varchar2 := null,
a_exclude_schema_expr varchar2 := null,
a_exclude_object_expr varchar2 := null
) is
begin
ut.run(
Expand All @@ -638,7 +743,11 @@ create or replace package body ut is
a_force_manual_rollback,
a_random_test_order,
a_random_test_order_seed,
a_tags
a_tags,
a_include_schema_expr,
a_include_object_expr,
a_exclude_schema_expr,
a_exclude_object_expr
);
end;

Expand All @@ -655,7 +764,11 @@ create or replace package body ut is
a_force_manual_rollback boolean := false,
a_random_test_order boolean := false,
a_random_test_order_seed positive := null,
a_tags varchar2 := null
a_tags varchar2 := null,
a_include_schema_expr varchar2 := null,
a_include_object_expr varchar2 := null,
a_exclude_schema_expr varchar2 := null,
a_exclude_object_expr varchar2 := null
) is
begin
ut.run(
Expand All @@ -671,7 +784,11 @@ create or replace package body ut is
a_force_manual_rollback,
a_random_test_order,
a_random_test_order_seed,
a_tags
a_tags,
a_include_schema_expr,
a_include_object_expr,
a_exclude_schema_expr,
a_exclude_object_expr
);
end;

Expand Down
Loading