0

I'm learning the Play Framework... and I'm wondering how to implement an auditing mechanism to track DB operations (add, modify, delete). For instance, I'd expect something very similar to Hibernate where audit tables are created automatically... Does anybody know if there is a good document that explains how to audit database changes with the Play Framework? I'm using the Play! 2.0 and PostgreSQL 9.1.

Any help would be really appreciated ;-)

DataNucleus
  • 15,497
  • 3
  • 32
  • 37
j3d
  • 9,492
  • 22
  • 88
  • 172
  • If you even don't specify Play's version and selected ORM, I can ensure you, that nobdy give you the correct answer. – biesior Nov 17 '12 at 05:21
  • OK, I've just updated my post with version information. – j3d Nov 17 '12 at 09:29
  • @j3d I am not aware of what Hibernate does. But as a solution (if there's no better solution) you could try to start a transaction and add your data and the executed operation in another table. – Andrew Nov 18 '12 at 10:21

1 Answers1

0

I suppose you are using an ORM (you didn't specify)

In that case, you should take into account that anorm is not a full fledged orm (ANti ORM, I guess that's where it's name come from) it's just a tiny and practical wrapper around plain jdbc.

So I think you should implement some kind of logging by yourself, as Andrew suggested.

You could also try hacking into anorm itself, or come up with something playing with function compositions.

Sam
  • 6,770
  • 7
  • 50
  • 91
opensas
  • 60,462
  • 79
  • 252
  • 386
  • Yes, I'm using anorm... but I think I should give a look at Slick. Let me try it and then I'll come back with more info. – j3d Nov 19 '12 at 08:52