# 转单条数据
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
sqlalchemy 将查询的数据转化json格式
最新推荐文章于 2024-05-31 10:06:01 发布