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

on:
  push:
    branches:
      - 'master'
      - 'master-*'
    paths:
      # containers
      - 'Containers/postgres/do-postgres-11'
      - 'Containers/postgres/**.sh'
      - 'Containers/postgres/**.sql'
      # main project - most common part, that may have changes that affect
      - 'Orm/Xtensive.Orm/Orm/Providers/**'
      - 'Orm/Xtensive.Orm/Orm/Rse/**'
      - 'Orm/Xtensive.Orm/Orm/Upgrade/**'
      - 'Orm/Xtensive.Orm/Sql/**'
      # provider
      - 'Orm/Xtensive.Orm.PostgreSql/**'
      - '!Orm/Xtensive.Orm.PostgreSql/**.csproj'
      - '!Orm/Xtensive.Orm.PostgreSql/NuGetContent/**'
      # main test project - any code change
      - 'Orm/Xtensive.Orm.Tests/Issues/**'
      - 'Orm/Xtensive.Orm.Tests/Storage/**'
      - 'Orm/Xtensive.Orm.Tests/Upgrade/**'
      # 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'
      # ability to trigger on demand
      - 'TestFileForBuildServerTests.txt'

  pull_request:
    branches:
      - 'master'
    paths:
      # containers
      - 'Containers/postgres/do-postgres-11'
      - 'Containers/postgres/**.sh'
      - 'Containers/postgres/**.sql'
      # main project - most common part, that may have changes that affect
      - 'Orm/Xtensive.Orm/Orm/Providers/**'
      - 'Orm/Xtensive.Orm/Orm/Rse/**'
      - 'Orm/Xtensive.Orm/Orm/Upgrade/**'
      - 'Orm/Xtensive.Orm/Sql/**'
      # provider
      - 'Orm/Xtensive.Orm.PostgreSql/**'
      - '!Orm/Xtensive.Orm.PostgreSql/**.csproj'
      - '!Orm/Xtensive.Orm.PostgreSql/NuGetContent/**'
      # main test project - any code change
      - 'Orm/Xtensive.Orm.Tests/Issues/**'
      - 'Orm/Xtensive.Orm.Tests/Storage/**'
      - 'Orm/Xtensive.Orm.Tests/Upgrade/**'
      # 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'
      # ability to trigger on demand
      - 'TestFileForBuildServerTests.txt'

  pull_request_review:
    branches:
      - 'master'
    paths:
      # containers
      - 'Containers/postgres/do-postgres-11'
      - 'Containers/postgres/**.sh'
      - 'Containers/postgres/**.sql'
      # main project - most common part, that may have changes that affect
      - 'Orm/Xtensive.Orm/Orm/Providers/**'
      - 'Orm/Xtensive.Orm/Orm/Rse/**'
      - 'Orm/Xtensive.Orm/Orm/Upgrade/**'
      - 'Orm/Xtensive.Orm/Sql/**'
      # provider
      - 'Orm/Xtensive.Orm.PostgreSql/**'
      - '!Orm/Xtensive.Orm.PostgreSql/**.csproj'
      - '!Orm/Xtensive.Orm.PostgreSql/NuGetContent/**'
      # main test project - any code change
      - 'Orm/Xtensive.Orm.Tests/Issues/**'
      - 'Orm/Xtensive.Orm.Tests/Storage/**'
      - 'Orm/Xtensive.Orm.Tests/Upgrade/**'
      # 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'
      # 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_pgsql110:
    name: Tests on PostgreSQL 11.0
    strategy:
      matrix:
        net: [ 'net8.0' ] # for cold runs we run for one .net
    # 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: pgsql110
      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