Skip to content
This repository has been archived by the owner on Mar 11, 2021. It is now read-only.

Record work item comments revisions #914

Closed
xcoulon opened this issue Mar 2, 2017 · 0 comments
Closed

Record work item comments revisions #914

xcoulon opened this issue Mar 2, 2017 · 0 comments

Comments

@xcoulon
Copy link
Contributor

xcoulon commented Mar 2, 2017

Similar to #840:

Every time a work item comment is modified in the database, a record of the previous version should be saved in a new history table, work_item_comment_revisions (to be created).
This history table would contain the same columns as the work_item_links table itself, plus 3 extra columns for the identity of the change author, and the type of change (ADDED / UPDATED / REMOVED) and the timestamp of the operation.

@xcoulon xcoulon self-assigned this Mar 2, 2017
xcoulon added a commit to xcoulon/fabric8-wit that referenced this issue Mar 3, 2017
Added a `comment_revisions` table to retain all changes on comments,
along with a timestamp, the Id of the author identity and the type
of operation that was performed.
When the comment is deleted, the 'body' and 'markup' fields are 'Nil'.
The list of revisions is retrieved in its historical order.

Also renamed the `workitem.WorkItemRevision` to `workitem.Revision`
and removed the `WorkItem` part in the revision constants.

Fixes fabric8-services#914

Signed-off-by: Xavier Coulon <xcoulon@redhat.com>
xcoulon added a commit that referenced this issue Mar 3, 2017
* Record work item comments revisions (#914)

Added a `comment_revisions` table to retain all changes on comments,
along with a timestamp, the Id of the author identity and the type
of operation that was performed.
When the comment is deleted, the 'body' and 'markup' fields are 'Nil'.
The list of revisions is retrieved in its historical order.

Also renamed the `workitem.WorkItemRevision` to `workitem.Revision`
and removed the `WorkItem` part in the revision constants.

Fixes #914

Signed-off-by: Xavier Coulon <xcoulon@redhat.com>
AdamJ pushed a commit to AdamJ/almighty-core that referenced this issue Mar 7, 2017
…ervices#930)

* Record work item comments revisions (fabric8-services#914)

Added a `comment_revisions` table to retain all changes on comments,
along with a timestamp, the Id of the author identity and the type
of operation that was performed.
When the comment is deleted, the 'body' and 'markup' fields are 'Nil'.
The list of revisions is retrieved in its historical order.

Also renamed the `workitem.WorkItemRevision` to `workitem.Revision`
and removed the `WorkItem` part in the revision constants.

Fixes fabric8-services#914

Signed-off-by: Xavier Coulon <xcoulon@redhat.com>
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

1 participant