@@ -14,170 +14,170 @@ defaults:
14
14
15
15
jobs :
16
16
17
- build :
18
- name : Build and test on ${{matrix.db_version_name}} DB
19
- runs-on : ubuntu-latest
20
- env :
21
- ORACLE_VERSION : ${{matrix.oracle-version}}
22
- CONNECTION_STR : ${{matrix.connection-str}}
23
- ORACLE_PASSWORD : oracle
24
- DOCKER_VOLUME : ${{matrix.docker-volume}}
25
- strategy :
26
- fail-fast : false
27
- matrix :
28
- include :
29
- - oracle-version : " gvenzl/oracle-xe:11-full"
30
- connection-str : ' 127.0.0.1:1521/XE'
31
- id : 1
32
- db_version_name : ' 11xe'
33
- # TODO - need to add healthcheck.sh into our containers
34
- # - oracle-version: "utplsqlv3/oracledb:12c-r1-se2-small"
35
- # connection-str: '127.0.0.1:1521/ORCLCDB'
36
- # id: 2
37
- # db_version_name: '12.1se'
38
- # - oracle-version: "utplsqlv3/oracledb:12c-r2-se2-small"
39
- # connection-str: '127.0.0.1:1521/ORCLCDB'
40
- # id: 3
41
- # db_version_name: '12.2se'
42
- - oracle-version : " gvenzl/oracle-xe:18-slim"
43
- connection-str : ' 127.0.0.1:1521/XE'
44
- id : 4
45
- db_version_name : ' 18xe'
46
- # - oracle-version: "utplsqlv3/oracledb:18c-se2-small"
47
- # connection-str: '127.0.0.1:1521/ORCLCDB'
48
- # id: 5
49
- # db_version_name: '18se'
50
- # - oracle-version: "utplsqlv3/oracledb:19c-se2-small"
51
- # connection-str: '127.0.0.1:1521/ORCLCDB'
52
- # id: 6
53
- # db_version_name: '19se'
54
- - oracle-version : " gvenzl/oracle-xe:21-slim"
55
- connection-str : ' 127.0.0.1:1521/XE'
56
- id : 7
57
- db_version_name : ' 21xe'
58
-
59
- services :
60
- oracle :
61
- image : ${{matrix.oracle-version}}
62
- env :
63
- ORACLE_PASSWORD : oracle
64
- MATRIX_JOB_ID : ${{matrix.id}}
65
- credentials :
66
- username : ${{ secrets.DOCKER_USER }}
67
- password : ${{ secrets.DOCKER_PASSWORD }}
68
- ports :
69
- - 1521:1521
70
- options : >-
71
- --health-cmd healthcheck.sh
72
- --health-interval 10s
73
- --health-timeout 5s
74
- --health-retries 10
75
-
76
- steps :
77
- - uses : actions/checkout@v2
78
- with :
79
- fetch-depth : 0
80
- - uses : c-py/action-dotenv-to-setenv@v2
81
- with :
82
- env-file : .github/variables/.env
83
- - uses : FranzDiebold/github-env-vars-action@v2 # https://github.com/marketplace/actions/github-environment-variables-action
84
-
85
- - name : Set build version number env variables
86
- id : set-build-version-number-vars
87
- run : .github/scripts/set_version_numbers_env.sh
88
-
89
- - name : Update project version & build number to verify that code is deployable after the update
90
- id : update-project-version
91
- run : .github/scripts/update_project_version.sh
92
-
93
- - name : Download utPLSQL release for testing
94
- # For PR build - test using target branch as framework, for branch build use self as testing framework
95
- run : git clone --depth=1 --branch=${CI_HEAD_REF:-$CI_REF_NAME} https://github.com/utPLSQL/utPLSQL.git $UTPLSQL_DIR
96
-
97
- - name : Update privileges on sources
98
- run : chmod -R go+w ./{source,test,examples,${UTPLSQL_DIR}/source}
99
-
100
- - name : Add OJDBC home
101
- id : get-ojdbc
102
- run : mkdir -p ${OJDBC_HOME} && curl -Lk -o ${OJDBC_HOME}/ojdbc8.jar ${OJDBC_URL}/ojdbc8.jar && curl -Lk -o ${OJDBC_HOME}/orai18n.jar ${OJDBC_URL}/orai18n.jar
103
-
104
- - name : Install utPLSQL-cli
105
- id : install-utplsql-cli
106
- run : curl -Lk -o utPLSQL-cli.zip "https://github.com/utPLSQL/utPLSQL-cli/releases/download/v3.1.8/utPLSQL-cli.zip" && unzip utPLSQL-cli.zip && chmod -R u+x utPLSQL-cli
107
-
108
- - name : Install utPLSQL
109
- id : install-utplsql
110
- run : docker run --rm -v $(pwd):/utPLSQL -w /utPLSQL --network host --entrypoint bash ${DOCKER_ENV} ${ORACLE_VERSION} .github/scripts/install.sh
111
-
112
- - name : Install utPLSQL release
113
- id : install-utplsql-release
114
- run : docker run --rm -v $(pwd):/utPLSQL -w /utPLSQL --network host --entrypoint bash ${DOCKER_ENV} ${ORACLE_VERSION} .github/scripts/install_utplsql_release.sh
115
-
116
- - name : Run Examples
117
- id : run-examples
118
- run : docker run --rm -v $(pwd):/utPLSQL -w /utPLSQL --network host --entrypoint bash ${DOCKER_ENV} ${ORACLE_VERSION} .github/scripts/run_examples.sh
119
-
120
- - name : Install tests
121
- id : install-tests
122
- run : docker run --rm -v $(pwd):/utPLSQL -w /utPLSQL --network host --entrypoint bash ${DOCKER_ENV} ${ORACLE_VERSION} test/install_tests.sh
123
-
124
- - name : Run Tests
125
- id : run-tests
126
- run : bash test/run_tests.sh
127
-
128
- - name : Validate utPLSQL reports format
129
- id : validate-reports-format
130
- run : bash .github/scripts/validate_report_files.sh
131
-
132
- - name : SonarCloud Scan
133
- id : sonar
134
- uses : SonarSource/sonarcloud-github-action@master
135
- env :
136
- GITHUB_TOKEN : ${{ secrets.GITHUB_TOKEN }} # Needed to get PR information, if any
137
- SONAR_TOKEN : ${{ secrets.SONAR_TOKEN }}
138
-
139
- publish :
140
- name : Deploy documentation
141
- needs : [ build ]
142
- concurrency : publish
143
- runs-on : ubuntu-latest
144
- if : |
145
- github.repository == 'utPLSQL/utPLSQL' &&
146
- github.base_ref == null &&
147
- ( startsWith( github.ref, 'refs/heads/release/v' )
148
- || github.ref == 'refs/heads/develop'
149
- || github.ref == 'refs/heads/feature/github_actions'
150
- )
151
- steps :
152
- - uses : actions/checkout@v2
153
- with :
154
- fetch-depth : 0
155
- - uses : c-py/action-dotenv-to-setenv@v2
156
- with :
157
- env-file : .github/variables/.env
158
- - uses : FranzDiebold/github-env-vars-action@v2 # https://github.com/marketplace/actions/github-environment-variables-action
159
- - name : Set buid version number env variables
160
- id : set-build-version-number-vars
161
-
10000
run : .github/scripts/set_version_numbers_env.sh
162
- - name : Update project version & build number in source code and documentation
163
- id : update-project-version
164
- run : .github/scripts/update_project_version.sh
165
- - name : Push version update to repository
166
- id : push-version-number-update
167
- run : |
168
- git add sonar-project.properties VERSION source/* docs/*
169
- git commit -m 'Updated project version after build [skip ci]'
170
- git push --quiet origin HEAD:${CI_ACTION_REF_NAME}
171
- - name : Copy and push documentation to utPLSQL-github-io repo
172
- id : push-documentation
173
- env :
174
- API_TOKEN_GITHUB : ${{ secrets.API_TOKEN_GITHUB }}
175
- run : .github/scripts/push_docs_to_github_io.sh
17
+ # build:
18
+ # name: Build and test on ${{matrix.db_version_name}} DB
19
+ # runs-on: ubuntu-latest
20
+ # env:
21
+ # ORACLE_VERSION: ${{matrix.oracle-version}}
22
+ # CONNECTION_STR: ${{matrix.connection-str}}
23
+ # ORACLE_PASSWORD: oracle
24
+ # DOCKER_VOLUME: ${{matrix.docker-volume}}
25
+ # strategy:
26
+ # fail-fast: false
27
+ # matrix:
28
+ # include:
29
+ # - oracle-version: "gvenzl/oracle-xe:11-full"
30
+ # connection-str: '127.0.0.1:1521/XE'
31
+ # id: 1
32
+ # db_version_name: '11xe'
33
+ # # TODO - need to add healthcheck.sh into our containers
34
+ # # - oracle-version: "utplsqlv3/oracledb:12c-r1-se2-small"
35
+ # # connection-str: '127.0.0.1:1521/ORCLCDB'
36
+ # # id: 2
37
+ # # db_version_name: '12.1se'
38
+ # # - oracle-version: "utplsqlv3/oracledb:12c-r2-se2-small"
39
+ # # connection-str: '127.0.0.1:1521/ORCLCDB'
40
+ # # id: 3
41
+ # # db_version_name: '12.2se'
42
+ # - oracle-version: "gvenzl/oracle-xe:18-slim"
43
+ # connection-str: '127.0.0.1:1521/XE'
44
+ # id: 4
45
+ # db_version_name: '18xe'
46
+ # # - oracle-version: "utplsqlv3/oracledb:18c-se2-small"
47
+ # # connection-str: '127.0.0.1:1521/ORCLCDB'
48
+ # # id: 5
49
+ # # db_version_name: '18se'
50
+ # # - oracle-version: "utplsqlv3/oracledb:19c-se2-small"
51
+ # # connection-str: '127.0.0.1:1521/ORCLCDB'
52
+ # # id: 6
53
+ # # db_version_name: '19se'
54
+ # - oracle-version: "gvenzl/oracle-xe:21-slim"
55
+ # connection-str: '127.0.0.1:1521/XE'
56
+ # id: 7
57
+ # db_version_name: '21xe'
58
+ #
59
+ # services:
60
+ # oracle:
61
+ # image: ${{matrix.oracle-version}}
62
+ # env:
63
+ # ORACLE_PASSWORD: oracle
64
+ # MATRIX_JOB_ID: ${{matrix.id}}
65
+ # credentials:
66
+ # username: ${{ secrets.DOCKER_USER }}
67
+ # password: ${{ secrets.DOCKER_PASSWORD }}
68
+ # ports:
69
+ # - 1521:1521
70
+ # options: >-
71
+ # --health-cmd healthcheck.sh
72
+ # --health-interval 10s
73
+ # --health-timeout 5s
74
+ # --health-retries 10
75
+ #
76
+ # steps:
77
+ # - uses: actions/checkout@v2
78
+ # with:
79
+ # fetch-depth: 0
80
+ # - uses: c-py/action-dotenv-to-setenv@v2
81
+ # with:
82
+ # env-file: .github/variables/.env
83
+ # - uses: FranzDiebold/github-env-vars-action@v2 #https://github.com/marketplace/actions/github-environment-variables-action
84
+ #
85
+ # - name: Set build version number env variables
86
+ # id: set-build-version-number-vars
87
+ # run: .github/scripts/set_version_numbers_env.sh
88
+ #
89
+ # - name: Update project version & build number to verify that code is deployable after the update
90
+ # id: update-project-version
91
+ # run: .github/scripts/update_project_version.sh
92
+ #
93
+ # - name: Download utPLSQL release for testing
94
+ # # For PR build - test using target branch as framework, for branch build use self as testing framework
95
+ # run: git clone --depth=1 --branch=${CI_HEAD_REF:-$CI_REF_NAME} https://github.com/utPLSQL/utPLSQL.git $UTPLSQL_DIR
96
+ #
97
+ # - name: Update privileges on sources
98
+ # run: chmod -R go+w ./{source,test,examples,${UTPLSQL_DIR}/source}
99
+ #
100
+ # - name: Add OJDBC home
101
+ # id: get-ojdbc
102
+ # run: mkdir -p ${OJDBC_HOME} && curl -Lk -o ${OJDBC_HOME}/ojdbc8.jar ${OJDBC_URL}/ojdbc8.jar && curl -Lk -o ${OJDBC_HOME}/orai18n.jar ${OJDBC_URL}/orai18n.jar
103
+ #
104
+ # - name: Install utPLSQL-cli
105
+ # id: install-utplsql-cli
106
+ # run: curl -Lk -o utPLSQL-cli.zip "https://github.com/utPLSQL/utPLSQL-cli/releases/download/v3.1.8/utPLSQL-cli.zip" && unzip utPLSQL-cli.zip && chmod -R u+x utPLSQL-cli
107
+ #
108
+ # - name: Install utPLSQL
109
+ # id: install-utplsql
110
+ # run: docker run --rm -v $(pwd):/utPLSQL -w /utPLSQL --network host --entrypoint bash ${DOCKER_ENV} ${ORACLE_VERSION} .github/scripts/install.sh
111
+ #
112
+ # - name: Install utPLSQL release
113
+ # id: install-utplsql-release
114
+ # run: docker run --rm -v $(pwd):/utPLSQL -w /utPLSQL --network host --entrypoint bash ${DOCKER_ENV} ${ORACLE_VERSION} .github/scripts/install_utplsql_release.sh
115
+ #
116
+ # - name: Run Examples
117
+ # id: run-examples
118
+ # run: docker run --rm -v $(pwd):/utPLSQL -w /utPLSQL --network host --entrypoint bash ${DOCKER_ENV} ${ORACLE_VERSION} .github/scripts/run_examples.sh
119
+ #
120
+ # - name: Install tests
121
+ # id: install-tests
122
+ # run: docker run --rm -v $(pwd):/utPLSQL -w /utPLSQL --network host --entrypoint bash ${DOCKER_ENV} ${ORACLE_VERSION} test/install_tests.sh
123
+ #
124
+ # - name: Run Tests
125
+ # id: run-tests
126
+ # run: bash test/run_tests.sh
127
+ #
128
+ # - name: Validate utPLSQL reports format
129
+ # id: validate-reports-format
130
+ # run: bash .github/scripts/validate_report_files.sh
131
+ #
132
+ # - name: SonarCloud Scan
133
+ # id: sonar
134
+ # uses: SonarSource/sonarcloud-github-action@master
135
+ # env:
136
+ # GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }} # Needed to get PR information, if any
137
+ # SONAR_TOKEN: ${{ secrets.SONAR_TOKEN }}
138
+ #
139
+ # publish:
140
+ # name: Deploy documentation
141
+ # needs: [ build ]
142
+ # concurrency: publish
143
+ # runs-on: ubuntu-latest
144
+ # if: |
145
+ # github.repository == 'utPLSQL/utPLSQL' &&
146
+ # github.base_ref == null &&
147
+ # ( startsWith( github.ref, 'refs/heads/release/v' )
148
+ # || github.ref == 'refs/heads/develop'
149
+ # || github.ref == 'refs/heads/feature/github_actions'
150
+ # )
151
+ # steps:
152
+ # - uses: actions/checkout@v2
153
+ # with:
154
+ # fetch-depth: 0
155
+ # - uses: c-py/action-dotenv-to-setenv@v2
156
+ # with:
157
+ # env-file: .github/variables/.env
158
+ # - uses: FranzDiebold/github-env-vars-action@v2 #https://github.com/marketplace/actions/github-environment-variables-action
159
+ # - name: Set buid version number env variables
160
+ # id: set-build-version-number-vars
161
+ # run: .github/scripts/set_version_numbers_env.sh
162
+ # - name: Update project version & build number in source code and documentation
163
+ # id: update-project-version
164
+ # run: .github/scripts/update_project_version.sh
165
+ # - name: Push version update to repository
166
+ # id: push-version-number-update
167
+ # run: |
168
+ # git add sonar-project.properties VERSION source/* docs/*
169
+ # git commit -m 'Updated project version after build [skip ci]'
170
+ # git push --quiet origin HEAD:${CI_ACTION_REF_NAME}
171
+ # - name: Copy and push documentation to utPLSQL-github-io repo
172
+ # id: push-documentation
173
+ # env:
174
+ # API_TOKEN_GITHUB: ${{ secrets.API_TOKEN_GITHUB }}
175
+ # run: .github/scripts/push_docs_to_github_io.sh
176
176
177
177
dispatch :
178
178
name : Dispatch downstream builds
179
179
concurrency : trigger
180
- needs : [ build, publish ]
180
+ # needs: [ build, publish ]
181
181
runs-on : ubuntu-latest
182
182
if : |
183
183
github.repository == 'utPLSQL/utPLSQL' &&
@@ -195,21 +195,21 @@ jobs:
195
195
uses : peter-evans/repository-dispatch@v1
196
196
with :
197
197
token : ${{ secrets.API_TOKEN_GITHUB }}
198
- repository : ${{ matrix.repo }}
198
+ repository : ${{ matrix.repo }}
199
199
event-type : utPLSQL-build
200
200
201
- slack-workflow-status :
202
- if : always()
203
- name : Post Workflow Status To Slack
204
- needs : [ build, publish, dispatch ]
205
- runs-on : ubuntu-latest
206
- steps :
207
- - name : Slack Workflow Notification
208
- uses : Gamesight/slack-workflow-status@master
209
- with :
210
- # Required Input
211
- repo_token : ${{secrets.GITHUB_TOKEN}}
212
- slack_webhook_url : ${{secrets.SLACK_WEBHOOK_URL}}
213
- # Optional Input
214
- name : ' Github Actions[bot]'
215
- icon_url : ' https://octodex.github.com/images/mona-the-rivetertocat.png'
201
+ # slack-workflow-status:
202
+ # if: always()
203
+ # name: Post Workflow Status To Slack
204
+ # needs: [ build, publish, dispatch ]
205
+ # runs-on: ubuntu-latest
206
+ # steps:
207
+ # - name: Slack Workflow Notification
208
+ # uses: Gamesight/slack-workflow-status@master
209
+ # with:
210
+ # # Required Input
211
+ # repo_token: ${{secrets.GITHUB_TOKEN}}
212
+ # slack_webhook_url: ${{secrets.SLACK_WEBHOOK_URL}}
213
+ # # Optional Input
214
+ # name: 'Github Actions[bot]'
215
+ # icon_url: 'https://octodex.github.com/images/mona-the-rivetertocat.png'
0 commit comments