> On Sep 5, 2022, at 9:40 AM, Jan Vybíral <[email protected]> wrote: > > Hi Lukas, > > thanks for reply, unfortunately the actions often invole not only recomputing > some columns in db, but also sending data to other services using REST/kafka > messages, so triggers or computed columns won't cut it. > > The ExecuteListener looks promising, but I'm not sure how to get info about > what table and what values were updated in query provided by the listener. My > idea is that I'll register ExecuteListener, check if it's INSERT or UPDATE > query and then I'd somehow traverse the query using VisitListener to get info > about what is being updated, but can't find a way to do it. ? >
I’m always interested to see how other hand db interaction... You started out saying this was a “REST” (which I take to be same as “RESTful”). But it also sounds as though the clients are sending SQL (as opposed to using a matching http method (insert goes to post (iirc)). If that is the case it pretty much behooves the client to also say something about the context of the statement - though I think this might only be a problem for updates and selects as the two which are not pre-force whole records while insert, delete are whole-record interactions. -- 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/25748D2F-9ABE-4C53-A54D-777252E6E29D%40gmail.com.
