Skip to content
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

Getting error with demo code. #26

Closed
Tooblippe opened this issue Jun 19, 2014 · 1 comment
Closed

Getting error with demo code. #26

Tooblippe opened this issue Jun 19, 2014 · 1 comment

Comments

@Tooblippe
Copy link

Running the demo code I get this
In [2]: from pandasql import sqldf, load_meat, load_births

pysqldf = lambda q: sqldf(q, globals())
meat = load_meat()
births = load_births()
print pysqldf("SELECT * FROM meat LIMIT 10;").head()

In [3]: >>> pysqldf = lambda q: sqldf(q, globals())

In [4]: >>> meat = load_meat()

In [5]: >>> births = load_births()

In [6]: >>> print pysqldf("SELECT * FROM meat LIMIT 10;").head()

InterfaceError Traceback (most recent call last)
in ()
----> 1 print pysqldf("SELECT * FROM meat LIMIT 10;").head()

in (q)
----> 1 pysqldf = lambda q: sqldf(q, globals())

/Users/tobie/anaconda/lib/python2.7/site-packages/pandasql/sqldf.pyc in sqldf(q, env, inmemory)
124 df = env[table]
125 df = _ensure_data_frame(df, table)
--> 126 _write_table(table, df, conn)
127
128 try:

/Users/tobie/anaconda/lib/python2.7/site-packages/pandasql/sqldf.pyc in _write_table(tablename, df, conn)
74 raise Exception(msg)
75
---> 76 to_sql(df, name=tablename, con=conn, flavor='sqlite')
77
78

/Users/tobie/anaconda/lib/python2.7/site-packages/pandas/io/sql.pyc in to_sql(frame, name, con, flavor, if_exists, index, index_label)
438
439 pandas_sql.to_sql(frame, name, if_exists=if_exists, index=index,
--> 440 index_label=index_label)
441
442

/Users/tobie/anaconda/lib/python2.7/site-packages/pandas/io/sql.pyc in to_sql(self, frame, name, if_exists, index, index_label)
1059 name, self, frame=frame, index=index, if_exists=if_exists,
1060 index_label=index_label)
-> 1061 table.insert()
1062
1063 def has_table(self, name):

/Users/tobie/anaconda/lib/python2.7/site-packages/pandas/io/sql.pyc in insert(self)
927
928 cur = self.pd_sql.con.cursor()
--> 929 cur.executemany(ins, data_list)
930 cur.close()
931 self.pd_sql.con.commit()

InterfaceError: Error binding parameter 1 - probably unsupported type.

@glamp
Copy link
Contributor

glamp commented Jul 1, 2014

fixed in 42949a9

@glamp glamp closed this as completed Jul 1, 2014
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants