WIP: Improve MariaDB support #668

Workflow file for this run

.github/workflows/test_and_publish.yml at dc421b1

	name: CI

	# Controls when the action will run. Triggers the workflow on push or pull request
	# events but only for the master branch.
	on:
	push:
	branches: [ master ]
	tags:
	- '*'
	pull_request:
	workflow_dispatch:

	env:
	PGPASSWORD: gis

	jobs:
	# This workflow runs the tests
	tests:

	# Set shell to work properly with Mamba
	defaults:
	run:
	shell: bash -l {0}

	# Setup test matrix
	strategy:
	fail-fast: false
	matrix:
	python-version: [
	{"pkg_name": "python==3.7.*", "flag": "3.7"},
	{"pkg_name": "python==3.8.*", "flag": "3.8"},
	{"pkg_name": "python==3.9.*", "flag": "3.9"},
	{"pkg_name": "python==3.10.*", "flag": "3.10"},
	{"pkg_name": "python==3.11.*", "flag": "3.11"},
	{"pkg_name": "python==3.12.*", "flag": "3.12"},
	{"pkg_name": "pypy3.8", "flag": "pypy3.8"},
	]

	# The type of runner that the job will run on
	runs-on: ubuntu-22.04

	services:
	postgres:
	image: postgis/postgis:16-3.4
	env:
	POSTGRES_DB: gis
	POSTGRES_PASSWORD: gis
	POSTGRES_USER: gis
	ports:
	- 5432:5432
	# Set health checks to wait until postgres has started
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5
	mysql:
	image: mysql:latest
	ports:
	- 3307:3306
	env:
	MYSQL_USER: gis
	MYSQL_PASSWORD: gis
	MYSQL_DATABASE: gis
	MYSQL_ROOT_PASSWORD: gis
	# Set health checks to wait until MySQL has started
	options: >-
	--health-cmd="mysqladmin ping"
	--health-interval=10s
	--health-timeout=5s
	--health-retries=3
	mariadb:
	image: mariadb:latest
	ports:
	- 3308:3306
	env:
	MARIADB_USER: gis
	MARIADB_PASSWORD: gis
	MARIADB_DATABASE: gis
	MARIADB_ROOT_PASSWORD: gis
	# Set health checks to wait until MariaDB has started
	options: >-
	--health-cmd="healthcheck.sh --connect --innodb_initialized"
	--health-interval=10s
	--health-timeout=5s
	--health-retries=3


	steps:

	# Checks-out your repository under $GITHUB_WORKSPACE, so your job can access it
	- uses: actions/checkout@v4

	# Install MariaDB
	- name: Install MariaDB
	run: \|
	sudo apt-get install -y mariadb-server mariadb-client

	# Setup Conda for Python and Pypy
	- name: Install Conda environment with Micromamba
	uses: mamba-org/setup-micromamba@v2
	with:
	environment-name: test_${{ matrix.python-version.flag }}
	cache-environment: false
	create-args: >-
	${{ matrix.python-version.pkg_name }}
	libgdal
	libspatialite==5.0.1
	pyproj
	rasterio<1.4
	condarc: \|
	channels:
	- conda-forge
	- defaults
	channel_priority: strict

	# Config PostgreSQL
	- name: Configure PostgreSQL
	run: \|
	# Create schema "gis" into database "gis"
	psql -h localhost -p 5432 -U gis -d gis -c 'CREATE SCHEMA gis;'

	# Add PostGIS extension to "gis" database
	psql -h localhost -p 5432 -U gis -d gis -c 'CREATE EXTENSION IF NOT EXISTS postgis SCHEMA public;'

	# Drop PostGIS Tiger Geocoder extension to "gis" database
	psql -h localhost -p 5432 -U gis -d gis -c 'DROP EXTENSION IF EXISTS postgis_tiger_geocoder CASCADE;'

	# Add PostGISRaster extension to "gis" database
	psql -h localhost -p 5432 -U gis -d gis -c 'CREATE EXTENSION IF NOT EXISTS postgis_raster SCHEMA public;'

	# Drop PostGIS Topology extension to "gis" database
	psql -h localhost -p 5432 -U gis -d gis -c 'DROP EXTENSION IF EXISTS postgis_topology;'

	# Check MySQL
	- name: Check MySQL
	run: \|
	mysql --user=gis --password=gis --host=127.0.0.1 -P 3307 -e "SELECT VERSION();"
	mysql --user=root --password=gis --host=127.0.0.1 -P 3307 -e "GRANT ALL PRIVILEGES ON . TO 'gis'@'%' WITH GRANT OPTION;"

	# Check MariaDB
	- name: Check MariaDB
	run: \|
	mysql --user=gis --password=gis --host=127.0.0.1 -P 3308 -e "SELECT VERSION();"
	mysql --user=root --password=gis --host=127.0.0.1 -P 3308 -e "GRANT ALL PRIVILEGES ON . TO 'gis'@'%' WITH GRANT OPTION;"

	# Check python version
	- name: Display Python version
	run: \|
	/home/runner/micromamba-bin/micromamba info
	/home/runner/micromamba-bin/micromamba list
	python -c "import sys; print(sys.version)"

	# Install dependencies
	- name: Install dependencies
	run: \|
	python -m pip install --upgrade pip setuptools
	python -m pip install tox-gh-actions

	# Run the test suite
	- name: Run the tests
	env:
	SPATIALITE_LIBRARY_PATH: /home/runner/micromamba/envs/test_${{ matrix.python-version.flag }}/lib/mod_spatialite.so
	COVERAGE_FILE: .coverage
	PYTEST_MYSQL_DB_URL: mysql://gis:gis@127.0.0.1:3307/gis
	PYTEST_MARIADB_DB_URL: mariadb://gis:gis@127.0.0.1:3308/gis
	run: \|
	# Run the unit test suite with SQLAlchemy=1.4.* and then with the latest version of SQLAlchemy
	tox -vv

	# Export coverage to Coveralls
	- name: Coveralls
	uses: AndreMiras/coveralls-python-action@v20201129
	with:
	parallel: true
	flag-name: run-${{ matrix.python-version.flag }}


	# This workflow aggregates coverages from all jobs and export it to Coveralls
	coveralls:
	needs: tests
	runs-on: ubuntu-22.04
	steps:

	- name: Coveralls Finished
	uses: AndreMiras/coveralls-python-action@v20201129
	with:
	parallel-finished: true
	github-token: ${{ secrets.github_token }}

	# This workflow deploys the package
	deploy:
	needs: tests
	runs-on: ubuntu-22.04
	if: github.event_name == 'push' && startsWith(github.ref, 'refs/tags')

	steps:

	- uses: actions/checkout@v4

	- name: Set up Python 3.10
	uses: actions/setup-python@v5
	with:
	python-version: "3.10"

	# Build distribution and deploy to Pypi
	- name: Build and deploy package
	env:
	TWINE_USERNAME: ${{ secrets.PYPI_USERNAME }}
	TWINE_PASSWORD: ${{ secrets.PYPI_PASSWORD }}
	run: \|
	pip install --upgrade pip setuptools build twine
	python -m build -o dist
	twine upload dist/*

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

WIP: Improve MariaDB support #668

Workflow file

WIP: Improve MariaDB support #668

Jobs

Run details

Workflow file for this run