Hello everyone I m glad to announce that the `exposed gralde plugin` is here with a very small but usefult gradle task which allows to generate tables definitions by existing scheme <https plugins gradle org plugin com jetbrains exposed gradle plugin> The main idea is allow easily migrate your large or not so large existing projects to Exposed Please check a documentation on <https github com JetBrains exposed intellij plugin blob master exposed gradle plugin README md|github> and share your ideas on things that can be improved added to a gradle plugin For now I think that it can be useful to generate validate schemas or prepare migration scripts like ShemaUtils do What do you think The on of the next steps is to have intellij idea plugin to have same things in the IDE so share your thoughts about that too P S There can be bugs for sure

is here with a very small but usefult gradle task which allows to generate tables definitions by existing scheme. https://plugins.gradle.org/plugin/com.jetbrains.exposed.gradle.plugin The main idea is allow easily migrate your large (or not so large) existing projects to Exposed. Please check a documentation on github and share your ideas on things that can be improved/added to a gradle plugin. For now I think that it can be useful to generate/validate schemas or prepare migration scripts (like ShemaUtils do). What do you think? The on of the next steps is to have intellij-idea plugin to have same things in the IDE, so share your thoughts about that too:) P.S. There can be bugs for sure:)

👍 4

👌 11

Bogdan

06/14/2021, 6:17 PM

Are there restrictions for non-free (paid) databases like in JOOQ? Can I generate a schema for ORACLE?

tapac

06/14/2021, 6:58 PM

The only restriction as availability to connect to a database with jdbc:)

Bogdan

06/14/2021, 6:59 PM

super

spand

06/15/2021, 7:27 AM

The one man army continues!

Bogdan

06/15/2021, 4:39 PM

Copy code

exposedCodeGeneratorConfig { // documetation github
    // error
    configFilepath = "exposedCodeGeneratorConfig.yml"
    // there is only configFilepath, rename ?
}

Custom connection properties. until I found it until I found where to ask

so far caught this error:

Could not connect to jdbc: oracle: thin: @ 192.168.0.150: 1521: ORCL, for user 'user', with properties {}: ORA-00604: error occurred at recursive SQL level 1  ORA-01882: timezone region not found

tapac

06/16/2021, 8:41 PM

I'll look into it.

rnett

06/18/2021, 7:17 AM

Any chance of pushing the generated code in

example

? It would be nice to have an example of what exactly is generated.

dave08

06/28/2021, 1:27 PM

A nice thing to add might be using testcontainers + sql DDL files to pull up a db and generate the classes from it... @tapac. Sometimes we don't want the whole structure of the db in production (or don't want to open a connection to it...), just exporting the DDL might be better, also in integration tests we already have those DDL files commited (at least the main ones...)

12 Views