The current version of SQLAlchemy does not work with the latest version of MySQL and needs to be upgraded.
File "/Users/username/github/open-source-library-data-collector/venv/lib/python3.6/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1193, "Unknown system variable 'tx_isolation'")
Issue Summary
The current version of SQLAlchemy does not work with the latest version of MySQL and needs to be upgraded.
This is because the latest version of MySQL (8.x) has deprecated
tx_isolation. More details here: https://stackoverflow.com/questions/50156520/cannot-connect-to-a-local-mysql-db-with-sqlalchemy-on-windows-machineSteps to Reproduce
python app.pyTechnical details: