app.py
from flask import Flask, render_template, request,jsonify,json,g
import mysql.connector
app = Flask(__name__)
class TestMySQL():
@app.before_request
def before_request():
try:
g.db = mysql.connector.connect(user='root', password='root', database='mysql')
except mysql.connector.errors.Error as err:
resp = jsonify({'status': 500, 'error': "Error:{}".format(err)})
resp.status_code = 500
return resp
@app.route('/')
def input_info(self):
try:
cursor = g.db.cursor()
cursor.execute ('CREATE TABLE IF NOT EXISTS testmysql (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(40) NOT NULL, \
email VARCHAR(40) NOT NULL UNIQUE)')
cursor.close()
test.py
from app import *
class Test(unittest.TestCase):
def test_connection1(self):
with patch('__main__.mysql.connector.connect') as mock_mysql_connector_connect:
object = TestMySQL()
object.before_request() # Runtime error on calling this
我正在将app导入到test.py中进行单元测试。在调用test.py中的'before_request'函数时,它会抛出一个运行时错误:
working outside of application context
,同样的情况也会发生在调用'input_info()'时。
jsonify
而得到此错误。一个简单的 JSON 转换需要应用程序“在上下文中”运行,这真的很糟糕。 - milosmns