add test (but skip now) #130

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

	name: Python package

	on:
	push:
	branches: [ master ]
	pull_request:
	branches: [ master ]

	jobs:
	build:

	runs-on: ubuntu-24.04
	services:
	mysql:
	image: mysql:8.0
	env:
	MYSQL_ROOT_PASSWORD: password
	ports:
	- '3306:3306'
	options: --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=5s --health-retries=3
	strategy:
	matrix:
	python-version: ['pypy2.7', 3.8, 3.9, '3.10', '3.11', '3.12']
	steps:
	- uses: actions/checkout@v4
	- name: Set up MySQL
	run: \|
	mysql -h 127.0.0.1 -u root -ppassword -e 'CREATE DATABASE IF NOT EXISTS test_cymysql DEFAULT CHARACTER SET utf8mb4;'
	mysql -h 127.0.0.1 -u root -ppassword -e 'CREATE DATABASE IF NOT EXISTS test_cymysql2 DEFAULT CHARACTER SET utf8mb4;'
	- name: Set up Python ${{ matrix.python-version }}
	uses: actions/setup-python@v5
	with:
	python-version: ${{ matrix.python-version }}
	- name: Install dependencies
	run: \|
	python -m pip install setuptools
	python -m pip install --upgrade pip
	python -m pip install flake8
	- name: Test
	run: \|
	MYSQL_ROOT_PASSWORD=password python setup.py test
	python -m pip install cython
	python setup.py build_ext -i
	MYSQL_ROOT_PASSWORD=password python setup.py test

Provide feedback