Update testcontainers requirement from <4.9,>=3.7 to >=3.7,<4.10 (#51) #283

	name: Build and Test

	on:
	push:
	branches: [ main ]
	paths-ignore:
	- '.github/**'
	- '.idea/**'
	- '.run/**'
	pull_request:
	branches: [ main ]
	paths-ignore:
	- '.github/**'
	- '.idea/**'
	- '.run/**'

	jobs:
	build:

	runs-on: macos-latest
	strategy:
	fail-fast: false
	matrix:
	python-version: [ "3.9", "3.10", "3.11", "3.12" ]
	dbt-version: [ "1.6", "1.7", "1.8", "1.9" ]
	steps:
	- uses: actions/checkout@v4
	- name: Set up Python ${{ matrix.python-version }}
	uses: actions/setup-python@v5
	with:
	python-version: ${{ matrix.python-version }}
	dbt-version: ${{ matrix.dbt-version }}
	- name: Build & Install
	run: \|
	pip install -q coverage pylint
	pip install -q dbt-core==${{ matrix.dbt-version }}.* dbt-duckdb==${{ matrix.dbt-version }}.* --force-reinstall --upgrade
	# FIX for protobuf issue: https://github.com/dbt-labs/dbt-core/issues/9759
	pip install -q "apache-airflow" "protobuf>=4.25.3,<5.0.0" "opentelemetry-proto<1.28.0" --prefer-binary
	pip install -q .[test] --prefer-binary
	python --version
	python -c "from dbt.version import get_installed_version as get_dbt_version;print(f'dbt version={get_dbt_version()}')"
	python -m compileall -f opendbt
	python -m pylint opendbt
	- name: Run Tests
	run: \|
	python -c "from dbt.version import get_installed_version as get_dbt_version;print(f'dbt version={get_dbt_version()}')"
	python -m coverage run --source=./tests/ -m unittest discover -s tests/
	python -m coverage report -m ./opendbt/*.py

Provide feedback