JetBrains / Exposed

Kotlin SQL Framework
http://jetbrains.github.io/Exposed/
Apache License 2.0
8.05k stars 673 forks source link

Auditing table #309

Open aluismarte opened 6 years ago

aluismarte commented 6 years ago

Exposed is a fantastic ORM, but need something like ENVERS, is someone working on?

Tapac commented 5 years ago

Did you talk about http://hibernate.org/orm/envers/ ?

aluismarte commented 5 years ago

Yes

dsidharta commented 2 years ago

@aluismarte: Were you able to find a solution to your auditing needs?

Another way that I thought would make auditing possible is if a copy of writeValues (here) is made available to registerChange() (here). That way, we can listen to the EntityChangeType.Updated event (example here) and store an audit record accordingly. Currently writeValues is cleared by the time the subscriber's hook gets executed for that event.

Any thoughts from the contributors on how to create an audit record using Exposed? If nothing else, I can use DB triggers.

patryksz commented 1 year ago

Bumping, any updates? Do we have an official way of auditing the tables?

maricarmello commented 1 month ago

Another bump, any official way? If not, any suggestions on how to go about it?