Include sqlite to library path #34

	name: Test the library

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

	jobs:
	build:
	runs-on: ubuntu-latest
	strategy:
	matrix:
	python-version: ["3.8", "3.9", "3.10", "3.11", "3.12"]

	name: Python ${{ matrix.python-version }}
	steps:
	- uses: actions/checkout@v2
	- name: Setup Python
	uses: actions/setup-python@v2
	with:
	python-version: ${{ matrix.python-version }}
	cache: "pip"

	# - name: Update SQLite3
	# run: sudo apt install -y sqlite3

	# build SQLite from source, because I need 3.35<=
	- name: Download SQLite3
	run: \|
	wget https://www.sqlite.org/2024/sqlite-autoconf-3450300.tar.gz
	tar -xvf sqlite-autoconf-3450300.tar.gz

	- name: Install SQLite3
	run: \|
	./configure
	make
	sudo make install
	export PATH="/usr/local/lib:$PATH"
	working-directory: sqlite-autoconf-3450300

	- name: Install dependencies
	run: \|
	python -m pip install --upgrade pip
	pip install flake8 pytest tox
	env:
	LD_LIBRARY_PATH: /usr/local/lib
	# - name: Lint with flake8
	# run: \|
	# # stop the build if there are Python syntax errors or undefined names
	# flake8 . --count --select=E9,F63,F7,F82 --show-source --statistics
	# # exit-zero treats all errors as warnings. The GitHub editor is 127 chars wide
	# # flake8 . --count --exit-zero --max-complexity=10 --max-line-length=127 --statistics
	- name: Test with tox
	run: \|
	tox
	env:
	LD_LIBRARY_PATH: /usr/local/lib

Provide feedback