注册

利用sqlalchemy,pd.to_sql写入数据报错

99分的神经蛙 2023/11/11 460 1

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:centos7
【CPU】:X86
【问题描述】*:
dm:8
dmPython:2.4.5
sqlalchemy_dm: 2.0.0
sqlalchemy:2.0.18
pandas:2.0.3
应用sqlalchemy,pd.read_sql读取dm数据没问题,但是用pd.to_sql写数据就报错:TypeError: DMDialect.has_table() got an unexpected keyword argument 'info_cache',有没有人知道怎么破?
错误如下:
Traceback (most recent call last):
File "/tmp/pycharm_project_589/test15.py", line 261, in <module>
db.insert_data_bypd(tablename, df)
File "/tmp/pycharm_project_589/Decorator.py", line 30, in wraper
res = func(*args, **kwargs)
File "/tmp/pycharm_project_589/test15.py", line 226, in insert_data_bypd
df.to_sql(tablename, conn, if_exists='replace', index=False)
File "/root/miniconda3/lib/python3.10/site-packages/pandas/core/generic.py", line 2878, in to_sql
return sql.to_sql(
File "/root/miniconda3/lib/python3.10/site-packages/pandas/io/sql.py", line 769, in to_sql
return pandas_sql.to_sql(
File "/root/miniconda3/lib/python3.10/site-packages/pandas/io/sql.py", line 1910, in to_sql
table = self.prep_table(
File "/root/miniconda3/lib/python3.10/site-packages/pandas/io/sql.py", line 1814, in prep_table
table.create()
File "/root/miniconda3/lib/python3.10/site-packages/pandas/io/sql.py", line 903, in create
if self.exists():
File "/root/miniconda3/lib/python3.10/site-packages/pandas/io/sql.py", line 889, in exists
return self.pd_sql.has_table(self.name, self.schema)
File "/root/miniconda3/lib/python3.10/site-packages/pandas/io/sql.py", line 1943, in has_table
return insp.has_table(name, schema or self.meta.schema)
File "/root/miniconda3/lib/python3.10/site-packages/sqlalchemy/engine/reflection.py", line 429, in has_table
return self.dialect.has_table(
TypeError: DMDialect.has_table() got an unexpected keyword argument 'info_cache'

回答 0
暂无回答
扫一扫
联系客服