JOOQ - equivalent to sleep mode interceptor to populate history fields?

Question

Environment: Spring using JOOQ 3.7, automatically generating JOOQ conversion code from the schema, using Postgres as my database.

I was porting some code from Hibernate to JOOQ. Hibernate code retrieves some authentication information hidden based on each context to populate fields such as "createdBy", "updatedBy", dates, etc.

The only way I can do this with JOOQ at the moment is that the developers had to memorize the code for updating the fields manually each time they update the object, and I see that it will be tiring and easy to forget to fill out fields.

Using JOOQ, is there any way to deal with the “history fields” on each table better than writing a bunch of code manually?

We do not use DAO at the moment, I would prefer not to write / generate the entire code layer in order to deal with these history fields.

Another option would be to do this in the database, and if JOOQ does not help with this problem, it could be what we will do.

Answer 1

There are several ways to do this with jOOQ:

1. Use RecordListenerto generate these values ​​onUpdatableRecord

RecordListener SPI is called every time you call any of:

• TableRecord.insert()
• UpdatableRecord.store()
• UpdatableRecord.update()
• UpdatableRecord.delete()
• UpdatableRecord.refresh()

SPI DML. . :

• http://www.jooq.org/doc/latest/manual/sql-execution/crud-with-updatablerecords/crud-record-listener

2. VisitListener SQL, jOOQ

VisitListener SPI SQL. SQL, jOOQ, , .

UPDATE table SET a = 1, b = 2 WHERE id = 3

UPDATE table SET a = 1, b = 2, updatedBy = 'me' WHERE id = 3

SPI :

• http://www.jooq.org/doc/latest/manual/sql-building/queryparts/custom-sql-transformation

3.

, , . , , Java (, Perl script ..).

4. jOOQ 3.10

jOOQ 3.10:

• https://github.com/jOOQ/jOOQ/issues/1592

, :

• https://github.com/jOOQ/jOOQ/issues/4704

Answer 2

. , .

• . executeEnd. . query. , (/) . , executeStart, .

• Design. , , , - , - ? , . , , , , /. . , :).