如何用sqlAlchemy调用MySQL的存储过程?
我尝试了以下代码:
import webapp2
from sqlalchemy import *
from sqlalchemy.ext.automap import automap_base
from sqlalchemy.orm import create_session
from sqlalchemy import create_engine
class TestSQL(webapp2.RequestHandler):
def get(self):
Base = automap_base()
engine = create_engine(('mysql://root@127.0.0.1:3306/testDB?unix_socket=/cloudsql/School=:mysqlserver'))
# reflect the tables
Base.prepare(engine, reflect=True)
metadata = MetaData(bind=engine)
users = Table('Student', metadata, autoload=True)
student = metadata.tables ["Student"]
session = create_session()
pro = session.execute("p_get_teacher_requests", (1,0))
self.response.write(pro)
我得到的错误是:
UnboundExecutionError: Could not locate a bind configured on SQL expression or this Session
经过一些研究和许多试验,它使用了以下代码:
相关问题 更多 >
编程相关推荐