Skip to content

Instantly share code, notes, and snippets.

@willis7
Created August 23, 2013 12:31
This Gist shows how to run the utplsql project using Gradle
ext{
dbun = "SCOTT"
dbpw = "oracle"
dbinst = "orcl"
}
task deployUnitTests << {
def sqlplusCmd = "sqlplus -s $dbun/$dbpw @../src/test/sql/run.sql".execute()
sqlplusCmd.in.eachLine { line -> println line }
}
task runUnitTests << {
def sqlplusCmd = "sqlplus -s $dbun/$dbpw @ut_run.sql".execute()
sqlplusCmd.in.eachLine { line -> println line }
}
task deployDBUpdate << {
def sqlplusCmd = "sqlplus -s $dbun/$dbpw @../src/main/sql/run.sql".execute()
sqlplusCmd.in.eachLine { line -> println line }
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment