update-sql

Liquibase updateSQL command as a service.

Description

This service is useful for projects that treat Liquibase changelog as single source of truth but deliver plain SQL files as well.
So, when developers finish updating the changelog, they can easily generate the corresponding SQL files.

The result of running this service should be equal to the CLI command below:

/path/to/liquibase-bin/liquibase --url=offline:<db-type> --changeLogFile=/path/to/changelog.yml updateSQL

Limitations

The service:

• currently, supports YAML and XML changelogs (not JSON)
• generates SQL for MySql, MariaDB, MSSQL and Oracle databases
• replaces external SQL files inclusion with -- Content placeholder (<file-name>)
• does not support external changelogs inclusion (will result in Bad Request)

Running

Docker

AMD64

docker run -d -p 8080:8080 polarfish/update-sql:1.1.0-amd64

ARM64

docker run -d -p 8080:8080 polarfish/update-sql:1.1.0-arm64

JAR

mvn clean package && java -jar target/update-sql*.jar

spring-boot-maven-plugin

mvn spring-boot:run

Screenshots