Skip to content

Latest commit

 

History

History
58 lines (47 loc) · 1.8 KB

README.md

File metadata and controls

58 lines (47 loc) · 1.8 KB

Spring Boot & Liquibase

It is an open source library used to track, manage and implement database changes.

Liquibase Benefits

  • Open source
  • The database is independent
  • Flexible (changes can be applied now or later)
  • Easy to read, easy to follow
  • Can be loaded into the versioning system
  • All database changes can be viewed in one place
  • Changes from multiple developers can be combined
  • Automatically detects entity changes and generates change-log file
  • Change log file supports multiple formats (yaml, json, xml, sql)
  • Differences between two databases can be taken
  • Undo changes (rollback)
  • Liquibase keeps track of history (databasechangelog table)

Generate Diff Change log

mvn clean compile liquibase:diff -Dliquibase.url=jdbc:postgresql://localhost:5432/spring-boot-liquibase -Dliquibase.referenceUrl=hibernate:spring:io.perasoft?dialect=org.hibernate.dialect.PostgreSQLDialect&hibernate.physical_naming_strategy=org.springframework.boot.orm.jpa.hibernate.SpringPhysicalNamingStrategy&hibernate.implicit_naming_strategy=org.springframework.boot.orm.jpa.hibernate.SpringImplicitNamingStrategy

Update

mvn clean compile liquibase:update -Dliquibase.url=jdbc:postgresql://localhost:5432/spring-boot-liquibase

Rollback

mvn clean compile liquibase:rollback -Dliquibase.url=jdbc:postgresql://localhost:5432/spring-boot-liquibase -Dliquibase.rollbackCount=1

NOTE: rollback command does not work for sql files

Other helpful commands

  • To find out what the instruction set does
mvn liquibase:help
  • To see the history record (databasechangelog table)
mvn liquibase:history
  • To see if there is a lock on the databasechangeloglock table
mvn liquibase:listLocks
  • Release locks on databasechangeloglock table
mvn liquibase:releaseLocks