azure-pipelines.yml

trigger: none
pr: none

variables:
- name: packageUrl
  value: "https://github.com/erikbra/grate/releases/download/1.6.1/grate_1.6.1-1_amd64.deb"
- name: localFile
  value: /tmp/grate_1.6.1-1_amd64.deb
- name: dbRoot
  value: $(Build.SourcesDirectory)/examples/scripts/sqlite

jobs:
- job: dryrun
  displayName: Dry run - see what will change
  pool:
    vmImage: ubuntu-latest
  steps:
  - pwsh: Invoke-WebRequest -Uri $(packageUrl) -OutFile $(localFile)
    displayName: Download grate
  - pwsh: sudo dpkg -i $(localFile)
    displayName: Install grate
  - pwsh: grate --help
    displayName: Make sure grate is successfully installed
  - pwsh: grate --silent --dryrun --databasetype sqlite --connectionstring "Data Source=devops-db.db" --files $(dbRoot)
    displayName: Run migration in dryRun mode

- job: validate_migration
  displayName: Wait for approval
  dependsOn: dryrun
  pool: server
  timeoutInMinutes: 10
  steps:
  - task: ManualValidation@0
    inputs:
      notifyUsers: 
      instructions: 'Please verify that the grate dryrun migration looks OK'

- job: run_actual_migration
  displayName: Run actual migration
  dependsOn: validate_migration
  pool: 
    vmImage: ubuntu-latest
  steps:
  - pwsh: Invoke-WebRequest -Uri $(packageUrl) -OutFile $(localFile)
    displayName: Download grate
  - pwsh: sudo dpkg -i $(localFile)
    displayName: Install grate
  - pwsh: grate --help
    displayName: Make sure grate is successfully installed
  - pwsh: grate --silent --databasetype sqlite --connectionstring "Data Source=devops-db.db" --files $(dbRoot)
    displayName: Run migration for real