Gradle - keshavbaweja-git/guides GitHub Wiki

task('db-apply') {
    description = "Create a database table structure"
    doLast {
        def liquibaseChangeLog = "$projectDir" + File.separator + "db" + File.separator + "changelog-master.xml"
        def dbUrl = System.getenv('LIQUIBASE_URL') ?: 'jdbc:postgresql://localhost:5432/<schema>'
        def dbUsername = System.getenv('LIQUIBASE_USERNAME') ?: 'postgres'
        def dbPassword = System.getenv('LIQUIBASE_PASSWORD') ?: ''
        def dbSchema = System.getenv('LIQUIBASE_SCHEMA') ?: '<schema>'

        println "dbUrl= [ " + dbUrl + " ], dbUsername = [ " + dbUsername + " ], dbSchema [ " + dbSchema + " ]"

        liquibase {
            activities {
                main {
                    changeLogFile liquibaseChangeLog
                    url dbUrl
                    username dbUsername
                    password dbPassword
                    defaultSchemaName dbSchema
                    driver 'org.postgresql.Driver'
                }
            }
        }
    }
}

# Apply
../../gradlew.bat -p ../.. db-apply apply

# Status
../../gradlew.bat -p ../.. db-apply status

# Rollback
../../gradlew.bat-p../..db-applyrollbackCount-PliquibaseCommandValue=10