[Python] sqlalchemy, json으로 변경 후 리턴

 

 

 

user = User.query
df = pd.read_sql(user.statement, user.session.bind)

#df = df.drop(columns=['updated_datetime'])
df.columns = map(str.lower, df.columns)

result_json = json.loads(df.astype(str).to_json(orient='records', double_precision=15, date_format='iso'))
result_json = json.dumps(result_json).replace('None', '')
result_json = json.loads(result_json)