db.changelog.20210609-add-metadata-to-environment.yml Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of keel-sql Show documentation

Spinnaker Keel

There is a newer version: 1.4.1

databaseChangeLog:
- changeSet:
    id: add-metadata-to-environment
    author: lpollo
    changes:
    - addColumn:
        tableName: environment
        columns:
        - name: metadata
          type: json
          constraints:
            nullable: true
    - dropView:
        viewName: active_environment
    - createView:
        viewName: active_environment
        selectQuery: |
          select uid, delivery_config_uid, name, version, is_preview, constraints, notifications, verifications, post_deploy_actions, metadata
          from environment
          join active_environment_version
            on environment.uid = active_environment_version.environment_uid
          join environment_version
            on environment_version.environment_uid = active_environment_version.environment_uid
            and environment_version.version = active_environment_version.active_version;