运行时错误:在应用程序上下文之外工作-数据库问题

RuntimeError: working outside of application context(运行时错误:在应用程序上下文之外工作)

本文介绍了运行时错误:在应用程序上下文之外工作的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

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 进行单元测试.在调用 'before_request' 函数到 test.py 时，它抛出运行时错误:在应用程序上下文之外工作调用 'input_info()'

I am importing app into test.py for unit testing.On calling 'before_request' function into test.py ,it is throwing RuntimeError: working outside of application context same is happening on calling 'input_info()'

推荐答案

Flask 有一个应用程序上下文，似乎您需要执行以下操作:

Flask has an Application Context, and it seems like you'll need to do something like:

def test_connection(self):
    with app.app_context():
        #test code

您也可以将 app.app_context() 调用推送到测试设置方法中.希望这会有所帮助.

You can probably also shove the app.app_context() call into a test setup method as well. Hope this helps.

这篇关于运行时错误:在应用程序上下文之外工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！