It is now possible to directly access database with groovy's very powerful features.
Few steps are required:
1) add the database definition to the script settings
# REMOTEDBURL = postgresql:host:5432:database:user:password
2) request the groovy SQL connection
def sql = getDbConnection()
3) execute the query and do something with the result
sql.eachRow(the_query){
// the closure
}
That would all look like:
No comments:
Post a Comment