utPLSQL-maven-plugin

Compatibility

Prerequisites

<dependency>    <groupId>com.oracle.database.jdbc</groupId>    <artifactId>ojdbc8</artifactId>    <version>21.3.0.0</version></dependency>

Usage

Skipping Tests

<configuration>    <skipUtplsqlTests>true</skipUtplsqlTests></configuration>

mvn install -DskipTests

Skipping by Default

<configuration>    <skipUtplsqlTests>true</skipUtplsqlTests></configuration>

mvn install -DskipUtplsqlTests=false

Configuration

<projectxmlns="http://maven.apache.org/POM/4.0.0"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">    <modelVersion>4.0.0</modelVersion>    <groupId>org.my_org</groupId>    <artifactId>my-artifact-name</artifactId>    <version>1.0.0</version>    <properties><!-- URL of the connection to the database.--><!-- Can also be passed as execution parameters.--><!-- -DdbUrl="jdbc:oracle:thin:@127.0.0.1:1521:xe"-->        <dbUrl>url_of_connection</dbUrl><!-- Database connection user.--><!-- -DdbUser="user"-->        <dbUser>user</dbUser><!-- Database connection password.--><!-- -DdbPassword="password"-->        <dbPass>password</dbPass>    </properties>    <build>        <plugins>            <plugin>                <groupId>org.utplsql</groupId>                <artifactId>utplsql-maven-plugin</artifactId>                <version>3.1.11</version>                <executions>                    <execution>                        <goals>                            <goal>test</goal>                        </goals>                        <configuration><!-- REQUIRED PARAMETERS--><!-- A list of tests suite paths.--><!-- The path(s) can be in one of the following formats:--><!--     schema[.package[.procedure]]--><!--     schema:suite[.suite[.suite][...]][.procedure]--><!-- Both formats can be mixed in the list.--><!-- If only schema is provided, then all suites--><!-- owned by that schema are executed.-->                            <paths>                                <path>schema_name</path>                            </paths>                            <sources>                                <source><!-- Path to project source files.-->                                    <directory>src/test/resources/scripts/sources</directory><!-- File patterns to include.-->                                    <includes>                                        <include>**/*pkg</include>                                        <include>**/*pkb</include>                                    </includes>                                </source>                            </sources>                            <tests>                                <test><!-- Path to project test files.-->                                    <directory>src/test/resources/scripts/test</directory><!-- File patterns to include.-->                                    <includes>                                        <include>**/*pkg</include>                                        <include>**/*pkb</include>                                    </includes>                                </test>                            </tests><!-- OPTIONAL PARAMETERS--><!-- Continue in case of failure.--><!-- Defaults to: ${maven.test.failure.ignore}-->                            <ignoreFailure>false</ignoreFailure><!-- Skip the utPLSQL version compatibility check.--><!-- Defaults to: false-->                            <skipCompatibilityCheck>false</skipCompatibilityCheck><!-- Skip the tests--><!-- Defaults to: false-->                            <skipUtplsqlTests>false</skipUtplsqlTests><!-- Enables DBMS_OUTPUT--><!-- Defaults to: false-->                            <dbmsOutput>false</dbmsOutput><!-- Sets a timeout around Reporter creation and retries when not ready after a while.--><!-- 0 = no timeout.-->                            <oraStuckTimeout>0</oraStuckTimeout><!-- A list of tags to run.-->                            <tags>                                <tag>test_tag</tag>                            </tags><!-- Enables random order of test executions.-->                            <randomTestOrder>true</randomTestOrder><!-- Sets the seed to use for random test execution order. If set, it sets -random to true.-->                            <randomTestOrderSeed>5</randomTestOrderSeed><!-- Comma-separated object list to include in the coverage report.--><!-- Format: [schema.]package[,[schema.]package ...].--><!-- See coverage reporting options in framework documentation.-->                            <includeObject>app.test1,app.test2</includeObject><!-- Comma-separated object list to exclude from the coverage report.--><!-- Format: [schema.]package[,[schema.]package ...].--><!-- See coverage reporting options in framework documentation.-->                            <excludeObject>app.test1,app.test2</excludeObject><!-- Regular expression to match against schema name to include in coverage-->                            <includeSchemaExpr>app.test1,app.test2</includeSchemaExpr><!-- Regular expression to match against schema name to exclude in coverage-->                            <excludeSchemaExpr>app.test1,app.test2</excludeSchemaExpr><!-- Regular expression to match against schema name to include in coverage-->                            <includeObjectExpr>app.test1,app.test2</includeObjectExpr><!-- Regular expression to match against object name to exclude in coverage-->                            <excludeObjectExpr>app.test1,app.test2</excludeObjectExpr><!-- List of reporters.--><!-- You can pass the name of the reporter and/or the output file--><!-- of the reporter and/or if the report is logged to the console.--><!-- If you don't pass any reporter, UT_DOCUMENTATION_REPORTER will be used.--><!-- This is a current list of the names of the reporters,--><!-- see UtPLSQL documentation in order to check the final list:--><!--     UT_DOCUMENTATION_REPORTER--><!--     UT_COVERAGE_HTML_REPORTER--><!--     UT_TEAMCITY_REPORTER--><!--     UT_XUNIT_REPORTER--><!--     UT_COVERALLS_REPORTER--><!--     UT_COVERAGE_SONAR_REPORTER--><!--     UT_SONAR_TEST_REPORTER-->                            <reporters>                                <reporter>                                    <name>UT_COVERAGE_SONAR_REPORTER</name><!-- The file output path.-->                                    <fileOutput>utplsql/coverage-sonar-reporter.xml</fileOutput><!-- Indicates if should write to console.-->                                    <consoleOutput>true</consoleOutput>                                </reporter>                                <reporter>                                    <name>UT_SONAR_TEST_REPORTER</name>                                    <fileOutput>utplsql/sonar-test-reporter.xml</fileOutput>                                    <consoleOutput>false</consoleOutput>                                </reporter>                                <reporter>                                    <name>UT_TEAMCITY_REPORTER</name>                                </reporter>                            </reporters><!-- Custom source code mapping options.--><!-- See coverage reporting options in framework documentation.-->                            <sourcesOwner>code_owner</sourcesOwner>                            <sourcesRegexExpression>.*/\w+/(\w+)/(\w+)\.\w{3}</sourcesRegexExpression>                            <sourcesOwnerSubexpression>app</sourcesOwnerSubexpression>                            <sourcesNameSubexpression>2</sourcesNameSubexpression>                            <sourcesTypeSubexpression>1</sourcesTypeSubexpression>                            <sourcesCustomTypeMapping>                                <customTypeMapping>                                    <type>package body</type>                                    <customMapping>package_bodies</customMapping>                                </customTypeMapping>                            </sourcesCustomTypeMapping><!-- Custom test code mapping options.--><!-- See coverage reporting options in framework documentation.-->                            <testsOwner>tests_owner</testsOwner>                            <testsRegexExpression>.*/\w+/(\w+)/(\w+)\.\w{3}</testsRegexExpression>                            <testsOwnerSubexpression>test</testsOwnerSubexpression>                            <testsNameSubexpression>2</testsNameSubexpression>                            <testsTypeSubexpression>1</testsTypeSubexpression>                            <testsCustomTypeMapping>                                <customTypeMapping>                                    <type>package body</type>                                    <customMapping>package_bodies</customMapping>                                </customTypeMapping>                            </testsCustomTypeMapping>                        </configuration>                    </execution>                </executions>            </plugin>        </plugins>    </build></project>

Comparison with utPLSQL CLI