liquibase:updateSQL

Full name:

org.kuali.maven.plugins:liquibase-maven-plugin:2.0.2:updateSQL

Description:

Generates the SQL that is required to update the database to the current version as specified in the DatabaseChangeLogs.

Attributes:

  • Requires a Maven project to be executed.
  • Requires dependency resolution of artifacts in scope: test.

Optional Parameters

Name Type Since Description
changeLogFile String - Specifies the change log file to use for Liquibase.
changesToApply int - The number of changes to apply to the database. By default this value is 0, which will result in all changes (not already applied to the database) being applied.
Default value is: 0.
clearCheckSums boolean - Flag for forcing the checksums to be cleared from teh DatabaseChangeLog table.
Default value is: false.
contexts String - The Liquibase contexts to execute, which can be "," separated if multiple contexts are required. If no context is specified then ALL contexts will be executed.
databaseClass String - The class to use as the database object.
defaultSchemaName String - The default schema name to use the for database connection.
driver String - The fully qualified name of the driver class to use to connect to the database.
emptyPassword boolean - Deprecated. Use an empty or null value for the password instead.
Default value is: false.
expressionVariables Map - Array to put a expression variable to maven plugin.
expressionVars Properties - Array to put a expression variable to maven plugin.
includeArtifact boolean - Allows for the maven project artifact to be included in the class loader for obtaining the Liquibase property and DatabaseChangeLog files.
Default value is: true.
includeTestOutputDirectory boolean - Allows for the maven test output directory to be included in the class loader for obtaining the Liquibase property and DatabaseChangeLog files.
Default value is: true.
logging String - Controls the level of logging from Liquibase when executing. The value can be "all", "finest", "finer", "fine", "info", "warning", "severe" or "off". The value is case insensitive.
Default value is: INFO.
migrationSqlOutputFile File - The file to output the Migration SQL script to, if it exists it will be overwritten.
Default value is: ${project.build.directory}/liquibase/migrate.sql.
password String - The database password to use to connect to the specified database.
promptOnNonLocalDatabase boolean - Controls the prompting of users as to whether or not they really want to run the changes on a database that is not local to the machine that the user is current executing the plugin on.
Default value is: true.
propertyFile String - The Liquibase properties file used to configure the Liquibase Liquibase.
propertyFileWillOverride boolean - Flag allowing for the Liquibase properties file to override any settings provided in the Maven plugin configuration. By default if a property is explicity specified it is not overridden if it also appears in the properties file.
Default value is: false.
server String - The server id in settings.xml to use when authenticating with.
skip boolean - Set this to 'true' to skip running liquibase. Its use is NOT RECOMMENDED, but quite convenient on occasion.
systemProperties Properties - List of system properties to pass to the database.
url String - The Database URL to connect to for executing Liquibase.
username String - The database username to use to connect to the specified database.
verbose boolean - Controls the verbosity of the output from invoking the plugin.
Default value is: false.

Parameter Details

changeLogFile:

Specifies the change log file to use for Liquibase.
  • Type: java.lang.String
  • Required: No
  • Expression: ${liquibase.changeLogFile}

changesToApply:

The number of changes to apply to the database. By default this value is 0, which will result in all changes (not already applied to the database) being applied.
  • Type: int
  • Required: No
  • Expression: ${liquibase.changesToApply}
  • Default: 0

clearCheckSums:

Flag for forcing the checksums to be cleared from teh DatabaseChangeLog table.
  • Type: boolean
  • Required: No
  • Expression: ${liquibase.clearCheckSums}
  • Default: false

contexts:

The Liquibase contexts to execute, which can be "," separated if multiple contexts are required. If no context is specified then ALL contexts will be executed.
  • Type: java.lang.String
  • Required: No
  • Expression: ${liquibase.contexts}

databaseClass:

The class to use as the database object.
  • Type: java.lang.String
  • Required: No
  • Expression: ${liquibase.databaseClass}

defaultSchemaName:

The default schema name to use the for database connection.
  • Type: java.lang.String
  • Required: No
  • Expression: ${liquibase.defaultSchemaName}

driver:

The fully qualified name of the driver class to use to connect to the database.
  • Type: java.lang.String
  • Required: No
  • Expression: ${liquibase.driver}

emptyPassword:

Deprecated. Use an empty or null value for the password instead.
Use an empty string as the password for the database connection. This should not be used along side the password setting.
  • Type: boolean
  • Required: No
  • Expression: ${liquibase.emptyPassword}
  • Default: false

expressionVariables:

Array to put a expression variable to maven plugin.
  • Type: java.util.Map
  • Required: No

expressionVars:

Array to put a expression variable to maven plugin.
  • Type: java.util.Properties
  • Required: No

includeArtifact:

Allows for the maven project artifact to be included in the class loader for obtaining the Liquibase property and DatabaseChangeLog files.
  • Type: boolean
  • Required: No
  • Expression: ${liquibase.includeArtifact}
  • Default: true

includeTestOutputDirectory:

Allows for the maven test output directory to be included in the class loader for obtaining the Liquibase property and DatabaseChangeLog files.
  • Type: boolean
  • Required: No
  • Expression: ${liquibase.includeTestOutputDirectory}
  • Default: true

logging:

Controls the level of logging from Liquibase when executing. The value can be "all", "finest", "finer", "fine", "info", "warning", "severe" or "off". The value is case insensitive.
  • Type: java.lang.String
  • Required: No
  • Expression: ${liquibase.logging}
  • Default: INFO

migrationSqlOutputFile:

The file to output the Migration SQL script to, if it exists it will be overwritten.
  • Type: java.io.File
  • Required: No
  • Expression: ${liquibase.migrationSqlOutputFile}
  • Default: ${project.build.directory}/liquibase/migrate.sql

password:

The database password to use to connect to the specified database.
  • Type: java.lang.String
  • Required: No
  • Expression: ${liquibase.password}

promptOnNonLocalDatabase:

Controls the prompting of users as to whether or not they really want to run the changes on a database that is not local to the machine that the user is current executing the plugin on.
  • Type: boolean
  • Required: No
  • Expression: ${liquibase.promptOnNonLocalDatabase}
  • Default: true

propertyFile:

The Liquibase properties file used to configure the Liquibase Liquibase.
  • Type: java.lang.String
  • Required: No
  • Expression: ${liquibase.propertyFile}

propertyFileWillOverride:

Flag allowing for the Liquibase properties file to override any settings provided in the Maven plugin configuration. By default if a property is explicity specified it is not overridden if it also appears in the properties file.
  • Type: boolean
  • Required: No
  • Expression: ${liquibase.propertyFileWillOverride}
  • Default: false

server:

The server id in settings.xml to use when authenticating with.
  • Type: java.lang.String
  • Required: No
  • Expression: ${liquibase.server}

skip:

Set this to 'true' to skip running liquibase. Its use is NOT RECOMMENDED, but quite convenient on occasion.
  • Type: boolean
  • Required: No
  • Expression: ${liquibase.should.run}

systemProperties:

List of system properties to pass to the database.
  • Type: java.util.Properties
  • Required: No

url:

The Database URL to connect to for executing Liquibase.
  • Type: java.lang.String
  • Required: No
  • Expression: ${liquibase.url}

username:

The database username to use to connect to the specified database.
  • Type: java.lang.String
  • Required: No
  • Expression: ${liquibase.username}

verbose:

Controls the verbosity of the output from invoking the plugin.
  • Type: boolean
  • Required: No
  • Expression: ${liquibase.verbose}
  • Default: false