db.changelog.20200302-drop-api-version.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: drop-api-version
    author: fletch
    changes:
    - sql:
        sql: >
          update resource
          set kind = concat(
            substring(api_version, 1, locate('.', api_version) - 1),
            '/',
            kind,
            '@',
            substring(api_version, locate('/', api_version) + 1)
          )
    - dropColumn:
        tableName: resource
        columnName: api_version
    rollback:
      - createColumn:
          tableName: resource
          column:
            name: api_version
            type: varchar(255)
      - sql:
          sql: update resource set api_version = concat(substring(kind, 1, locate('/', kind) - 1), '.spinnaker.netflix.com/v1')
      - addNotNullConstraint:
          tableName: resource
          columnName: api_version
          columnDataType: varchar(255)
      - sql:
          sql: update resource set kind = substring(kind, locate('/', kind) + 1)
      - sql:
          sql: update resource set kind = substring(kind, 1, locate('@', kind) - 1)