dataobjects-net/.github/workflows/auto-pgsql140-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
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: ⚙🐘🔅 Automated PostgreSQL 14.0 tests
run-name: Tests on PostgreSQL 14.0 tests triggered by '${{ github.event_name }}'. Run No ${{ github.run_number }}.

on:
  push:
    branches:
      - 'master'
      - 'master-*'
    paths:
      # containers
      - 'Containers/postgres/do-postgres-14'
      - 'Containers/postgres/**.sh'
      - 'Containers/postgres/**.sql'
      # extensions code only
      - 'Extensions/**'
      - '!Extensions/**.csproj'
      - '!Extensions/**.md'
      - '!Extensions/**.props'
      - '!Extensions/**.snk'
      #main project
      - 'Orm/Xtensive.Orm/**'
      - '!Orm/Xtensive.Orm/**.csproj'
      # provider
      - 'Orm/Xtensive.Orm.PostgreSql/**'
      - '!Orm/Xtensive.Orm.PostgreSql/**.csproj'
      - '!Orm/Xtensive.Orm.PostgreSql/NuGetContent/**'
      # tests framework
      - 'Orm/Xtensive.Orm.Framework/**'
      - '!Orm/Xtensive.Orm.Framework/**.csproj'
      # main test project - any code change
      - 'Orm/Xtensive.Orm.Tests/**'
      - '!Orm/Xtensive.Orm.Tests/**.csproj'
      # sql tests - general and provider-specific
      - 'Orm/Xtensive.Orm.Tests.Sql/**'
      - '!Orm/Xtensive.Orm.Tests.Sql/Firebird/**'
      - '!Orm/Xtensive.Orm.Tests.Sql/MySQL/**'
      - '!Orm/Xtensive.Orm.Tests.Sql/Oracle/**'
      #- '!Orm/Xtensive.Orm.Tests.Sql/PostgreSql/**'
      - '!Orm/Xtensive.Orm.Tests.Sql/Sqlite/**'
      - '!Orm/Xtensive.Orm.Tests.Sql/SqlServer/**'
      - '!Orm/Xtensive.Orm.Tests.Sql/SqlServerCe/**'
      - '!Orm/Xtensive.Orm.Tests.Sql/**.csproj'
      # weaver changes
      - 'Weaver/**'
      # ability to trigger on demand
      - 'TestFileForBuildServerTests.txt'

  pull_request:
    branches:
      - 'master'
    paths:
      # containers
      - 'Containers/postgres/do-postgres-14'
      - 'Containers/postgres/**.sh'
      - 'Containers/postgres/**.sql'
      # extensions code only
      - 'Extensions/**'
      - '!Extensions/**.csproj'
      - '!Extensions/**.md'
      - '!Extensions/**.props'
      - '!Extensions/**.snk'
      #main project
      - 'Orm/Xtensive.Orm/**'
      - '!Orm/Xtensive.Orm/**.csproj'
      # provider
      - 'Orm/Xtensive.Orm.PostgreSql/**'
      - '!Orm/Xtensive.Orm.PostgreSql/**.csproj'
      - '!Orm/Xtensive.Orm.PostgreSql/NuGetContent/**'
      # tests framework
      - 'Orm/Xtensive.Orm.Framework/**'
      - '!Orm/Xtensive.Orm.Framework/**.csproj'
      # main test project - any code change
      - 'Orm/Xtensive.Orm.Tests/**'
      - '!Orm/Xtensive.Orm.Tests/**.csproj'
      # sql tests - general and provider-specific
      - 'Orm/Xtensive.Orm.Tests.Sql/**'
      - '!Orm/Xtensive.Orm.Tests.Sql/Firebird/**'
      - '!Orm/Xtensive.Orm.Tests.Sql/MySQL/**'
      - '!Orm/Xtensive.Orm.Tests.Sql/Oracle/**'
      #- '!Orm/Xtensive.Orm.Tests.Sql/PostgreSql/**'
      - '!Orm/Xtensive.Orm.Tests.Sql/Sqlite/**'
      - '!Orm/Xtensive.Orm.Tests.Sql/SqlServer/**'
      - '!Orm/Xtensive.Orm.Tests.Sql/SqlServerCe/**'
      - '!Orm/Xtensive.Orm.Tests.Sql/**.csproj'
      # weaver changes
      - 'Weaver/**'
      # ability to trigger on demand
      - 'TestFileForBuildServerTests.txt'

  pull_request_review:
    branches:
      - 'master'
    paths:
      # containers
      - 'Containers/postgres/do-postgres-14'
      - 'Containers/postgres/**.sh'
      - 'Containers/postgres/**.sql'
      # extensions code only
      - 'Extensions/**'
      - '!Extensions/**.csproj'
      - '!Extensions/**.md'
      - '!Extensions/**.props'
      - '!Extensions/**.snk'
      #main project
      - 'Orm/Xtensive.Orm/**'
      - '!Orm/Xtensive.Orm/**.csproj'
      # provider
      - 'Orm/Xtensive.Orm.PostgreSql/**'
      - '!Orm/Xtensive.Orm.PostgreSql/**.csproj'
      - '!Orm/Xtensive.Orm.PostgreSql/NuGetContent/**'
      # tests framework
      - 'Orm/Xtensive.Orm.Framework/**'
      - '!Orm/Xtensive.Orm.Framework/**.csproj'
      # main test project - any code change
      - 'Orm/Xtensive.Orm.Tests/**'
      - '!Orm/Xtensive.Orm.Tests/**.csproj'
      # sql tests - general and provider-specific
      - 'Orm/Xtensive.Orm.Tests.Sql/**'
      - '!Orm/Xtensive.Orm.Tests.Sql/Firebird/**'
      - '!Orm/Xtensive.Orm.Tests.Sql/MySQL/**'
      - '!Orm/Xtensive.Orm.Tests.Sql/Oracle/**'
      #- '!Orm/Xtensive.Orm.Tests.Sql/PostgreSql/**'
      - '!Orm/Xtensive.Orm.Tests.Sql/Sqlite/**'
      - '!Orm/Xtensive.Orm.Tests.Sql/SqlServer/**'
      - '!Orm/Xtensive.Orm.Tests.Sql/SqlServerCe/**'
      - '!Orm/Xtensive.Orm.Tests.Sql/**.csproj'
      # weaver changes
      - 'Weaver/**'
      # ability to trigger on demand
      - 'TestFileForBuildServerTests.txt'

# 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_pgsql140:
    name: Tests on PostgreSQL 14.0
    strategy:
      matrix:
        net: [ 'net8.0', 'net10.0' ] # only LTS
    # For security reasons we allow test runs either for pushes from the team or for pull-requests after their changes were seen and approved by someone
    #
    # push filter - to cover pushes from the team to main branch of major version
    # first 'pull_request_review' filter - to cover external pull-requests, since there are major security concerns about content of pull-request we cannot allow auto-runs of tests
    # second 'pull_request_review' - to cover internal pull-requests that were not covered by 'on push' trigger
    #
    if: |
      github.event_name == 'push'
        || (github.event_name == 'pull_request_review'
             && github.event.pull_request.head.repo.full_name != github.event.pull_request.base.repo.full_name
             && startsWith(github.event.pull_request.base.ref, 'master')
             && github.event.review.state == 'approved')
        || (github.event_name == 'pull_request'
             && github.event.pull_request.head.repo.full_name == github.event.pull_request.base.repo.full_name
             && !startsWith(github.head_ref, 'master-'))
    uses: DataObjects-NET/dataobjects-net/.github/workflows/reusable-storage-dependant-tests.yml@master
    with:
      storage: pgsql140
      build_config: Release
      target_framework: ${{ matrix.net }}
      test_output_verbosity: minimal
      test_run_timeout: 30
      run_main: true
      run_sql: true
      run_extensions: true
      publish_raw_results: false