• Home
• io.spinnaker.keel
• keel-sql
• 0.199.0
• source code
• 20200515-add-unique-id-to-event.yml

×

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.20200515-add-unique-id-to-event.yml Maven / Gradle / Ivy

databaseChangeLog:
- changeSet:
    id: add-unique-id-to-event
    author: fletch
    changes:
    - addColumn:
        tableName: event
        columns:
        - name: uid
          type: char(26)
          constraints:
            nullable: true
    - modifySql:
        dbms: mysql
        append:
          value: " first"
- changeSet:
    id: add-ref-to-events-with-no-uid
    author: fletch
    changes:
    - sql:
        sql: >
          update event
          set json = json_insert(json, '$.ref', json->'$.id')
          where not(json_contains_path(json, 'one', '$.uid'))
- changeSet:
    id: update-uid-to-ref-in-event-json
    author: fletch
    changes:
    - sql:
        sql: >
          update event
          set json = json_remove(json_insert(json, '$.ref', json->'$.uid'), '$.uid')
          where json_contains_path(json, 'one', '$.uid')