dataobjects-net/.github/workflows/dispatched-mssql-tests.yml at master · DataObjects-NET/dataobjects-net · 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
name: 🛠📚 MS SQL Server tests
run-name: Run database tests on MS SQL Server on dispatch. Run No ${{ github.run_number }}.
on:
  workflow_dispatch:
    inputs:
      specific_sha:
        description: 'Commit SHA to checkout'
        required: false
        default: ''
        type: string
      show_all_fails:
        description: 'No mute tests'
        type: boolean
        default: false
        required: true
      mssql2017:
        description: 'MS SQL Server 2017'
        type: boolean
        default: false
        required: true
      mssql2019:
        description: 'MS SQL Server 2019'
        type: boolean
        default: true
        required: true
      mssql2022:
        description: 'MS SQL Server 2022'
        type: boolean
        default: false
        required: true
      mssql2025:
        description: 'MS SQL Server 2025'
        type: boolean
        default: true
        required: true

# new commits with the same key will cancel previously run workflows
concurrency:
  group: ${{ github.workflow }}-${{ github.ref }}
  cancel-in-progress: true

permissions:
  contents: read
  actions: read
  checks: write

jobs:
  test_on_mssql2017:
    name: Tests on MS SQL Server 2017
    if: ${{ inputs.mssql2017 }}
    strategy:
      matrix:
        net: [ 'net8.0', 'net10.0' ]
    uses: DataObjects-NET/dataobjects-net/.github/workflows/reusable-storage-dependant-tests.yml@master
    with:
      storage: mssql2017
      build_config: Release
      target_framework: ${{ matrix.net }}
      specific_sha: ${{ inputs.specific_sha }}
      show_all_fails: ${{ fromJSON(inputs.show_all_fails) }}
      test_output_verbosity: minimal
      test_run_timeout: 50
      run_main: true
      run_sql: true
      run_extensions: true
      publish_raw_results: true

  test_on_mssql2019:
    name: Tests on MS SQL Server 2019
    if: ${{ inputs.mssql2019 }}
    strategy:
      matrix:
        net: [ 'net8.0', 'net10.0' ]
    uses: DataObjects-NET/dataobjects-net/.github/workflows/reusable-storage-dependant-tests.yml@master
    with:
      storage: mssql2019
      build_config: Release
      target_framework: ${{ matrix.net }}
      specific_sha: ${{ inputs.specific_sha }}
      show_all_fails: ${{ fromJSON(inputs.show_all_fails) }}
      test_output_verbosity: minimal
      test_run_timeout: 50
      run_main: true
      run_sql: true
      run_extensions: true
      publish_raw_results: true

  test_on_mssql2022:
    name: Tests on MS SQL Server 2022
    if: ${{ inputs.mssql2022 }}
    strategy:
      matrix:
        net: [ 'net8.0', 'net10.0' ]
    uses: DataObjects-NET/dataobjects-net/.github/workflows/reusable-storage-dependant-tests.yml@master
    with:
      storage: mssql2022
      build_config: Release
      target_framework: ${{ matrix.net }}
      specific_sha: ${{ inputs.specific_sha }}
      show_all_fails: ${{ fromJSON(inputs.show_all_fails) }}
      test_output_verbosity: minimal
      test_run_timeout: 50
      run_main: true
      run_sql: true
      run_extensions: true
      publish_raw_results: true

  test_on_mssql2025:
    name: Tests on MS SQL Server 2025
    if: ${{ inputs.mssql2025 }}
    strategy:
      matrix:
        net: [ 'net8.0', 'net10.0' ]
    uses: DataObjects-NET/dataobjects-net/.github/workflows/reusable-storage-dependant-tests.yml@master
    with:
      storage: mssql2025
      build_config: Release
      target_framework: ${{ matrix.net }}
      specific_sha: ${{ inputs.specific_sha }}
      show_all_fails: ${{ fromJSON(inputs.show_all_fails) }}
      test_output_verbosity: minimal
      test_run_timeout: 50
      run_main: true
      run_sql: true
      run_extensions: true
      publish_raw_results: true