I’ve set up a recorder with pymssql. Since the upgrade of Python to 3.7, pysql stopped working.
When I check the website of pysql, it states that version 2.1.4 is compatible with python 3.7.
I’ve tried to upgrade pymssql, but it gives me a DeprecationWarning:
(homeassistant) homeassistant@homeassistant:/home/pi $ pip3 install --upgrade pymssql
Looking in indexes: https://pypi.org/simple, https://www.piwheels.org/simple
Collecting pymssql
Using cached https://files.pythonhosted.org/packages/2e/81/99562b93d75f3fc5956fa65decfb35b38a4ee97cf93c1d0d3cb799fffb99/pymssql-2.1.4.tar.gz
ERROR: Complete output from command python setup.py egg_info:
ERROR: /srv/homeassistant/lib/python3.7/site-packages/setuptools/dist.py:45: DistDeprecationWarning: Do not call this function
warnings.warn("Do not call this function", DistDeprecationWarning)
Traceback (most recent call last):
File "<string>", line 1, in <module>
File "/tmp/pip-install-maqg50yl/pymssql/setup.py", line 88, in <module>
from Cython.Distutils import build_ext as _build_ext
ModuleNotFoundError: No module named 'Cython'
----------------------------------------
ERROR: Command "python setup.py egg_info" failed with error code 1 in /tmp/pip-install-maqg50yl/pymssql/
Thought it might be the pip installer being out-of-date but:
(homeassistant) homeassistant@homeassistant:/home/pi $ pip3 install --upgrade pip
Looking in indexes: https://pypi.org/simple, https://www.piwheels.org/simple
Requirement already up-to-date: pip in /srv/homeassistant/lib/python3.7/site-packages (19.1.1)
Any help on this one?