Is it possible to upsert using jOOQ-generated record classes?

Question

I can perform an insertInto().onDuplicateKeyUpdate() if I want to write my insert manually using the DSL, but is there an equivalent on the generated Record class?

Answer 1

As of jOOQ 3.7, this is not yet possible out of the box. There's a pending feature request for this: #2961.

Alternatively, you can write a utility that translates an UpdatableRecord into a corresponding INSERT .. ON DUPLICATE KEY UPDATE statement. All the meta information needed for this is available from the UpdatableRecord:

• Record.getTable() to discover the target table
• Record.fields() to discover all the fields in a record
• Table.getPrimaryKey() primary key information, if you need that
• Record.changed() flags to discover the modified values of a record