• Home
• io.spinnaker.keel
• keel-sql
• 0.199.0
• source code
• 20201203-cleanup-event-and-paused-orhpans.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.20201203-cleanup-event-and-paused-orhpans.yml Maven / Gradle / Ivy

databaseChangeLog:
- changeSet:
    id: cleanup-event-and-paused-orphans
    author: lpollo
    changes:
    - sql:
        sql: >
          delete from event
            where scope = 'APPLICATION'
            and not exists (select 1 from delivery_config where application = event.ref)
    - sql:
        sql: >
          delete from event
            where scope = 'RESOURCE'
            and not exists (select 1 from resource where uid = event.ref)
    - sql:
        sql: >
          delete from paused
            where scope = 'APPLICATION'
            and not exists (select 1 from delivery_config where application = paused.name)
    - sql:
        sql: >
          delete from paused
            where scope = 'RESOURCE'
            and not exists (select 1 from resource where id = paused.name)