Missing requirement for pymssql

hohonuuli commented 5 months ago

Build failed when building wheel for pymssql. The workaround is to install freetds (eg. brew install freetds on macOS). No biggie, but may need to add a note in the README. The error is:

Building wheels for collected packages: pymssql
  Building wheel for pymssql (pyproject.toml) ... error
  error: subprocess-exited-with-error

  × Building wheel for pymssql (pyproject.toml) did not run successfully.
  │ exit code: 1
  ╰─> [32 lines of output]
      /private/var/folders/zn/j87g9m_s1jz2gnm_g0r_s53h0000gn/T/pip-build-env-x3ka5o8s/overlay/lib/python3.11/site-packages/setuptools_scm/_integration/setuptools.py:92: UserWarning: version of pymssql already set
        warnings.warn(f"version of {dist_name} already set")
      setup.py: platform.system() => Darwin
      setup.py: platform.architecture() => ('64bit', '')
      setup.py: platform.libc_ver() => ('', '')
      setup.py: include_dirs => []
      setup.py: library_dirs => []
      running bdist_wheel
      running build
      running build_py
      creating build
      creating build/lib.macosx-10.9-x86_64-cpython-311
      creating build/lib.macosx-10.9-x86_64-cpython-311/pymssql
      copying src/pymssql/__init__.py -> build/lib.macosx-10.9-x86_64-cpython-311/pymssql
      copying src/pymssql/exceptions.py -> build/lib.macosx-10.9-x86_64-cpython-311/pymssql
      copying src/pymssql/__init__.pyi -> build/lib.macosx-10.9-x86_64-cpython-311/pymssql
      copying src/pymssql/exceptions.pyi -> build/lib.macosx-10.9-x86_64-cpython-311/pymssql
      copying src/pymssql/_mssql.pyi -> build/lib.macosx-10.9-x86_64-cpython-311/pymssql
      copying src/pymssql/_pymssql.pyi -> build/lib.macosx-10.9-x86_64-cpython-311/pymssql
      running build_ext
      Compiling src/pymssql/_mssql.pyx because it changed.
      [1/1] Cythonizing src/pymssql/_mssql.pyx
      building 'pymssql._mssql' extension
      creating build/temp.macosx-10.9-x86_64-cpython-311
      creating build/temp.macosx-10.9-x86_64-cpython-311/src
      creating build/temp.macosx-10.9-x86_64-cpython-311/src/pymssql
      clang -DNDEBUG -fwrapv -O2 -Wall -fPIC -O2 -isystem /opt/miniconda3/envs/vars-gridview/include -fPIC -O2 -isystem /opt/miniconda3/envs/vars-gridview/include -I/opt/miniconda3/envs/vars-gridview/include/python3.11 -c src/pymssql/_mssql.c -o build/temp.macosx-10.9-x86_64-cpython-311/src/pymssql/_mssql.o -DMSDBLIB
      src/pymssql/_mssql.c:1271:10: fatal error: 'sqlfront.h' file not found
      #include "sqlfront.h"
               ^~~~~~~~~~~~
      1 error generated.
      error: command '/usr/bin/clang' failed with exit code 1
      [end of output]

  note: This error originates from a subprocess, and is likely not a problem with pip.
  ERROR: Failed building wheel for pymssql
Failed to build pymssql
ERROR: Could not build wheels for pymssql, which is required to install pyproject.toml-based projects

kevinsbarnard commented 5 months ago

@hohonuuli I'll add a note to the README.

lonnylundsten commented 1 month ago

@kevinsbarnard Can we close this as completed?

mbari-org / vars-gridview

Missing requirement for pymssql #78