python初学者麻烦各位给看看,flask 提示'list' object is not callable
最近试着学习flask 要在数据库中查询一个数据,然后返回给页面,(例如 http://127.0.0.1:5000/查询)分段写数据库查询和获取参数都很顺利,可以一放到一起就出现问题,总提示'list' object is not callable。麻烦各位大神给看看究竟哪里出错。
from flask import Flask, request , jsonify
from sqlalchemy import *
from sqlalchemy.sql import select
from sqlalchemy.schema import *
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base()
db_engine = create_engine('oracle+cx_oracle://test:test@192.168.0.1:1521/test', echo=True)
meta = MetaData()
meta.bind = db_engine
t = Table("testl",meta,autoload=True)
def getnum(num):
e = t.select(t.c.cert-man == num ).execute().fetchall()
return e
app = Flask(__name__)
@app.route('/')
def hello():
text = request.args.get('text')
return getnum(text)
if __name__ == '__main__':
app.debug = True
app.run()