Lahti 120 tarkempi tyhjennysvalin maaritus #96

	name: migration test workflow

	on:
	pull_request:
	branches: [main]
	paths:
	- "db/migrations/*.sql"

	# Allows you to run this workflow manually from the Actions tab
	workflow_dispatch:

	jobs:
	migration_test:
	runs-on: ubuntu-latest
	services:
	postgres:
	image: kartoza/postgis:12.0
	env:
	POSTGRES_PASSWORD: postgres
	POSTGRES_USER: jkr_admin
	POSTGRES_DB: jkr
	POSTGRES_MULTIPLE_EXTENSIONS: postgis,btree_gist
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5
	ports:
	- 5432:5432
	steps:
	- uses: actions/checkout@v2
	- name: Copy the flyway conf
	run: cp db/flyway.conf ./flyway.conf
	- uses: joshuaavalon/[email protected]
	with:
	url: jdbc:postgresql://postgres:5432/jkr
	user: jkr_admin
	password: postgres
	locations: filesystem:./db/migrations
	- run: echo 'testing completed'

Provide feedback