"Sqlalchemy和Flask API无法从数据库中返回列和值"

Question

我正在运行一个连接到sqlite数据库的flaskweb框架。我在返回同时包含列名和该列值的查询时遇到问题。我包括下面的相关代码。在

import threading
import time
import KeySys
import serial
from flask import Flask, request
from flask_restful import reqparse, abort, Api, Resource
from sqlalchemy import create_engine
from json import dumps
from time import sleep
from datetime import datetime

e = create_engine('sqlite:///lockdb.db')
app = Flask(__name__)
api = Api(app)
parser = reqparse.RequestParser()
parser.add_argument('LockSwitch')

class Keystat_Meta(Resource):
    def get(self):
        #Connect to databse
        conn = e.connect()
        #Perform query and return JSON data
        query = conn.execute('select * from LockStat')
        return {'KeyStat': [query.cursor.fetchall()]} # I've tried keys() all() items(column, value) and various different queries.

api.add_resource(Keystat_Meta, '/keystat')

if __name__ == '__main__':
    app.run()

Answer 1

如果有人在为此挣扎，我花了一天的时间来努力，但我找到了解决办法

return{'KeyStat'：[dict（zip（元组(查询.keys（）），我）为了我查询.cursor]}在