db.cy.yaml

trigger:
  - main

pool:
  vmImage: 'windows-latest'

variables:
  solution: '**/*.sln'
  buildPlatform: 'Any CPU'
  buildConfiguration: 'Release'
  unitTestDb:  intesa-db-unit

steps:
- task: NuGetToolInstaller@1

- task: MSBuild@1
  displayName: Database DACPAC build
  inputs:
    solution: 'src-db/ISPV/Database1/Database1.sqlproj'
    msbuildArguments: '/p:OutDir=$(Build.ArtifactStagingDirectory)'

- task: SqlDacpacDeploymentOnMachineGroup@0
  inputs:
    TaskType: 'dacpac'
    DacpacFile: '$(Build.ArtifactStagingDirectory)\Database1.dacpac'
    TargetMethod: 'server'
    ServerName: 'localhost'
    DatabaseName: $(unitTestDb)
    AuthScheme: 'sqlServerAuthentication'
    SqlUsername: 'sa'
    SqlPassword: '$(password)'

- task: PowerShell@2
  inputs:
    targetType: 'inline'
    script: '.\execAllTsql.ps1 -OutputFolder "$(Build.SourcesDirectory)" -DatabaseServer ".\" -userName sa -password $(password) -DatabaseName $(unitTestDb)'
    workingDirectory: '$(Build.SourcesDirectory)/src-db/ISPV/'

- task: PublishBuildArtifacts@1
  displayName: Publish binaries
  inputs:
    PathtoPublish: '$(Build.ArtifactStagingDirectory)'
    ArtifactName: 'drop'
    publishLocation: 'Container'