• Home
• io.spinnaker.keel
• keel-sql
• 0.199.0
• source code
• 20210526-remove-deprecated-verification-fields.yaml

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.changelog.20210526-remove-deprecated-verification-fields.yaml Maven / Gradle / Ivy

databaseChangeLog:
- changeSet:
    id: remove-deprecated-verification-fields
    author: fletch
    changes:
    - sql:
        sql: |
          update environment
          set verifications = json_set(verifications, '$[0].image', verifications ->> '$[0].imageId')
          where json_length(verifications) > 0
          and verifications ->> '$[0].image' is null;
    - sql:
        sql: |
          update environment
          set verifications = json_remove(verifications, '$[0].imageId', '$[0].repository', '$[0].tag')
          where json_length(verifications) > 0;