Parameters for <sqlFile> tags

Liquibase Development
1

Hi,


It’s still me and my parameters on sqlFile.


Since version 3.1.0, they are correctly taken into account inside sql File.


Now you can have :


changeSet1.xml :

  2. <?xml version="1.0" encoding="UTF-8"?>
  3. <databaseChangeLog
  4.   xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
  5.   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  6.   xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
  7.          http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.0.xsd">

  9. Idea : Being able to define parameters on different levels.


    Parameters on top level are usefull for many projects, but they can also be usefull if they are defined on :

    • changeSet level
      - and levels


    I don’t know if I’m the only one trying to use it this way, but I really think it would be a great feature.

2

I created https://liquibase.jira.com/browse/CORE-1746 and https://liquibase.jira.com/browse/CORE-1747 to track the features.


The reason I split them up is because while both are useful, parameters may work better. The paramter logic currently works like it does in Ant where once a parameter is set, the value cannot be changed. That has advantages, but it makes it so you can’t override values in a changset or changelog without breaking that logic and introducing backwards compatibility issues. 


It is a common request and there are ways to implement it, though, like adding a “override=true” flag or a scope=“changelog|changeset|global” flag