search

utPLSQL / utPLSQL-cli

Command line client for invoking utPLSQL
Apache License 2.0
40 stars 15 forks source link

Question - limiting the types to ignore triggers #215

Open clarkec21 opened 1 year ago

clarkec21 commented 1 year ago

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.

jgebal commented 1 year ago

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 commented 1 year ago

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.