我对Python和Flask比较陌生,如果这是非常基本的,那么很抱歉。我在我的方法中运行一个查询,如下所示:
@app.route('/coreteams')
def coreteams():
db = FlaskApp.db_connect()
coreteams = db.execute(text(
"SELECT service_users.id AS user_id, core_teams.service_user, core_teams.staff_name , core_teams.role, staff_list.id AS staff_id, staff_list.status, core_teams.workbase" \
" FROM core_teams" \
" LEFT JOIN staff_list" \
" ON staff_list.name = core_teams.staff_name" \
" LEFT JOIN service_users" \
" ON service_users.name = core_teams.service_user" \
" WHERE staff_list.status <> 'Left'" \
" AND staff_list.status <> 'Name Changed';"
)).fetchall()
return jsonify(core=coreteams)
我得到的结果与此类似:
^{pr2}$我本以为应该是这样的:
^{3}$那么基本上返回的JSON也包含数据库中的列名?这可能吗?在
目前没有回答
相关问题 更多 >
编程相关推荐