之前的测试都是用的sqlite数据库,一行代码就完成
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///./Article2.db'
这篇文章讲一下如何连接MySQL
其实在之前问答平台小项目中,已经涉及过了,这里单独拿出来再说一次
新建主py文件, app.py
,新建配置文件 config.py
app.py
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
app.config.from_object(config)
db = SQLAlchemy(app)
@app.route('/')
def index():
return 'index'
if __name__ == '__main__':
app.run()
config.py
HOSTNAME = '127.0.0.1'
PORT = '3306'
DATABASE = 'demo' //数据库名
USERNAME = 'root'
PASSWORD = 'password'
DB_URI = 'mysql+mysqldb://{}:{}@{}:{}/{}'.format(USERNAME,PASSWORD,HOSTNAME,PORT,DATABASE)
SQLALCHEMY_DATABASE_URI = DB_URI
SQLALCHEMY_TRACK_MODIFICATIONS = False