database‐migration‐ci.yml - elyjhone23/ado-pipe GitHub Wiki

trigger: none

parameters:
- name: dbName
  displayName: "Database name"
  type: string
  default: "testdb"

- name: dbUser
  displayName: "Database user"
  type: string
  default: "admin"

- name: dbEngine
  displayName: "Database engine"
  type: string
  default: "postgres"
  values:
    - postgres
    - sqlserver

- name: sqlScript
  displayName: "SQL script to execute"
  type: string
  default: "SELECT 1;"

variables:
- group: database-secrets

pool:
  vmImage: ubuntu-latest

jobs:
- job: TestInputs
  steps:
  - script: |
      echo "DB Name: ${{ parameters.dbName }}"
      echo "DB User: ${{ parameters.dbUser }}"
      echo "DB Engine: ${{ parameters.dbEngine }}"
      echo "SQL Script: ${{ parameters.sqlScript }}"
      echo "Password (masked): $(PRD_DB_USER_PASSWORD)"