-
Notifications
You must be signed in to change notification settings - Fork 101
104 lines (94 loc) · 4.11 KB
/
integration-tests-azure.yml
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
---
name: Integration tests on Azure
on: # yamllint disable-line rule:truthy
workflow_dispatch:
push:
branches:
- master
- v*
pull_request:
branches:
- master
- v*
jobs:
integration-tests-azure:
name: Regular
strategy:
fail-fast: false
matrix:
python_version: ["3.7", "3.8", "3.9", "3.10", "3.11"]
profile: ["ci_azure_cli", "ci_azure_auto", "ci_azure_environment", "ci_azure_basic"]
msodbc_version: ["17", "18"]
runs-on: ubuntu-latest
container:
image: ghcr.io/${{ github.repository }}:CI-${{ matrix.python_version }}-msodbc${{ matrix.msodbc_version }}
steps:
- name: AZ CLI login
run: az login --service-principal --username="${AZURE_CLIENT_ID}" --password="${AZURE_CLIENT_SECRET}" --tenant="${AZURE_TENANT_ID}"
env:
AZURE_CLIENT_ID: ${{ secrets.DBT_AZURE_SP_NAME }}
AZURE_CLIENT_SECRET: ${{ secrets.DBT_AZURE_SP_SECRET }}
AZURE_TENANT_ID: ${{ secrets.DBT_AZURE_TENANT }}
- uses: actions/checkout@v3
- name: Install dependencies
run: pip install -r dev_requirements.txt
- name: Wake up server
env:
DBT_AZURESQL_SERVER: ${{ secrets.DBT_AZURESQL_SERVER }}
DBT_AZURESQL_DB: ${{ secrets.DBT_AZURESQL_DB }}
DBT_AZURESQL_UID: ${{ secrets.DBT_AZURESQL_UID }}
DBT_AZURESQL_PWD: ${{ secrets.DBT_AZURESQL_PWD }}
MSODBC_VERSION: ${{ matrix.msodbc_version }}
run: python devops/scripts/wakeup_azure.py
- name: Configure test users
run: sqlcmd -b -I -i devops/scripts/init.sql
env:
DBT_TEST_USER_1: DBT_TEST_USER_1
DBT_TEST_USER_2: DBT_TEST_USER_2
DBT_TEST_USER_3: DBT_TEST_USER_3
SQLCMDUSER: ${{ secrets.DBT_AZURESQL_UID }}
SQLCMDPASSWORD: ${{ secrets.DBT_AZURESQL_PWD }}
SQLCMDSERVER: ${{ secrets.DBT_AZURESQL_SERVER }}
SQLCMDDBNAME: ${{ secrets.DBT_AZURESQL_DB }}
- name: Run functional tests
env:
DBT_AZURESQL_SERVER: ${{ secrets.DBT_AZURESQL_SERVER }}
DBT_AZURESQL_DB: ${{ secrets.DBT_AZURESQL_DB }}
DBT_AZURESQL_UID: ${{ secrets.DBT_AZURESQL_UID }}
DBT_AZURESQL_PWD: ${{ secrets.DBT_AZURESQL_PWD }}
AZURE_CLIENT_ID: ${{ secrets.DBT_AZURE_SP_NAME }}
AZURE_CLIENT_SECRET: ${{ secrets.DBT_AZURE_SP_SECRET }}
AZURE_TENANT_ID: ${{ secrets.DBT_AZURE_TENANT }}
DBT_TEST_USER_1: DBT_TEST_USER_1
DBT_TEST_USER_2: DBT_TEST_USER_2
DBT_TEST_USER_3: DBT_TEST_USER_3
SQLSERVER_TEST_DRIVER: 'ODBC Driver ${{ matrix.msodbc_version }} for SQL Server'
run: pytest --ignore=tests/functional/adapter/test_provision_users.py -ra -v tests/functional --profile "${{ matrix.profile }}"
flaky-tests-azure:
name: Flaky tests on Azure
runs-on: ubuntu-latest
container:
image: ghcr.io/${{ github.repository }}:CI-3.11-msodbc18
steps:
- uses: actions/checkout@v3
- name: Install dependencies
run: pip install -r dev_requirements.txt
- name: Wake up server
env:
DBT_AZURESQL_SERVER: ${{ secrets.DBT_AZURESQL_SERVER }}
DBT_AZURESQL_DB: ${{ secrets.DBT_AZURESQL_DB }}
DBT_AZURESQL_UID: ${{ secrets.DBT_AZURESQL_UID }}
DBT_AZURESQL_PWD: ${{ secrets.DBT_AZURESQL_PWD }}
MSODBC_VERSION: ${{ matrix.msodbc_version }}
run: python devops/scripts/wakeup_azure.py
- name: Run auto provisioning tests
env:
DBT_AZURESQL_SERVER: ${{ secrets.DBT_AZURESQL_SERVER }}
DBT_AZURESQL_DB: ${{ secrets.DBT_AZURESQL_DB }}
AZURE_CLIENT_ID: ${{ secrets.DBT_AZURE_SP_NAME }}
AZURE_CLIENT_SECRET: ${{ secrets.DBT_AZURE_SP_SECRET }}
AZURE_TENANT_ID: ${{ secrets.DBT_AZURE_TENANT }}
DBT_TEST_AAD_PRINCIPAL_1: ${{ secrets.DBT_TEST_AAD_PRINCIPAL_1 }}
DBT_TEST_AAD_PRINCIPAL_2: ${{ secrets.DBT_TEST_AAD_PRINCIPAL_2 }}
SQLSERVER_TEST_DRIVER: 'ODBC Driver 18 for SQL Server'
run: pytest -ra -v tests/functional/adapter/test_provision_users.py --profile "ci_azure_environment"