Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-9889

Store the history of schema updates

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Fixed
    • Icon: L3 - Default L3 - Default
    • 7.11.0
    • None
    • 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)

        This is the controller panel for Smart Panels app

            [CAM-9889] Store the history of schema updates

            Thorben Lindhauer created issue -
            Thorben Lindhauer made changes -
            Remote Link New: This issue links to "Page (camunda confluence)" [ 12741 ]
            Thorben Lindhauer made changes -
            Status Original: Open [ 1 ] New: Ready [ 10005 ]
            Daniel Meyer made changes -
            Link New: This issue is depended on by SUPPORT-5301 [ SUPPORT-5301 ]
            Thorben Lindhauer made changes -
            Assignee New: Miklas Boskamp [ miklas.boskamp ]
            Miklas Boskamp made changes -
            Assignee Original: Miklas Boskamp [ miklas.boskamp ] New: Thorben Lindhauer [ thorben.lindhauer ]
            Thorben Lindhauer made changes -
            Summary Original: Store the version of the database schema in the database New: Store the history of schema updates
            Thorben Lindhauer made changes -
            Description Original: * ACT_GE_PROPERTY
            * Consider to exposing via engine API
            * Decide how we can ensure that we always update this property with every patch that changes the schema
            Thorben Lindhauer made changes -
            Description New: 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/update-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)
            Miklas Boskamp made changes -
            Assignee Original: Thorben Lindhauer [ thorben.lindhauer ] New: Miklas Boskamp [ miklas.boskamp ]

              miklas.boskamp Miklas Boskamp
              thorben.lindhauer Thorben Lindhauer
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: