Looking for sqlite.h

[DavidPratten]

Hi,

• Python 3.9.1 (tags/v3.9.1:1e5d33e, Dec 7 2020, 17:08:21) [MSC v.1927 64 bit (AMD64)] on win32
• Cython and
• C++ Build Tools installed.

Then it appears to be looking for sqlite.h

Can you advise?

David

C:\Users\david>pip install vtfunc
Collecting vtfunc
  Using cached vtfunc-0.4.0.tar.gz (70 kB)
Building wheels for collected packages: vtfunc
  Building wheel for vtfunc (setup.py) ... error
  ERROR: Command errored out with exit status 1:
   command: 'c:\users\david\appdata\local\programs\python\python39\python.exe' -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'C:\\Users\\david\\AppData\\Local\\Temp\\pip-install-09_uz0xr\\vtfunc_50b60fa58fd44c1bac627fac6a5eef0c\\setup.py'"'"'; __file__='"'"'C:\\Users\\david\\AppData\\Local\\Temp\\pip-install-09_uz0xr\\vtfunc_50b60fa58fd44c1bac627fac6a5eef0c\\setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' bdist_wheel -d 'C:\Users\david\AppData\Local\Temp\pip-wheel-2lqq8y2w'
       cwd: C:\Users\david\AppData\Local\Temp\pip-install-09_uz0xr\vtfunc_50b60fa58fd44c1bac627fac6a5eef0c\
  Complete output (11 lines):
  running bdist_wheel
  running build
  running build_ext
  building 'vtfunc' extension
  creating build
  creating build\temp.win-amd64-3.9
  creating build\temp.win-amd64-3.9\Release
  C:\Program Files (x86)\Microsoft Visual Studio\2019\BuildTools\VC\Tools\MSVC\14.28.29910\bin\HostX86\x64\cl.exe /c /nologo /Ox /W3 /GL /DNDEBUG /MD -DMODULE_NAME="vtfunc" -Ic:\users\david\appdata\local\programs\python\python39\include -Ic:\users\david\appdata\local\programs\python\python39\include -IC:\Program Files (x86)\Microsoft Visual Studio\2019\BuildTools\VC\Tools\MSVC\14.28.29910\include -IC:\Program Files (x86)\Windows Kits\10\include\10.0.19041.0\ucrt -IC:\Program Files (x86)\Windows Kits\10\include\10.0.19041.0\shared -IC:\Program Files (x86)\Windows Kits\10\include\10.0.19041.0\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.19041.0\winrt -IC:\Program Files (x86)\Windows Kits\10\include\10.0.19041.0\cppwinrt /Tcvtfunc.c /Fobuild\temp.win-amd64-3.9\Release\vtfunc.obj
  vtfunc.c
  vtfunc.c(636): fatal error C1083: Cannot open include file: 'sqlite3.h': No such file or directory
  error: command 'C:\\Program Files (x86)\\Microsoft Visual Studio\\2019\\BuildTools\\VC\\Tools\\MSVC\\14.28.29910\\bin\\HostX86\\x64\\cl.exe' failed with exit code 2
  ----------------------------------------
  ERROR: Failed building wheel for vtfunc
  Running setup.py clean for vtfunc
Failed to build vtfunc
Installing collected packages: vtfunc
    Running setup.py install for vtfunc ... error
    ERROR: Command errored out with exit status 1:
     command: 'c:\users\david\appdata\local\programs\python\python39\python.exe' -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'C:\\Users\\david\\AppData\\Local\\Temp\\pip-install-09_uz0xr\\vtfunc_50b60fa58fd44c1bac627fac6a5eef0c\\setup.py'"'"'; __file__='"'"'C:\\Users\\david\\AppData\\Local\\Temp\\pip-install-09_uz0xr\\vtfunc_50b60fa58fd44c1bac627fac6a5eef0c\\setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record 'C:\Users\david\AppData\Local\Temp\pip-record-x8yuy7pv\install-record.txt' --single-version-externally-managed --compile --install-headers 'c:\users\david\appdata\local\programs\python\python39\Include\vtfunc'
         cwd: C:\Users\david\AppData\Local\Temp\pip-install-09_uz0xr\vtfunc_50b60fa58fd44c1bac627fac6a5eef0c\
    Complete output (11 lines):
    running install
    running build
    running build_ext
    building 'vtfunc' extension
    creating build
    creating build\temp.win-amd64-3.9
    creating build\temp.win-amd64-3.9\Release
    C:\Program Files (x86)\Microsoft Visual Studio\2019\BuildTools\VC\Tools\MSVC\14.28.29910\bin\HostX86\x64\cl.exe /c /nologo /Ox /W3 /GL /DNDEBUG /MD -DMODULE_NAME="vtfunc" -Ic:\users\david\appdata\local\programs\python\python39\include -Ic:\users\david\appdata\local\programs\python\python39\include -IC:\Program Files (x86)\Microsoft Visual Studio\2019\BuildTools\VC\Tools\MSVC\14.28.29910\include -IC:\Program Files (x86)\Windows Kits\10\include\10.0.19041.0\ucrt -IC:\Program Files (x86)\Windows Kits\10\include\10.0.19041.0\shared -IC:\Program Files (x86)\Windows Kits\10\include\10.0.19041.0\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.19041.0\winrt -IC:\Program Files (x86)\Windows Kits\10\include\10.0.19041.0\cppwinrt /Tcvtfunc.c /Fobuild\temp.win-amd64-3.9\Release\vtfunc.obj
    vtfunc.c
    vtfunc.c(636): fatal error C1083: Cannot open include file: 'sqlite3.h': No such file or directory
    error: command 'C:\\Program Files (x86)\\Microsoft Visual Studio\\2019\\BuildTools\\VC\\Tools\\MSVC\\14.28.29910\\bin\\HostX86\\x64\\cl.exe' failed with exit code 2
    ----------------------------------------
ERROR: Command errored out with exit status 1: 'c:\users\david\appdata\local\programs\python\python39\python.exe' -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'C:\\Users\\david\\AppData\\Local\\Temp\\pip-install-09_uz0xr\\vtfunc_50b60fa58fd44c1bac627fac6a5eef0c\\setup.py'"'"'; __file__='"'"'C:\\Users\\david\\AppData\\Local\\Temp\\pip-install-09_uz0xr\\vtfunc_50b60fa58fd44c1bac627fac6a5eef0c\\setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record 'C:\Users\david\AppData\Local\Temp\pip-record-x8yuy7pv\install-record.txt' --single-version-externally-managed --compile --install-headers 'c:\users\david\appdata\local\programs\python\python39\Include\vtfunc' Check the logs for full command output.

[coleifer]

You can obtain sqlite3 headers at the sqlite.org website. I'm not very familiar with build processes on windows, so I'd suggest trying stackoverflow if you need additional help.

[DavidPratten]

Hi

Hope this helps someone!

I successfully ran pip install vtfunc on Windows 10 after

1. pip install Cython
2. Getting sqlite3.h and creating sqlite3.lib files according to https://gist.github.com/zeljic/d8b542788b225b1bcb5fce169ee28c55
3. Reading the error messages and copying the sqlite3.h file to one of the -IC: folders
4. Reading the error messages and copying the sqlite3.lib file to one of the /LIBPATH: folders

Your mileage may vary.

All the best,

David