db.changelog.20210420-add-post-deploy-actions.yml Maven / Gradle / Ivy
databaseChangeLog:
- changeSet:
id: add-environment-post-deploy-actions
author: emjburns
changes:
- addColumn:
tableName: environment
columns:
- column:
name: post_deploy_actions
type: json
- update:
tableName: environment
columns:
- column:
name: post_deploy_actions
value: '[]'
- addNotNullConstraint:
tableName: environment
columnName: post_deploy_actions
columnDataType: json
- dropView:
viewName: latest_environment
- createView:
viewName: latest_environment
selectQuery: |
select uid, delivery_config_uid, name, version, constraints, notifications, verifications, post_deploy_actions
from environment
join environment_version
on environment.uid = environment_version.environment_uid
and environment_version.version = (
select max(ev2.version)
from environment_version ev2
where environment.uid = ev2.environment_uid
);