Change tracking capability for compliance or management requirements.

[sequelize]

Change tracking capability for compliance or management requirements.

[sdepold]

sounds good.

[Trakkasure]

I have this feature completed.
New option: trackChanges
If set to true, a new table for the existing table is created: tablename_history

A field "updatedAt" keeps track of when the table was updated from the historical value.

[Trakkasure]

I have all of these features committed in my fork. Is there some thing can do to get you a copy?

[sdepold]

when u access the website of your forked repo there is a button named "send pull request" or smth like that :)

[Trakkasure]

Pull request sent.

[faceleg]

Hate to resurrect this issue, but was the PR successful?

[mickhansen]

@faceleg i don't believe so.

[janmeier]

@faceleg The updatedAt column mentioned in the PR still exists, but I've never seen any of the other features mentioned.

However, this should actually be pretty easy to do as a plugin

• Add an afterDefine hook, which defines a _history model whenenver a model is defined.
• In the same hook, add an afterCreate / afterUpdate hook to the model, which will insert a new row in the history table, each time a row is updated
• Perhaps also an afterDelete hook?

One problem might be bulk destroy / update. You could fix this by forcing individualHooks to true with a beforeBulkUpdate/Destroy hook

[faceleg]

Thanks @janmeier, I thought about doing that. Although I'd love to create a plugin like this I don't have time at the moment.

I'm going to investigate using this for the time being: https://github.com/2ndQuadrant/audit-trigger

[faceleg]

@janmeier would it be appropriate to open an issue "Creation of a revision tracking plugin", that listed requirements and suggested implementation as you have described?

Anyone looking to get their feet wet in some excellent OSS projects might see this and decide to implemented it.

Dreams are free

[janmeier]

@faceleg Sure, fine by me :)