Ploosh is easy to use and can be integrated with any CI/CD pipeline. The following steps are required to run Ploosh tests in Azure DevOps and publish the results into Azure DevOps Test Plans.

Exemple of pipeline

1. Install ODBC driver for SQL Server if SQL Server connector is used
2. Install Ploosh package from PyPi
3. Execute Ploosh

1. Publish test results

trigger:

main
variables:

group: demo

stages:
  - stage: 
    displayName: Build
    jobs:
      - job: 
        steps:
          - checkout: self
          - task: CmdLine@2
            displayName: Install ODBC driver for SQL Server
            inputs:
              script: |
                curl https://packages.microsoft.com/keys/microsoft.asc | sudo tee /etc/apt/trusted.gpg.d/microsoft.asc
                curl https://packages.microsoft.com/config/ubuntu/$(lsb_release -rs)/prod.list | sudo tee /etc/apt/sources.list.d/mssql-release.list
                sudo apt-get update
                sudo ACCEPT_EULA=Y apt-get install -y msodbcsql18
          - task: CmdLine@2
            displayName: Install ploosh
            inputs:
              script: |
                pip install ploosh
          - task: CmdLine@2
            displayName: Execute ploosh
            inputs:
              script: ploosh  --connections "connections.yml" --cases "testcases" --export "TRX" --failure False --pmysqlpassworddb "$(mysqlpassword)" --pmssqlpassworddb "$(mssqlpassword)" --ppostgresqlpassworddb "$(postgresql_password)"
          - task: PublishTestResults@2
            inputs:
              testResultsFormat: 'VSTest'
              testResultsFiles: '*.xml'
              searchFolder: 'output/trx/'
              mergeTestResults: true
              testRunTitle: '$(Build.DefinitionName)'