Minimalistic build.gradle file for creating a jOOQ model from a database

build.gradle

import org.jooq.codegen.GenerationTool
import org.jooq.meta.jaxb.*
import org.jooq.meta.*

// These can also go into gradle.properties
def packageName = "my.package"
def postgresDriverVersion = "42.1.4"
def jooqVersion = "3.11.1"
def debugDatabaseHost="localhost"
def debugDatabasePort=5432
def debugDatabaseName="database"
def debugDatabaseUsername="postgres"
def debugDatabaseSchema="public"
def debugDatabasePassword="ssssshhhhh!"


buildscript {
        repositories {
                jcenter()
                maven { url "https://plugins.gradle.org/m2/" }
        }
        
        dependencies {
                classpath "org.postgresql:postgresql:$postgresDriverVersion"
                classpath "org.jooq:jooq-meta:$jooqVersion"
                classpath "org.jooq:jooq-codegen:$jooqVersion"
        }
}

apply plugin:"groovy"

dependencies { 
        compile group: 'org.jooq', name: 'jooq', version: jooqVersion
}


tasks.create(name:'jooqModel', description: 'Generates a jOOQ model from the database', group: 'DB').doLast {
        
        def excludes = [
                        //Liquibase database versioning
                        '.*databasechangelog*'
        ].join('|')
        
        def config = new org.jooq.meta.jaxb.Configuration()
                .withJdbc(new Jdbc()
                        .withDriver('org.postgresql.Driver')
                        .withUrl("jdbc:postgresql://$debugDatabaseHost:$debugDatabasePort/$debugDatabaseName")
                        .withUser(debugDatabaseUsername)
                        .withPassword(debugDatabasePassword)
                        .withSchema(debugDatabaseSchema) )
                .withGenerator(new Generator()
                        .withGenerate(new Generate()
                                .withDeprecated(false)
                                .withValidationAnnotations(true) )
                        .withTarget(new Target()
                                .withPackageName(packageName)
                                .withDirectory("${projectDir}/src/java"))
                        .withDatabase(new Database()
                                .withName('org.jooq.meta.postgres.PostgresDatabase')
                                .withIncludeExcludeColumns(true)
                                .withExcludes(excludes)
                                .withInputSchema('public') ) )
        
        GenerationTool.generate(config)
}