Skip to content
CD

Update suzuki-shunsuke/github-action-renovate-config-validator action to v1.1.1 #99

Sign in to view logs

Update suzuki-shunsuke/github-action-renovate-config-validator action to v1.1.1

Update suzuki-shunsuke/github-action-renovate-config-validator action to v1.1.1 #99

Workflow file for this run

.github/workflows/cd.yml at d2104d0
name: CD
on:
push:
branches:
- main
pull_request:
jobs:
publish_docker_image_to_docker_hub:
name: Build & Push docker image to dockerhub
runs-on: ubuntu-24.04
steps:
- name: Checkout code
uses: actions/checkout@v4
- name: Get metadata as environment variables
uses: HSLdevcom/jore4-tools/github-actions/extract-metadata@extract-metadata-v1
- name: Pull previous images to support caching
run: |
docker pull $IMAGE_NAME:latest || echo "Previous image not found"
docker pull $IMAGE_NAME:empty || echo "Previous image not found"
docker pull $IMAGE_NAME:schema-only || echo "Previous image not found"
- name: Build docker images
run: |
# build docker image containing the MSSQL service only, no data
docker build \
--cache-from=$IMAGE_NAME:latest \
--cache-from=$IMAGE_NAME:empty \
-t $IMAGE_NAME:empty \
-t $IMAGE_NAME:latest \
-t $IMAGE_NAME:empty-$COMMIT_ID \
--target empty .
# build docker image containing the jore3 test schema, no data
docker build \
--cache-from=$IMAGE_NAME:latest \
--cache-from=$IMAGE_NAME:schema-only \
-t $IMAGE_NAME:schema-only \
-t $IMAGE_NAME:schema-only-$COMMIT_ID \
--target schema-only .
- name: Login to Docker Hub
uses: docker/login-action@v3
with:
username: ${{ secrets.JORE4_DOCKERHUB_USER }}
password: ${{ secrets.JORE4_DOCKERHUB_TOKEN }}
- name: Push images tagged with git commit details to Docker Hub
run: |
docker push $IMAGE_NAME:empty-$COMMIT_ID
docker push $IMAGE_NAME:schema-only-$COMMIT_ID
- name: Push rest of the tags to Docker Hub
if: ${{ github.ref == 'refs/heads/main' }}
run: |
docker push $IMAGE_NAME:empty
docker push $IMAGE_NAME:schema-only
docker push $IMAGE_NAME:latest
publish_docker_image_to_acr:
name: Publish Docker image to ACR
permissions:
id-token: write
contents: read
uses: HSLdevcom/jore4-tools/.github/workflows/shared-build-and-publish-docker-image.yml@shared-build-and-publish-docker-image-v1
with:
docker_image_name: jore4-mssql-testdb
secrets:
azure_client_id: ${{ secrets.AZURE_CLIENT_ID }}
azure_tenant_id: ${{ secrets.AZURE_TENANT_ID }}
azure_subscription_id: ${{ secrets.AZURE_SUBSCRIPTION_ID }}
test-docker-images:
name: verify that the docker images work
needs: publish_docker_image_to_docker_hub
runs-on: ubuntu-24.04
env:
SA_PASSWORD: "P@ssw0rd"
strategy:
matrix:
include:
# empty image, no test dumps are imported
- dockerImage: empty
volumeMapping: ""
expectedOutput: |
name
--------------------------------------------------------------------------------------------------------------------------------
master
model
msdb
tempdb
(4 rows affected)
# schema-only image, no test dumps are imported
- dockerImage: schema-only
volumeMapping: ""
expectedOutput: |
name
--------------------------------------------------------------------------------------------------------------------------------
jore3testdb
master
model
msdb
tempdb
(5 rows affected)
# empty image, but test dumps are imported
- dockerImage: empty
volumeMapping: ' -v "$(pwd)/docker-image-test-data:/data:ro"'
expectedOutput: |
name
--------------------------------------------------------------------------------------------------------------------------------
bardb
foodb
master
model
msdb
tempdb
(6 rows affected)
# schema-only image, also test dumps are imported
- dockerImage: schema-only
volumeMapping: ' -v "$(pwd)/docker-image-test-data:/data:ro"'
expectedOutput: |
name
--------------------------------------------------------------------------------------------------------------------------------
bardb
foodb
jore3testdb
master
model
msdb
tempdb
(7 rows affected)
steps:
- name: Checkout code
uses: actions/checkout@v4
- name: Get metadata as environment variables
uses: HSLdevcom/jore4-tools/github-actions/extract-metadata@extract-metadata-v1
- name: Read Current MS SQL Docker Image
id: docker
shell: bash
run: |
echo mssql_docker_image="$(grep FROM Dockerfile | sed -E 's/FROM *([^ ]*)( AS.*)?/\1/g' | head -n 1)" >> "${GITHUB_OUTPUT}"
- name: Start up mssql docker container
run: |
# A custom network is used so that Docker containers can be referred with names instead of IPs
docker network rm hsl || true
docker network create -d bridge --subnet=10.240.0.0/24 hsl
docker network ls
docker run \
-d \
--rm \
-p 1433:1433 \
--name mssql \
--hostname mssql \
--network hsl \
-e SA_PASSWORD="$SA_PASSWORD" \
${{ matrix.volumeMapping }} \
$IMAGE_NAME:${{ matrix.dockerImage }}-$COMMIT_ID
- name:
Verify that dockerized MSSQL database is up and can be connected to
uses: HSLdevcom/jore4-tools/github-actions/healthcheck@healthcheck-v1
with:
command:
'docker run
--network hsl
${{ steps.docker.outputs.mssql_docker_image }}
/opt/mssql-tools18/bin/sqlcmd
-C
-S mssql
-U sa
-P "$SA_PASSWORD"
-d master
-Q "SELECT ''OK'';"'
- name:
Verify that the proper sql dumps got imported (diff expected results)
env:
# query for listing all available database names
DB_QUERY: "SELECT name FROM master.sys.databases ORDER BY name;"
# A custom entrypoint needs to be used so that the output does not contain lines printed by
# the default entrypoint which would make the diff fail
run: |
docker run \
--network hsl \
--entrypoint /opt/mssql-tools18/bin/sqlcmd \
${{ steps.docker.outputs.mssql_docker_image }} \
-C \
-S mssql \
-U sa \
-P "$SA_PASSWORD" \
-d master \
-Q "$DB_QUERY" \
> dbresults.txt
echo "${{ matrix.expectedOutput }}" > expectedresults.txt
diff --ignore-all-space --ignore-blank-lines dbresults.txt expectedresults.txt