I have a dynamic query builder, it may join a couple of tables and let the
user select what fields show up in the returned Record. Some of these
fields may use default converters and others may use more complex
conversation (like the string result of a CASE being turned into an Enum).
What's the simplest way to do this in JOOQ? What I'd like to be able to do
is add a lambda to each "thing" I put in select. I would be able to do this:
selects.select(USERS.ID, (b, v)->b.setId(v));
selects.select( {complex case}, (b,
v)->b.setStatus(UserStatus.valueOf(v));
...
And so on. I could define these up front. I can't really do this with JOOQ
and that's okay because I want to do things the JOOQ-way. So what would you
suggest? I have tried to just have a bean and use the default bean mapper
but I couldn't get it to understand my more complex types (like a case
result to an enum). Also, the bean mapper does not look to be super
efficient.
Thanks for any guidance here!
R.
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
