azure-pipelines.yml

# ASP.NET Core (.NET Framework)
# Build and test ASP.NET Core projects targeting the full .NET Framework.
# Add steps that publish symbols, save build artifacts, and more:
# https://docs.microsoft.com/azure/devops/pipelines/languages/dotnet-core
name: 1.0.0$(rev:.r)
trigger:
- master

pool:
  vmImage: 'windows-latest'

variables:
  solution: '**/*.sln'
  buildPlatform: 'Any CPU'
  buildConfiguration: 'Release'

steps:
- task: NuGetToolInstaller@1

- task: UseDotNet@2
  displayName: 'Use .NET Core sdk'
  inputs:
    packageType: sdk
    version: 2.x
    installationPath: $(Agent.ToolsDirectory)/dotnet

- task: DotNetCoreCLI@2
  inputs:
    command: 'restore'
    projects: '$(solution)'
    feedsToUse: 'select'

- task: DotNetCoreCLI@2
  inputs:
    command: 'build'
    arguments: '--no-restore --configuration $(BuildConfiguration) /p:Version=$(Build.BuildNumber) /p:AssemblyVersion=1.0.0.0'

- task: DotNetCoreCLI@2
  inputs:
    command: 'test'
    projects: '**/*Test/*.csproj'
    arguments: '--no-build --no-restore --configuration $(buildConfiguration) --collect "Code coverage"'

- task: SqlAzureDacpacDeployment@1
  inputs:
    azureSubscription: $(AZURESUBSCRIPTION)
    AuthenticationType: 'server'
    ServerName: $(SERVERNAME)
    DatabaseName: $(DATABASENAME_W)
    SqlUsername: $(USERNAME)
    SqlPassword: $(PASSWORD)
    deployType: 'SqlTask'
    SqlFile: '$(System.DefaultWorkingDirectory)/HighAvailabilityModule.Server.SQL/SQLstartup.sql'
    IpDetectionMethod: 'AutoDetect'

- task: SqlAzureDacpacDeployment@1
  inputs:
    azureSubscription: $(AZURESUBSCRIPTION)
    AuthenticationType: 'server'
    ServerName: $(SERVERNAME)
    DatabaseName: $(DATABASENAME_W)
    SqlUsername: $(USERNAME)
    SqlPassword: $(PASSWORD)
    deployType: 'SqlTask'
    SqlFile: '$(System.DefaultWorkingDirectory)/HighAvailabilityModule.UnitTest.SQL/tSQLt.class.sql'
    IpDetectionMethod: 'AutoDetect'

- task: SqlAzureDacpacDeployment@1
  inputs:
    azureSubscription: $(AZURESUBSCRIPTION)
    AuthenticationType: 'server'
    ServerName: $(SERVERNAME)
    DatabaseName: $(DATABASENAME_W)
    SqlUsername: $(USERNAME)
    SqlPassword: $(PASSWORD)
    deployType: 'SqlTask'
    SqlFile: '$(System.DefaultWorkingDirectory)/HighAvailabilityModule.UnitTest.SQL/MembershipServerSQLUnitTest.sql'
    IpDetectionMethod: 'AutoDetect'

- task: runtsqltunittests@0
  inputs:
    connectionString: $(CONSTR_W)
    queryTimeout: '60'
    rootOutput: '$(System.DefaultWorkingDirectory)/tSQLt-out'
    testResultsFileName: 'TEST-Results.xml'
    enableCodeCoverage: false
    coberturaFileName: 'Cobertura.xml'
    htmlReportsOutput: '$(System.DefaultWorkingDirectory)/AzurePipelines'
    testOrClassName: 'Dummy'

# - task: PublishCodeCoverageResults@1
#   inputs:
#     codeCoverageTool: 'Cobertura'
#     summaryFileLocation: '$(Build.SourcesDirectory)/out/Cobertura.xml'
#     reportDirectory: '$(Build.SourcesDirectory)/out/AzurePipelines.html'

- task: SqlAzureDacpacDeployment@1
  inputs:
    azureSubscription: $(AZURESUBSCRIPTION)
    AuthenticationType: 'server'
    ServerName: $(SERVERNAME)
    DatabaseName: $(DATABASENAME_S)
    SqlUsername: $(USERNAME)
    SqlPassword: $(PASSWORD)
    deployType: 'SqlTask'
    SqlFile: '$(System.DefaultWorkingDirectory)/HighAvailabilityModule.Storage.Server/startup.sql'
    IpDetectionMethod: 'AutoDetect'

- task: SqlAzureDacpacDeployment@1
  inputs:
    azureSubscription: $(AZURESUBSCRIPTION)
    AuthenticationType: 'server'
    ServerName: $(SERVERNAME)
    DatabaseName: $(DATABASENAME_S)
    SqlUsername: $(USERNAME)
    SqlPassword: $(PASSWORD)
    deployType: 'SqlTask'
    SqlFile: '$(System.DefaultWorkingDirectory)/HighAvailabilityModule.UnitTest.SQL/tSQLt.class.sql'
    IpDetectionMethod: 'AutoDetect'

- task: SqlAzureDacpacDeployment@1
  inputs:
    azureSubscription: $(AZURESUBSCRIPTION)
    AuthenticationType: 'server'
    ServerName: $(SERVERNAME)
    DatabaseName: $(DATABASENAME_S)
    SqlUsername: $(USERNAME)
    SqlPassword: $(PASSWORD)
    deployType: 'SqlTask'
    SqlFile: '$(System.DefaultWorkingDirectory)/HighAvailabilityModule.UnitTest.SQL/MembershipSQLStorageUnitTest.sql'
    IpDetectionMethod: 'AutoDetect'

- task: runtsqltunittests@0
  inputs:
    connectionString: $(CONSTR_S)
    queryTimeout: '60'
    rootOutput: '$(System.DefaultWorkingDirectory)/tSQLt-out'
    testResultsFileName: 'TEST-Results2.xml'
    enableCodeCoverage: false
    coberturaFileName: 'Cobertura2.xml'
    htmlReportsOutput: '$(System.DefaultWorkingDirectory)/AzurePipelines2'
    testOrClassName: 'Dummy'

- task: PublishTestResults@2
  inputs:
    testResultsFormat: 'JUnit'
    testResultsFiles: '**/TEST-*.xml'

- task: NuGetCommand@2
  inputs:
    command: 'pack'
    packagesToPack: '**/*.nuspec'
    versioningScheme: 'byBuildNumber'
    includeSymbols: true

- task: NuGetCommand@2
  inputs:
    command: 'push'
    packagesToPush: '$(Build.ArtifactStagingDirectory)/**/*.nupkg;!$(Build.ArtifactStagingDirectory)/**/*.symbols.nupkg'
    nuGetFeedType: 'internal'
    publishVstsFeed: 'cee98d90-2032-4dbd-a9f1-fef9a7662fc7'
    allowPackageConflicts: true