Postgres direkt aus Gradle

import groovy.sql.Sql

import java.sql.Driver
import java.sql.DriverManager

configurations {
  driver
}

buildscript {
  ext.postgresVersion = '42.1.1'

  dependencies {
    classpath("org.postgresql:postgresql:${postgresVersion}")
  }
}

dependencies {
  driver "org.postgresql:postgresql:${postgresVersion}"
}

// register jdbc drivers:
URLClassLoader loader = GroovyObject.class.classLoader
configurations.driver.each { File file ->
  loader.addURL(file.toURI().toURL())
}
Class driverClass = loader.loadClass('org.postgresql.Driver')
Driver driverInstance = driverClass.newInstance()
DriverManager.registerDriver(driverInstance)

task fooBar() {
  doLast {
    def sql = Sql.newInstance('jdbc:postgresql://localhost:5432/database', 'user', 'password')
    sql.execute(/* ... */)
    sql.close()
  }
}

import groovy.sql.Sql

import java.sql.Driver

import java.sql.DriverManager

configurations {

driver

}

buildscript {

ext.postgresVersion = '42.1.1'

dependencies {

classpath("org.postgresql:postgresql:${postgresVersion}")

}

dependencies {

driver "org.postgresql:postgresql:${postgresVersion}"

}

// register jdbc drivers:

URLClassLoader loader = GroovyObject.class.classLoader

configurations.driver.each { File file ->

loader.addURL(file.toURI().toURL())

}

Class driverClass = loader.loadClass('org.postgresql.Driver')

Driver driverInstance = driverClass.newInstance()

DriverManager.registerDriver(driverInstance)

task fooBar() {

doLast {

def sql = Sql.newInstance('jdbc:postgresql://localhost:5432/database', 'user', 'password')

sql.execute(/* ... */)

sql.close()

}

im Wesentlichen von hier.

crusy.net

Postgres direkt aus Gradle

Leave a Reply Cancel reply