impex:convertsql

Full name:

org.kuali.maven.plugins:maven-impex-plugin:1.1.7-SNAPSHOT:convertsql

Description:

Examine SQL files and convert the delimiter style from using a ; at the end of the line to a / on it's own line

Attributes:

  • Requires a Maven project to be executed.

Required Parameters

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

Optional Parameters

Name Type Since Description
encoding String - The encoding to use when reading/writing files
Default value is: ${project.build.sourceEncoding}.
excludes String - Files to exclude
includes String - Files to include
Default value is: *.sql.
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.

Parameter Details

encoding:

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

excludes:

Files to exclude
  • Type: java.lang.String
  • Required: No
  • Expression: ${impex.excludes}

includes:

Files to include
  • Type: java.lang.String
  • Required: No
  • Expression: ${impex.includes}
  • Default: *.sql

newDelimiter:

The new delimiter to put on its own line
  • Type: java.lang.String
  • Required: Yes
  • Expression: ${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
  • Expression: ${impex.oldDelimiter}
  • Default: ;

outputDir:

Directory to generate the converted files into
  • Type: java.io.File
  • Required: Yes
  • Expression: ${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
  • Expression: ${impex.skipIrrelevantLiquibaseMetadataLines}
  • Default: false

sourceDir:

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