Modifying or Creating Code Generation to provide complete CRUD

[David P]

I would like to create a template that would generate the GUI in addition to the database calls. Unfortunately, I don't see instructions or an example of how to.

Can someone let me know where I can find some? I assume it has already been done.

[Rob Sargent]

Using what stack, exactly?

CRUD screens are rarely successful UIs

On Nov 22, 2020, at 9:58 AM, David P <oce...@gmail.com> wrote:

I would like to create a template that would generate the GUI in addition to the database calls. Unfortunately, I don't see instructions or an example of how to.

Can someone let me know where I can find some? I assume it has already been done.

--
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+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/8578e47a-532f-4fee-8957-f80c3135840bn%40googlegroups.com.

[David P]

I will start with SWING for starters. Then with VAADIN.

Depends on what you mean by a successful UI. If you want a quick and dirty way of navigating through the data, it would do what I need.

I am not looking for a production-ready final product etc. Just a quick viewer and manipulator for in-house.

I know there are other products like ROO or Grail etc, but I did a first try with JOOQ and saw how easy it was to use.

It seems to enable customization but I don't see easy instructions like a "hello world" example.

[Rob Sargent]

ok, knock yourself out. :)

In the database realm "hello world" amounts to something like "select 1".  If you're using java that means getting hold of the correct JDBC driver, creating a connection, generating a query, executing the  query and reading the result(s).

Where in the jOO* universe do you see any UI components?  I think its (maniacal?) focus on type-safe data/sql is why many of us like jOOQ so much.

To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/08132cea-5425-4151-8a4b-8abd17d32eb2n%40googlegroups.com.

[David P]

Thanks Rob, but what I would like is some instruction on where the templates are, when are they called/used?

Like examples of how templates are modified or created.

[Rob Sargent]

Yeah, sorry.  I don't know to which templates you refer?  Screen/JPanel/label-value generators?

Have you seen what tools like pgAdmin, DBeaver, DbVisualizer can do?

To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/932d0c91-ad25-4a30-97bd-ef13b7b74a4cn%40googlegroups.com.

[David P]

If it is using Velocity or Freemarker I was expecting some files it is using as a template.

For instance, one of my generated files is says

/*

 * This file is generated by jOOQ.

 */

package generated;

I would like to know how it was generated so that I can have it generate more code. That is all I am asking for.

Thank you for your help.

[Lukas Eder]

We're not using templates to generate code. Most of the logic is in a single Java class, the org.jooq.codegen.JavaGenerator:

https://github.com/jOOQ/jOOQ/blob/main/jOOQ-codegen/src/main/java/org/jooq/codegen/JavaGenerator.java

Hope this helps,

Lukas

To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/e2012e6e-3067-496b-8e9c-fe06fbac5eb7n%40googlegroups.com.

[David P]

Thank You, that was what I was looking for.

[Rob Sargent]

I'm sorry, I didn't understand that OP was planning on writing swing objects as part of code generation.  In this day and age I would be (slightly) more tempted to generate web-ready components, but I stand by my original thesis ;)

To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO7uafVeMM8P_AU16ZJC9dfPCXTJyaPDAeO5PZUW5c5gDw%40mail.gmail.com.

[David P]

I actually agree with you Rob, and I appreciate you letting me know about DBeaver, I always thought Navicat was the only tool to have.

Swing is going to be more of a proof of concept, VAADIN will be the web project.

Also, webswing will allow a swing program to be used on the web but I have not tried it with jdbc calls yet.

https://www.webswing.org/downloads

Their GUI doesn't seem production-ready but for a quick and dirty project, webswing looks ok.

As far as using JOOQ now, I looked into the file that Lukas mentioned and I see I would have to add sections to it. From what I can see, add my stuff, build it, and use the new jars in my project should do the job.

[Rob Sargent]

You probably want to extend that class. I have done so to add fasterxml annotations and package lines. 

On Nov 23, 2020, at 11:23 PM, David P <oce...@gmail.com> wrote:

I actually agree with you Rob, and I appreciate you letting me know about DBeaver, I always thought Navicat was the only tool to have.

To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/04b1e5b9-fa8a-4a88-bb30-6923a1032932n%40googlegroups.com.