mini.py

from flask import Flask
from sqlalchemy import create_engine
import json

app = Flask("jsonapi")
engine = create_engine('mysql://root:@localhost:3306/testdb')

@app.route("/")
def item():
    result = engine.execute("select * from lookups").fetchall()
    d = {"result": [{"id": id, "val": val} for (id,val) in result]}
    return json.dumps(d)

app.run()