If you're using jooq records, you could use a RecordListener like I do for
a similar case.
My *from* field is *modified_by* and I populate it automatically:
/**
This RecordListener serves as an interceptor for the record.store() calls
and inserts a ‘modified_by’ field if one exists.
As it is not possible to search for the field, we search for the
corresponding getter method ‘getModifiedBy’.
As the search for a corresponding method is expensive, we remember the
results in a cache.
*/
public class JooqRecordListenerSetModifiedBy extends DefaultRecordListener {
@Override
public void insertStart(RecordContext ctx) {
setModifiedBy(ctx);
}
@Override
public void storeStart(RecordContext ctx) {
setModifiedBy(ctx);
}
private void setModifiedBy(RecordContext ctx) {
Record dbRecord = ctx.record();
Class<?> clazz = dbRecord.getClass();
Boolean hasModifiedBy = cache.get(clazz);
if (hasModifiedBy == null) {
hasModifiedBy = hasModifiedBy(dbRecord);
cache.put(clazz, hasModifiedBy);
}
if (hasModifiedBy.equals(Boolean.TRUE)) {
dbRecord.setValue(DSL.field(DSL.name("modified_by")), UsernameResolver.
resolveUsername());
}
}
private Boolean hasModifiedBy(Record dbRecord) {
Boolean result = Boolean.FALSE;
Method[] methods = dbRecord.getClass().getDeclaredMethods();
for (Method method : methods) {
if (method.getName().equals("getModifiedBy")) {
result = Boolean.TRUE;
break;
}
}
return result;
}
}
The other audit field is *modified_at* and it's automatically set by JOOQ
due to the maven plugin configuration:
<generator>
<database>
<recordTimestampFields>modified_at</recordTimestampFields>
....
Hope it helps
Dominik
--
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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/jooq-user/efd98b9e-c9b4-42c4-a013-9defe67256e9n%40googlegroups.com.
