Skip to content

test_integer_col_names: compatibility with wheezy sqlalchemy? #7330

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
yarikoptic opened this issue Jun 4, 2014 · 1 comment · Fixed by #7456
Closed

test_integer_col_names: compatibility with wheezy sqlalchemy? #7330

yarikoptic opened this issue Jun 4, 2014 · 1 comment · Fixed by #7456
Labels
IO SQL to_sql, read_sql, read_sql_query
Milestone

Comments

@yarikoptic
Copy link
Contributor

======================================================================
ERROR: test_integer_col_names (pandas.io.tests.test_sql.TestSQLApi)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/home/buildslave/nd-bb-slave-sparc-wheezy/pandas-py2_7-wheezy-sparc/build/venv/lib/python2.7/site-packages/pandas-0.14.0_45_g1754bb5-py2.7-linux-sparc64.egg/pandas/io/tests/test_sql.py", line 561, in test_integer_col_names
    if_exists='replace')
  File "/home/buildslave/nd-bb-slave-sparc-wheezy/pandas-py2_7-wheezy-sparc/build/venv/lib/python2.7/site-packages/pandas-0.14.0_45_g1754bb5-py2.7-linux-sparc64.egg/pandas/io/sql.py", line 440, in to_sql
    index_label=index_label)
  File "/home/buildslave/nd-bb-slave-sparc-wheezy/pandas-py2_7-wheezy-sparc/build/venv/lib/python2.7/site-packages/pandas-0.14.0_45_g1754bb5-py2.7-linux-sparc64.egg/pandas/io/sql.py", line 815, in to_sql
    table.insert()
  File "/home/buildslave/nd-bb-slave-sparc-wheezy/pandas-py2_7-wheezy-sparc/build/venv/lib/python2.7/site-packages/pandas-0.14.0_45_g1754bb5-py2.7-linux-sparc64.egg/pandas/io/sql.py", line 584, in insert
    self.pd_sql.execute(ins, data_list)
  File "/home/buildslave/nd-bb-slave-sparc-wheezy/pandas-py2_7-wheezy-sparc/build/venv/lib/python2.7/site-packages/pandas-0.14.0_45_g1754bb5-py2.7-linux-sparc64.egg/pandas/io/sql.py", line 783, in execute
    return self.engine.execute(*args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2447, in execute
    return connection.execute(statement, *multiparams, **params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute
    params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1576, in _execute_clauseelement
    inline=len(distilled_params) > 1)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/expression.py", line 1778, in compile
    return self._compiler(dialect, bind=bind, **kw)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/expression.py", line 1784, in _compiler
    return dialect.statement_compiler(dialect, self, **kw)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/compiler.py", line 277, in __init__
    engine.Compiled.__init__(self, dialect, statement, **kwargs)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 705, in __init__
    self.string = self.process(self.statement)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 724, in process
    return obj._compiler_dispatch(self, **kwargs)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 72, in _compiler_dispatch
    return getter(visitor)(self, **kw)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/compiler.py", line 1047, in visit_insert
    colparams = self._get_colparams(insert_stmt)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/compiler.py", line 1243, in _get_colparams
    for key in self.column_keys
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/compiler.py", line 1245, in <genexpr>
    key not in stmt.parameters)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/expression.py", line 1396, in _column_as_key
    return element.key
AttributeError: 'long' object has no attribute 'key'

http://nipy.bic.berkeley.edu/builders/pandas-py2.7-wheezy-sparc/builds/193/steps/shell_7/logs/stdio

INSTALLED VERSIONS
------------------
commit: None
python: 2.7.3.final.0
python-bits: 32
OS: Linux
OS-release: 2.6.32-5-sparc64-smp
machine: sparc64
processor: 
byteorder: big
LC_ALL: None
LANG: None

pandas: 0.14.0-45-g1754bb5
nose: 1.1.2
Cython: 0.19
numpy: 1.6.2
scipy: 0.10.1
statsmodels: 0.5.0
IPython: 0.13.1
sphinx: 1.1.3
patsy: 0.2.1
scikits.timeseries: None
dateutil: 1.5
pytz: 2012c
bottleneck: None
tables: 2.3.1
numexpr: 2.0.1
matplotlib: 1.1.1rc2
openpyxl: 1.7.0
xlrd: 0.6.1
xlwt: 0.7.4
xlsxwriter: None
lxml: 2.3.2
bs4: 4.1.0
html5lib: 0.95-dev
bq: None
apiclient: None
rpy2: 2.2.6
sqlalchemy: 0.7.8
pymysql: None
psycopg2: None
@jorisvandenbossche jorisvandenbossche added this to the 0.14.1 milestone Jun 4, 2014
@jorisvandenbossche
Copy link
Member

Related to #6340 and #7022. We saw the same error there.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
IO SQL to_sql, read_sql, read_sql_query
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants