I am new to Flask and trying to build a simple application with a MySQL database. However, I prefer not to use SQLAlchemy. Instead, I would like to use mysql.connector and direct SQL statements to SELECT, INSERT, UPDATE or DELETE from the database.
I have a question: is it mandatory to define the MySQL database connection/parameters inside the factory function? The Flask tutorial shows a SQLite database being defined inside the factory function, create_app().
Sample tutorial code:
import os
from flask import Flask
def create_app(test_config=None):
# create and configure the app
app = Flask(__name__, instance_relative_config=True)
app.config.from_mapping(
SECRET_KEY='dev',
DATABASE=os.path.join(app.instance_path, 'flaskr.sqlite'),
)
if test_config is None:
# load the instance config, if it exists, when not testing
app.config.from_pyfile('config.py', silent=True)
else:
# load the test config if passed in
app.config.from_mapping(test_config)
# ensure the instance folder exists
try:
os.makedirs(app.instance_path)
except OSError:
pass
# a simple page that says hello
@app.route('/hello')
def hello():
return 'Hello, World!'
return app