FLASK-SQLAlchemy的使用

数据库的创建：create database db_demo1 charset utf8;

数据库的销毁：drop database db_demo1;

头文件：

import pymysql
pymysql.install_as_MySQLdb()

初始化：

app = Flask(__name__)
app.config.from_object(config)
db = SQLAlchemy(app)

设置配置信息：

DIALECT = 'mysql'
DRIVER = 'mysqldb'
USERNAME = 'root'
PASSWORD = '123456'
HOST = '127.0.0.1'
PORT = '3306'
DATABASE = 'db_demo1'   #数据库名字

SQLALCHEMY_DATABASE_URI = "{}+{}://{}:{}@{}:{}/{}?charset=utf8".format(DIALECT,DRIVER,USERNAME,PASSWORD
                                            ,HOST,PORT,DATABASE)
SQLALCHEMY_TRACK_MODIFICATIONS = False

db.py

from flask import Flask
from flask_sqlalchemy import SQLAlchemy
import config
import pymysql
pymysql.install_as_MySQLdb()

app = Flask(__name__)
app.config.from_object(config)
db = SQLAlchemy(app)

db.create_all()

@app.route('/')
def hello_world():
    return 'Hello World!'


if __name__ == '__main__':
    app.run()