【DM版本】:dm8
【操作系统】:centos7
【问题描述】*:
简单的查询语句报错(代码和报错我都贴在下面)
最奇葩的是,我把表的字段status,先改成其他字段,再改回来,代码就不报错了。
有哪位大神能解释下吗,或者告诉我怎么绕过这个坑
#!/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)
大家都没遇到过这个问题吗o(╥﹏╥)o