注册

sqlalchemy操作达梦数据库遇到的奇葩问题

123456 2023/08/21 718 2

【DM版本】:dm8
【操作系统】:centos7
【问题描述】*:
简单的查询语句报错(代码和报错我都贴在下面)
最奇葩的是,我把表的字段status,先改成其他字段,再改回来,代码就不报错了。
有哪位大神能解释下吗,或者告诉我怎么绕过这个坑
image.png

#!/usr/bin/env python # coding: utf-8 import datetime from sqlalchemy import create_engine from sqlalchemy import Column, Date, Integer, String, ForeignKey from sqlalchemy.ext.declarative import declarative_base from sqlalchemy import Column, Integer, String, Boolean, Text, DateTime, BIGINT, Float, DATETIME from sqlalchemy.orm import sessionmaker # 连接数据库 engine = create_engine('dm+dmPython://NCAF:Dameng123@172.16.5.242:5236', echo=True) MysqlBase = declarative_base() Session = sessionmaker(bind=engine) session = Session() class DPISetting(MysqlBase): __tablename__ = 'dpi_setting' dev_id = Column(String(36), primary_key=True) dev_name = Column(String(255)) status = Column(String(36)) if __name__ == '__main__': dpi_setting = session.query(DPISetting).filter_by(dev_id='fc178003-3b4a-11ee-955c-fad437251200').first() print(dpi_setting)
回答 0
暂无回答
扫一扫
联系客服