Liquibase

Path Settings

export MYSQL_HOME=/usr/local/mysql
export PATH=$PATH:$MYSQL_HOME/bin

Configuration

mkdir -p $HOME/.chorke/etc/liquibase/init
cp ./src/test/resources/liquibase/*.properties $HOME/.chorke/etc/liquibase/init
cd $HOME/.chorke/etc/liquibase/init
explorer .

Migration Commands

Command Syntax

This syntax developed by considering four types of profiles. Please find the details in Profiles. Where default profiles are blank. Need not to mention in Maven build.

# mvn clean install -P[[[diff]database,]context,]command
# mvn clean install -P[[[dat,]mys,]dev,]log

mvn clean install -Pmys,dev,log      # mysql , development
mvn clean install -Pora,pro,log      # oracle, production
mvn clean install -Pdev,log          # h2    , development
mvn clean install -Plog              # h2    , development

Generate Change Log

# exclude data mvn clean install -Pmys,dev,log # mysql , development mvn clean install -Pora,pro,log # oracle, production mvn clean install -Pdev,log # h2 , development mvn clean install -Plog # h2 , development

# include data mvn clean install -Pdat,mys,dev,log # mysql , development mvn clean install -Pdat,ora,pro,log # oracle, production mvn clean install -Pdat,dev,log # h2 , development mvn clean install -Pdat,log # h2 , development

Differential Change Log

# exclude data mvn clean install -Pmys,dev,dif # mysql , development mvn clean install -Pora,pro,dif # oracle, production mvn clean install -Pdev,dif # h2 , development mvn clean install -Pdif # h2 , development

# include data mvn clean install -Pdat,mys,dev,dif # mysql , development mvn clean install -Pdat,ora,pro,dif # oracle, production mvn clean install -Pdat,dev,dif # h2 , development mvn clean install -Pdat,dif # h2 , development

Synchronize Change Log

mvn clean install -Pmys,dev,syn                        # mysql , development
mvn clean install -Pora,pro,syn                        # oracle, production
mvn clean install -Pdev,syn                            # h2    , development
mvn clean install -Psyn                                # h2    , development

Migrate/Update Database

mvn clean install -Pmys,dev,upd                        # mysql , development
mvn clean install -Pora,pro,upd                        # oracle, production
mvn clean install -Pdev,upd                            # h2    , development
mvn clean install -Pupd                                # h2    , development

Rollback Change Log

mvn clean install -Pmys,dev,rol -chorke.tag=20131216   # mysql , development
mvn clean install -Pora,pro,rol -chorke.tag=20131216   # oracle, production
mvn clean install -Pdev,rol -chorke.tag=20131216       # h2    , development
mvn clean install -Prol -chorke.tag=20131216           # h2    , development

Drop All/Clean Database

mvn clean install -Pmys,dev,del                        # mysql , development
mvn clean install -Pora,pro,del                        # oracle, production
mvn clean install -Pdev,del                            # h2    , development
mvn clean install -Pdel                                # h2    , development

Profiles

Four types of profiles are considerate for Maven build. Please find those profiles details are as respectively as below:

1. Diff (dat, default)
2. Database (der, h2d, hsq, mys, ora, pos, default)
3. Context (dev, qac, uat, pro, default)
4. Command (log, dif, syn, upd, cle, rol, del)

Where default profiles are blank. Need not to mention in Maven build.

Diff

Porfile	Note	Diff Types
dat	Include Data	tables,views,columns,indexes,foreignkeys,primarykeys,uniqueconstraints,data
default	Exclude Data	tables,views,columns,indexes,foreignkeys,primarykeys,uniqueconstraints

Database

Porfile	Database	Type	JDBC	Notes
der	Apache Derby	derby	jdbc:derby	No Issues
h2d	H2	h2	jdbc:h2:file	No Issues
hsq	HSQL	hsqldb	jdbc:hsqldb:file	No Issues
mys	MySQL	mysql	jdbc:mysql	No Issues
ora	Oracle	oracle	jdbc:oracle:thin	11g driver for diff with AL32UTF8 or AL16UTF16
pos	PostgreSQL	postgresql	jdbc:postgresql	8.2+ for drop all database objects
default	MySQL	mysql	jdbc:mysql	No Issues

Context

Porfile	Context	Notes
dev	Development	Development Environment
qac	Quality Assurance & Control	QAC Environment
uat	User Acceptance Test	UAT Environment
pro	Production	Production Environment
default	Development	Development Environment

Command

Porfile	Commands	Notes
log	generateChangeLog	Generate Change Log
dif	diff	Generate Database Diff Change Log
syn	changelogSync	Synchronize Database with Change Log
upd	update	Migration/Update Database
cle	clearCheckSums	Removes current checksums, on next run recomputed
rol	rollback	Rollback Database to the Date/Tag
del	dropAll	Empty/Clean Database

Notes

<plugin>
    <groupId>org.liquibase</groupId>
    <artifactId>liquibase-maven-plugin</artifactId>
    <configuration>
        <changeSetAuthor>chorke</changeSetAuthor>
        <changeSetContext>dev,qac,uat,pro</changeSetContext>
        <dataDir>${project.build.directory}/${change.on}</dataDir>
        <changeLogFile>META-INF/migrations/db.changelog-master.xml</changeLogFile>
        <propertyFile>${user.home}/.chorke/etc/liquibase/init/${chorke.env}.properties</propertyFile>
        <diffTypes>tables,views,columns,indexes,foreignkeys,primarykeys,uniqueconstraints,data</diffTypes>
        <outputChangeLogFile>${project.build.directory}/db.changelog-V${version.chorke.version}_${change.on}.xml</outputChangeLogFile>
        <diffIncludeObjects>table:T.*,</diffIncludeObjects>
        <contexts>${chorke.ctx}</contexts>
    </configuration>
    <executions>
        <execution>
            <phase>prepare-package</phase>
            <goals><goal>generateChangeLog</goal></goals>
        </execution>
    </executions>
</plugin>

References

• Database Independent Script in Liquibase
• Liquibase Migration Example
• Java Persistence/Inheritance
• Liquibase Documentation
• Generate Change Log
• Diff Exclude Objects
• Diff Include Objects
• Epoch Converter