Yeah, it looks so ugly with all those setters, compared to the DSL API, which is why we forget it right away :)
Cheers, Lukas 2017-03-03 15:10 GMT+01:00 Emrul Islam <[email protected]>: > Hi Lukas, > > I always forget about the model API - I think the query is working really > well, thank you! Very excited about 3.10 also :) > > -Emrul > > On Thursday, March 2, 2017 at 8:26:01 AM UTC, Lukas Eder wrote: >> >> Hello, >> >> Thanks for your messages. Indeed, these are known limitations of jOOQ >> version 3.9, which will be fixed in version 3.10: >> >> >> - ON CONFLICT .. RETURNING: #2123 >> <https://github.com/jOOQ/jOOQ/issues/2123> >> - ON CONFLICT .. WHERE: #5637 >> <https://github.com/jOOQ/jOOQ/issues/5637> >> >> ON CONFLICT .. WHERE is already available from GitHub master. Returning >> could be achieved (I haven't tested) by casting the type of your DSL step >> to the relevant type that contains the returning() clause, or by using the >> model API rather than the DSL API, through DSLContext.insertQuery(). I >> believe that the RETURNING limitation is a mere limitation of the DSL API. >> >> >> Hope this helps, >> Lukas >> >> 2017-03-01 19:58 GMT+01:00 Emrul Islam <[email protected]>: >> >>> Opened a GH issue for this https://github.com/jOOQ/jOOQ/issues/5933 >>> >>> In the meantime, if there's a workaround I'll happily take it - I am >>> having to convert my insert statement to a String and append the WHERE and >>> RETURNING clauses. >>> >>> >>> >>> On Tuesday, February 28, 2017 at 9:22:40 PM UTC, Emrul Islam wrote: >>>> >>>> Also, I can't seem to add a RETURNING statement if I use .onConflict(). >>>> doUpdate().set().. >>>> >>>> On Tuesday, February 28, 2017 at 8:11:03 PM UTC, Emrul Islam wrote: >>>>> >>>>> Hi, >>>>> >>>>> Progressing with my current project and run into one more snag - I >>>>> need to do an UPSERT as defined here: https://www.postgresql.o >>>>> rg/docs/current/static/sql-insert.html#SQL-ON-CONFLICT and I need to >>>>> be able to do DO UPDATE SET ... *WHERE*. Seems that the ability to >>>>> add the WHERE might be missing from the class InsertOnDuplicateSetMore >>>>> Step >>>>> >>>>> As usual, I think I can work around it for now and move forward but >>>>> would be handy to get this in a future release. >>>>> >>>>> Thanks >>>>> >>>> -- >>> 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. >>> >> >> -- > 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. > -- 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.
