impex:convertsql

Full name:

org.kuali.maven.plugins:maven-impex-plugin:1.1.13:convertsql

Description:

Examine SQL files and convert them to always use the delimiter / on it's own line. Convert any lines ending with ; to use a / on it's own line.

Attributes:

  • Requires a Maven project to be executed.

Required Parameters

Name Type Since Description
includes String - CSV list of regex patterns for files to include
Default value is: **/*.sql.
User property is: impex.includes.
newDelimiter String - The new delimiter to put on its own line
Default value is: /.
User property is: impex.newDelimiter.
oldDelimiter String - The old delimiter used to terminate a SQL statement by being present at the end of a line.
Default value is: ;.
User property is: impex.oldDelimiter.
outputDir File - Directory to generate the converted files into
Default value is: ${project.build.directory}/sql/output.
User property is: impex.outputDir.
sourceDir File - Directory to examine for .sql files
Default value is: ${project.build.directory}/sql/source.
User property is: impex.sourceDir.

Optional Parameters

Name Type Since Description
encoding String - The encoding to use when reading/writing files
Default value is: ${project.build.sourceEncoding}.
User property is: impex.encoding.
excludes String - CSV list of regex patterns for files to exclude
Default value is: **/.svn/**,**/.git/**.
User property is: impex.excludes.
skipIrrelevantLiquibaseMetadataLines boolean - Liquibase injects a handful of metadata at the top of each SQL file that causes "noise". All of the checksums and actual SQL may stay the same, but the Liquibase metadata makes it appear as though the resulting SQL file has changed. By omitting the metadata you can run the same change set multiple times and get the exact same SQL file as output. This makes it much easier to perform validation checks on the SQL.
Default value is: false.
User property is: impex.skipIrrelevantLiquibaseMetadataLines.

Parameter Details

encoding:

The encoding to use when reading/writing files
  • Type: java.lang.String
  • Required: No
  • User Property: impex.encoding
  • Default: ${project.build.sourceEncoding}

excludes:

CSV list of regex patterns for files to exclude
  • Type: java.lang.String
  • Required: No
  • User Property: impex.excludes
  • Default: **/.svn/**,**/.git/**

includes:

CSV list of regex patterns for files to include
  • Type: java.lang.String
  • Required: Yes
  • User Property: impex.includes
  • Default: **/*.sql

newDelimiter:

The new delimiter to put on its own line
  • Type: java.lang.String
  • Required: Yes
  • User Property: impex.newDelimiter
  • Default: /

oldDelimiter:

The old delimiter used to terminate a SQL statement by being present at the end of a line.
  • Type: java.lang.String
  • Required: Yes
  • User Property: impex.oldDelimiter
  • Default: ;

outputDir:

Directory to generate the converted files into
  • Type: java.io.File
  • Required: Yes
  • User Property: impex.outputDir
  • Default: ${project.build.directory}/sql/output

skipIrrelevantLiquibaseMetadataLines:

Liquibase injects a handful of metadata at the top of each SQL file that causes "noise". All of the checksums and actual SQL may stay the same, but the Liquibase metadata makes it appear as though the resulting SQL file has changed. By omitting the metadata you can run the same change set multiple times and get the exact same SQL file as output. This makes it much easier to perform validation checks on the SQL.
  • Type: boolean
  • Required: No
  • User Property: impex.skipIrrelevantLiquibaseMetadataLines
  • Default: false

sourceDir:

Directory to examine for .sql files
  • Type: java.io.File
  • Required: Yes
  • User Property: impex.sourceDir
  • Default: ${project.build.directory}/sql/source