sqlalchemy 将查询的数据转化json格式

张飞的技术博客

于 2024-05-04 01:10:16 发布

阅读量742

点赞数 2

文章标签： sql python

本文链接：https://blog.youkuaiyun.com/qq_45878803/article/details/138429423

版权

# 转单条数据
def to_dict(items,table_items):
    table_info = [i for i in UserInfo.__dict__ if '__' not in i and '_sa_class_manager' not in i]
    result = {}
    for i in table_info:
        # result[i] = eval(f'items.{i}')
        key = eval(f'items.{i}')
        if type(key) == decimal.Decimal:
            result[i] = int(key)
        elif type(key) == datetime.datetime:
            result[i] = str(key)
        else:
            result[i] = key
    # print(result)
    return result
# 批量转数据
def to_json(items,table_items):
    result = []
    for i in items:
        aa = to_dict(i,table_items)
        result.append(aa)
    # print(result)
    return result