Liquibase Ant Implementation

├─ build.xml ├─ ivysettings.xml ├─ ivy.xml └─ ant ├─ build.js └─ build.properties

SELECT id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id FROM databasechangelog;

SELECT id, locked, lockgranted, lockedby FROM databasechangeloglock;

Settings

ivysettings.xml

<ivysettings>
    <settings defaultResolver="chorke.chain"/>
    <caches defaultCacheDir="${basedir}/.ivy2/cache"/>
    <credentials host="mvn.chorke.org" realm="Authorization" username="maven" passwd="chorke"/>
    <resolvers>
        <ibiblio name="central" m2compatible="true"/>
        <ibiblio name="chorke.public" root="http://mvn.chorke.org/m2/public" m2compatible="true"/>
        <ibiblio name="chorke.releases" root="http://mvn.chorke.org/m2/releases" m2compatible="true"/>
        <chain name="chorke.chain">
            <resolver ref="central"/>
            <resolver ref="chorke.public"/>
            <resolver ref="chorke.releases"/>
        </chain>
    </resolvers>
    <modules>
        <module organisation="com.oracle.jdbc" resolver="chorke.public"/>
    </modules>
</ivysettings>

Ivy

ivy.xml

<ivy-module version="2.0">
    <info organisation="org.chorke.make" module="chorke-make-migrat" status="integration"/>
    <configurations>
        <conf name="compile" description="compile time dependencies"/>
        <conf name="runtime" description="run-time dependencies" extends="compile"/>
        <conf name="test" description="unit testing dependencies" extends="runtime"/>
        <conf name="build" description="ant dependencies"/>
    </configurations>
    <dependencies>
        <dependency org="org.liquibase" name="liquibase-core" rev="3.5.3" conf="build->default"/>
        <dependency org="ant-contrib" name="ant-contrib" rev="1.0b3" conf="build->default">
            <exclude org="ant" module="ant"/>
        </dependency>

        <!-- vendor specific jdbc driver to perform liquibase migration -->
        <dependency org="com.microsoft.sqlserver" name="mssql-jdbc" rev="6.2.2.jre7" conf="build->default"/>
        <dependency org="org.apache.derby" name="derbyclient" rev="10.10.2.0" conf="build->default"/>
        <dependency org="postgresql" name="postgresql" rev="9.0-801.jdbc4" conf="build->default"/>
        <dependency org="mysql" name="mysql-connector-java" rev="5.1.21" conf="build->default"/>
        <dependency org="org.apache.derby" name="derby" rev="10.10.2.0" conf="build->default"/>
        <dependency org="com.oracle.jdbc" name="ojdbc6" rev="11.2.0.4" conf="build->default">
            <exclude org="com.oracle.jdbc" module="xmlparserv2"/>
            <exclude org="com.oracle.jdbc" module="oraclepki"/>
            <exclude org="com.oracle.jdbc" module="osdt_cert"/>
            <exclude org="com.oracle.jdbc" module="osdt_core"/>
            <exclude org="com.oracle.jdbc" module="orai18n"/>
            <exclude org="com.oracle.jdbc" module="xdb6"/>
        </dependency>
        <dependency org="com.h2database" name="h2" rev="1.4.190" conf="build->default"/>
        <dependency org="org.hsqldb" name="hsqldb" rev="2.3.3" conf="build->default"/>
    </dependencies>
</ivy-module>

Ant Build

build.xml

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<project name="chorke" default="cki.ini" basedir="." 
    xmlns:liq="antlib:liquibase.integration.ant"
    xmlns:ivy="antlib:org.apache.ivy.ant" 
    xmlns:con="antlib:net.sf.antcontrib">

    <description>chorke ant ivy impl</description>
    <property name="ant.dir" location="${basedir}/ant"/>
    <property name="ant.lib" location="${user.home}/.ant/lib"/>
    <property name="chorke.home" location="${user.home}/.chorke"/>
    <available file="${ant.lib}/ivy.jar" property="ivy.jar.exist"/>
    <property name="academia.home" location="${chorke.home}/academia"/>
    <property name="sonatype.local" value="https://repository.sonatype.org/service/local"/>
    <property name="central.proxy" value="${sonatype.local}/artifact/maven/redirect?r=central-proxy"/>
    <property name="dev.mysql.params" value="autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=utf-8&amp;zeroDateTimeBehavior=convertToNull"/>
    <property name="dev.mysql.url" value="jdbc:mysql://db.chorke.org:3306/chorke_init_pro?${dev.mysql.params}"/>


    <property name="liquibase.diffTypes" value="tables,views,columns,indexes,foreignkeys,primarykeys,uniqueconstraints"/>
    <property name="liquibase.changeSetAuthor" value="Chorke Academia, Inc"/>
    <property name="liquibase.changeSetContext" value="dev,qac,uat,pro"/>
    <property name="liquibase.contexts" value="dev"/>

    <!-- <path id="driver.classpath">
        <filelist files="${basedir}/lib/runtime" />
    </path> -->

    <target name="cki.log">
        <script language="javascript" src="${ant.dir}/build.js">
            Chorke.ant.init(true);
        </script>
    </target>

    <target name="cki.get" depends="cki.log" unless="ivy.jar.exist">
        <mkdir dir="${ant.lib}"/>
        <get src="${central.proxy}&amp;g=org.apache.ivy&amp;a=ivy&amp;v=2.3.0&amp;e=jar" dest="${ant.lib}/ivy.jar"/>
    </target>

    <target name="cki.ivy" depends="cki.get" if="ivy.jar.exist">
        <ivy:resolve/>
        <ivy:report todir="${basedir}/target/ivy-reports" graph="false" xml="false"/>
        <ivy:cachepath pathid="compile.path" conf="compile"/>
        <ivy:cachepath pathid="runtime.path" conf="runtime"/>
        <ivy:cachepath pathid="build.path" conf="build"/>
        <ivy:cachepath pathid="test.path" conf="test"/>

        <ivy:retrieve sync="false" conf="compile" pattern="lib/[conf]/[artifact](-[classifier]).[ext]"/>
        <ivy:retrieve sync="false" conf="runtime" pattern="lib/[conf]/[artifact](-[classifier]).[ext]"/>
        <ivy:retrieve sync="false" conf="build" pattern="lib/[conf]/[artifact](-[classifier]).[ext]"/>
        <ivy:retrieve sync="false" conf="test" pattern="lib/[conf]/[artifact](-[classifier]).[ext]"/>
    </target>

    <target name="cki.def" depends="cki.ivy" if="ivy.jar.exist">
        <taskdef resource="net/sf/antcontrib/antlib.xml" uri="antlib:net.sf.antcontrib" classpathref="build.path"/>
        <taskdef resource="liquibase/integration/ant/antlib.xml" uri="antlib:liquibase.integration.ant" classpathref="build.path"/>
    </target>

    <target name="cki.dep" if="ivy.jar.exist">
        <path id="driver.classpath">
            <filelist dir="${basedir}/lib/build">
                <file name="liquibase-core.jar" />
            </filelist>
            <filelist dir="${basedir}/lib/runtime">
                <file name="mysql-connector-java.jar" />
            </filelist>
        </path>
        <liq:generateChangeLog classpathref="driver.classpath">
            <liq:database driver="com.mysql.jdbc.Driver" url="${dev.mysql.url}" user="chorke_init_pro" password="chorke_init_pro"/>
            <liq:xml outputfile="${basedir}/target/changelog.xml" encoding="UTF-8"/>
            <liq:changeLogParameters>
                <liq:changeLogParameter name="diffTypes" value="tables,views,columns,indexes,foreignkeys,primarykeys,uniqueconstraints,data"/>
                <liq:changeLogParameter name="changeSetContext" value="dev,qac,uat,pro"/>
                <liq:changeLogParameter name="dataDir" value="${basedir}/target"/>
                <liq:changeLogParameter name="changeSetAuthor" value="chorke"/>
                <liq:changeLogParameter name="contexts" value="dev"/>
                <propertyset>
                    <propertyref prefix="params"/>
                </propertyset>
            </liq:changeLogParameters>
        </liq:generateChangeLog>
    </target>

    <target name="cki.ini" depends="cki.def">
        <sequential>
            <antcall target="cki.dep"/>
        </sequential>
    </target>
</project>

References

• Run an Ant build.xml file inside a Jar
• Apache Ivy™ > Ant Tasks > Retrieve
• Add repositories and specificy repository
• Specify jar in Liquibase Ant Configuration
• Download dependencies with Ant and Ivy
• Put Ivy dependencies in a custom directory