Feature - include/exclude objects and schemas by regex by lwasylow · Pull Request #1186 · utPLSQL/utPLSQL · GitHub

Adding support for inclusion and exclusion of objects and schemas using regex.

begin
  ut.run(
    a_path => 'unit_test_schema', 
    a_reporter => ut_coverage_html_reporter(), 
    a_include_schema_expr => '(user_...)|(..._user)',
    a_include_object_expr => '(bonus.*)|(.*_process_.*)',
    a_exclude_schema_expr => '(user_t..)|(t.._user)',
    a_exclude_object_expr => '(.*award.*)|(.*calc.*)'
  );
end;

Current approach is that a_include_object_expr and a_include_schema_expr silently overwrites a_include_object_expr

Closes #1053

Codecov Report

Merging #1186 (2533638) into develop (cc75f85) will decrease coverage by 0.38%.
The diff coverage is 93.93%.

@@             Coverage Diff             @@
##           develop    #1186      +/-   ##
===========================================
- Coverage    94.77%   94.39%   -0.39%     
===========================================
  Files          104      107       +3     
  Lines         4881     5063     +182     
  Branches        22       22              
===========================================
+ Hits          4626     4779     +153     
- Misses         247      277      +30     
+ Partials         8        7       -1

Flag	Coverage Δ
11XE	93.67% <93.93%> (-0.49%)	⬇️
12.1EE	93.69% <93.93%> (-0.42%)	⬇️
18XE	94.02% <93.93%> (-0.40%)	⬇️
21XE	94.19% <93.93%> (-0.41%)	⬇️

Flags with carried forward coverage won't be shown. Click here to find out more.

Impacted Files	Coverage Δ
source/api/ut.pkb	93.26% <ø> (ø)
source/api/ut_runner.pkb	95.32% <ø> (+1.86%)	⬆️
source/core/coverage/ut_coverage.pkb	97.05% <93.10%> (+15.00%)	⬆️
source/core/types/ut_coverage_options.tpb	100.00% <100.00%> (+15.78%)	⬆️
...ource/reporters/ut_coverage_report_html_helper.pkb	52.77% <0.00%> (ø)
source/reporters/ut_coverage_html_reporter.tpb	88.88% <0.00%> (ø)
source/reporters/ut_coveralls_reporter.tpb	74.28% <0.00%> (ø)
source/core/ut_utils.pkb	94.44% <0.00%> (+0.25%)	⬆️
...ource/reporters/ut_coverage_cobertura_reporter.tpb	96.96% <0.00%> (+3.03%)	⬆️
... and 5 more

Continue to review full report at Codecov.

Legend - Click here to learn more
Δ = absolute <relative> (impact), ø = not affected, ? = missing data
Powered by Codecov. Last update b4d72e3...2533638. Read the comment docs.

Unit Test Results

      1 files       2 suites 3m 5s ⏱️
1 039 tests 1 035 ✔️ 4 💤 0 ❌
1 042 runs 1 034 ✔️ 8 💤 0 ❌

Results for commit 2533638.

♻️ This comment has been updated with latest results.

…ture/1053_exclude_include_cov_by_regex Adding supporting tests

@lwasylow
It would probably be good to have those new parameters exposed in utPLSQLcli/SQLDeveloper/PL-SQLDeveloper/maven-plugin.

Can you open issues in corresponding projects, once this PR is complete and merged?

Dealing with precedence. Adding some more tests.

…e table types. Update docs.

…de_include_cov_by_regex

…SQL with coverage into main testing session coverage.

…de_include_cov_by_regex

…PLSQL

Fixed datatype for ut_coverage_options.tps attributes Formatting.

Kudos, SonarCloud Quality Gate passed!

0 Bugs
0 Vulnerabilities
0 Security Hotspots
0 Code Smells

95.2% Coverage
0.0% Duplication

Initial checkin for exclude objects regex.

0c57a9c

lwasylow added 2 commits February 22, 2022 11:21

commit changes

8370aa9

Merge branch 'develop' of https://github.com/utPLSQL/utPLSQL into fea…

fc7bee9

…ture/1053_exclude_include_cov_by_regex Adding supporting tests

jgebal reviewed Feb 23, 2022

View reviewed changes

Comment thread source/core/coverage/ut_coverage.pkb Outdated

jgebal reviewed Feb 23, 2022

View reviewed changes

Comment thread source/core/coverage/ut_coverage.pkb Outdated

jgebal reviewed Feb 23, 2022

View reviewed changes

Comment thread source/core/coverage/ut_coverage.pkb Outdated

jgebal reviewed Feb 23, 2022

View reviewed changes

Comment thread source/core/coverage/ut_coverage.pkb Outdated

lwasylow added 3 commits February 25, 2022 00:05

Making more changes

7b9e085

Update to code to address sql injection concerns.

4eec03e

Dealing with precedence. Adding some more tests.

Splitting skipped framework objects and excluded objects into separat…

e7d59b4

…e table types. Update docs.

jgebal added this to the 3.1.13 milestone Feb 25, 2022

jgebal reviewed Feb 25, 2022

View reviewed changes

Comment thread source/core/types/ut_coverage_options.tps Outdated

jgebal added 2 commits February 26, 2022 01:25

Update of coverage documentation

6f5b2dc

Fixed typo in documentation

b430b43

jgebal changed the title Initial checkin for exclude objects regex. Feature - include/exclude objects and schemas by regex Feb 26, 2022

jgebal added the enhancement label Feb 26, 2022

jgebal and others added 11 commits February 26, 2022 02:57

Merge remote-tracking branch 'origin/develop' into feature/1053_exclu…

efa78a3

…de_include_cov_by_regex

Added ability to publish coverage generated by test jobs running utPL…

4ab0f58

…SQL with coverage into main testing session coverage.

Merge remote-tracking branch 'origin/develop' into feature/1053_exclu…

5201f2a

…de_include_cov_by_regex

Adding extra tests for code coverage

a84246b

Added extra coverage for file mapping.

090207c

g_coverage_run_id is now reset after coverage collection is stopped.

df31fba

Improved coverage collection scope and stability on self-tests for ut…

0a2f478

…PLSQL

Coverage documentation improvements.

bd05e4c

Fixed datatype for ut_coverage_options.tps attributes Formatting.

Coverage documentation improvements.

3b9b626

Fixing flaky test

3bdb9d0

Update of coverage.md

7cca6b4

Update coverage.md

2533638

jgebal merged commit 428eda5 into develop Mar 2, 2022

jgebal deleted the feature/1053_exclude_include_cov_by_regex branch March 3, 2022 00:09

Feature - include/exclude objects and schemas by regex by lwasylow · Pull Request #1186 · utPLSQL/utPLSQL · GitHub

Uh oh!

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

Feature - include/exclude objects and schemas by regex#1186
jgebal merged 20 commits into
developfrom
feature/1053_exclude_include_cov_by_regex

lwasylow commented Feb 9, 2022

Uh oh!

codecov Bot commented Feb 9, 2022 •
edited
Loading

Uh oh!

Uh oh!

github-actions Bot commented Feb 9, 2022 •
edited
Loading

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

jgebal commented Feb 23, 2022

Uh oh!

Uh oh!

Uh oh!

sonarqubecloud Bot commented Mar 2, 2022

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

2 participants

Feature - include/exclude objects and schemas by regex by lwasylow · Pull Request #1186 · utPLSQL/utPLSQL · GitHub

Uh oh!

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

Feature - include/exclude objects and schemas by regex#1186jgebal merged 20 commits intodeveloputPLSQL/utPLSQL:developfrom feature/1053_exclude_include_cov_by_regexutPLSQL/utPLSQL:feature/1053_exclude_include_cov_by_regexCopy head branch name to clipboard

Conversation

lwasylow commented Feb 9, 2022

Uh oh!

codecov Bot commented Feb 9, 2022 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Codecov Report

Uh oh!

github-actions Bot commented Feb 9, 2022 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Unit Test Results

Uh oh!

Uh oh!

Uh oh!

Uh oh!

jgebal commented Feb 23, 2022

Uh oh!

Uh oh!

Uh oh!

sonarqubecloud Bot commented Mar 2, 2022

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

2 participants

Feature - include/exclude objects and schemas by regex#1186
jgebal merged 20 commits into
developfrom
feature/1053_exclude_include_cov_by_regex

codecov Bot commented Feb 9, 2022 •
edited
Loading

github-actions Bot commented Feb 9, 2022 •
edited
Loading