Add code tests to CI, run CI weekly, add windows & macos platforms, test all supported python versions #5

	name: Tests on windows-latest

	on:
	push:
	branches: [ main ]
	pull_request:
	branches: [ main ]
	schedule:
	- cron: "0 12 * * 1" # every Monday at 12:00 UTC
	workflow_dispatch:

	jobs:
	tests_windows_latest:
	runs-on: ${{ matrix.os }}
	strategy:
	matrix:
	os: [windows-latest]
	python-version: ['3.8', '3.9', '3.10', '3.11', '3.12']
	timeout-minutes: 5

	steps:
	- name: Check out code repository
	uses: actions/checkout@v4

	- name: Set up Python ${{ matrix.python-version }}
	uses: actions/setup-python@v5
	with:
	python-version: ${{ matrix.python-version }}

	- name: Install harlequin-databricks and dependencies
	run: \|
	python -m pip install --upgrade pip
	pip install harlequin databricks-sql-connector databricks-sdk pytest
	pip install -e .

	- name: Run tests
	env:
	DATABRICKS_HOST: ${{ secrets.DATABRICKS_HOST }}
	DATABRICKS_HTTP_PATH: ${{ secrets.DATABRICKS_HTTP_PATH }}
	DATABRICKS_CLIENT_ID: ${{ secrets.DATABRICKS_CLIENT_ID }}
	DATABRICKS_CLIENT_SECRET: ${{ secrets.DATABRICKS_CLIENT_SECRET }}
	run: \|
	pytest -v

Provide feedback