azure-pipelines.yml

trigger:
  - master
  - dev
  - 1ES

schedules:
- cron: "0 9 * * *"
  displayName: Daily midnight build
  branches:
    include:
    - dev
  always: true

variables:
- group: DjangoTestApp

jobs:
  - job: Windows
    pool:
      name: Django-1ES-pool
      demands:
      - imageOverride -equals JDBC-MMS2019-SQL2019-2
    timeoutInMinutes: 120

    strategy:
      matrix:
        Python3.12 - Django 5.0:
          python.version: '3.12'
          tox.env: 'py312-django50'
        Python3.11 - Django 5.0:
          python.version: '3.11'
          tox.env: 'py311-django50'
        Python3.10 - Django 5.0:
          python.version: '3.10'
          tox.env: 'py310-django50'

        Python3.11 - Django 4.2:
          python.version: '3.11'
          tox.env: 'py311-django42'
        Python3.10 - Django 4.2:
          python.version: '3.10'
          tox.env: 'py310-django42'
        Python 3.9 - Django 4.2:
          python.version: '3.9'
          tox.env: 'py39-django42'
        Python 3.8 - Django 4.2:
          python.version: '3.8'
          tox.env: 'py38-django42'

        Python3.11 - Django 4.1:
          python.version: '3.11'
          tox.env: 'py311-django41'
        Python3.10 - Django 4.1:
          python.version: '3.10'
          tox.env: 'py310-django41'
        Python 3.9 - Django 4.1:
          python.version: '3.9'
          tox.env: 'py39-django41'
        Python 3.8 - Django 4.1:
          python.version: '3.8'
          tox.env: 'py38-django41'

        Python3.11 - Django 4.0:
          python.version: '3.11'
          tox.env: 'py311-django40'
        Python3.10 - Django 4.0:
          python.version: '3.10'
          tox.env: 'py310-django40'
        Python 3.9 - Django 4.0:
          python.version: '3.9'
          tox.env: 'py39-django40'
        Python 3.8 - Django 4.0:
          python.version: '3.8'
          tox.env: 'py38-django40'

        Python3.11 - Django 3.2:
          python.version: '3.11'
          tox.env: 'py311-django32'
        Python 3.9 - Django 3.2:
          python.version: '3.9'
          tox.env: 'py39-django32'
        Python 3.8 - Django 3.2:
          python.version: '3.8'
          tox.env: 'py38-django32'


    steps:
      - task: CredScan@3
        inputs:
          toolMajorVersion: 'V2'

      - task: UsePythonVersion@0
        inputs:
          versionSpec: "$(python.version)"
        displayName: Use Python $(python.version)

      - powershell: |
          $IP=Get-NetIPAddress -AddressFamily IPv4 -InterfaceIndex $(Get-NetConnectionProfile -IPv4Connectivity Internet | Select-Object -ExpandProperty InterfaceIndex) | Select-Object -ExpandProperty IPAddress

          (Get-Content $pwd/testapp/settings.py).replace('localhost', $IP) | Set-Content $pwd/testapp/settings.py

          Invoke-WebRequest https://download.microsoft.com/download/6/f/f/6ffefc73-39ab-4cc0-bb7c-4093d64c2669/en-US/17.10.5.1/x64/msodbcsql.msi -OutFile msodbcsql.msi
          msiexec /quiet /passive /qn /i msodbcsql.msi IACCEPTMSODBCSQLLICENSETERMS=YES
          Get-OdbcDriver
        displayName: Install ODBC

      - powershell: |
          Import-Module "sqlps"
          Invoke-Sqlcmd @"
              EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2
              ALTER LOGIN [sa] ENABLE;
              ALTER LOGIN [sa] WITH PASSWORD = '$(TestAppPassword)', CHECK_POLICY=OFF;
          "@
        displayName: Set up SQL Server

      - powershell: |
          Restart-Service -Name MSSQLSERVER -Force
        displayName: Restart SQL Server

      - powershell: |
          (Get-Content -ReadCount 0 testapp\settings.py) -replace 'MyPassword42', '$(TestAppPassWord)' | Set-Content testapp\settings.py
        displayName: Change PASSWORD in settings.py

      - powershell: |
          python -m pip install --upgrade pip wheel setuptools
          python -m pip install tox
          git clone https://github.com/django/django.git

          python -m tox -e $(tox.env)
        displayName: Run tox

  - job: Linux
    pool:
      name: Django-1ES-pool
      demands:
      - imageOverride -equals Ubuntu22.04-AzurePipelines
    timeoutInMinutes: 120

    strategy:
      matrix:
        Python3.12 - Django 5.0:
          python.version: '3.12'
          tox.env: 'py312-django50'
        Python3.11 - Django 5.0:
          python.version: '3.11'
          tox.env: 'py311-django50'
        Python3.10 - Django 5.0:
          python.version: '3.10'
          tox.env: 'py310-django50'

        Python3.11 - Django 4.2:
          python.version: '3.11'
          tox.env: 'py311-django42'
        Python3.10 - Django 4.2:
          python.version: '3.10'
          tox.env: 'py310-django42'
        Python 3.9 - Django 4.2:
          python.version: '3.9'
          tox.env: 'py39-django42'
        Python 3.8 - Django 4.2:
          python.version: '3.8'
          tox.env: 'py38-django42'

        Python3.11 - Django 4.1:
          python.version: '3.11'
          tox.env: 'py311-django41'
        Python3.10 - Django 4.1:
          python.version: '3.10'
          tox.env: 'py310-django41'
        Python 3.9 - Django 4.1:
          python.version: '3.9'
          tox.env: 'py39-django41'
        Python 3.8 - Django 4.1:
          python.version: '3.8'
          tox.env: 'py38-django41'

        Python3.11 - Django 4.0:
          python.version: '3.11'
          tox.env: 'py311-django40'
        Python3.10 - Django 4.0:
          python.version: '3.10'
          tox.env: 'py310-django40'
        Python 3.9 - Django 4.0:
          python.version: '3.9'
          tox.env: 'py39-django40'
        Python 3.8 - Django 4.0:
          python.version: '3.8'
          tox.env: 'py38-django40'

        Python3.11 - Django 3.2:
          python.version: '3.11'
          tox.env: 'py311-django32'
        Python 3.9 - Django 3.2:
          python.version: '3.9'
          tox.env: 'py39-django32'
        Python 3.8 - Django 3.2:
          python.version: '3.8'
          tox.env: 'py38-django32'

    steps:
      - task: UsePythonVersion@0
        inputs:
          versionSpec: "$(python.version)"
        displayName: Use Python $(python.version)

      - script: |
          docker version
          docker pull mcr.microsoft.com/mssql/server:2022-latest
          docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=$(TestAppPassword)' -p 1433:1433 -d mcr.microsoft.com/mssql/server:2022-latest
          curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
          curl https://packages.microsoft.com/config/ubuntu/22.04/prod.list | sudo tee /etc/apt/sources.list.d/mssql-release.list
        displayName: Install SQL Server

      - script: |
          python -m pip install --upgrade pip wheel setuptools
          pip install tox
          git clone https://github.com/django/django.git
        displayName: Install requirements

      - script: |
          sed -i 's/MyPassword42/$(TestAppPassword)/g' testapp/settings.py
        displayName: Change PASSWORD in settings.py

      - script: tox -e $(tox.env)
        displayName: Run tox

      - task: PublishCodeCoverageResults@1
        inputs:
          codeCoverageTool: 'Cobertura'
          summaryFileLocation: 'django/coverage.xml'

      - task: PublishTestResults@2
        displayName: Publish test results via jUnit
        inputs:
          testResultsFormat: 'JUnit'
          testResultsFiles: 'django/result.xml'
          testRunTitle: 'junit-$(Agent.OS)-$(Agent.OSArchitecture)-$(tox.env)'