# JOOQ

## JOOQ Usage

* `fetchOne` - this is a pretty useful method to get a single result also making sure that there is only one result from the constructed query.
  * Difference between `fetchOne` and `fetchMany` - <https://stackoverflow.com/questions/30307448/jooq-difference-between-fetchany-and-fetchone>
* Ignore duplicates on inserts - <https://www.jooq.org/doc/3.12/manual/sql-building/sql-statements/insert-statement/insert-on-duplicate-key/#N5454E>
* Update on duplicates - <https://www.jooq.org/doc/3.12/manual/sql-building/sql-statements/insert-statement/insert-on-duplicate-key/>