Use MySQL Flask connection in different python file

Question

i have a app.py with:

from flask import FlasK
from flask_mysqldb import MySQL


# Objeto Flask
app = Flask(__name__)

# Secret key
app.secret_key = "appLogin"

# BD config
app.config['MYSQL_HOST'] = 'localhost'
app.config['MYSQL_USER'] = 'xxx'
app.config['MYSQL_PASSWORD'] = 'xxxx'
app.config['MYSQL_DB'] = 'feedlotdb'

# Obj MySQL
mysql = MySQL(app)


@app.route('/register', methods=["GET", "POST"])
def register():
   # USE BD
       sQuery = "INSERT INTO user (mail, password, name) VALUES (%s, %s, %s)"
       cur = mysql.connection.cursor()
       cur.execute(sQuery, (mail, password, name))
       mysql.connection.commit()

QUESTION:

I put part of the code above How can I take "/Register" and encapsulate the user code there in a file like user.py and use the same sql.connection? thx

ANISH KUMAR MOURYA · Accepted Answer · 2020-03-16 07:09:40Z

1

you can create user.py and import mysql and app

users.py

from app import mysql
import app

from flask import Blueprint, render_template, abort

users_bp = Blueprint('users_bp', __name__)



@users_bp.route('/register', methods=["GET", "POST"])
def register():
       # USE BD
       sQuery = "INSERT INTO user (mail, password, name) VALUES (%s, %s, %s)"
       cur = mysql.connection.cursor()
       cur.execute(sQuery, (mail, password, name))
       mysql.connection.commit()

register blueprint in main app :-

from users import users_bp
app.register_blueprint(users_bp, url_prefix='/users')

edited Mar 16, 2020 at 7:09

answered Mar 13, 2020 at 10:07

ANISH KUMAR MOURYA

3451 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mariano Over a year ago

Did not work. When I call the event /Register in user.py Not Found The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again. Try use flask.palletsprojects.com/en/1.1.x/patterns/lazyloading/… but I also couldn't

ANISH KUMAR MOURYA Over a year ago

if the request URL is not found then i am sure you have not registered users.py file as blueprint to main app . see flask blueprint for more detail :- flask.palletsprojects.com/en/1.1.x/blueprints

Collectives™ on Stack Overflow

Use MySQL Flask connection in different python file

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related