Sqlchemy查询结果转json

表

class User(Base):
    __tablename__ = 'student'
    id = Column(Integer, primary_key=True)
    name = Column(String(32), index=True)
    money = Column(String(32), index=True)

    def __init__(self, name, money):
        self.name = name
        self.author = money

    def to_json(self):
        dict = self.__dict__
        if "_sa_instance_state" in dict:
            del dict["_sa_instance_state"]
        return dict

查询

try:
	# 查询所有结果
	userInfo = db.query(User).all()
	
	# 查询具体用户
	# userInfo = db.query(User).filter_by(id=1)
	
	# 格式转为 json
	user_list = []
	for i in userInfo:
		user_list.append(i.to_json())
		
	print(user_list)
	
except Exception as e:
	print(e)

# 查询所有结果
[
{'money': '9999', 'name': '1', 'id': 1},
{'money': '9999', 'name': '1', 'id': 2}, 
{'money': '9999', 'name': '1', 'id': 3}
]
# 查询id=1的用户
[{'money': '9999', 'name': '1', 'id': 1}]

指定字段查询

def to_json(self):
	return {
		"id": self.id,
		"name": self.name
	}

try:                                             
    # 查询所有结果                                     
    userInfo = db.query(User).all()              
    print(userInfo)                              
                                                 
    user_list = []                               
    for i in userInfo:                           
        user_list.append(i.to_json())            
                                                 
    print(user_list)                             
                                                 
except Exception as e:                           
    print(e)