Project

General

Profile

Actions

Feature #2375

closed

Add a row to the Logs table whenever a row in any other [interesting] table is created or changed

Added by Tom Clegg about 10 years ago. Updated about 10 years ago.

Status:
Resolved
Priority:
Normal
Assigned To:
Category:
-
Story points:
1.0

Description

  • Log object is added even if "update" does not actually change the database content (e.g., "node is still alive")
  • Log object's "properties" attribute (rename it, it's currently called "info") includes:
    • uuid of user making the change (usually same as modified_by, except delete and some updates)
    • etag of the new version (nil for delete)
    • etag of the old version (nil for create)
    • all attributes of the new version (nil if deleting)
    • all attributes of the old version (nil if creating)
  • modified_by is current_user (the user whose transaction is being logged)
  • owner_uuid is system_user (this prevents users from deleting logs)

Subtasks 3 (0 open3 closed)

Task #2469: alter existing logs table to support logging of changesResolvedBrett Smith04/08/2014Actions
Task #2468: write one little code section (rake middleware? strategically placed active record call? Cf. acts-as-versioned gem) to log changesResolvedBrett Smith04/08/2014Actions
Task #2559: Review 2375-log-tableResolvedBrett Smith04/08/2014Actions
Actions

Also available in: Atom PDF