Store the history of schema updates

XMLWordPrintable

    • Type: Feature Request
    • Resolution: Fixed
    • Priority: L3 - Default
    • 7.11.0
    • Affects Version/s: None
    • Component/s: engine
    • None

      AT:

      • There is a new table ACT_GE_SCHEMA_LOG
      • This table has two columns: ID_ (varchar, primary key), TIMESTAMP_ (date field), VERSION_ (varchar)
      • The create script inserts a row into this table with the current version and timestamp
      • The 7.11 update script inserts this row as well
      • There is a new query API in ManagementService to retrieve schema log entries (returning SchemaLogEntry)
      • I can filter the query by: version
      • I can order the query by: timestamp
      • I can apply limits
      • Authorization: I must be member of group camunda-admin for the query to return any results. If I am not member of this group, I get an empty list as result.
      • REST API: There is a new resource at path GET /schema/log that exposes the schema log query
      • Testing: There is a mechanism that ensures that the schema log always contains entries for the current schema version (two cases: I create the database from scratch; I update an existing database)

            Assignee:
            Miklas Boskamp
            Reporter:
            Thorben Lindhauer
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: