[Dbix-class] Audit Trails/History Component

[Tobias Kremer]

Zitat von Brian Cassidy <brian.cassidy at nald.ca>:

> Brian Cassidy wrote:
> >
> > Having done something similar, be aware that your "reference" to the id
> > should be an actual foreign key. Try to delete a row and you'll see what
> > i mean. :)
> >
> errr... should NOT, should NOT! :)

Fortunately MySQL has no real foreign keys for MyISAM tables (yet) - other
than that, you're right: I'd be in for a surprise :)

Have you also implemented something that stores which actual columns changed
(from -> to value)? I haven't figured out yet how to get a list of
changed (dirty) columns and retrieve their value prior to any column updates.
$obj->is_changed() doesn't seem to work on the object passed into the
insert/update/delete methods in my component ...

Toby