注册

python使用sqlalchemy_dm

刘晓佳 2024/10/19 389 0

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】:centos7
【CPU】:Intel(R) Xeon(R) Gold 5218 CPU @ 2.30GHz
【问题描述】
username = 'SYSDBA'
password = '
*****'
host = '127.0.0.1'
port = '5236' # 默认端口号

connection_string = f'dm+dmPython://{username}:{password}@{host}:{port}/'
# 创建数据库引擎
engine = create_engine(connection_string)
table_name = 'PIESAT_DGDQ.SWDATA_OBS_DEN_FUSED'
data.to_sql(table_name, engine, index=False, if_exists='append')

执行到to_sql时,报错 File "/usr/local/lib/python3.6/site-packages/sqlalchemy_dm-1.1.10-py3.6.egg/sqlalchemy_dm/dmPython.py", line 400, in initialize
File "/usr/local/lib/python3.6/site-packages/sqlalchemy_dm-1.1.10-py3.6.egg/sqlalchemy_dm/base.py", line 1607, in initialize
File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/engine/default.py", line 414, in initialize
connection
File "/usr/local/lib/python3.6/site-packages/sqlalchemy_dm-1.1.10-py3.6.egg/sqlalchemy_dm/base.py", line 1747, in _get_default_schema_name
File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1370, in execute
future=False,
File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1676, in _exec_driver_sql
distilled_parameters,
File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1826, in _execute_context
context.pre_exec()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy_dm-1.1.10-py3.6.egg/sqlalchemy_dm/dmPython.py", line 114, in pre_exec
AttributeError: 'DMExecutionContext_dmPython' object has no attribute 'compiled_parameters'

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