[cuebot] Convert null value from job.str_os to empty string in SQL (#… #496

	name: OpenCue SonarCloud Pipeline

	# Trigger this pipeline on new commits to master.
	on:
	push:
	branches: [ master ]

	jobs:
	analyze_python:
	runs-on: ubuntu-22.04
	container: aswf/ci-opencue:2024.1
	name: Analyze Python Components
	env:
	ACTIONS_ALLOW_USE_UNSECURE_NODE_VERSION: true
	steps:
	- name: Checkout
	uses: actions/checkout@v3
	with:
	# Fetch all Git history, otherwise the current version number will
	# not be correctly calculated.
	fetch-depth: 0

	- name: Generate coverage report
	run: ci/python_coverage_report.sh

	- name: Analyze and send to SonarCloud
	uses: sonarsource/sonarcloud-github-action@master
	env:
	GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
	SONAR_TOKEN: ${{ secrets.SONAR_TOKEN }}

	analyze_cuebot:
	runs-on: ubuntu-22.04
	container: aswf/ci-opencue:2024.1
	name: Analyze Cuebot
	env:
	ACTIONS_ALLOW_USE_UNSECURE_NODE_VERSION: true
	steps:
	- name: Checkout
	uses: actions/checkout@v3
	with:
	# Fetch all Git history, otherwise the current version number will
	# not be correctly calculated.
	fetch-depth: 0

	- name: Analyze and send to SonarCloud
	env:
	GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
	SONAR_TOKEN: ${{ secrets.SONAR_TOKEN }}
	run: \|
	sudo yum -y install java-17-openjdk.x86_64
	sudo yum -y install java-17-openjdk-devel.x86_64
	sudo alternatives --set java java-17-openjdk.x86_64
	sudo alternatives --set javac java-17-openjdk.x86_64
	sudo alternatives --set jre_openjdk java-17-openjdk.x86_64
	chown -R aswfuser:aswfgroup .
	su -c "cd cuebot && ./gradlew jacocoTestReport sonar" aswfuser

Provide feedback