sqlalchemy/.github/workflows/run-test.yaml at main · dlevy-msft-sql/sqlalchemy · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
name: Run tests

on:
  # run on push in main or rel_* branches excluding changes are only on doc or example folders
  push:
    branches:
      - main
      - "rel_*"
      # branches used to test the workflow
      - "workflow_test_*"
    paths-ignore:
      - "examples/**"

env:
  # global env to all steps
  TOX_WORKERS: -n4

permissions:
  contents: read

jobs:
  run-test:
    name: test-${{ matrix.python-version }}-${{ matrix.os }}-${{ matrix.architecture }}-${{ matrix.build-type }}
    runs-on: ${{ matrix.os }}
    strategy:
      # run this job using this matrix, excluding some combinations below.
      matrix:
        os:
          - "ubuntu-22.04"
          - "ubuntu-22.04-arm"
          - "windows-latest"
          - "windows-11-arm"
          - "macos-latest"
        python-version:
          - "3.10"
          - "3.11"
          - "3.12"
          - "3.13"
          - "3.14"
          - "3.14t"
          - "pypy-3.11"
        build-type:
          # builds greenlet, runs asyncio tests.  includes aiosqlite driver
          - "cext-greenlet"

          # these do not install greenlet at all and skip asyncio tests.
          # does not include aiosqlite driver
          - "cext"
          - "nocext"
        architecture:
          - x64
          - x86
          - arm64

        include:
          # autocommit tests fail on the ci for some reason
          - python-version: "pypy-3.11"
            pytest-args: "-k 'not test_autocommit_on and not test_turn_autocommit_off_via_default_iso_level and not test_autocommit_isolation_level'"

        exclude:
          # cext-greenlet only runs on ubuntu x64 and arm64
          - build-type: "cext-greenlet"
            os: "windows-latest"
          - build-type: "cext-greenlet"
            os: "windows-11-arm"
          - build-type: "cext-greenlet"
            os: "macos-latest"

          # the threaded pythons are not stable under greenlet. Even
          # though we can run individual tests, when you run the whole suite
          # with xdist and the greenlet wrapper, the workers keep crashing
          # and getting replaced
          - build-type: "cext-greenlet"
            python-version: "3.13t"

          - build-type: "cext-greenlet"
            python-version: "3.14t"

          # linux do not have x86 / arm64 python
          - os: "ubuntu-22.04"
            architecture: x86
          - os: "ubuntu-22.04"
            architecture: arm64
          # linux-arm do not have x86 / x64 python
          - os: "ubuntu-22.04-arm"
            architecture: x86
          - os: "ubuntu-22.04-arm"
            architecture: x64
          # windows des not have arm64 python
          - os: "windows-latest"
            architecture: arm64
          # macos: latests uses arm macs. no x86/x64
          - os: "macos-latest"
            architecture: x86
          - os: "macos-latest"
            architecture: x64
          # pypy does not have cext or x86 or arm on linux
          - python-version: "pypy-3.11"
            build-type: "cext"
          - os: "ubuntu-22.04-arm"
            python-version: "pypy-3.11"
          - os: "windows-latest"
            python-version: "pypy-3.11"
            architecture: x86
          # Setup-python does not support any versions before 3.11 for arm64 windows
          - os: "windows-11-arm"
            python-version: "pypy-3.11"
          - os: "windows-11-arm"
            python-version: "3.10"
          - os: "windows-11-arm"
            architecture: x86
          - os: "windows-11-arm"
            architecture: x64

      fail-fast: false

    # steps to run in each job. Some are github actions, others run shell commands
    steps:
      - name: Checkout repo
        uses: actions/checkout@v4

      - name: Set up python
        uses: actions/setup-python@v5
        with:
          python-version: ${{ matrix.python-version }}
          architecture: ${{ matrix.architecture }}

      - name: Install dependencies
        run: |
          python -m pip install --upgrade pip
          pip install --upgrade nox setuptools
          pip list

      - name: Run tests
        run: nox -v -s github-${{ matrix.build-type }} -- ${{ matrix.pytest-args }}
        continue-on-error: ${{ matrix.python-version == 'pypy-3.11' }}

  run-nox:
    name: ${{ matrix.nox-env }}-${{ matrix.python-version }}
    runs-on: ${{ matrix.os }}
    strategy:
      # run this job using this matrix, excluding some combinations below.
      matrix:
        os:
          - "ubuntu-22.04"
        python-version:
          - "3.14"
        nox-env:
          - mypy
          - pep484
          - pep8

      fail-fast: false

    # steps to run in each job. Some are github actions, others run shell commands
    steps:
      - name: Checkout repo
        uses: actions/checkout@v4

      - name: Set up python
        uses: actions/setup-python@v5
        with:
          python-version: ${{ matrix.python-version }}
          architecture: ${{ matrix.architecture }}

      - name: Install dependencies
        run: |
          python -m pip install --upgrade pip
          pip install --upgrade nox setuptools
          pip list

      - name: Run nox
        run: nox -v -e ${{ matrix.nox-env }} ${{ matrix.pytest-args }}