问:
Python: ImportError: DLL load failed: The specified module could not be found, Console Working, but Project Interpreter NO
I have the error "ImportError: DLL load failed: The specified module could not be found" when trying to import some Python Packets as Scipy and SKlearn. I have search in other post and I came up with the solution: download 2 .dll libraries_ MSVCP71.dll and msvcr71.dll and put them in C:\Windows\SysWOW64,

After that moment I can correctly Run my script in Pycharm Console, but it continues not working in Pycharm Project Interpreter. I have the same interpreter for Console and project, checked by:

```<code>import sys; print(sys.version)
C:\ProgramData\Anaconda3\pythonw.exe C:/Users/XX/test.py
3.7.1 (default, Dec 10 2018, 22:54:23) [MSC v.1915 64 bit (AMD64)]
</code>```

Checking further I have noticed that the DLL Libraries are different in Console and in Project, do you know how can I configure same DLL paths for Project and Console?

Checked by:

```<code>import win32process

for process in win32process.EnumProcessModules(-1):
    name = win32process.GetModuleFileNameEx(-1, process)
    # if "python27.dll" in name:
    print(name)
</code>```

With the project interpreter I got:

```<code>C:\ProgramData\Anaconda3\pythonw.exe
C:\WINDOWS\SYSTEM32\ntdll.dll
C:\WINDOWS\System32\KERNEL32.DLL
C:\WINDOWS\System32\KERNELBASE.dll
C:\WINDOWS\System32\ucrtbase.dll
C:\ProgramData\Anaconda3\python37.dll
C:\ProgramData\Anaconda3\VCRUNTIME140.dll
C:\WINDOWS\System32\SHLWAPI.dll
C:\WINDOWS\System32\msvcrt.dll
C:\WINDOWS\SYSTEM32\VERSION.dll
C:\WINDOWS\System32\combase.dll
C:\WINDOWS\System32\RPCRT4.dll
C:\WINDOWS\System32\bcryptPrimitives.dll
C:\WINDOWS\System32\GDI32.dll
C:\WINDOWS\System32\gdi32full.dll
C:\WINDOWS\System32\msvcp_win.dll
C:\WINDOWS\System32\USER32.dll
C:\WINDOWS\System32\win32u.dll
C:\WINDOWS\System32\WS2_32.dll
C:\WINDOWS\System32\ADVAPI32.dll
C:\WINDOWS\System32\sechost.dll
C:\WINDOWS\System32\IMM32.DLL
C:\WINDOWS\System32\CRYPTSP.dll
C:\WINDOWS\system32\rsaenh.dll
C:\WINDOWS\System32\bcrypt.dll
C:\WINDOWS\SYSTEM32\CRYPTBASE.dll
C:\ProgramData\Anaconda3\python3.dll
C:\ProgramData\Anaconda3\DLLs\_bz2.pyd
C:\ProgramData\Anaconda3\DLLs\_lzma.pyd
C:\ProgramData\Anaconda3\DLLs\_hashlib.pyd
C:\WINDOWS\SYSTEM32\libcrypto-1_1-x64.dll
C:\ProgramData\Anaconda3\DLLs\_socket.pyd
C:\ProgramData\Anaconda3\DLLs\select.pyd
C:\ProgramData\Anaconda3\DLLs\_ssl.pyd
C:\WINDOWS\System32\CRYPT32.dll
C:\WINDOWS\System32\MSASN1.dll
C:\WINDOWS\SYSTEM32\libssl-1_1-x64.dll
C:\ProgramData\Anaconda3\DLLs\_ctypes.pyd
C:\WINDOWS\System32\ole32.dll
C:\WINDOWS\System32\OLEAUT32.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\libmmd.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\libifcoremd.dll
C:\WINDOWS\System32\imagehlp.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\_multiarray_umath.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\mkl_rt.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\_multiarray_tests.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\numpy\linalg\lapack_lite.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\numpy\linalg\_umath_linalg.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\DLLs\_decimal.pyd
C:\ProgramData\Anaconda3\lib\site-packages\numpy\fft\fftpack_lite.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\numpy\random\mtrand.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\mkl_intel_thread.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\libiomp5md.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\mkl_core.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\mkl_avx2.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\mkl_vml_avx2.dll
C:\ProgramData\Anaconda3\lib\site-packages\win32\win32process.pyd
C:\ProgramData\Anaconda3\lib\site-packages\win32\pywintypes37.dll
C:\WINDOWS\System32\Psapi.dll
</code>```

and with console interpreter(the same interpreter) I got:

```<code>C:\ProgramData\Anaconda3\pythonw.exe
C:\WINDOWS\SYSTEM32\ntdll.dll
C:\WINDOWS\System32\KERNEL32.DLL
C:\WINDOWS\System32\KERNELBASE.dll
C:\WINDOWS\System32\ucrtbase.dll
C:\ProgramData\Anaconda3\python37.dll
C:\ProgramData\Anaconda3\VCRUNTIME140.dll
C:\WINDOWS\System32\SHLWAPI.dll
C:\WINDOWS\System32\msvcrt.dll
C:\WINDOWS\System32\combase.dll
C:\WINDOWS\System32\RPCRT4.dll
C:\WINDOWS\System32\bcryptPrimitives.dll
C:\WINDOWS\System32\GDI32.dll
C:\WINDOWS\System32\gdi32full.dll
C:\WINDOWS\System32\msvcp_win.dll
C:\WINDOWS\System32\USER32.dll
C:\WINDOWS\System32\win32u.dll
C:\WINDOWS\System32\WS2_32.dll
C:\WINDOWS\System32\ADVAPI32.dll
C:\WINDOWS\System32\sechost.dll
C:\WINDOWS\SYSTEM32\VERSION.dll
C:\WINDOWS\System32\IMM32.DLL
C:\WINDOWS\System32\CRYPTSP.dll
C:\WINDOWS\system32\rsaenh.dll
C:\WINDOWS\System32\bcrypt.dll
C:\WINDOWS\SYSTEM32\CRYPTBASE.dll
C:\ProgramData\Anaconda3\python3.dll
C:\ProgramData\Anaconda3\DLLs\_bz2.pyd
C:\ProgramData\Anaconda3\DLLs\_lzma.pyd
C:\ProgramData\Anaconda3\DLLs\_hashlib.pyd
C:\WINDOWS\SYSTEM32\libcrypto-1_1-x64.dll
C:\ProgramData\Anaconda3\DLLs\_socket.pyd
C:\ProgramData\Anaconda3\DLLs\select.pyd
C:\ProgramData\Anaconda3\DLLs\_ssl.pyd
C:\WINDOWS\System32\CRYPT32.dll
C:\WINDOWS\System32\MSASN1.dll
C:\WINDOWS\SYSTEM32\libssl-1_1-x64.dll
C:\ProgramData\Anaconda3\DLLs\_ctypes.pyd
C:\WINDOWS\System32\ole32.dll
C:\WINDOWS\System32\OLEAUT32.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\libmmd.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\libifcoremd.dll
C:\WINDOWS\System32\imagehlp.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\_multiarray_umath.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\mkl_rt.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\_multiarray_tests.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\numpy\linalg\lapack_lite.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\numpy\linalg\_umath_linalg.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\DLLs\_decimal.pyd
C:\ProgramData\Anaconda3\lib\site-packages\numpy\fft\fftpack_lite.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\numpy\random\mtrand.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\mkl_intel_thread.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\libiomp5md.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\mkl_core.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\mkl_avx2.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\mkl_vml_avx2.dll
C:\ProgramData\Anaconda3\DLLs\_queue.pyd
C:\ProgramData\Anaconda3\DLLs\pyexpat.pyd
C:\ProgramData\Anaconda3\lib\site-packages\win32\win32api.pyd
C:\WINDOWS\System32\SHELL32.dll
C:\WINDOWS\System32\cfgmgr32.dll
C:\WINDOWS\System32\shcore.dll
C:\WINDOWS\System32\windows.storage.dll
C:\WINDOWS\System32\profapi.dll
C:\WINDOWS\System32\powrprof.dll
C:\WINDOWS\System32\kernel.appcore.dll
C:\ProgramData\Anaconda3\lib\site-packages\win32\pywintypes37.dll
C:\WINDOWS\SYSTEM32\secur32.dll
C:\WINDOWS\SYSTEM32\SSPICLI.DLL
C:\ProgramData\Anaconda3\lib\site-packages\win32\_win32sysloader.pyd
C:\ProgramData\Anaconda3\Library\bin\pythoncom37.dll
C:\WINDOWS\system32\uxtheme.dll
c:\Program Files\HP\HP ProtectTools Security Manager\Bin\DpoFeedb.dll
C:\WINDOWS\SYSTEM32\USERENV.dll
C:\WINDOWS\SYSTEM32\urlmon.dll
C:\WINDOWS\SYSTEM32\iertutil.dll
C:\ProgramData\Anaconda3\DLLs\_contextvars.pyd
C:\ProgramData\Anaconda3\DLLs\_asyncio.pyd
C:\ProgramData\Anaconda3\DLLs\_overlapped.pyd
C:\WINDOWS\system32\mswsock.dll
C:\ProgramData\Anaconda3\DLLs\_sqlite3.pyd
C:\ProgramData\Anaconda3\Library\bin\sqlite3.dll
C:\ProgramData\Anaconda3\DLLs\unicodedata.pyd
C:\WINDOWS\SYSTEM32\DNSAPI.dll
C:\WINDOWS\System32\NSI.dll
C:\WINDOWS\SYSTEM32\IPHLPAPI.DLL
C:\Windows\System32\rasadhlp.dll
C:\WINDOWS\System32\fwpuclnt.dll
C:\ProgramData\Anaconda3\lib\site-packages\pyodbc.cp37-win_amd64.pyd
C:\WINDOWS\SYSTEM32\ODBC32.dll
C:\WINDOWS\SYSTEM32\DPAPI.DLL
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslib.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\conversion.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\np_datetime.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\nattype.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\timedeltas.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\timezones.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\parsing.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\ccalendar.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\strptime.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\timestamps.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\fields.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\hashtable.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\missing.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\lib.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\algos.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\properties.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\hashing.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\bottleneck\reduce.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\bottleneck\nonreduce.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\bottleneck\nonreduce_axis.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\bottleneck\move.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\index.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\period.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\frequencies.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\resolution.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\offsets.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\join.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\ops.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\interval.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\indexing.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\internals.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\sparse.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\matplotlib\_path.cp37-win_amd64.pyd
C:\WINDOWS\SYSTEM32\MSVCP140.dll
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\window.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\skiplist.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\reduction.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\groupby.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\reshape.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\parsers.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\json.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\writers.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\io\msgpack\_packer.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\io\msgpack\_unpacker.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\util\_move.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\testing.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\cryptography\hazmat\bindings\_constant_time.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\_cffi_backend.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\cryptography\hazmat\bindings\_openssl.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\_lib\_ccallback_c.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\special\_ufuncs.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libopenblas.IPBC74C7KURV7CB2PKT5Z5FNR3SIBV4J.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libdgamln.L2MD744DJHVE3HDIDGQFBRBYHR75FSAI.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\special\_ufuncs_cxx.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\special\specfun.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libspecfun.BHLTWMBI4EYWDACZN4DQUESSDJRJNGEL.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\linalg\_fblas.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libwrap_dum.Y5YNB62CEIOAELCP2WZDLJGRR3KZYA7H.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\linalg\_flapack.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libwrap_dum.MRQ7UAVPNY36S6LDFETEBLDUEUIEUBHR.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\linalg\_flinalg.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libdet.MC6JBNE6VNYD6FNPXJKRRGWJPYV2NN2N.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\linalg\_solve_toeplitz.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\linalg\_decomp_update.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\linalg\cython_blas.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\lib_blas_su.NB4WQJWKUFT4P25L5KENNGUG4L73EMTU.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\linalg\cython_lapack.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\special\_comb.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\special\_ellip_harm_2.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\interpolate\_fitpack.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libbispeu.5N2XSD7URZS4WTOSLTOG4DDMA4HGB46U.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\interpolate\dfitpack.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libdfitpack.PJU6IBGOYZCWITNVROHYOQAYNGAXO3HT.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\interpolate\_bspl.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\interpolate\_ppoly.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\interpolate\interpnd.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\sparse\_sparsetools.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\sparse\_csparsetools.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\sparse\csgraph\_shortest_path.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\sparse\csgraph\_tools.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\sparse\csgraph\_traversal.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\sparse\csgraph\_min_spanning_tree.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\sparse\csgraph\_reordering.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\spatial\ckdtree.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\spatial\qhull.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\_lib\messagestream.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\spatial\_voronoi.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\spatial\_distance_wrap.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\spatial\_hausdorff.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\PIL\_imaging.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\Library\bin\zlib.dll
C:\ProgramData\Anaconda3\Library\bin\tiff.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\optimize\minpack2.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libdcsrch.I2AOPDCXAPDRFNPWY55H5UE7XZSU5CVN.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\optimize\_trlib\_trlib.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\sparse\linalg\isolve\_iterative.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libgetbreak.3JNHTDZYEWBO45P4ZRQMAM3G2F777JB5.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\sparse\linalg\dsolve\_superlu.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\sparse\linalg\eigen\arpack\_arpack.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\lib_arpack-.XS6PLV3734SEBIN3L7VHQL4V6AFVR3MS.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\optimize\_group_columns.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\optimize\_lbfgsb.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\liblbfgsb.UBS3OB2ZGZATGJADSNFQXG6JBUJXYZFS.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\optimize\moduleTNC.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\optimize\_cobyla.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libcobyla2.JEGTSUUFJ7DFXWZN5PAYZTTLBDATC4WD.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\optimize\_slsqp.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libslsqp_op.LIFGE6AEK5GZMIV4YAH6Q4UEDG4INU5S.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\optimize\_minpack.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libchkder.G7WSOGIYYQO3UWFVEZ3PPXCXR53ADVPA.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\optimize\_lsq\givens_elimination.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\optimize\_zeros.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\optimize\_nnls.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libnnls.IXEEHJUCGHJL42YZEM6UIEMROJWXHMLJ.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\integrate\_odepack.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libblkdta00.ZGG7V3JKZ4GEJEF2MTA5BHMT7BJIUCKN.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\integrate\_quadpack.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libdqag.NBT4GJCYXTJZ6FKYPTMU262SBAG2QI76.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\integrate\vode.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libvode.UPE44X4HLFF56JWPT3ESOS5IVN5QQ5A4.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\integrate\_dop.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libdop853.6TJTQZW3I3Q3QIDQHEOBEZKJ3NYRXI4B.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\integrate\lsoda.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\stats\_stats.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\stats\statlib.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libansari.R6EA3HQP5KZ6TAXU4Y4ZVTRPT7UVA53Z.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\stats\mvn.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libmvndst.5VXNIPAPINAF5NIHXAFNA4OTHOPNDEWG.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\DLLs\_multiprocessing.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\__check_build\_check_build.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\utils\murmurhash.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\psutil\_psutil_windows.cp37-win_amd64.pyd
C:\WINDOWS\System32\PSAPI.DLL
C:\WINDOWS\SYSTEM32\WTSAPI32.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\io\matlab\mio_utils.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\io\matlab\mio5_utils.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\io\matlab\streams.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\utils\_logistic_sigmoid.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\utils\sparsefuncs_fast.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\DLLs\_elementtree.pyd
C:\ProgramData\Anaconda3\DLLs\_tkinter.pyd
C:\ProgramData\Anaconda3\DLLs\tcl86t.dll
C:\ProgramData\Anaconda3\DLLs\tk86t.dll
C:\WINDOWS\System32\COMDLG32.dll
C:\WINDOWS\SYSTEM32\NETAPI32.dll
C:\WINDOWS\WinSxS\amd64_microsoft.windows.common-controls_6595b64144ccf1df_6.0.17763.379_none_05b83be8071c94a1\COMCTL32.dll
C:\WINDOWS\SYSTEM32\LOGONCLI.DLL
C:\WINDOWS\SYSTEM32\SAMCLI.DLL
C:\WINDOWS\SYSTEM32\NETUTILS.DLL
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\feature_extraction\_hashing.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\utils\_random.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\datasets\_svmlight_format.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\svm\libsvm.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\svm\liblinear.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\svm\libsvm_sparse.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\utils\seq_dataset.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\utils\arrayfuncs.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\metrics\cluster\expected_mutual_info_fast.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\utils\lgamma.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\metrics\pairwise_fast.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\linear_model\cd_fast.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\linear_model\sgd_fast.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\utils\weight_vector.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\linear_model\sag_fast.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\neighbors\ball_tree.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\neighbors\dist_metrics.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\neighbors\typedefs.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\neighbors\kd_tree.cp37-win_amd64.pyd
C:\windows\system32\msodbcsql17.dll
C:\windows\system32\WININET.dll
C:\windows\system32\MSVCR120.dll
C:\windows\system32\MSVCP120.dll
C:\WINDOWS\SYSTEM32\MTXDM.DLL
C:\WINDOWS\System32\clbcatq.dll
C:\Windows\System32\comsvcs.dll
C:\windows\system32\1033\msodbcsqlr17.rll
C:\WINDOWS\SYSTEM32\netbios.dll
C:\WINDOWS\SYSTEM32\CLUSAPI.DLL
C:\WINDOWS\SYSTEM32\RESUTILS.DLL
C:\WINDOWS\system32\schannel.DLL
</code>```

Where you can see in the Console interpreter I have the line:

```<code>C:\WINDOWS\SYSTEM32\MSVCP140.dll
</code>```

Which I think is the one that make it works,

How can I add this dll path to the project interpreter?

Thanks in advance!

答: Try 2019.1.3 RC build. I believe you are facing a known issue and it was fixed there.</p>

Body:
I have the error "ImportError: DLL load failed: The specified module could not be found" when trying to import some Python Packets as Scipy and SKlearn. I have search in other post and I came up with the solution: download 2 .dll libraries_ MSVCP71.dll and msvcr71.dll and put them in C:\Windows\SysWOW64,

After that moment I can correctly Run my script in Pycharm Console, but it continues not working in Pycharm Project Interpreter. I have the same interpreter for Console and project, checked by:

import sys; print(sys.version)
C:\ProgramData\Anaconda3\pythonw.exe C:/Users/XX/test.py
3.7.1 (default, Dec 10 2018, 22:54:23) [MSC v.1915 64 bit (AMD64)]

Checking further I have noticed that the DLL Libraries are different in Console and in Project, do you know how can I configure same DLL paths for Project and Console?

Checked by:

import win32process

for process in win32process.EnumProcessModules(-1):
    name = win32process.GetModuleFileNameEx(-1, process)
    # if "python27.dll" in name:
    print(name)

With the project interpreter I got:

C:\ProgramData\Anaconda3\pythonw.exe
C:\WINDOWS\SYSTEM32\ntdll.dll
C:\WINDOWS\System32\KERNEL32.DLL
C:\WINDOWS\System32\KERNELBASE.dll
C:\WINDOWS\System32\ucrtbase.dll
C:\ProgramData\Anaconda3\python37.dll
C:\ProgramData\Anaconda3\VCRUNTIME140.dll
C:\WINDOWS\System32\SHLWAPI.dll
C:\WINDOWS\System32\msvcrt.dll
C:\WINDOWS\SYSTEM32\VERSION.dll
C:\WINDOWS\System32\combase.dll
C:\WINDOWS\System32\RPCRT4.dll
C:\WINDOWS\System32\bcryptPrimitives.dll
C:\WINDOWS\System32\GDI32.dll
C:\WINDOWS\System32\gdi32full.dll
C:\WINDOWS\System32\msvcp_win.dll
C:\WINDOWS\System32\USER32.dll
C:\WINDOWS\System32\win32u.dll
C:\WINDOWS\System32\WS2_32.dll
C:\WINDOWS\System32\ADVAPI32.dll
C:\WINDOWS\System32\sechost.dll
C:\WINDOWS\System32\IMM32.DLL
C:\WINDOWS\System32\CRYPTSP.dll
C:\WINDOWS\system32\rsaenh.dll
C:\WINDOWS\System32\bcrypt.dll
C:\WINDOWS\SYSTEM32\CRYPTBASE.dll
C:\ProgramData\Anaconda3\python3.dll
C:\ProgramData\Anaconda3\DLLs\_bz2.pyd
C:\ProgramData\Anaconda3\DLLs\_lzma.pyd
C:\ProgramData\Anaconda3\DLLs\_hashlib.pyd
C:\WINDOWS\SYSTEM32\libcrypto-1_1-x64.dll
C:\ProgramData\Anaconda3\DLLs\_socket.pyd
C:\ProgramData\Anaconda3\DLLs\select.pyd
C:\ProgramData\Anaconda3\DLLs\_ssl.pyd
C:\WINDOWS\System32\CRYPT32.dll
C:\WINDOWS\System32\MSASN1.dll
C:\WINDOWS\SYSTEM32\libssl-1_1-x64.dll
C:\ProgramData\Anaconda3\DLLs\_ctypes.pyd
C:\WINDOWS\System32\ole32.dll
C:\WINDOWS\System32\OLEAUT32.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\libmmd.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\libifcoremd.dll
C:\WINDOWS\System32\imagehlp.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\_multiarray_umath.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\mkl_rt.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\_multiarray_tests.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\numpy\linalg\lapack_lite.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\numpy\linalg\_umath_linalg.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\DLLs\_decimal.pyd
C:\ProgramData\Anaconda3\lib\site-packages\numpy\fft\fftpack_lite.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\numpy\random\mtrand.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\mkl_intel_thread.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\libiomp5md.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\mkl_core.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\mkl_avx2.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\mkl_vml_avx2.dll
C:\ProgramData\Anaconda3\lib\site-packages\win32\win32process.pyd
C:\ProgramData\Anaconda3\lib\site-packages\win32\pywintypes37.dll
C:\WINDOWS\System32\Psapi.dll

and with console interpreter(the same interpreter) I got:

C:\ProgramData\Anaconda3\pythonw.exe
C:\WINDOWS\SYSTEM32\ntdll.dll
C:\WINDOWS\System32\KERNEL32.DLL
C:\WINDOWS\System32\KERNELBASE.dll
C:\WINDOWS\System32\ucrtbase.dll
C:\ProgramData\Anaconda3\python37.dll
C:\ProgramData\Anaconda3\VCRUNTIME140.dll
C:\WINDOWS\System32\SHLWAPI.dll
C:\WINDOWS\System32\msvcrt.dll
C:\WINDOWS\System32\combase.dll
C:\WINDOWS\System32\RPCRT4.dll
C:\WINDOWS\System32\bcryptPrimitives.dll
C:\WINDOWS\System32\GDI32.dll
C:\WINDOWS\System32\gdi32full.dll
C:\WINDOWS\System32\msvcp_win.dll
C:\WINDOWS\System32\USER32.dll
C:\WINDOWS\System32\win32u.dll
C:\WINDOWS\System32\WS2_32.dll
C:\WINDOWS\System32\ADVAPI32.dll
C:\WINDOWS\System32\sechost.dll
C:\WINDOWS\SYSTEM32\VERSION.dll
C:\WINDOWS\System32\IMM32.DLL
C:\WINDOWS\System32\CRYPTSP.dll
C:\WINDOWS\system32\rsaenh.dll
C:\WINDOWS\System32\bcrypt.dll
C:\WINDOWS\SYSTEM32\CRYPTBASE.dll
C:\ProgramData\Anaconda3\python3.dll
C:\ProgramData\Anaconda3\DLLs\_bz2.pyd
C:\ProgramData\Anaconda3\DLLs\_lzma.pyd
C:\ProgramData\Anaconda3\DLLs\_hashlib.pyd
C:\WINDOWS\SYSTEM32\libcrypto-1_1-x64.dll
C:\ProgramData\Anaconda3\DLLs\_socket.pyd
C:\ProgramData\Anaconda3\DLLs\select.pyd
C:\ProgramData\Anaconda3\DLLs\_ssl.pyd
C:\WINDOWS\System32\CRYPT32.dll
C:\WINDOWS\System32\MSASN1.dll
C:\WINDOWS\SYSTEM32\libssl-1_1-x64.dll
C:\ProgramData\Anaconda3\DLLs\_ctypes.pyd
C:\WINDOWS\System32\ole32.dll
C:\WINDOWS\System32\OLEAUT32.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\libmmd.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\libifcoremd.dll
C:\WINDOWS\System32\imagehlp.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\_multiarray_umath.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\mkl_rt.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\_multiarray_tests.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\numpy\linalg\lapack_lite.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\numpy\linalg\_umath_linalg.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\DLLs\_decimal.pyd
C:\ProgramData\Anaconda3\lib\site-packages\numpy\fft\fftpack_lite.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\numpy\random\mtrand.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\mkl_intel_thread.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\libiomp5md.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\mkl_core.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\mkl_avx2.dll
C:\ProgramData\Anaconda3\lib\site-packages\numpy\core\mkl_vml_avx2.dll
C:\ProgramData\Anaconda3\DLLs\_queue.pyd
C:\ProgramData\Anaconda3\DLLs\pyexpat.pyd
C:\ProgramData\Anaconda3\lib\site-packages\win32\win32api.pyd
C:\WINDOWS\System32\SHELL32.dll
C:\WINDOWS\System32\cfgmgr32.dll
C:\WINDOWS\System32\shcore.dll
C:\WINDOWS\System32\windows.storage.dll
C:\WINDOWS\System32\profapi.dll
C:\WINDOWS\System32\powrprof.dll
C:\WINDOWS\System32\kernel.appcore.dll
C:\ProgramData\Anaconda3\lib\site-packages\win32\pywintypes37.dll
C:\WINDOWS\SYSTEM32\secur32.dll
C:\WINDOWS\SYSTEM32\SSPICLI.DLL
C:\ProgramData\Anaconda3\lib\site-packages\win32\_win32sysloader.pyd
C:\ProgramData\Anaconda3\Library\bin\pythoncom37.dll
C:\WINDOWS\system32\uxtheme.dll
c:\Program Files\HP\HP ProtectTools Security Manager\Bin\DpoFeedb.dll
C:\WINDOWS\SYSTEM32\USERENV.dll
C:\WINDOWS\SYSTEM32\urlmon.dll
C:\WINDOWS\SYSTEM32\iertutil.dll
C:\ProgramData\Anaconda3\DLLs\_contextvars.pyd
C:\ProgramData\Anaconda3\DLLs\_asyncio.pyd
C:\ProgramData\Anaconda3\DLLs\_overlapped.pyd
C:\WINDOWS\system32\mswsock.dll
C:\ProgramData\Anaconda3\DLLs\_sqlite3.pyd
C:\ProgramData\Anaconda3\Library\bin\sqlite3.dll
C:\ProgramData\Anaconda3\DLLs\unicodedata.pyd
C:\WINDOWS\SYSTEM32\DNSAPI.dll
C:\WINDOWS\System32\NSI.dll
C:\WINDOWS\SYSTEM32\IPHLPAPI.DLL
C:\Windows\System32\rasadhlp.dll
C:\WINDOWS\System32\fwpuclnt.dll
C:\ProgramData\Anaconda3\lib\site-packages\pyodbc.cp37-win_amd64.pyd
C:\WINDOWS\SYSTEM32\ODBC32.dll
C:\WINDOWS\SYSTEM32\DPAPI.DLL
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslib.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\conversion.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\np_datetime.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\nattype.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\timedeltas.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\timezones.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\parsing.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\ccalendar.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\strptime.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\timestamps.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\fields.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\hashtable.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\missing.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\lib.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\algos.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\properties.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\hashing.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\bottleneck\reduce.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\bottleneck\nonreduce.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\bottleneck\nonreduce_axis.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\bottleneck\move.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\index.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\period.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\frequencies.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\resolution.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\tslibs\offsets.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\join.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\ops.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\interval.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\indexing.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\internals.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\sparse.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\matplotlib\_path.cp37-win_amd64.pyd
C:\WINDOWS\SYSTEM32\MSVCP140.dll
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\window.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\skiplist.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\reduction.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\groupby.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\reshape.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\parsers.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\json.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\writers.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\io\msgpack\_packer.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\io\msgpack\_unpacker.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\util\_move.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\pandas\_libs\testing.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\cryptography\hazmat\bindings\_constant_time.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\_cffi_backend.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\cryptography\hazmat\bindings\_openssl.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\_lib\_ccallback_c.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\special\_ufuncs.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libopenblas.IPBC74C7KURV7CB2PKT5Z5FNR3SIBV4J.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libdgamln.L2MD744DJHVE3HDIDGQFBRBYHR75FSAI.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\special\_ufuncs_cxx.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\special\specfun.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libspecfun.BHLTWMBI4EYWDACZN4DQUESSDJRJNGEL.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\linalg\_fblas.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libwrap_dum.Y5YNB62CEIOAELCP2WZDLJGRR3KZYA7H.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\linalg\_flapack.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libwrap_dum.MRQ7UAVPNY36S6LDFETEBLDUEUIEUBHR.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\linalg\_flinalg.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libdet.MC6JBNE6VNYD6FNPXJKRRGWJPYV2NN2N.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\linalg\_solve_toeplitz.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\linalg\_decomp_update.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\linalg\cython_blas.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\lib_blas_su.NB4WQJWKUFT4P25L5KENNGUG4L73EMTU.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\linalg\cython_lapack.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\special\_comb.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\special\_ellip_harm_2.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\interpolate\_fitpack.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libbispeu.5N2XSD7URZS4WTOSLTOG4DDMA4HGB46U.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\interpolate\dfitpack.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libdfitpack.PJU6IBGOYZCWITNVROHYOQAYNGAXO3HT.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\interpolate\_bspl.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\interpolate\_ppoly.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\interpolate\interpnd.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\sparse\_sparsetools.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\sparse\_csparsetools.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\sparse\csgraph\_shortest_path.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\sparse\csgraph\_tools.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\sparse\csgraph\_traversal.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\sparse\csgraph\_min_spanning_tree.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\sparse\csgraph\_reordering.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\spatial\ckdtree.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\spatial\qhull.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\_lib\messagestream.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\spatial\_voronoi.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\spatial\_distance_wrap.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\spatial\_hausdorff.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\PIL\_imaging.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\Library\bin\zlib.dll
C:\ProgramData\Anaconda3\Library\bin\tiff.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\optimize\minpack2.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libdcsrch.I2AOPDCXAPDRFNPWY55H5UE7XZSU5CVN.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\optimize\_trlib\_trlib.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\sparse\linalg\isolve\_iterative.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libgetbreak.3JNHTDZYEWBO45P4ZRQMAM3G2F777JB5.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\sparse\linalg\dsolve\_superlu.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\sparse\linalg\eigen\arpack\_arpack.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\lib_arpack-.XS6PLV3734SEBIN3L7VHQL4V6AFVR3MS.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\optimize\_group_columns.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\optimize\_lbfgsb.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\liblbfgsb.UBS3OB2ZGZATGJADSNFQXG6JBUJXYZFS.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\optimize\moduleTNC.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\optimize\_cobyla.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libcobyla2.JEGTSUUFJ7DFXWZN5PAYZTTLBDATC4WD.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\optimize\_slsqp.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libslsqp_op.LIFGE6AEK5GZMIV4YAH6Q4UEDG4INU5S.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\optimize\_minpack.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libchkder.G7WSOGIYYQO3UWFVEZ3PPXCXR53ADVPA.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\optimize\_lsq\givens_elimination.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\optimize\_zeros.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\optimize\_nnls.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libnnls.IXEEHJUCGHJL42YZEM6UIEMROJWXHMLJ.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\integrate\_odepack.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libblkdta00.ZGG7V3JKZ4GEJEF2MTA5BHMT7BJIUCKN.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\integrate\_quadpack.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libdqag.NBT4GJCYXTJZ6FKYPTMU262SBAG2QI76.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\integrate\vode.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libvode.UPE44X4HLFF56JWPT3ESOS5IVN5QQ5A4.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\integrate\_dop.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libdop853.6TJTQZW3I3Q3QIDQHEOBEZKJ3NYRXI4B.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\integrate\lsoda.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\stats\_stats.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\stats\statlib.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libansari.R6EA3HQP5KZ6TAXU4Y4ZVTRPT7UVA53Z.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\stats\mvn.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\extra-dll\libmvndst.5VXNIPAPINAF5NIHXAFNA4OTHOPNDEWG.gfortran-win_amd64.dll
C:\ProgramData\Anaconda3\DLLs\_multiprocessing.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\__check_build\_check_build.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\utils\murmurhash.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\psutil\_psutil_windows.cp37-win_amd64.pyd
C:\WINDOWS\System32\PSAPI.DLL
C:\WINDOWS\SYSTEM32\WTSAPI32.dll
C:\ProgramData\Anaconda3\lib\site-packages\scipy\io\matlab\mio_utils.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\io\matlab\mio5_utils.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\scipy\io\matlab\streams.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\utils\_logistic_sigmoid.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\utils\sparsefuncs_fast.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\DLLs\_elementtree.pyd
C:\ProgramData\Anaconda3\DLLs\_tkinter.pyd
C:\ProgramData\Anaconda3\DLLs\tcl86t.dll
C:\ProgramData\Anaconda3\DLLs\tk86t.dll
C:\WINDOWS\System32\COMDLG32.dll
C:\WINDOWS\SYSTEM32\NETAPI32.dll
C:\WINDOWS\WinSxS\amd64_microsoft.windows.common-controls_6595b64144ccf1df_6.0.17763.379_none_05b83be8071c94a1\COMCTL32.dll
C:\WINDOWS\SYSTEM32\LOGONCLI.DLL
C:\WINDOWS\SYSTEM32\SAMCLI.DLL
C:\WINDOWS\SYSTEM32\NETUTILS.DLL
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\feature_extraction\_hashing.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\utils\_random.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\datasets\_svmlight_format.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\svm\libsvm.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\svm\liblinear.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\svm\libsvm_sparse.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\utils\seq_dataset.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\utils\arrayfuncs.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\metrics\cluster\expected_mutual_info_fast.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\utils\lgamma.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\metrics\pairwise_fast.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\linear_model\cd_fast.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\linear_model\sgd_fast.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\utils\weight_vector.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\linear_model\sag_fast.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\neighbors\ball_tree.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\neighbors\dist_metrics.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\neighbors\typedefs.cp37-win_amd64.pyd
C:\ProgramData\Anaconda3\lib\site-packages\sklearn\neighbors\kd_tree.cp37-win_amd64.pyd
C:\windows\system32\msodbcsql17.dll
C:\windows\system32\WININET.dll
C:\windows\system32\MSVCR120.dll
C:\windows\system32\MSVCP120.dll
C:\WINDOWS\SYSTEM32\MTXDM.DLL
C:\WINDOWS\System32\clbcatq.dll
C:\Windows\System32\comsvcs.dll
C:\windows\system32\1033\msodbcsqlr17.rll
C:\WINDOWS\SYSTEM32\netbios.dll
C:\WINDOWS\SYSTEM32\CLUSAPI.DLL
C:\WINDOWS\SYSTEM32\RESUTILS.DLL
C:\WINDOWS\system32\schannel.DLL

Where you can see in the Console interpreter I have the line:

C:\WINDOWS\SYSTEM32\MSVCP140.dll

Which I think is the one that make it works,

How can I add this dll path to the project interpreter?

Thanks in advance!


来源: stackexchange

问:
ON DELETE CASCADE for multiple foreign keys with Sequelize
Suppose I have three models:

Task: A thing that needs done, like "take out the recycling".  Can be done many times.

TaskList: An object that represents a list of tasks, and has its own metadata.

TaskListEntry: An association between Task and TaskList, that may have data such as the priority or who is assigned to it.

I have my associations set up like this:

```<code>Task.hasMany(TaskListEntry, {onDelete: 'cascade', hooks: true}));

TaskList.hasMany(TaskListEntry, {onDelete: 'cascade', hooks: true});

TaskListEntry.belongsTo(TaskList);
TaskListEntry.belongsTo(Task);
</code>```

This works fine, except for deleting.  When I delete a Task, any associated TaskListEntries are deleted as expected.  However, when I delete a TaskList, its associated TaskListEntries simply have their foreign key for the TaskList set to null.

It seems that Sequelize is generating the following table:

```<code>CREATE TABLE `TaskListEntries`(
  `id` UUID PRIMARY KEY,
  /* some other fields here */
  `createdAt` DATETIME NOT NULL,
  `updatedAt` DATETIME NOT NULL,
  `TaskId` UUID REFERENCES `Tasks`(`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  `TaskListId` UUID REFERENCES `TaskLists`(`id`) ON DELETE SET NULL ON UPDATE CASCADE);
</code>```

Despite the associations being configured the same, the foreign keys for Tasks and TaskLists have different DELETE behavior.  If I remove one of the associations, the other works just fine.

Therefore, I think the issue is multiple foreign keys with ON DELETE CASCADE, at least as far as Sequelize seeis it.

Any thoughts on how to correct this?

答:
I had to set the allowNull:false for the foreignKey for getting 'CASCADE' on deletions to work. So it should be something like this in your case:

```<code>TaskListEntry.belongsTo(TaskList, {
  onDelete: 'cascade',
  foreignKey: { allowNull: false }    //   <-------------
  hooks: true
});
</code>```

Given the case, that your models are in general similar to this structure from http://docs.sequelizejs.com/manual/associations.html#belongs-to-many-associations:

```<code>class User extends Model {}
User.init({}, { sequelize, modelName: 'user' })

class Project extends Model {}
Project.init({}, { sequelize, modelName: 'project' })

class UserProjects extends Model {}
UserProjects.init({
  status: DataTypes.STRING
}, { sequelize, modelName: 'userProjects' })

User.belongsToMany(Project, { through: UserProjects })
Project.belongsToMany(User, { through: UserProjects })
</code>```

ContentLicense: CC BY-SA 4.0

Body:
Suppose I have three models:

Task: A thing that needs done, like "take out the recycling".  Can be done many times.

TaskList: An object that represents a list of tasks, and has its own metadata.

TaskListEntry: An association between Task and TaskList, that may have data such as the priority or who is assigned to it.

I have my associations set up like this:

Task.hasMany(TaskListEntry, {onDelete: 'cascade', hooks: true}));

TaskList.hasMany(TaskListEntry, {onDelete: 'cascade', hooks: true});

TaskListEntry.belongsTo(TaskList);
TaskListEntry.belongsTo(Task);

This works fine, except for deleting.  When I delete a Task, any associated TaskListEntries are deleted as expected.  However, when I delete a TaskList, its associated TaskListEntries simply have their foreign key for the TaskList set to null.

It seems that Sequelize is generating the following table:

CREATE TABLE `TaskListEntries`(
  `id` UUID PRIMARY KEY,
  /* some other fields here */
  `createdAt` DATETIME NOT NULL,
  `updatedAt` DATETIME NOT NULL,
  `TaskId` UUID REFERENCES `Tasks`(`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  `TaskListId` UUID REFERENCES `TaskLists`(`id`) ON DELETE SET NULL ON UPDATE CASCADE);

Despite the associations being configured the same, the foreign keys for Tasks and TaskLists have different DELETE behavior.  If I remove one of the associations, the other works just fine.

Therefore, I think the issue is multiple foreign keys with ON DELETE CASCADE, at least as far as Sequelize seeis it.

Any thoughts on how to correct this?

Body:
I had to set the allowNull:false for the foreignKey for getting 'CASCADE' on deletions to work. So it should be something like this in your case:

TaskListEntry.belongsTo(TaskList, {
  onDelete: 'cascade',
  foreignKey: { allowNull: false }    //   <-------------
  hooks: true
});

Given the case, that your models are in general similar to this structure from http://docs.sequelizejs.com/manual/associations.html#belongs-to-many-associations:

class User extends Model {}
User.init({}, { sequelize, modelName: 'user' })

class Project extends Model {}
Project.init({}, { sequelize, modelName: 'project' })

class UserProjects extends Model {}
UserProjects.init({
  status: DataTypes.STRING
}, { sequelize, modelName: 'userProjects' })

User.belongsToMany(Project, { through: UserProjects })
Project.belongsToMany(User, { through: UserProjects })


问:
Filter array by indices
I have an array of elements. I also have an IndexSet that specifies which indices of the array need to be extracted into a new array. E.g.:

```<code>let array = ["sun", "moon", "star", "meteor"]
let indexSet: IndexSet = [2, 3]
// Some magic happens here to get:
let result = ["star", "meteor"]
</code>```

I'm looking to use the swift filter function, but haven't got the answer yet. How can I do this?

答:
You can use Array.elements(at:)

let result = array.elements(at: indexSet)
```

ContentLicense: CC BY-SA 3.0

Title: Filter array by indices

Body:
I have an array of elements. I also have an IndexSet that specifies which indices of the array need to be extracted into a new array. E.g.:

let array = ["sun", "moon", "star", "meteor"]
let indexSet: IndexSet = [2, 3]
// Some magic happens here to get:
let result = ["star", "meteor"]

I'm looking to use the swift filter function, but haven't got the answer yet. How can I do this?


问:
Routes not working on Slim framework
I am learning the slim framework. I got a point where I have to set up my webserver such that I can see something like http://slimapp instead of http://localhost/slimapp/public/index.php.

I have included a .htaccess file in the public folder of my project like so

```<code>RewriteEngine on
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule . index.php [L]
</code>```

I have also set up a virtual host on my wamp server

```<code><VirtualHost *:80>
    DocumentRoot "C:\wamp64\www\slimapp\public"
    ServerName slimapp

    <Directory "C:\wamp64\www\slimapp\public">
        AllowOverride All
        Order allow,deny
        Allow from all
    </Directory>
</VirtualHost>
</code>```

I have also added this to my hosts file

```<code>127.0.0.1 slimapp
</code>```

I restarted my server but I get a 'Not Found' error when I try to access my routes.

```<code>"Not Found
The requested URL /hello/uche was not found on this server."
</code>```

This is my index.php file

```<code><?php
use \Psr\Http\Message\ServerRequestInterface as Request;
use \Psr\Http\Message\ResponseInterface as Response;

require '../vendor/autoload.php';

$app = new \Slim\App;
$app->get('/hello/{name}', function (Request $request, Response $response) {
    $name = $request->getAttribute('name');
    $response->getBody()->write("Hello, $name");

    return $response;
});
$app->run();
</code>```

Please help me here.

答:
In case someone still face this problem, this is how I solved it:

Enable model rewrite. In your terminal type:

sudo a2enmod rewrite && sudo service apache2 restart

http://help.slimframework.com/discussions/problems/10216-beginner-routes-not-working

Title: Routes not working on Slim framework

Body:
I am learning the slim framework. I got a point where I have to set up my webserver such that I can see something like http://slimapp instead of http://localhost/slimapp/public/index.php.

I have included a .htaccess file in the public folder of my project like so

RewriteEngine on
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule . index.php [L]

I have also set up a virtual host on my wamp server

<VirtualHost *:80>
    DocumentRoot "C:\wamp64\www\slimapp\public"
    ServerName slimapp

    <Directory "C:\wamp64\www\slimapp\public">
        AllowOverride All
        Order allow,deny
        Allow from all
    </Directory>
</VirtualHost>

I have also added this to my hosts file

127.0.0.1 slimapp

I restarted my server but I get a 'Not Found' error when I try to access my routes.

"Not Found
The requested URL /hello/uche was not found on this server."

This is my index.php file

<?php
use \Psr\Http\Message\ServerRequestInterface as Request;
use \Psr\Http\Message\ResponseInterface as Response;

require '../vendor/autoload.php';

$app = new \Slim\App;
$app->get('/hello/{name}', function (Request $request, Response $response) {
    $name = $request->getAttribute('name');
    $response->getBody()->write("Hello, $name");

    return $response;
});
$app->run();

Please help me here.


问:
How to convert array of string to simple string in JavaScript?
I have the following JavaScript array of strings:

```<code>arrayOfString = ['a', 'b,c', 'd,e', 'f'];
</code>```

And I would like to convert this array to an array similar to this:

```<code>myString = ["a", "b", "c", "d", "e", "f"];
</code>```

How I can accomplish that?

答:
You can use flatMap() and split()

let arrayOfString = ['a', 'b,c', 'd,e','f'];
let res = arrayOfString.flatMap(x => x.split(','))
console.log(res)```
</div>
</div>
</p>

<p>If <code>flatMap()</code> is not supported by your browser then use <code>map()</code> <code>concat()</code> and spread operator. Pass the result of <code>map()</code> to <code>concat()</code> using spread operator.</p>

<p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
<div class="snippet-code">
<pre class="snippet-code-js lang-js prettyprint-override"><code>let arrayOfString = ['a', 'b,c', 'd,e','f'];
let res = [].concat(...arrayOfString.map(x => x.split(',')))
console.log(res)</code>```

Body:
I have the following JavaScript array of strings:

arrayOfString = ['a', 'b,c', 'd,e', 'f'];

And I would like to convert this array to an array similar to this:

myString = ["a", "b", "c", "d", "e", "f"];

How I can accomplish that?

Body:
You can use flatMap() and split()

let arrayOfString = ['a', 'b,c', 'd,e','f'];
let res = arrayOfString.flatMap(x => x.split(','))
console.log(res)

If flatMap() is not supported by your browser then use map() concat() and spread operator. Pass the result of map() to concat() using spread operator.

let arrayOfString = ['a', 'b,c', 'd,e','f'];
let res = [].concat(...arrayOfString.map(x => x.split(',')))
console.log(res)


问:
How to check if environment variable contains specific string (in a BATCH file)
I have tried this but it doesn't work because variable (PATH environment variable)contains spaces: Check if variable contains a piece of text in BATCH</p>

答:
The path variable can contain quotes and special characters like "C:\Docs & other stuff".

Therefore, it's a good idea to use delayed instead of percent expansion.

```<code>setlocal EnableDelayedExpansion
if "!path:%myVar%=!" NEQ "!path!" echo path contains !myVar!
</code>```

Body:
The path variable can contain quotes and special characters like "C:\Docs & other stuff".

Therefore, it's a good idea to use delayed instead of percent expansion.

setlocal EnableDelayedExpansion
if "!path:%myVar%=!" NEQ "!path!" echo path contains !myVar!


问:
Compiler error - msgfmt command not found
I'm trying to update Git from my shared hosting. For that I'm following these steps:

Download latest Git version

Unpack and place it on the server

Configure and create the Makefile -> ./configure --prefix=$HOME/dev/git/src --without-tcltk

Build the package -> make then make install

Update PATH .bash_profile

I'm stuck at point 4. When I run the make command, I get the following:

```<code>user@ssh1:~/dev/git/src$ make
SUBDIR gitweb
SUBDIR ../
make[2]: ? GIT-VERSION-FILE ? est ? jour.
GEN git-instaweb
SUBDIR perl
SUBDIR git_remote_helpers
SUBDIR templates
MSGFMT po/build/locale/is/LC_MESSAGES/git.mo
/bin/sh: msgfmt: command not found
make: *** [po/build/locale/is/LC_MESSAGES/git.mo] Erreur 127
</code>```

Compiler throws a msgfmt command not found error.

I Googled it and it seems to be related to the gettext package.

Any idea how to fix that error on a shared hosting?

答:
You can install gettext in the same way you are installing git. By downloading, extracting, building and installing it to a given location in your home folder:

```<code>curl -O https://ftp.gnu.org/pub/gnu/gettext/gettext-0.20.1.tar.gz
tar xvf gettext-0.20.1.tar.gz
cd gettext-0.20.1/
./configure --prefix=/home/$HOME/opt
make
make install
</code>```

Set the prefix to the location you want for the installation.

Body:
I'm trying to update Git from my shared hosting. For that I'm following these steps:

Download latest Git version

Unpack and place it on the server

Configure and create the Makefile -> ./configure --prefix=$HOME/dev/git/src --without-tcltk

Build the package -> make then make install

Update PATH .bash_profile

I'm stuck at point 4. When I run the make command, I get the following:

user@ssh1:~/dev/git/src$ make
SUBDIR gitweb
SUBDIR ../
make[2]: ? GIT-VERSION-FILE ? est ? jour.
GEN git-instaweb
SUBDIR perl
SUBDIR git_remote_helpers
SUBDIR templates
MSGFMT po/build/locale/is/LC_MESSAGES/git.mo
/bin/sh: msgfmt: command not found
make: *** [po/build/locale/is/LC_MESSAGES/git.mo] Erreur 127

Compiler throws a msgfmt command not found error.

I Googled it and it seems to be related to the gettext package.

Any idea how to fix that error on a shared hosting?

Body:
You can install gettext in the same way you are installing git. By downloading, extracting, building and installing it to a given location in your home folder:

curl -O https://ftp.gnu.org/pub/gnu/gettext/gettext-0.20.1.tar.gz
tar xvf gettext-0.20.1.tar.gz
cd gettext-0.20.1/
./configure --prefix=/home/$HOME/opt
make
make install

Set the prefix to the location you want for the installation.


问:
jQuery news rotator not breaking without JavaScript
I'm trying to build a simple news rotator in jQuery and I'm looking at examples on the internet.

I'm trying to achieve something like this http://www.webstylepress.com/jquery-smooth-news-rotator/ but I want it to NOT break when JavaScript is disabled, just show the first element. I know that this is a very frequently asked question, but all of the examples I have seen break somehow when JavaScript is disabled.

答: I suggest that you simply hide all elements except the first one by default (using CSS). You can adjust the styles later if JavaScript is enabled and start the slider afterwards.</p>


问:
Hide notification bell in status bar
How can i hide the notification bell icon in the status bar at the bottom right in visual studio code.

I tried searching in the settings but cant find anything for this.

答:
I wanted to hide it only when there weren't notifications. In my case, I used the custom css and JS loaded plugin that @Alex mentioned, but with this css:

[title="No Notifications"] {
    display: none !important;
}
```

Title: Hide notification bell in status bar


问:
How to use Expanded in SingleChildScrollView?
How to use Expanded in SingleChildScrollView? I have a screen with Image.network, ListView.builder and Row (TextFormField and IconButton). I wrapped ListView with Expanded. How to wrap this column with SingleChildScrollView? I need to move screen when the keyboard is open to see what I am writing. When I wrap my column I have this error.

      body: SingleChildScrollView(
        child: Column(
          children: <Widget>[
            Container(
              child: GestureDetector(
                child:
                Image.network(
                  postOne.imageUrl,
                  fit: BoxFit.fitWidth,
                  height: MediaQuery
                      .of(context)
                      .size
                      .width,
                  width: MediaQuery
                      .of(context)
                      .size
                      .width,
                ),
                onLongPress: () {},
                onDoubleTap: () {},
              ),
            ),
            Expanded(
              //height: MediaQuery.of(context).size.width*0.33,
              child: ListView.builder(
                  itemCount: commentList.length,
                  itemBuilder: (context, position) {
                    return GestureDetector(
                        onLongPress: () {},
                        child: Card(
                          child: Padding(
                            padding: EdgeInsets.all(5.0),
                            child: new CheckboxListTile(
                                title: new Text(commentList
                                    .elementAt(position)
                                    .coment,
                                  style: TextStyle(fontSize: 18.0),),
                                value: values[commentList
                                    .elementAt(position)
                                    .coment],
                                onChanged: (bool value) {}),
                          ),
                        )
                    );
                  }
              ),
            ),
            Container(
              child: Row(
                  crossAxisAlignment: CrossAxisAlignment.start,
                  children: [
                    new Flexible(
                      child: Theme(
                        data: new ThemeData(
                            brightness: Brightness.light,
                            primarySwatch: Colors.grey,
                            inputDecorationTheme: new InputDecorationTheme(
                              labelStyle: new TextStyle(
                                  color: Colors.black45, fontSize: 18.0
                              ),
                            )
                        ),
                        child: new Form(
                          key: _formKey,
                          child: new TextFormField(
                            validator: (value) {
                              if (value.isEmpty) {
                                return 'Please enter the comment';
                              }
                            },
                            controller: commentController,
                            decoration: new InputDecoration(
                              labelText: "Add comment",
                              //hintText: 'Add comment'
                            ),
                            keyboardType: TextInputType.text,
                          ),
                        ),
                      ),
                    ),
                    new Container(
                        margin: EdgeInsets.only(left: 10.0, top: 12.0),
                        child: new IconButton(
                            icon: new Icon(Icons.send, color: Colors.black,),
                            onPressed: () {}
                        )
                    ),
                  ]),
            ),
          ],
        ),
      ),
```
```I/flutter ( 6816): ══╡ EXCEPTION CAUGHT BY RENDERING LIBRARY ╞═════════════════════════════════════════════════════════
I/flutter ( 6816): The following assertion was thrown during performLayout():
I/flutter ( 6816): RenderFlex children have non-zero flex but incoming height constraints are unbounded.
I/flutter ( 6816): When a column is in a parent that does not provide a finite height constraint, for example if it is
I/flutter ( 6816): in a vertical scrollable, it will try to shrink-wrap its children along the vertical axis. Setting a
I/flutter ( 6816): flex on a child (e.g. using Expanded) indicates that the child is to expand to fill the remaining
I/flutter ( 6816): space in the vertical direction.
I/flutter ( 6816): These two directives are mutually exclusive. If a parent is to shrink-wrap its child, the child
I/flutter ( 6816): cannot simultaneously expand to fit its parent.
I/flutter ( 6816): Consider setting mainAxisSize to MainAxisSize.min and using FlexFit.loose fits for the flexible
I/flutter ( 6816): children (using Flexible rather than Expanded). This will allow the flexible children to size
I/flutter ( 6816): themselves to less than the infinite remaining space they would otherwise be forced to take, and
I/flutter ( 6816): then will cause the RenderFlex to shrink-wrap the children rather than expanding to fit the maximum
I/flutter ( 6816): constraints provided by the parent.
I/flutter ( 6816): The affected RenderFlex is:
I/flutter ( 6816):   RenderFlex#9f534 relayoutBoundary=up11 NEEDS-LAYOUT NEEDS-PAINT
I/flutter ( 6816): The creator information is set to:
I/flutter ( 6816):   Column ← _SingleChildViewport ← IgnorePointer-[GlobalKey#3670d] ← Semantics ← Listener ←
I/flutter ( 6816):   _GestureSemantics ← RawGestureDetector-[LabeledGlobalKey<RawGestureDetectorState>#4878e] ←
I/flutter ( 6816):   Listener ← _ScrollableScope ← _ScrollSemantics-[GlobalKey#c5885] ← RepaintBoundary ← CustomPaint ←
I/flutter ( 6816):   ⋯
I/flutter ( 6816): The nearest ancestor providing an unbounded width constraint is:
I/flutter ( 6816):   _RenderSingleChildViewport#155d8 relayoutBoundary=up10 NEEDS-LAYOUT NEEDS-PAINT
I/flutter ( 6816):   creator: _SingleChildViewport ← IgnorePointer-[GlobalKey#3670d] ← Semantics ← Listener ←
I/flutter ( 6816):   _GestureSemantics ← RawGestureDetector-[LabeledGlobalKey<RawGestureDetectorState>#4878e] ←
I/flutter ( 6816):   Listener ← _ScrollableScope ← _ScrollSemantics-[GlobalKey#c5885] ← RepaintBoundary ← CustomPaint ←
I/flutter ( 6816):   RepaintBoundary ← ⋯
I/flutter ( 6816):   parentData: <none> (can use size)
I/flutter ( 6816):   constraints: BoxConstraints(0.0<=w<=440.8, 0.0<=h<=649.3)
I/flutter ( 6816):   size: MISSING
I/flutter ( 6816): See also: https://flutter.dev/layout/
I/flutter ( 6816): If this message did not help you determine the problem, consider using debugDumpRenderTree():
I/flutter ( 6816):   https://flutter.dev/debugging/#rendering-layer
I/flutter ( 6816):   http://docs.flutter.io/flutter/rendering/debugDumpRenderTree.html
I/flutter ( 6816): If none of the above helps enough to fix this problem, please don't hesitate to file a bug:
I/flutter ( 6816):   https://github.com/flutter/flutter/issues/new?template=BUG.md
I/flutter ( 6816):

```

答:
Try this,

```<code>LayoutBuilder(
  builder: (context, constraint) {
    return SingleChildScrollView(
      child: ConstrainedBox(
        constraints: BoxConstraints(minHeight: constraint.maxHeight),
        child: IntrinsicHeight(
          child: Column(
            children: <Widget>[
              Text("Header"),
              Expanded(
                child: Container(
                  color: Colors.red,
                ),
              ),
              Text("Footer"),
            ],
          ),
        ),
      ),
    );
  },
)
</code>```

I got this solution from git issues when I get into the same situation. I don't have the git link. I think it may help you.

Reusable widget:

Note: use it, only if one of the children is Expanded

```<code>import 'package:flutter/material.dart';

class ScrollColumnExpandable extends StatelessWidget {
  final List<Widget> children;
  final CrossAxisAlignment crossAxisAlignment;
  final MainAxisAlignment mainAxisAlignment;
  final VerticalDirection verticalDirection;
  final TextDirection textDirection;
  final TextBaseline textBaseline;
  final EdgeInsetsGeometry padding;

  const ScrollColumnExpandable({
    Key key,
    this.children,
    CrossAxisAlignment crossAxisAlignment,
    MainAxisAlignment mainAxisAlignment,
    VerticalDirection verticalDirection,
    EdgeInsetsGeometry padding,
    this.textDirection,
    this.textBaseline,
  })  : crossAxisAlignment = crossAxisAlignment ?? CrossAxisAlignment.center,
        mainAxisAlignment = mainAxisAlignment ?? MainAxisAlignment.start,
        verticalDirection = verticalDirection ?? VerticalDirection.down,
        padding = padding ?? EdgeInsets.zero,
        super(key: key);

  @override
  Widget build(BuildContext context) {
    final children = <Widget>[const SizedBox(width: double.infinity)];

    if (this.children != null) children.addAll(this.children);
    return LayoutBuilder(
      builder: (context, constraint) {
        return SingleChildScrollView(
          child: Padding(
            padding: padding,
            child: ConstrainedBox(
              constraints: BoxConstraints(
                minHeight: constraint.maxHeight - padding.vertical,
              ),
              child: IntrinsicHeight(
                child: Column(
                  crossAxisAlignment: crossAxisAlignment,
                  mainAxisAlignment: mainAxisAlignment,
                  mainAxisSize: MainAxisSize.max,
                  verticalDirection: verticalDirection,
                  children: children,
                  textBaseline: textBaseline,
                  textDirection: textDirection,
                ),
              ),
            ),
          ),
        );
      },
    );
  }
}
</code>```

Body:
How to use Expanded in SingleChildScrollView? I have a screen with Image.network, ListView.builder and Row (TextFormField and IconButton). I wrapped ListView with Expanded. How to wrap this column with SingleChildScrollView? I need to move screen when the keyboard is open to see what I am writing. When I wrap my column I have this error.

      body: SingleChildScrollView(
        child: Column(
          children: <Widget>[
            Container(
              child: GestureDetector(
                child:
                Image.network(
                  postOne.imageUrl,
                  fit: BoxFit.fitWidth,
                  height: MediaQuery
                      .of(context)
                      .size
                      .width,
                  width: MediaQuery
                      .of(context)
                      .size
                      .width,
                ),
                onLongPress: () {},
                onDoubleTap: () {},
              ),
            ),
            Expanded(
              //height: MediaQuery.of(context).size.width*0.33,
              child: ListView.builder(
                  itemCount: commentList.length,
                  itemBuilder: (context, position) {
                    return GestureDetector(
                        onLongPress: () {},
                        child: Card(
                          child: Padding(
                            padding: EdgeInsets.all(5.0),
                            child: new CheckboxListTile(
                                title: new Text(commentList
                                    .elementAt(position)
                                    .coment,
                                  style: TextStyle(fontSize: 18.0),),
                                value: values[commentList
                                    .elementAt(position)
                                    .coment],
                                onChanged: (bool value) {}),
                          ),
                        )
                    );
                  }
              ),
            ),
            Container(
              child: Row(
                  crossAxisAlignment: CrossAxisAlignment.start,
                  children: [
                    new Flexible(
                      child: Theme(
                        data: new ThemeData(
                            brightness: Brightness.light,
                            primarySwatch: Colors.grey,
                            inputDecorationTheme: new InputDecorationTheme(
                              labelStyle: new TextStyle(
                                  color: Colors.black45, fontSize: 18.0
                              ),
                            )
                        ),
                        child: new Form(
                          key: _formKey,
                          child: new TextFormField(
                            validator: (value) {
                              if (value.isEmpty) {
                                return 'Please enter the comment';
                              }
                            },
                            controller: commentController,
                            decoration: new InputDecoration(
                              labelText: "Add comment",
                              //hintText: 'Add comment'
                            ),
                            keyboardType: TextInputType.text,
                          ),
                        ),
                      ),
                    ),
                    new Container(
                        margin: EdgeInsets.only(left: 10.0, top: 12.0),
                        child: new IconButton(
                            icon: new Icon(Icons.send, color: Colors.black,),
                            onPressed: () {}
                        )
                    ),
                  ]),
            ),
          ],
        ),
      ),

I/flutter ( 6816): ══╡ EXCEPTION CAUGHT BY RENDERING LIBRARY ╞═════════════════════════════════════════════════════════
I/flutter ( 6816): The following assertion was thrown during performLayout():
I/flutter ( 6816): RenderFlex children have non-zero flex but incoming height constraints are unbounded.
I/flutter ( 6816): When a column is in a parent that does not provide a finite height constraint, for example if it is
I/flutter ( 6816): in a vertical scrollable, it will try to shrink-wrap its children along the vertical axis. Setting a
I/flutter ( 6816): flex on a child (e.g. using Expanded) indicates that the child is to expand to fill the remaining
I/flutter ( 6816): space in the vertical direction.
I/flutter ( 6816): These two directives are mutually exclusive. If a parent is to shrink-wrap its child, the child
I/flutter ( 6816): cannot simultaneously expand to fit its parent.
I/flutter ( 6816): Consider setting mainAxisSize to MainAxisSize.min and using FlexFit.loose fits for the flexible
I/flutter ( 6816): children (using Flexible rather than Expanded). This will allow the flexible children to size
I/flutter ( 6816): themselves to less than the infinite remaining space they would otherwise be forced to take, and
I/flutter ( 6816): then will cause the RenderFlex to shrink-wrap the children rather than expanding to fit the maximum
I/flutter ( 6816): constraints provided by the parent.
I/flutter ( 6816): The affected RenderFlex is:
I/flutter ( 6816):   RenderFlex#9f534 relayoutBoundary=up11 NEEDS-LAYOUT NEEDS-PAINT
I/flutter ( 6816): The creator information is set to:
I/flutter ( 6816):   Column ← _SingleChildViewport ← IgnorePointer-[GlobalKey#3670d] ← Semantics ← Listener ←
I/flutter ( 6816):   _GestureSemantics ← RawGestureDetector-[LabeledGlobalKey<RawGestureDetectorState>#4878e] ←
I/flutter ( 6816):   Listener ← _ScrollableScope ← _ScrollSemantics-[GlobalKey#c5885] ← RepaintBoundary ← CustomPaint ←
I/flutter ( 6816):   ⋯
I/flutter ( 6816): The nearest ancestor providing an unbounded width constraint is:
I/flutter ( 6816):   _RenderSingleChildViewport#155d8 relayoutBoundary=up10 NEEDS-LAYOUT NEEDS-PAINT
I/flutter ( 6816):   creator: _SingleChildViewport ← IgnorePointer-[GlobalKey#3670d] ← Semantics ← Listener ←
I/flutter ( 6816):   _GestureSemantics ← RawGestureDetector-[LabeledGlobalKey<RawGestureDetectorState>#4878e] ←
I/flutter ( 6816):   Listener ← _ScrollableScope ← _ScrollSemantics-[GlobalKey#c5885] ← RepaintBoundary ← CustomPaint ←
I/flutter ( 6816):   RepaintBoundary ← ⋯
I/flutter ( 6816):   parentData: <none> (can use size)
I/flutter ( 6816):   constraints: BoxConstraints(0.0<=w<=440.8, 0.0<=h<=649.3)
I/flutter ( 6816):   size: MISSING
I/flutter ( 6816): See also: https://flutter.dev/layout/
I/flutter ( 6816): If this message did not help you determine the problem, consider using debugDumpRenderTree():
I/flutter ( 6816):   https://flutter.dev/debugging/#rendering-layer
I/flutter ( 6816):   http://docs.flutter.io/flutter/rendering/debugDumpRenderTree.html
I/flutter ( 6816): If none of the above helps enough to fix this problem, please don't hesitate to file a bug:
I/flutter ( 6816):   https://github.com/flutter/flutter/issues/new?template=BUG.md
I/flutter ( 6816):

Body:
Try this,

LayoutBuilder(
  builder: (context, constraint) {
    return SingleChildScrollView(
      child: ConstrainedBox(
        constraints: BoxConstraints(minHeight: constraint.maxHeight),
        child: IntrinsicHeight(
          child: Column(
            children: <Widget>[
              Text("Header"),
              Expanded(
                child: Container(
                  color: Colors.red,
                ),
              ),
              Text("Footer"),
            ],
          ),
        ),
      ),
    );
  },
)

I got this solution from git issues when I get into the same situation. I don't have the git link. I think it may help you.

Reusable widget:

Note: use it, only if one of the children is Expanded

import 'package:flutter/material.dart';

class ScrollColumnExpandable extends StatelessWidget {
  final List<Widget> children;
  final CrossAxisAlignment crossAxisAlignment;
  final MainAxisAlignment mainAxisAlignment;
  final VerticalDirection verticalDirection;
  final TextDirection textDirection;
  final TextBaseline textBaseline;
  final EdgeInsetsGeometry padding;

  const ScrollColumnExpandable({
    Key key,
    this.children,
    CrossAxisAlignment crossAxisAlignment,
    MainAxisAlignment mainAxisAlignment,
    VerticalDirection verticalDirection,
    EdgeInsetsGeometry padding,
    this.textDirection,
    this.textBaseline,
  })  : crossAxisAlignment = crossAxisAlignment ?? CrossAxisAlignment.center,
        mainAxisAlignment = mainAxisAlignment ?? MainAxisAlignment.start,
        verticalDirection = verticalDirection ?? VerticalDirection.down,
        padding = padding ?? EdgeInsets.zero,
        super(key: key);

  @override
  Widget build(BuildContext context) {
    final children = <Widget>[const SizedBox(width: double.infinity)];

    if (this.children != null) children.addAll(this.children);
    return LayoutBuilder(
      builder: (context, constraint) {
        return SingleChildScrollView(
          child: Padding(
            padding: padding,
            child: ConstrainedBox(
              constraints: BoxConstraints(
                minHeight: constraint.maxHeight - padding.vertical,
              ),
              child: IntrinsicHeight(
                child: Column(
                  crossAxisAlignment: crossAxisAlignment,
                  mainAxisAlignment: mainAxisAlignment,
                  mainAxisSize: MainAxisSize.max,
                  verticalDirection: verticalDirection,
                  children: children,
                  textBaseline: textBaseline,
                  textDirection: textDirection,
                ),
              ),
            ),
          ),
        );
      },
    );
  }
}


问:
How to search for the number of times that keywords will appear in several text between two tables
I have 2 tables and the they have the following columns.

```<code>articles: id (PK), article (longtext), date (date)

keywords: id (PK), keyword (varchar)
</code>```

For the moment I can only do that, search for a hard keyword and display the text where the word appears the most times :

```<code>SELECT * , MATCH (article) AGAINST ("keyword*" IN BOOLEAN MODE) AS relevance
FROM `articles`
WHERE MATCH (article) AGAINST ("keyword*" IN BOOLEAN MODE) ORDER BY relevance DESC LIMIT 10
</code>```

How can I search for the number of times each keyword (Table : keywords) appears in each text (Table : articles) ?

I have try that (I do not know if it's possible?) but I get "Invalid argument at AGAINST":

```<code>SELECT keyword
FROM keywords
CROSS JOIN articles
WHERE MATCH (keywords.keyword)
        AGAINST (articles.article IN NATURAL LANGUAGE MODE)
</code>```

EDIT FOR Gordon Linoff :

```<code>Table : Keywords

Id     Keyword

1      first
2      second
3      text
4      keyword
</code>```

-

```<code>Table : Articles

Id     Article

1      the first text
2      the second text
3      text text text
</code>```

Desired results :

```<code>Keyword     score

text        5
first       1
second      1
keyword     0
</code>```

答:
```<code>select kw.motcle, count(d.articles)
from test_motcle kw left join
     articles d
     on concat(' ', d.articles, ' ') like concat('% ', kw.motcle, ' %')
group by kw.motcle
ORDER BY count(d.articles) DESC
LIMIT 10
</code>```

<p>:)</p>

Body:
I have 2 tables and the they have the following columns.

articles: id (PK), article (longtext), date (date)

keywords: id (PK), keyword (varchar)

For the moment I can only do that, search for a hard keyword and display the text where the word appears the most times :

SELECT * , MATCH (article) AGAINST ("keyword*" IN BOOLEAN MODE) AS relevance
FROM `articles`
WHERE MATCH (article) AGAINST ("keyword*" IN BOOLEAN MODE) ORDER BY relevance DESC LIMIT 10

How can I search for the number of times each keyword (Table : keywords) appears in each text (Table : articles) ?

I have try that (I do not know if it's possible?) but I get "Invalid argument at AGAINST":

SELECT keyword
FROM keywords
CROSS JOIN articles
WHERE MATCH (keywords.keyword)
        AGAINST (articles.article IN NATURAL LANGUAGE MODE)

EDIT FOR Gordon Linoff :

Table : Keywords

Id     Keyword

1      first
2      second
3      text
4      keyword

-

Table : Articles

Id     Article

1      the first text
2      the second text
3      text text text

Desired results :

Keyword     score

text        5
first       1
second      1
keyword     0

Body:
select kw.motcle, count(d.articles)
from test_motcle kw left join
     articles d
     on concat(' ', d.articles, ' ') like concat('% ', kw.motcle, ' %')
group by kw.motcle
ORDER BY count(d.articles) DESC
LIMIT 10

:)


问:
padding a fieldset, trouble with IE
What is going on with rendering the padding of a fieldset. It behaves as expected in FF and Chrome but fails in IE. This is the code im talking about:

```<code><html>
    <head>
    </head>
    <body>
        <fieldset>
            <legend>Hello world!</legend>
            <div>Lorem ipsum</div>
        </fieldset>
    </body>
</html>
</code>```

And this is the css

```<code>fieldset {
    border: 1px solid black;
    padding: 30px;
    }
    fieldset legend {
        background-color: silver;
    }
    fieldset div {
        border: 1px dotted silver;
    }
</code>```

Can also be seen here:
http://jsfiddle.net/nRAGM/6/

So my question is: how to get the above html to display as intended in IE?

答:
The following code is cross-browser compatible.

You can control the indent of the fieldset legend independently. In padding the fieldset you also indent the legend. While this may be the desired effect in some cases, the following method offers more flexibility. Also adding the margin to the inner div will give you better control of your layout (because adding padding to a container can add unwanted width).

http://jsfiddle.net/nRAGM/35/

```<code>fieldset {
  border: 2px solid silver;
}

fieldset legend {
    border: 2px solid silver;
    margin-left: 30px;
}

fieldset div {
    border: 1px dotted silver;
    margin: 30px;
}
</code>```

Title: padding a fieldset, trouble with IE

Body:
What is going on with rendering the padding of a fieldset. It behaves as expected in FF and Chrome but fails in IE. This is the code im talking about:

        <fieldset>
            <legend>Hello world!</legend>

Lorem ipsum

        </fieldset>

And this is the css

fieldset {
    border: 1px solid black;
    padding: 30px;
    }
    fieldset legend {
        background-color: silver;
    }
    fieldset div {
        border: 1px dotted silver;
    }

Can also be seen here:
http://jsfiddle.net/nRAGM/6/

So my question is: how to get the above html to display as intended in IE?

Body:
The following code is cross-browser compatible.

You can control the indent of the fieldset legend independently. In padding the fieldset you also indent the legend. While this may be the desired effect in some cases, the following method offers more flexibility. Also adding the margin to the inner div will give you better control of your layout (because adding padding to a container can add unwanted width).

http://jsfiddle.net/nRAGM/35/

fieldset {
  border: 2px solid silver;
}

fieldset legend {
    border: 2px solid silver;
    margin-left: 30px;
}

fieldset div {
    border: 1px dotted silver;
    margin: 30px;
}


问:
Rails multiple select on array attribute not working
The following isn't displaying a multiple select in Firefox:

<%= f.select :days, days_of_week_for_select, { selected: '0' }, multple: 'true' %>

The html produced is:

```<code><div class="col-12 col-md-10">
<select multple="true" rows="5" name="series[days]" id="series_days">
<option value="0">Sunday</option>
<option value="1">Monday</option>
<option value="2">Tuesday</option>
<option value="3">Wednesday</option>
<option value="4">Thursday</option>
<option value="5">Friday</option>
<option value="6">Saturday</option>
</select>
</div>
</code>```

And the helper:

```<code>  def days_of_week_for_select
    array = Date::DAYNAMES.each_with_index.map { |day, ind| [day, ind] }
    options_for_select array
  end
</code>```

The select list is a normal, single select, not multiple.

答: It should be multiple: true instead of multple: true. You are missing a character in that option :)

Body:
The following isn't displaying a multiple select in Firefox:

<%= f.select :days, days_of_week_for_select, { selected: '0' }, multple: 'true' %>

The html produced is:

<select multple="true" rows="5" name="series[days]" id="series_days">
<option value="0">Sunday</option>
<option value="1">Monday</option>
<option value="2">Tuesday</option>
<option value="3">Wednesday</option>
<option value="4">Thursday</option>
<option value="5">Friday</option>
<option value="6">Saturday</option>
</select>

And the helper:

  def days_of_week_for_select
    array = Date::DAYNAMES.each_with_index.map { |day, ind| [day, ind] }
    options_for_select array
  end

The select list is a normal, single select, not multiple.


问:
Vue equivalent of setTimeout?
I'm making a shopping cart system with Laravel and Vue. When I add an item to the basket, I display a confirmation message by toggling a Vue variable being watched by a v-if:

```<code><div class="alert alert-success" v-if="basketAddSuccess" transition="expand">Added to the basket</div>
</code>```

And the JS:

```<code>addToBasket: function(){
                item = this.product;
                this.$http.post('/api/buy/addToBasket', item);
                this.basketAddSuccess = true;
            }
</code>```

(And yes, I will be adding this in a then-catch shortly).

This works fine and the message appears. However, I'd like the message to disappear again after a certain time, say a few seconds. How can I do this with Vue? I've tried setTimeOut but Vue doesn't seem to like it, saying it's undefined.

EDIT: I was misspelling setTimeout like an idiot. However, it still doesn't work:

My function is now:

```<code>addToBasket: function(){
                item = this.photo;
                this.$http.post('/api/buy/addToBasket', item);
                this.basketAddSuccess = true;
                setTimeout(function(){
                    this.basketAddSuccess = false;
                }, 2000);
            }
</code>```

答:
There's no need for bind(this) when you are using arrow functions:

```<code>  setTimeout( ()=> {
    // some code
   }, 500)
</code>```

Title: Vue equivalent of setTimeout?

Body:
I'm making a shopping cart system with Laravel and Vue. When I add an item to the basket, I display a confirmation message by toggling a Vue variable being watched by a v-if:

Added to the basket

And the JS:

addToBasket: function(){
                item = this.product;
                this.$http.post('/api/buy/addToBasket', item);
                this.basketAddSuccess = true;
            }

(And yes, I will be adding this in a then-catch shortly).

This works fine and the message appears. However, I'd like the message to disappear again after a certain time, say a few seconds. How can I do this with Vue? I've tried setTimeOut but Vue doesn't seem to like it, saying it's undefined.

EDIT: I was misspelling setTimeout like an idiot. However, it still doesn't work:

My function is now:

addToBasket: function(){
                item = this.photo;
                this.$http.post('/api/buy/addToBasket', item);
                this.basketAddSuccess = true;
                setTimeout(function(){
                    this.basketAddSuccess = false;
                }, 2000);
            }

Body:
There's no need for bind(this) when you are using arrow functions:

  setTimeout( ()=> {
    // some code
   }, 500)


问:
Get specific fields from Kendo locales js files
Kendo Internationalization library provide a huge amount of JS files with the specific information of each country culture. I'm using its IntlService and TranslateService to handle the language in the system, but now I need to get specific information from these files, like the currency and decimal separator for the current language and available languages.

These files are located in @progress/kendo-angular-intl/locales and the json is encapsulated inside a function called setData(). I don't want to copy the information of them (easy path), but reuse them in order to automatize the addition of a new language for example. At last, I searched if kendo already implements a service that provides the option to get specific fields of these files, but there is not.

So, my question is: How can I get information from these files? Does it exist a service for that purpose or I have to implement it by myself?

I show an example of one of the files:

```<code>import { setData } from '@progress/kendo-angular-intl';
setData({
    name: "es-CL",
    identity: {
        language: "es",
        territory: "CL"
    },
    territory: "CL",
    numbers: {
        symbols: {
            decimal: ",",
            group: ".",
            list: ";",
            percentSign: "%",
            plusSign: "+",
            minusSign: "-",
            exponential: "E",
            superscriptingExponent: "×",
            perMille: "‰",
            infinity: "∞",
            nan: "NaN",
            timeSeparator: ":"
        },
</code>```

答:
To get the number symbols you just need to import in your component

```<code>import { numberSymbols } from '@progress/kendo-angular-intl';
</code>```

and then access its values with the function numberSymbols using the local Id you need. Example: to get the decimal with es-CL:

```<code> numberSymbols('es-CL').decimal
</code>```

returns , as expected.

I guess the other values have equivalent functions to access them. You can check here if you need it.

Body:
Kendo Internationalization library provide a huge amount of JS files with the specific information of each country culture. I'm using its IntlService and TranslateService to handle the language in the system, but now I need to get specific information from these files, like the currency and decimal separator for the current language and available languages.

These files are located in @progress/kendo-angular-intl/locales and the json is encapsulated inside a function called setData(). I don't want to copy the information of them (easy path), but reuse them in order to automatize the addition of a new language for example. At last, I searched if kendo already implements a service that provides the option to get specific fields of these files, but there is not.

So, my question is: How can I get information from these files? Does it exist a service for that purpose or I have to implement it by myself?

I show an example of one of the files:

import { setData } from '@progress/kendo-angular-intl';
setData({
    name: "es-CL",
    identity: {
        language: "es",
        territory: "CL"
    },
    territory: "CL",
    numbers: {
        symbols: {
            decimal: ",",
            group: ".",
            list: ";",
            percentSign: "%",
            plusSign: "+",
            minusSign: "-",
            exponential: "E",
            superscriptingExponent: "×",
            perMille: "‰",
            infinity: "∞",
            nan: "NaN",
            timeSeparator: ":"
        },

Body:
To get the number symbols you just need to import in your component

import { numberSymbols } from '@progress/kendo-angular-intl';

and then access its values with the function numberSymbols using the local Id you need. Example: to get the decimal with es-CL:

 numberSymbols('es-CL').decimal

returns , as expected.

I guess the other values have equivalent functions to access them. You can check here if you need it.


问:
what is the difference between Write, WriteChar and WriteChars Methods from DataOutputStream class in java?
what is the difference between Write, WriteChar and WriteChars Methods in java?

I am Writing to output and i am seeing three methods for it , Kindly which method to use in what condition?

答:
From documentation:

write( int b ) writes b value as byte

writeChar( int c ) writes c value as char

writeChars( String s ) writes s as list of chars


问:
Attaching an xml file to webservices
How can we attach an xml file to a webservice call.
I need to do in c#.
Any links appreciated.
i have googled and no c# results is coming.

by wse 3.0 onwards we can   attach xml file to webservice by using mtom
i have serached for links in c#.but not available. any links appreciated.

Thanks

supriya

答: Probably this may help you Codeproject XML document loading</p>

Title: Attaching an xml file to webservices


问:
Need to use double code and pass variable in sed command
Searching pattern and displaying with SED which have double code (") and variable need to pass.

Actual log is:

```<code><confirmation ID="123456-109" status>
</code>```

Want to Print 109

This is with actual sed command which worked :

```<code>sed -n 's%.*confirmation="123456-\(.*\)" status.*%\%p' /tmp/log
</code>```

output: 109

But when I tried use this in script where passing 123456 as variable it is not working.

```<code>req_data=`sed -n 's%.*confirmation="$variable-\(.*\)" status.*%\%p' /tmp/log`
</code>```

When I run in Script is is not giving me any output.

I am expecting output: 109

答:
Execute a command and assign its output to variable res as res="$(command)".

You need to used sed -E to make parenthesis work for grouping (or in normal mode, you have to escape each parenthesis). (note that -E option of sed is not part of the posix standard)

Also, as stated in the comments, variables are not expanded/interpolated inside single quotes. If you are in a single quoted block, terminate that before the variable and start a different block after the variable.

Following should addresses all the above and should solve your problem.

```<code>req_data="$(sed -En 's%.*confirmation ID=\\"'$variable'-(.+)\\" status.*%\1%p' /tmp/log)"
</code>```

Body:
Searching pattern and displaying with SED which have double code (") and variable need to pass.

Actual log is:

<confirmation ID="123456-109" status>

Want to Print 109

This is with actual sed command which worked :

sed -n 's%.*confirmation="123456-\(.*\)" status.*%\%p' /tmp/log

output: 109

But when I tried use this in script where passing 123456 as variable it is not working.

req_data=`sed -n 's%.*confirmation="$variable-\(.*\)" status.*%\%p' /tmp/log`

When I run in Script is is not giving me any output.

I am expecting output: 109

Body:
Execute a command and assign its output to variable res as res="$(command)".

You need to used sed -E to make parenthesis work for grouping (or in normal mode, you have to escape each parenthesis). (note that -E option of sed is not part of the posix standard)

Also, as stated in the comments, variables are not expanded/interpolated inside single quotes. If you are in a single quoted block, terminate that before the variable and start a different block after the variable.

Following should addresses all the above and should solve your problem.

req_data="$(sed -En 's%.*confirmation ID=\\"'$variable'-(.+)\\" status.*%\1%p' /tmp/log)"