-
Notifications
You must be signed in to change notification settings - Fork 0
117 lines (109 loc) · 4.09 KB
/
devWorkflow.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
105
106
107
108
109
110
111
112
113
114
115
116
117
name: Dev Deployment
on:
push:
branches:
- main
paths:
- ".github/workflows/**"
- "code/MyDotNetCoreSqlProject/**"
- "code/MyDotNetSqlProject/**"
- "code/Scripts/**"
- "code/synapseParameters/**"
- "infra/**"
- "data-auto-dev-synapse001/**"
pull_request:
branches:
- main
paths:
- ".github/workflows/**"
- "code/MyDotNetCoreSqlProject/**"
- "code/MyDotNetSqlProject/**"
- "code/Scripts/**"
- "code/synapseParameters/**"
- "infra/**"
jobs:
sql_dotnet_build:
uses: ./.github/workflows/buildDotNetTemplate.yml
name: "Build SQL Project"
with:
build_artifact_name: buildDotNet
working_directory: "code/MyDotNetSqlProject/MyDotNetSqlProject"
sql_dotnetcore_build:
uses: ./.github/workflows/buildDotNetCoreTemplate.yml
name: "Build SQL Project"
with:
build_artifact_name: buildDotNetCore
dotnet_version: "6.0.x"
working_directory: "code/MyDotNetCoreSqlProject/"
infra_validation_dev:
uses: ./.github/workflows/infraValidationTemplate.yml
name: "Validation of IaC templates - Dev"
with:
environment: "dev"
secrets:
azure_subscription_id: ${{ secrets.AZURE_SUBSCRIPTION_ID }}
azure_resource_group_name: ${{ secrets.AZURE_RESOURCE_GROUP_NAME }}
azure_location_name: ${{ secrets.AZURE_LOCATION }}
tenant_id: ${{ secrets.TENANT_ID }}
client_id: ${{ secrets.CLIENT_ID }}
client_secret: ${{ secrets.CLIENT_SECRET }}
synapse_validation_dev:
uses: ./.github/workflows/synapseValidationTemplate.yml
name: "Validation of Synapse artifacts - Dev"
with:
environment: "dev"
target_synapse_workspace_name: "data-auto-dev-synapse001"
secrets:
azure_subscription_id: ${{ secrets.AZURE_SUBSCRIPTION_ID }}
azure_resource_group_name: ${{ secrets.AZURE_RESOURCE_GROUP_NAME }}
tenant_id: ${{ secrets.TENANT_ID }}
client_id: ${{ secrets.CLIENT_ID }}
client_secret: ${{ secrets.CLIENT_SECRET }}
sql_dotnetcore_report_dev:
uses: ./.github/workflows/sqlReportTemplate.yml
name: "Report SQL Changes - Dev"
needs: [sql_dotnet_build, sql_dotnetcore_build]
with:
environment: "dev"
build_artifact_name: "buildDotNetCore"
report_artifact_name: "reportDotNetCore"
working_directory: "code/MyDotNetCoreSqlProject/"
project_name: "MyDotNetCoreSqlProject"
secrets:
azure_subscription_id: ${{ secrets.AZURE_SUBSCRIPTION_ID }}
target_server_name: ${{ secrets.SQL_SERVER_NAME }}
target_database_name: ${{ secrets.SQL_DATABASE_NAME }}
tenant_id: ${{ secrets.TENANT_ID }}
client_id: ${{ secrets.CLIENT_ID }}
client_secret: ${{ secrets.CLIENT_SECRET }}
infra_deployment_dev:
uses: ./.github/workflows/infraDeploymentTemplate.yml
name: "Deployment of IaC templates - Dev"
needs: [infra_validation_dev, synapse_validation_dev, sql_dotnetcore_report_dev]
if: github.event_name == 'push' || github.event_name == 'release'
with:
environment: "dev"
secrets:
azure_subscription_id: ${{ secrets.AZURE_SUBSCRIPTION_ID }}
azure_resource_group_name: ${{ secrets.AZURE_RESOURCE_GROUP_NAME }}
azure_location_name: ${{ secrets.AZURE_LOCATION }}
tenant_id: ${{ secrets.TENANT_ID }}
client_id: ${{ secrets.CLIENT_ID }}
client_secret: ${{ secrets.CLIENT_SECRET }}
sql_dotnetcore_deployment_dev:
uses: ./.github/workflows/sqlDeploymentTemplate.yml
name: "Deploy SQL Changes - Dev"
needs: [infra_deployment_dev]
if: github.event_name == 'push' || github.event_name == 'release'
with:
environment: "dev"
build_artifact_name: "buildDotNetCore"
working_directory: "code/MyDotNetCoreSqlProject/"
project_name: "MyDotNetCoreSqlProject"
secrets:
azure_subscription_id: ${{ secrets.AZURE_SUBSCRIPTION_ID }}
target_server_name: ${{ secrets.SQL_SERVER_NAME }}
target_database_name: ${{ secrets.SQL_DATABASE_NAME }}
tenant_id: ${{ secrets.TENANT_ID }}
client_id: ${{ secrets.CLIENT_ID }}
client_secret: ${{ secrets.CLIENT_SECRET }}