I need to generate a grails application from a SQL DB Years grails #questions

I need to generate a grails application from a SQL...

Jim Mason

01/15/2025, 6:59 PM

I need to generate a grails application from a SQL DB. Years ago there was a plugin that no longer works that did this reasonably well including creating the domain relations. In Grails 7 and GORM is there some way to generate domain classes from a SQL RDB? Thanks

jdaugherty

01/16/2025, 7:08 AM

Do you have the plugin name / source?

James Fredley

01/16/2025, 2:59 PM

It might be https://grails-plugins.github.io/grails-db-reverse-engineer/v3/guide/single.html

Jim Mason

01/16/2025, 7:39 PM

Yes this is the plugin that stopped loading in Grails around version 5 --- reverse-engineer Earlier it was VERY valuable - I could generate the full Grails domain class model in minutes from an existing data model. I used to a lab with this back in Grails 3 that brought a lot of interest in Grails. https://grails-plugins.github.io/grails-db-reverse-engineer/v3/guide/single.html

Jim Mason

01/16/2025, 7:48 PM

If this plugin can't work in Grails 7 looking at the next easiest option to generate the domain class model from a SQL RDB Thanks

jdaugherty

01/18/2025, 2:28 PM

I'm going to take a look at upgrading this to grails 7

👏 1

jdaugherty

01/21/2025, 8:30 PM

https://github.com/grails-plugins/grails-db-reverse-engineer/pull/16 upgrades it to grails 7 with hibernate 5 support.

jdaugherty

01/21/2025, 8:31 PM

The grails command isn't working, but you can use a sample app to generate the domains. Take a look at

example/mysql

for how it does this. The app will startup, create domains, and shutdown.

Jim Mason

01/23/2025, 7:54 PM

Thanks I'll give that a try

👍 1

Open in Slack

Previous Next