Builder for Delete and Update statements

[sca...@live.com]

There is a convenient builder for Select queries, e.g. SelectQuery query = selectDistinct().from( myTable ).getQuery(); and then query.addConditions(...); query.addFrom(...) etc.

Is there a similar builder for Delete and Update statements? Like deleteFrom(table).getQuery().addConditions(...).

[Lukas Eder]

Hello,

In fact, that getQuery() method is a leftover from early jOOQ versions, which exposes jOOQ's internal model API from the DSL API [1]. The standard way to access the model API is by using DSLContext.selectQuery(), DSLContext.insertQuery(), DSLContext.deleteQuery(), DSLContext.updateQuery().

I hope this helps,

Lukas

[1]: https://www.jooq.org/doc/latest/manual/sql-building/sql-statements/dsl-and-non-dsl/

[sca...@live.com]

Awesome, thanks! Wasn't aware of these methods before, and that's right the uniformity I needed.