Testops Report FORTNIGHTLY #68

	name: Testops Report FORTNIGHTLY

	# Every other Sat. @4am UTC
	on:
	schedule:
	- cron: "0 4 * * 6/2"

	jobs:
	deploy:
	name: TestOps Report (DAILY)
	runs-on: ubuntu-latest

	steps:
	- name: Check out source repository
	uses: actions/checkout@v2

	- name: Setup python
	uses: actions/setup-python@v1

	- name: Establish Cloud SQL Proxy
	uses: mattes/gce-cloudsql-proxy-action@v1
	with:
	creds: ${{ secrets.GCLOUD_AUTH }}
	instance: ${{ secrets.CLOUD_SQL_CONNECTION_NAME }}
	port: ${{ secrets.CLOUD_SQL_DATABASE_PORT }}

	- name: Install requirements
	run: pip install -r requirements.txt

	- name: Set env vars
	run: \|
	echo "CLOUD_SQL_DATABASE_USERNAME=${{ secrets.CLOUD_SQL_DATABASE_USERNAME }}" >> $GITHUB_ENV
	echo "CLOUD_SQL_DATABASE_PASSWORD=${{ secrets.CLOUD_SQL_DATABASE_PASSWORD }}" >> $GITHUB_ENV
	echo "CLOUD_SQL_DATABASE_NAME=${{ secrets.CLOUD_SQL_DATABASE_NAME }}" >> $GITHUB_ENV
	echo "CLOUD_SQL_DATABASE_PORT=${{ secrets.CLOUD_SQL_DATABASE_PORT }}" >> $GITHUB_ENV
	echo "TESTRAIL_HOST=${{ secrets.TESTRAIL_HOST }}" >> $GITHUB_ENV
	echo "TESTRAIL_USERNAME=${{ secrets.TESTRAIL_USERNAME }}" >> $GITHUB_ENV
	echo "TESTRAIL_PASSWORD=${{ secrets.TESTRAIL_PASSWORD }}" >> $GITHUB_ENV
	echo "GITHUB_TOKEN=${{ secrets.GITHUB_TOKEN }}" >> $GITHUB_ENV

	#- name: Update DB - test runs
	# run: python ./__main__.py --report-type xxxx --project ALL --num-days 7

Provide feedback