I'm getting this error after I installed pandas and run the tests
======================================================================
ERROR: test_readonly_axis_zlib_to_sql (pandas.io.tests.test_packers.TestCompression)
----------------------------------------------------------------------
Traceback (most recent call last):
File "/home/matt/pandas-mattrijk/pandas/io/tests/test_packers.py", line 738, in test_readonly_axis_zlib_to_sql
df.to_sql('test', eng, if_exists='append')
File "/home/matt/pandas-mattrijk/pandas/core/generic.py", line 1200, in to_sql
chunksize=chunksize, dtype=dtype)
File "/home/matt/pandas-mattrijk/pandas/io/sql.py", line 460, in to_sql
pandas_sql = pandasSQL_builder(con, schema=schema, flavor=flavor)
File "/home/matt/pandas-mattrijk/pandas/io/sql.py", line 530, in pandasSQL_builder
return SQLDatabase(con, schema=schema, meta=meta)
File "/home/matt/pandas-mattrijk/pandas/io/sql.py", line 960, in __init__
meta = MetaData(self.connectable, schema=schema)
TypeError: __init__() got an unexpected keyword argument 'schema'
----------------------------------------------------------------------
Ran 11101 tests in 1117.090s
FAILED (SKIP=255, errors=1)
Output of pd.show_versions()
## INSTALLED VERSIONS
commit: 5033a4a799c77fdc7e868a9f332384eabcc332b8
python: 2.7.12.final.0
python-bits: 64
OS: Linux
OS-release: 4.4.0-38-generic
machine: x86_64
processor: x86_64
byteorder: little
LC_ALL: None
LANG: en_US.UTF-8
LOCALE: None.None
pandas: 0.19.0rc1+39.g5033a4a.dirty
nose: 1.3.7
pip: 8.1.2
setuptools: 27.2.0
Cython: 0.24.1
numpy: 1.11.1
scipy: 0.18.1
statsmodels: None
xarray: None
IPython: 5.1.0
sphinx: 1.4.6
patsy: 0.4.1
dateutil: 2.5.3
pytz: 2016.6.1
blosc: None
bottleneck: 1.1.0
tables: 3.2.3.1
numexpr: 2.6.1
matplotlib: 1.5.3
openpyxl: 2.0.3
xlrd: 1.0.0
xlwt: 1.1.2
xlsxwriter: 0.4.6
lxml: 3.6.4
bs4: 4.2.1
html5lib: 1.0b2
httplib2: None
apiclient: None
sqlalchemy: 0.7.1
pymysql: 0.6.2.None
psycopg2: None
jinja2: 2.8
boto: None
pandas_datareader: None
Comment From: chris-b1
That's a very old version of sqlalchemy
in the docs we recommend 0.8.1, but don't list a minimum version. So probably need to document / check a minimum version.
http://pandas.pydata.org/pandas-docs/stable/install.html#optional-dependencies
Comment From: jorisvandenbossche
We have 0.7.8 in of the ci requirement files, so as low as that one should be tested. But it seems you are using 0.7.1
Comment From: MattRijk
I did requirements_all.txt with anaconda and got 0.7.1 for some reason. I updated sqlalchemy to 0.8.1 and all tests pass
Comment From: gfyoung
@jorisvandenbossche , @chris-b1 : Looks like this issue can be closed based on the comment above.