On 3/14/19 3:21 AM, Lukas Eder wrote:
*Rob,*
Thanks for your help. In general, it is always a good idea to explain
why something is a bad idea. Or, maybe, ask for the context in which
some specific feature is needed by the user, because believe it or
not, there are valid use cases for the asterisk even if you may have
strong opinions about it.
You're right of course. The effort of explaining the long list of
assumptions which have to be true for safely using asterisk escapes me.
*Dharm,*
You can use the DSL.asterisk() expression to create an asterisk in
your query:
https://www.jooq.org/javadoc/latest/org/jooq/impl/DSL.html#asterisk--
You cannot use that with selectFrom(), but if you want to fetch
PersonRecords from any arbitrary query, you can call fetchInto(PERSON):
https://www.jooq.org/javadoc/latest/org/jooq/ResultQuery.html#fetchInto-org.jooq.Table-
This will transform arbitrary projections back to typed TableRecords.
The reason why jOOQ lists your column names explicitly is because the
generated code was generated against a specific schema version, and in
general, it is a good idea to expect only columns from that specific
schema version to be in the result type - for instance when you use
SELECT DISTINCT. This will produce more predictable results.
I hope this helps,
Lukas
On Wed, Mar 13, 2019 at 10:04 PM Rob Sargent <[email protected]
<mailto:[email protected]>> wrote:
Let's just agree that this is a bad idea and quietly move on :)
On 3/13/19 2:50 PM, Dharmaraj Parmar wrote:
Hi,
I would like to know if it is possible to have the generated SQL
statement contain asterisk instead of listing all the columns.
*JOOQ:*
ctx.selectFrom(*/PERSON/*).fetch();
*Expected:*
select * from PERSON
*Actual:*
select PERSON.ID <http://PERSON.ID>, PERSON.NAME
<http://PERSON.NAME> from PERSON
Regards,
Dharm
--
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]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout.
--
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]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout.
--
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]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout.
--
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.
