Slackbot
11/29/2023, 10:18 PMChris
11/29/2023, 10:20 PMimport org.jooq.meta.jaxb.ForcedType
import org.jooq.meta.jaxb.Logging
import org.jooq.meta.jaxb.Property
val ktorVersion: String by project
val kotlinVersion: String by project
val logbackVersion: String by project
val exposedVersion: String by project
val mariadbVersion: String by project
val log4jVersion: String by project
val jooqVersion: String by project
plugins {
application
java
kotlin("jvm") version "1.9.10"
id("io.ktor.plugin") version "2.1.2"
id("org.jetbrains.kotlin.plugin.serialization") version "1.9.10"
id("nu.studer.jooq") version "8.2"
}
group = "com.package"
version = "0.0.1"
application {
mainClass.set("com.package.ApplicationKt")
val isDevelopment: Boolean = project.ext.has("development")
applicationDefaultJvmArgs = listOf("-Dio.ktor.development=$isDevelopment")
}
repositories {
mavenCentral()
}
buildscript {
configurations["classpath"].resolutionStrategy.eachDependency {
if (requested.group == "org.jooq") {
useVersion("3.17.3")
}
}
}
dependencies {
implementation("io.ktor:ktor-server-content-negotiation-jvm:$ktorVersion")
implementation("io.ktor:ktor-server-core-jvm:$ktorVersion")
implementation("io.ktor:ktor-serialization-kotlinx-json-jvm:$ktorVersion")
implementation("org.jetbrains.kotlinx:kotlinx-html-jvm:0.7.3")
implementation("io.ktor:ktor-server-html-builder-jvm:$ktorVersion")
implementation("io.ktor:ktor-server-freemarker-jvm:$ktorVersion")
implementation("io.ktor:ktor-server-metrics-jvm:$ktorVersion")
implementation("io.ktor:ktor-server-call-logging-jvm:$ktorVersion")
implementation("io.ktor:ktor-server-caching-headers-jvm:$ktorVersion")
implementation("io.ktor:ktor-server-host-common-jvm:$ktorVersion")
implementation("io.ktor:ktor-server-status-pages-jvm:$ktorVersion")
implementation("io.ktor:ktor-server-resources:$ktorVersion")
implementation("io.ktor:ktor-server-auth-jvm:$ktorVersion")
implementation("io.ktor:ktor-server-netty-jvm:$ktorVersion")
implementation("ch.qos.logback:logback-classic:$logbackVersion")
implementation("org.jetbrains.exposed:exposed-core:$exposedVersion")
implementation("org.jetbrains.exposed:exposed-dao:$exposedVersion")
implementation("org.jetbrains.exposed:exposed-jdbc:$exposedVersion")
implementation("org.mariadb.jdbc:mariadb-java-client:$mariadbVersion")
// Jooq
implementation("org.jooq:jooq:${jooqVersion}")
implementation("org.jooq:jooq-meta:${jooqVersion}")
implementation("org.jooq:jooq-codegen:${jooqVersion}")
jooqGenerator("org.mariadb.jdbc:mariadb-java-client:${mariadbVersion}")
jooqGenerator("org.jooq:jooq-meta-extensions:${jooqVersion}")
// Logging
implementation("org.apache.logging.log4j:log4j-api:${log4jVersion}")
implementation("org.apache.logging.log4j:log4j-core:${log4jVersion}")
implementation("org.apache.logging.log4j:log4j-slf4j-impl:${log4jVersion}")
jooqGenerator("org.apache.logging.log4j:log4j-slf4j-impl:${log4jVersion}")
testImplementation("io.ktor:ktor-server-tests-jvm:$ktorVersion")
testImplementation("org.jetbrains.kotlin:kotlin-test-junit:$kotlinVersion")
}
jooq {
version.set("3.17.3") // default (can be omitted)
edition.set(nu.studer.gradle.jooq.JooqEdition.OSS) // default (can be omitted)
configurations {
create("main") { // name of the jOOQ configuration
generateSchemaSourceOnCompilation.set(true) // default (can be omitted)
jooqConfiguration.apply {
logging = Logging.WARN
jdbc.apply {
driver = "org.mariadb.Driver"
url = "jdbc:<mariadb://localhost:6603/db>"
user = "user"
password = "pass"
properties.add(Property().apply {
key = "ssl"
value = "true"
})
}
generator.apply {
name = "org.jooq.codegen.DefaultGenerator"
database.apply {
name = "org.jooq.meta.mariadb.MariaDBDatabase"
inputSchema = "db"
forcedTypes.addAll(listOf(
ForcedType().apply {
name = "varchar"
includeExpression = ".*"
includeTypes = "JSONB?"
},
ForcedType().apply {
name = "varchar"
includeExpression = ".*"
includeTypes = "INET"
}
))
}
generate.apply {
isDeprecated = false
isRecords = true
isImmutablePojos = true
isFluentSetters = true
}
target.apply {
packageName = "com.package.mine"
directory = "build/generated-src/jooq/main" // default (can be omitted)
}
strategy.name = "org.jooq.codegen.DefaultGeneratorStrategy"
}
}
}
}
}
I've followed the suggestion in the error about ignored Bindings but can't seem to resolve the issue.
Am I doing something wrong somewhere?Vampire
11/30/2023, 3:19 PMgenerateJooq is and why it might fail.Chris
11/30/2023, 5:31 PM