liquibase preconditions yaml

Question

Is it possible to use Precondition in YAML i didn't find any sources except this page http://www.liquibase.org/documentation/yaml_format.html

But I am looking for the equivalent of :

<changeSet id="addColumn-example">
  <preConditions onFail="MARK_RAN">
     <columnExists schemaName="earls" 
           tableName="category" columnName="display_name"/>
  </preConditions>
  <dropColumn columnName="display_name" schemaName="earls" tableName="category"/>
</changeSet>

So my natural translation will be :

changeSet:
  id: addColumn-example
  author: francis
  preConditions:
    - columnExist:
      schemaName: earls
      tableName: category
      columnName: display_name                    
  changes:
    - addColumn:
      columns:
        - column:
          name: display_name
          type: varchar(100)

But i am missing onFail...

Did you ever figure out an answer for this? I'm to do the same thing, but can't figure out how to do onFail: MARK_RAN. — Matt Raible, Oct 03 '14 at 20:35
For what I remember from this issue (in 2014), it was simply not possible with YAML, I had to do it with XML. But maybe with the new version it should be working now. — Cifren, Mar 17 '16 at 10:14

score 27 · Answer 1 · edited Apr 29 '20 at 06:45

this topic is poor documented, but after many tries... you can write something like this:

databaseChangeLog:
  - changeSet:
      id: 1
      author: pazfernando
      preConditions:
        - onFail: MARK_RAN
        - tableExists:
            schemaName: sa
            tableName: PROVEEDORBIENSERVICIO
      changes:
        - renameTable:
            newTableName: PROVEEDORBIENSERVICIO
            oldTableName: PROVEEDORSERVICIO
            schemaName: sa

Here is another example with the sqlCheck:

preConditions:
  - onFail: CONTINUE
  - onError: CONTINUE
  - sqlCheck:
      expectedResult: 0
      sql: select count(*) from oss_organization where Status is null
  - sqlCheck:
      expectedResult: 0
      sql: select count(*) from oss_organization where Type is null

Everything in liquibase is poorly documented – Dave May 07 '19 at 02:38 — Dave, May 07 '19 at 02:38

score 7 · Answer 2 · answered Oct 03 '14 at 20:43

7

The following seems to work:

databaseChangeLog:
  - changeSet:
      id: 1
      author: mraible
      preConditions:
        onFail: MARK_RAN
        not:
          sequenceExists:
            schemaName: public
            sequenceName: hibernate_sequence
      changes:
      - createSequence:
          sequenceName: hibernate_sequence

answered Oct 03 '14 at 20:43

Matt Raible

8,187
9
61
120

actually this is the correct syntax. It is a double negation. `*Exists` is returning `true`, but the `MARK_RAN` is `onFail` so the `not:` is needed to negate the response to `false` to meet `onFail` condition. Sadly there is no `onSuccess` :( – Markus Mar 20 '23 at 16:02

score 2 · Answer 3 · answered Sep 25 '18 at 14:07

Syntax for sqlCheck condition:

databaseChangeLog:
- changeSet:
    id: changeSet-id
    author: myName
    preConditions:
      - onFail: MARK_RAN
      - sqlCheck:
          expectedResult: 1
          sql: "select count(*) from foo where some-condition"
    changes:
      - sql: "your sql script"

score 1 · Answer 4 · answered Jun 02 '14 at 20:23

1

It is probably something that didn't work with Liquibase 3.1.x but should work in the just-released 3.2.0 version. Your example changeSet should be right.

answered Jun 02 '14 at 20:23

Nathan Voxland

15,453
2
48
64

score 0 · Answer 5 · answered Nov 18 '19 at 11:53

DBMS precondition

databaseChangeLog:
  - changeSet:
      id: 1
      author: yourname
      dbms: oracle,h2
      changes:
        - sql: "your sql script"

As you can see, this is not a real precondition, but I found it to be working similar: the changeset is ignored if the database type is not matching.

liquibase preconditions yaml

5 Answers5