ipython-sql icon indicating copy to clipboard operation
ipython-sql copied to clipboard

Test cases fail, missing sqlparse

Open ZelphirKaltstahl opened this issue 8 years ago • 0 comments

I forked the repository to fix a small issue (import of reduce in sql/run.py). However, when I run ./run_tests.sh, tests fail, which have nothing to do with my change:

./run_tests.sh 
EEE.....
======================================================================
ERROR: Failure: ModuleNotFoundError (No module named 'sqlparse')
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/home/xiaolong/apps/anaconda3/lib/python3.6/site-packages/nose/failure.py", line 39, in runTest
    raise self.exc_val.with_traceback(self.tb)
  File "/home/xiaolong/apps/anaconda3/lib/python3.6/site-packages/nose/loader.py", line 417, in loadTestsFromName
    addr.filename, addr.module)
  File "/home/xiaolong/apps/anaconda3/lib/python3.6/site-packages/nose/importer.py", line 47, in importFromPath
    return self.importFromDir(dir_path, fqname)
  File "/home/xiaolong/apps/anaconda3/lib/python3.6/site-packages/nose/importer.py", line 94, in importFromDir
    mod = load_module(part_fqname, fh, filename, desc)
  File "/home/xiaolong/apps/anaconda3/lib/python3.6/imp.py", line 244, in load_module
    return load_package(name, filename)
  File "/home/xiaolong/apps/anaconda3/lib/python3.6/imp.py", line 216, in load_package
    return _load(spec)
  File "<frozen importlib._bootstrap>", line 675, in _load
  File "<frozen importlib._bootstrap>", line 655, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 678, in exec_module
  File "<frozen importlib._bootstrap>", line 205, in _call_with_frames_removed
  File "/home/xiaolong/development/datax/forks/ipython-sql/src/sql/__init__.py", line 1, in <module>
    from .magic import *
  File "/home/xiaolong/development/datax/forks/ipython-sql/src/sql/magic.py", line 20, in <module>
    import sql.run
  File "/home/xiaolong/development/datax/forks/ipython-sql/src/sql/run.py", line 8, in <module>
    import sqlparse
ModuleNotFoundError: No module named 'sqlparse'

======================================================================
ERROR: Failure: ModuleNotFoundError (No module named 'sqlparse')
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/home/xiaolong/apps/anaconda3/lib/python3.6/site-packages/nose/failure.py", line 39, in runTest
    raise self.exc_val.with_traceback(self.tb)
  File "/home/xiaolong/apps/anaconda3/lib/python3.6/site-packages/nose/loader.py", line 417, in loadTestsFromName
    addr.filename, addr.module)
  File "/home/xiaolong/apps/anaconda3/lib/python3.6/site-packages/nose/importer.py", line 47, in importFromPath
    return self.importFromDir(dir_path, fqname)
  File "/home/xiaolong/apps/anaconda3/lib/python3.6/site-packages/nose/importer.py", line 94, in importFromDir
    mod = load_module(part_fqname, fh, filename, desc)
  File "/home/xiaolong/apps/anaconda3/lib/python3.6/imp.py", line 234, in load_module
    return load_source(name, filename, file)
  File "/home/xiaolong/apps/anaconda3/lib/python3.6/imp.py", line 172, in load_source
    module = _load(spec)
  File "<frozen importlib._bootstrap>", line 675, in _load
  File "<frozen importlib._bootstrap>", line 655, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 678, in exec_module
  File "<frozen importlib._bootstrap>", line 205, in _call_with_frames_removed
  File "/home/xiaolong/development/datax/forks/ipython-sql/src/tests/test_column_guesser.py", line 4, in <module>
    from sql.magic import SqlMagic
  File "/home/xiaolong/development/datax/forks/ipython-sql/src/sql/__init__.py", line 1, in <module>
    from .magic import *
  File "/home/xiaolong/development/datax/forks/ipython-sql/src/sql/magic.py", line 20, in <module>
    import sql.run
  File "/home/xiaolong/development/datax/forks/ipython-sql/src/sql/run.py", line 8, in <module>
    import sqlparse
ModuleNotFoundError: No module named 'sqlparse'

======================================================================
ERROR: Failure: ModuleNotFoundError (No module named 'sqlparse')
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/home/xiaolong/apps/anaconda3/lib/python3.6/site-packages/nose/failure.py", line 39, in runTest
    raise self.exc_val.with_traceback(self.tb)
  File "/home/xiaolong/apps/anaconda3/lib/python3.6/site-packages/nose/loader.py", line 417, in loadTestsFromName
    addr.filename, addr.module)
  File "/home/xiaolong/apps/anaconda3/lib/python3.6/site-packages/nose/importer.py", line 47, in importFromPath
    return self.importFromDir(dir_path, fqname)
  File "/home/xiaolong/apps/anaconda3/lib/python3.6/site-packages/nose/importer.py", line 94, in importFromDir
    mod = load_module(part_fqname, fh, filename, desc)
  File "/home/xiaolong/apps/anaconda3/lib/python3.6/imp.py", line 234, in load_module
    return load_source(name, filename, file)
  File "/home/xiaolong/apps/anaconda3/lib/python3.6/imp.py", line 172, in load_source
    module = _load(spec)
  File "<frozen importlib._bootstrap>", line 675, in _load
  File "<frozen importlib._bootstrap>", line 655, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 678, in exec_module
  File "<frozen importlib._bootstrap>", line 205, in _call_with_frames_removed
  File "/home/xiaolong/development/datax/forks/ipython-sql/src/tests/test_magic.py", line 3, in <module>
    from sql.magic import SqlMagic
  File "/home/xiaolong/development/datax/forks/ipython-sql/src/sql/__init__.py", line 1, in <module>
    from .magic import *
  File "/home/xiaolong/development/datax/forks/ipython-sql/src/sql/magic.py", line 20, in <module>
    import sql.run
  File "/home/xiaolong/development/datax/forks/ipython-sql/src/sql/run.py", line 8, in <module>
    import sqlparse
ModuleNotFoundError: No module named 'sqlparse'

----------------------------------------------------------------------
Ran 8 tests in 0.363s

FAILED (errors=3)

I've set up an anaconda environment, where I installed sqlparse and others:

$ conda list
# packages in environment at /home/xiaolong/apps/anaconda3/envs/ipython-sql:
#
click                     6.7                       <pip>
ipython-genutils          0.2.0                     <pip>
openssl                   1.0.2l                        0  
pgspecial                 1.8.0                     <pip>
pip                       9.0.1                    py36_1  
prettytable               0.7.2                     <pip>
python                    3.6.2                         0  
readline                  6.2                           2  
setuptools                27.2.0                   py36_0  
six                       1.10.0                   py36_0  
sqlalchemy                1.1.11                   py36_0  
sqlite                    3.13.0                        0  
sqlparse                  0.1.19                   py36_0  
tk                        8.5.18                        0  
wheel                     0.29.0                   py36_0  
xz                        5.2.2                         1  
zlib                      1.2.8                         3  

Now I don't know how to proceed to be able to make a good pull request.

ZelphirKaltstahl avatar Aug 08 '17 12:08 ZelphirKaltstahl