database - liquibase可以在sql中有配置占位符吗

Question

liquibase在sql中可以有配置占位符吗？

示例代码:

<changeSet author="name" id="sql-example" runAlways="true" failOnError="true">
    <sql>SELECT schema.admin_insert('PARAMETER_PLACEHOLDER')</sql>
</changeSet>

我可以在属性文件中定义参数值吗？以便 liquibase 替换属性文件中的参数值？

Answer 1

是的，你可以。 Liquibase 称这些为“变更日志参数”

http://www.liquibase.org/documentation/changelog_parameters.html

该页面的简短摘录:

Liquibase allows dynamic substitution of parameters in a changelog. The parameters to replace are described using the ${parameterName} syntax.

Configuring parameter values

Parameter values are looked up in the following order:

• Passed as a parameter to your Liquibase runner (see Ant, command_line, etc. documentation for how to pass them)
• As a JVM system property
• In the parameters block (<property> Tag) of the DatabaseChangeLog file itself.

示例

<createTable tableName="${table.name}">
      <column name="id" type="int"/>
      <column name="${column1.name}" type="varchar(${column1.length})"/>
      <column name="${column2.name}" type="int"/> 
</createTable>