misc auto_schema changes #103

	# This workflow will install Python dependencies, run tests and lint with a single version of Python
	# For more information see: https://help.github.com/actions/language-and-framework-guides/using-python-with-github-actions

	name: Python auto_schema tests

	on:
	pull_request:
	branches: [main]
	paths:
	- python/**

	defaults:
	run:
	working-directory: ./python/auto_schema

	jobs:
	build:

	runs-on: ubuntu-latest

	services:
	# Label used to access the service container
	postgres:
	# Docker Hub image
	image: postgres:14.6
	# Provide the password for postgres
	env:
	POSTGRES_PASSWORD: postgres
	# Set health checks to wait until postgres has started
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5
	ports:
	# Maps tcp port 5432 on service container to the host
	- 5432:5432

	sqlite:
	image: nouchka/sqlite3
	steps:
	- uses: actions/checkout@v3

	- name: Set up Python
	uses: actions/setup-python@v4
	with:
	python-version: '3.11'

	- uses: actions/cache@v3
	with:
	path: ~/.cache/pip
	key: ${{ runner.os }}-pip-
	restore-keys: \|
	${{ runner.os }}-pip-

	- uses: actions/cache@v3
	with:
	path: ~/.local/share/virtualenvs
	key: ${{ runner.os }}-pipenv-${{ hashFiles('Pipfile.lock') }}
	restore-keys: \|
	${{ runner.os }}-pipenv-

	- name: Install pipenv
	run: \|
	python -m pip install --upgrade pip
	pip install pipenv==2022.11.11

	- name: Install dependencies
	run: \|
	pipenv install --deploy --dev

	- name: run test suite
	run: \|
	pipenv run pytest -svv
	env:
	DB_CONNECTION_STRING: 'postgresql://postgres:postgres@localhost:5432'

Provide feedback