Add a jOOQ-meta-kotlin module for kotlin extensions to the jOOQ-meta module

[lukaseder]

jOOQ 3.19 will ship with a new official jooq-codegen-gradle plugin:

• Create an official jooq-codegen-gradle plugin #12985

To make configuring jOOQ from Groovy / Kotlin simpler, new modules could be added containing extension functions that DSL-ify the org.jooq.meta.jaxb.Configuration class, etc. For example:

fun configuration(block: Configuration.() -> Unit): Configuration {
    val c = Configuration()
    block(c)
    return c
}

fun Configuration.generator(block: Generator.() -> Unit) {
    if (generator == null)
        generator = Generator()

    block(generator)
}

fun Generator.database(block: Database.() -> Unit) {
    if (database == null)
        database = Database()

    block(database)
}

fun Generator.target(block: Target.() -> Unit) {
    if (target == null)
        target = Target()

    block(target)
}

fun Database.properties(block: MutableList<Property>.() -> Unit) {
    block(properties)
}

fun MutableList<Property>.property(block: Property.() -> Unit) {
    val p = Property()
    block(p)
    add(p)
}

println(configuration {
    generator {
        database {
            properties {
                property {
                    key = "sql"
                    value = """
                    create schema s;
                    create table s.t (i int primary key)
                    """
                }
            }
        }
        target {
            packageName = "com.example"
        }
    }
})

This produces a valid XML configuration as follows:

<configuration>
	<generator>
		<name>org.jooq.codegen.DefaultGenerator</name>
		<database>
			<properties>
				<property>
					<key>sql</key>
					<value>
                    			create schema s;
                    			create table s.t (i int primary key)
                    			</value>
				</property>
			</properties>
		</database>
		<target>
			<packageName>com.example</packageName>
		</target>
	</generator>
</configuration>

Seems like a super low hanging fruit! I'll check if the gradle/groovy integration can profit of a similar thing. The existing third party plugin https://github.com/etiennestuder/gradle-jooq-plugin does some reflection tricks, but it would be better if we could generate actual code to help the IDE with auto completion, etc.

[lukaseder]

This test passes!

assertEquals(
    Configuration()
        .withJdbc(Jdbc().withUrl("x"))
        .withLogging(Logging.DEBUG)
        .withGenerator(Generator()
            .withDatabase(Database()
                .withProperties(
                    Property().withKey("k").withValue("v"),
                    Property().withKey("x").withValue("y"))
                .withSyntheticObjects(SyntheticObjectsType()
                    .withPrimaryKeys(SyntheticPrimaryKeyType()
                        .withKey("k")
                        .withFields("a", "b", "c")))
                .withSchemata(SchemaMappingType()
                    .withInputSchema("input")
                    .withOutputSchema("output")
                ))
            .withGenerate(Generate()
                .withUdts(true))
        ),
    configuration {
        jdbc { url = "x" }
        logging = Logging.DEBUG
        generator {
            database {
                properties {
                    property {
                        key = "k"
                        value = "v"
                    }
                    property {
                        key = "x"
                        value = "y"
                    }
                }
                syntheticObjects {
                    primaryKeys {
                        primaryKey {
                            key = "k"
                            fields = listOf("a", "b", "c")
                        }
                    }
                }
                schemata {
                    schema {
                        inputSchema = "input"
                        outputSchema = "output"
                    }
                }
            }
            generate {
                isUdts = true
            }
        }
    }
)

Very cool!

[lukaseder]

Depending on whether #12985 will be backported, this will be backported as well.