Allow specifying insert method for bulk transactions #1484

	name: stac-fastapi
	on:
	push:
	branches: [main]
	pull_request:
	branches: [main]

	jobs:
	test:
	runs-on: ubuntu-latest
	strategy:
	matrix:
	python-version: ["3.8", "3.9", "3.10", "3.11"]
	timeout-minutes: 20

	services:
	db_service:
	image: ghcr.io/stac-utils/pgstac:v0.7.1
	env:
	POSTGRES_USER: username
	POSTGRES_PASSWORD: password
	POSTGRES_DB: postgis
	POSTGRES_HOST: localhost
	POSTGRES_PORT: 5432
	PGUSER: username
	PGPASSWORD: password
	PGDATABASE: postgis
	ALLOW_IP_RANGE: 0.0.0.0/0
	# Set health checks to wait until postgres has started
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 10s
	--health-retries 10
	--log-driver none
	ports:
	# Maps tcp port 5432 on service container to the host
	- 5432:5432

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

	# Setup Python (faster than using Python container)
	- name: Setup Python
	uses: actions/setup-python@v4
	with:
	python-version: ${{ matrix.python-version }}

	- name: Lint code
	if: ${{ matrix.python-version == 3.8 }}
	run: \|
	python -m pip install pre-commit
	pre-commit run --all-files

	- name: Install types
	run: \|
	pip install ./stac_fastapi/types[dev]

	- name: Install core api
	run: \|
	pip install ./stac_fastapi/api[dev]

	- name: Install Extensions
	run: \|
	pip install ./stac_fastapi/extensions[dev]

	- name: Test
	run: pytest -svvv
	env:
	ENVIRONMENT: testing

	test-docs:
	runs-on: ubuntu-latest
	steps:
	- uses: actions/checkout@v4
	- name: Test generating docs
	run: make docs

Provide feedback