Add tests for Ansible core 2.17 (devel is 2.18 today) and bump tests dependencies #1542

	---
	name: Roles CI
	on: # yamllint disable-line rule:truthy
	push:
	paths:
	- 'roles/**'
	- '.github/workflows/ansible-test-roles.yml'
	pull_request:
	paths:
	- 'roles/**'
	- '.github/workflows/ansible-test-roles.yml'
	schedule:
	- cron: '0 6 * * *'

	jobs:
	molecule:
	name: "Molecule (Python: ${{ matrix.python }}, Ansible: ${{ matrix.ansible }}, MySQL: ${{ matrix.mysql }})"
	runs-on: ubuntu-20.04
	env:
	PY_COLORS: 1
	ANSIBLE_FORCE_COLOR: 1
	strategy:
	matrix:
	mysql:
	- 2.0.12
	ansible:
	- stable-2.13
	- stable-2.14
	- stable-2.15
	- devel
	python:
	- '3.8'
	- '3.9'
	- '3.10'
	exclude:
	- python: 3.8
	ansible: devel

	- python: 3.9
	ansible: devel

	steps:

	- name: Check out code
	uses: actions/checkout@v3
	with:
	path: ansible_collections/community/mysql

	- name: Set up Python ${{ matrix.python }}
	uses: actions/setup-python@v4
	with:
	python-version: ${{ matrix.python }}

	- name: Install ansible-core (${{ matrix.ansible }})
	run: pip install https://github.com/ansible/ansible/archive/${{ matrix.ansible }}.tar.gz --disable-pip-version-check

	- name: Install molecule and related dependencies
	run: \|
	pip install ansible-lint docker flake8 molecule testinfra yamllint

	# - name: Run molecule default test scenario
	# run: for d in roles/*/; do (cd "$d" && molecule --version && molecule test) done
	# working-directory: ./ansible_collections/community/mysql

Provide feedback