<project name="Schema Update" default="update" basedir=".">

    <import file="commons.xml"/>

    <!-- Infos connexion de la base correspondant à l'ancien schéma -->
    <property name="oldDbUrl" value="${db.rec.url}" />
    <property name="oldDbUser" value="${db.rec.user}" />
    <property name="oldDbPass" value="${db.rec.pass}" />

    <!-- Infos connexion de la base correspondant au nouveau schéma -->
    <property name="newDbUrl" value="${db.int.url}" />
    <property name="newDbUser" value="${db.int.user}" />
    <property name="newDbPass" value="${db.int.pass}" />

    <!-- URL ou sera généré le changeset liquibase -->
    <property name="changesetFile" value="${project.directory}/target/changeset.xml" />

    <!-- URL ou sera généré le script de mise à jour de la base  -->
    <property name="outputUpdateFile" value="${project.directory}/target/update-schema-oracle.sql" />

    <!-- URL ou sera généré le script d'annulation de la mise à jour de la base -->
    <property name="outputRollbackFile" value="${project.directory}/target/rollback-schema-oracle.sql" />


    <!-- Crée un changeset liquibase à partir des 2 bases de données-->
    <target name="update">
        <path id="classpath">
            <pathelement location="${maven.repo}/dom4j/dom4j/1.6.1/dom4j-1.6.1.jar" />
            <pathelement location="${maven.repo}/commons-logging/commons-logging/1.1.1/commons-logging-1.1.1.jar" />
            <pathelement location="${maven.repo}/org/liquibase/liquibase-core/1.6.1/liquibase-core-1.6.1.jar" />
            <pathelement location="${maven.repo}/oracle/jdbc.driver.jdk.1.4/9.0.2.0.0/jdbc.driver.jdk.1.4-9.0.2.0.0.jar" />
        </path>

        <taskdef resource="liquibasetasks.properties">
            <classpath refid="classpath" />
        </taskdef>

         <migrateDatabase
                    changeLogFile="${changesetFile}"
                    driver="oracle.jdbc.driver.OracleDriver"
                    url="${oldDbUrl}"
                    username="${oldDbUser}"
                    password="${oldDbPass}"
                    dropFirst="false"
                    classpathref="classpath"
                    outputFile="${outputUpdateFile}"
            />


        <!--rollbackFutureDatabase
                    changeLogFile="${changesetFile}"
                    driver="oracle.jdbc.driver.OracleDriver"
                    url="jdbc:oracle:thin:@ar3dv007.groupe.generali.fr:1521:WEB1"
                    username="UOFIVI0"
                    password="UOFIVI9"
                    classpathref="classpath"
                    outputFile="${outputRollbackFile}"
            -->

    </target>

</project>