1.models.py中添加该方法，可通过该方法转dict
#驼峰
def to_hump_dict(self):
return {commonUtils.str2Hump(c.name): getattr(self, c.name, None) for c in self.__table__.columns}
def to_dict(self):
return {c.name: getattr(self, c.name, None) for c in self.__table__.columns}
Base.to_hump_dict = to_hump_dict
Base.to_dict = to_dict
class User(Base):
__tablename__ = 'key_user'
id = Column(INTEGER(11), primary_key=True, nullable=False, index=True)
uid = Column(String(32), primary_key=True, nullable=False)
username = Column(String(255), primary_key=True, nullable=False, index=True)
remarks = Column(String(255))
creater = Column(String(255))
create_time = Column(TIMESTAMP)
2.查询（入参没有的情况）、分页、排序
if username:
q = self.dbsession.query(KeyUser).filter(User.username == username)
if passwd:
q = q.filter(User.passwd== passwd)
q.limit(pageSize).offset(int(page-1)*pageSize).order_by(User.id.desc()).all()
3.使用timestamp类型时，对应的python获取
func.current_timestamp()
