feat: deps: bump to use simple-sqlite3-orm v0.5.0, update the otaproxy accordingly #772

	name: test CI

	on:
	pull_request:
	branches:
	- main
	types:
	- opened
	- synchronize
	- reopened
	# NOTE(20241016): this is a workaround for PR with head
	# updated by gen_requirements_txt workflow
	- review_requested
	- assigned
	push:
	branches:
	- main
	paths:
	- "src/**"
	- "tests/**"
	- ".github/workflows/test.yaml"
	# allow the test CI to be manually triggerred
	workflow_dispatch:

	jobs:
	pytest_with_coverage:
	runs-on: ubuntu-latest
	timeout-minutes: 20
	strategy:
	fail-fast: false
	matrix:
	test_base:
	- ubuntu-18.04
	- ubuntu-20.04
	- ubuntu-22.04
	steps:
	- name: Checkout commit
	uses: actions/checkout@v4
	# sonarcloud needs full git histories
	with:
	fetch-depth: 0
	- name: Build ota-test_base docker image
	run: \|
	docker compose -f docker/docker-compose_tests.yml build tester-${{ matrix.test_base }}
	- name: Execute pytest with coverage trace under ota-test_base container
	run: \|
	mkdir -p test_result
	docker compose -f docker/docker-compose_tests.yml run --rm tester-${{ matrix.test_base }}
	- name: SonarCloud Scan
	uses: SonarSource/sonarcloud-github-action@master
	continue-on-error: true
	env:
	SONAR_TOKEN: ${{ secrets.SONAR_TOKEN }}
	if: ${{ matrix.test_base == 'ubuntu-22.04' }}

	# export the coverage report to the comment!
	- name: Add coverage report to PR comment
	continue-on-error: true
	uses: MishaKav/[email protected]
	with:
	pytest-xml-coverage-path: test_result/coverage.xml
	junitxml-path: test_result/pytest.xml
	if: ${{ matrix.test_base == 'ubuntu-22.04' }}

Provide feedback