I'm new to jOOQ and I'm trying to use jOOQ's CLI tool to translate my
SQLite queries into Java code. The tool works well, but I noticed it uses
table and column names as strings in the generated queries. I found that
there's an option to provide a database schema, which allows the tool to
generate POJOs for the tables and columns, and then uses those classes in
the generated Java code.
However, instead of using the generated POJOs, I want to use my own custom
POJOs that I've already created for the tables and columns. Is there a way
to instruct jOOQ's CLI tool to use my custom POJOs instead of generating
new ones?
Example Scenario: Assume I have an SQLite query like this:
FROM users u
JOIN orders o ON u.id = o.user_id
WHERE u.active = 1;
When I use jOOQ's CLI tool without a schema, it generates something like:
DSL.select(field("u.name"), field("o.order_date"))
.from(table("users").as("u"))
.join(table("orders").as("o")).on(field("u.id").eq(field("o.user_id")))
.where(field("u.active").eq(1))
.fetch();
By providing the schema, jOOQ generates POJOs like 'Users' and 'Orders' and
the code becomes:
DSL.select(USERS.NAME, ORDERS.ORDER_DATE)
.from(USERS.as("u"))
.join(ORDERS.as("o")).on(USERS.ID.eq(ORDERS.USER_ID))
.where(USERS.ACTIVE.eq(1))
.fetch();
But I want to use my custom POJOs, such as 'MyUsers' and 'MyOrders', which
are defined as follows:
public class MyUsers {
public static final Table<MyUsers> TABLE = ...
public static final Field<String> NAME = ...
public static final Field<Integer> ID = ...
public static final Field<Boolean> ACTIVE = ...
}
public class MyOrders {
public static final Table<MyOrders> TABLE = ...
public static final Field<Integer> USER_ID = ...
public static final Field<Date> ORDER_DATE = ...
}
I would like the generated code to look like this:
DSL.select(MyUsers.NAME, MyOrders.ORDER_DATE)
.from(MyUsers.TABLE.as("u"))
.join(MyOrders.TABLE.as("o")).on(MyUsers.ID.eq(MyOrders.USER_ID))
.where(MyUsers.ACTIVE.eq(true))
.fetch();
My Questions:
1. CLI Tool Configuration: Is there a way to configure jOOQ's CLI tool
to use my custom POJOs instead of generating new ones?
2. jOOQ API: If the CLI tool doesn't support this, is it possible to
achieve this using jOOQ's API programmatically? If so, could you provide an
example or point me in the right direction?
--
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/9f7874a2-eea2-4340-8c4d-22f152e09029n%40googlegroups.com.
