Repository navigation
Question - limiting the types to ignore triggers #215
Description
Hi
I am calling utplsql-cli via GitHub Actions on a runner server on OCI as ADMIN user. I pass in multiple schemas to be processed and am writing the documentation to a file and coverage html to a file. My question is: I do not want to report on coverage for triggers and I am not using Projects and files I am only using the database. Can yo advise how I do this.
Activity
jgebal commentedon Jan 16, 2023
At the moment there is no way to include/exclude objects in coverage by object type in utPLSQL core framework.
Also, the option for inclusion/exclusion of objects by regular expression is not implemented in
utPLSQL-cli.So your only option currently would be to provide a long list of object names to exclude.
It seems like a potential gap in utPLSQL capabilities.
Do you have a naming convention for triggers that would make it possible to exclude objects by part of name (prefix/suffix etc?)
Would filtering by list of object_names be an option?
Why does it hurt to have Triggers in the report? Are they not part of the project source-code?
clarkec21 commentedon Feb 3, 2023
Hi @jgebal thnks for your reply
I should have explained our triggers either contain calls to packages (already utplsql tested) or standard code auto generated by us to write to history/journal tables - the testing of these is a bit of an overhead.
We do have a standard naming convention but wildcards are not utilised so I would have to maintain a large ever changing list - we can just include in the coverage report them but ignore their % for now. Any progress on Issue 212 should help us.