Thanks for your message. We'll have gradle examples eventually in our MCVE
template:
https://github.com/jOOQ/jOOQ-mcve/issues/41
They'll be using testcontainers too.
Unfortunately, until then, I can't really comment about the "best way" to
do it. (It will be very hard with gradle anyway, because there are so many
opinions). We'll be recommending the official plugin, not a third party
one...
On Tue, Jun 11, 2024 at 7:28 AM Debapriya Patra <debapriya.pa...@gmail.com>
wrote:
> Hi,
>
> Does anyone integrated Liquibase in a mysql testcontainer to apply DB
> migrations and use Jooq to connect to the MySql test container DB to
> generate java files?
>
> I wanted to do this inside a gradle Spring Boot application. Can someone
> help me on this ?
>
> Any example or reference might be helpful ?
>
> I am trying to go in the following sequence.
>
> - Spinup MySql test container
> - Apply DB migrations using Liquibase against MySql test container.
> - Generate Java files from the DB against MySql testcontainer DB.
>
> Also I wanted to have the code separated in three .gradle files.
> Here is what I have started with
>
> *mysqltc.gradle*
> ------------------------
> ```
> // mysql-tc.gradle
>
> import org.testcontainers.containers.MySQLContainer
>
> buildscript {
> repositories {
> mavenCentral()
> }
> dependencies {
> classpath "org.testcontainers:testcontainers:${testcontainersVersion}"
> classpath "org.testcontainers:mysql:${testcontainersVersion}"
> classpath "com.mysql:mysql-connector-j:8.4.0"
> }
> }
>
> tasks.register('startMySQLContainer') {
> println("----Stating MySql DB TC----")
> doLast {
> def mysqlContainer = new MySQLContainer("mysql:latest")
> .withDatabaseName("lmsdb")
> .withUsername("test")
> .withPassword("test")
> mysqlContainer.start()
>
> project.ext.dbUrl = mysqlContainer.getJdbcUrl()
> project.ext.dbUsername = mysqlContainer.getUsername()
> project.ext.dbPassword = mysqlContainer.getPassword()
> project.ext.dbDriver = mysqlContainer.getDriverClassName()
>
> println "MySQL container started with URL: ${project.ext.dbUrl}"
> }
> }
>
> tasks.register('stopMySqlContainer') {
> doLast {
> if (mysqlContainer) {
> mysqlContainer.stop()
> }
> }
> }
> ```
>
> * liquibase.gradle*
> ```
> println("----Configuring Liquibase----")
> dependencies {
> implementation 'org.liquibase:liquibase-core:4.24.0'
> }
>
> liquibase {
> activities {
> main {
> changeLogFile 'src/main/resources/db/changelog/changelog-master.sql'
> url project.ext.has('d') ? project.ext.jdbcUrl :
> 'jdbc:tc:mysql:8.0.36:///lmsdb?TC_TMPFS=/testtmpfs:rw'
> username project.ext.has('username') ? project.ext.username : 'test'
> password project.ext.has('password') ? project.ext.password : 'test'
> }
> }
> runList = 'main'
> }
>
> tasks.named('update') {
> dependsOn ':startMySQLContainer'
> }
> ```
>
> *jooq.gradle*
> -------------------
> ```/**
> * This gradle file is used to generate JOOQ DAO, POJOs and fluent API for
> writing SQL queries using
> * generated classes. The default configuration below should work in most
> cases, but it can be
> * modified as needed based on the plugin documentation:
> *
> * https://github.com/etiennestuder/gradle-jooq-plugin
> */
>
> import nu.studer.gradle.jooq.JooqGenerate
>
> buildscript {
> repositories {
> gradlePluginPortal()
> }
> dependencies {
> classpath "nu.studer:gradle-jooq-plugin:${jooqPluginVersion}"
> }
> ext {
> // use jOOQ version defined in Spring Boot
> jooqVersion = dependencyManagement.importedProperties['jooq.version']
> }
> configurations.classpath {
> // Enforce the jOOQ configuration XML schema version
> resolutionStrategy.eachDependency {
> if (requested.group == 'org.jooq' && requested.name.startsWith('jooq')) {
> useVersion jooqVersion
> }
> }
> }
> }
>
> apply plugin: nu.studer.gradle.jooq.JooqPlugin
>
> println("Configuring JOOQ dependencies and code generation plugin...")
>
> // JOOQ dependencies
> dependencies {
> implementation 'org.springframework.boot:spring-boot-starter-jooq'
> jooqGenerator 'com.mysql:mysql-connector-j'
> jooqGenerator 'org.slf4j:slf4j-simple'
>
> jooqGenerator 'com.fasterxml.jackson.core:jackson-databind'
> jooqGenerator "org.testcontainers:mysql"
> jooqGenerator 'software.aws.rds:aws-mysql-jdbc:1.+'
> implementation 'org.testcontainers:jdbc'
> }
>
> // Configure JOOQ
> jooq {
> version = jooqVersion
>
> configurations {
> main {
> generationTool {
> logging = org.jooq.meta.jaxb.Logging.WARN
> jdbc {
> driver = 'org.testcontainers.jdbc.ContainerDatabaseDriver'
> }
> generator {
> name = 'org.jooq.codegen.DefaultGenerator'
> database {
> name = 'org.jooq.meta.mysql.MySQLDatabase'
> inputSchema = 'lmsdb'
> }
> generate {
> records = true
> immutablePojos = true
> fluentSetters = true
> javaTimeTypes = false
> }
> target {
> packageName = "com.chegg.${mainPackageName}.db"
> }
> strategy.name = 'org.jooq.codegen.DefaultGeneratorStrategy'
> }
> }
> }
> }
> }
>
> // Add database-specific JDBC driver dependencies for JOOQ code generation
> and plugin configuration
> String databaseType = findProperty("databaseType") as String
>
> if (databaseType == "aurora-mysql") {
> ext.jooqSecrets = project.getSecretsById(project.getPropertyValue(
> "app.db.app-secret-id"))
>
> jooq.configurations.main {
> generationTool {
> jdbc {
> //url = "jdbc:mysql://" +
> (project.getPropertyValue("spring.datasource.url") as String).split("://",
> 2)[1]
> //user = jooqSecrets.get("username")
> //password = jooqSecrets.get("password")
> url = project.ext.has('jdbcUrl') ? project.ext.jdbcUrl :
> 'jdbc:tc:mysql:8.0.36:///lmsdb?TC_TMPFS=/testtmpfs:rw'
> }
> }
> }
> } else if (databaseType == "mysql") {
> jooq.configurations.main {
> generationTool {
> jdbc {
> url = project.getPropertyValue("spring.datasource.url")
> user = project.getPropertyValue("spring.datasource.username")
> password = project.getPropertyValue("spring.datasource.password")
> }
> }
> }
> }
>
> // Configure the JVM used for the JOOQ code generation process
> tasks.withType(JooqGenerate).configureEach {
> javaExecSpec = { JavaExecSpec s ->
> s.systemProperties System.properties
> }
> }
>
> tasks.named('generateJooq') {
> dependsOn ':startMySQLContainer', ':update'
> }```
>
> In my build.gradle I am applying from those three .gradle files.
>
> I am stuck with an error.
>
> --
> You received this message because you are subscribed to the Google Groups
> "jOOQ User Group" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to jooq-user+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/jooq-user/61012e09-94c7-4287-b1fd-7254fee3178en%40googlegroups.com
> <https://groups.google.com/d/msgid/jooq-user/61012e09-94c7-4287-b1fd-7254fee3178en%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to jooq-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/jooq-user/CAB4ELO4-9Vf%3Dw2Jdm1BxjCWmUyWZ3Fj7FH%3DHjkmx3yHCmPDqYw%40mail.gmail.com.
