Avoid DB import bugs by trimming strings at import transform #894

	name: Test Python

	on:
	push:
	branches:
	- main
	pull_request:
	branches:
	- main

	jobs:
	build:
	runs-on: ubuntu-latest

	services:
	postgres:
	image: postgres
	env:
	POSTGRES_DATABASE: test
	POSTGRES_PASSWORD: test
	POSTGRES_USER: test
	POSTGRES_HOST_AUTH_METHOD: trust
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5
	ports:
	- 5432:5432

	steps:
	# Python & dependency installation
	- uses: actions/checkout@v3
	- name: setup Python 3.9
	uses: actions/setup-python@v4
	with:
	python-version: 3.9
	- name: install Poetry
	uses: snok/[email protected]
	- name: cache Poetry virtualenv
	uses: actions/cache@v3
	id: cache
	with:
	path: ~/.virtualenvs/
	key: poetry-${{ hashFiles('**/poetry.lock') }}
	restore-keys: \|
	poetry-${{ hashFiles('**/poetry.lock') }}
	- name: set poetry config path
	run: poetry config virtualenvs.path ~/.virtualenvs

	- name: install dependencies
	run: poetry install

	- name: lint with flake8
	run: poetry run flake8 --show-source --statistics --ignore=E203,E501,W503
	- name: lint with mypy
	run: poetry run mypy openstates
	- name: pytest
	run: poetry run pytest --cov-report=xml --cov=openstates --ds=openstates.test_settings --reuse-db -v openstates
	env:
	DATABASE_URL: postgresql://test:test@localhost/test

Provide feedback