创建一个Flask应用
from flask import Flask
app = Flask(__name__)
@app.route('/')
def hello_world():
return 'Hello World!'
if __name__ == '__main__':
app.run()
连接数据库
app.config['SQLALCHEMY_DATABASE_URI'] = "mysql+pymysql://root:123@127.0.0.1:3306/JiaBlog"
app.config['SQLALCHEMY_COMMIT_TEARDOWN'] = True
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
app.config['SQLALCHEMY_COMMIT_ON_TEARDOWN'] = True
db = SQLAlchemy(app)
数据库创建数据库
create database JiaBlog charset='utf8';
数据库建表
class Article(db.Model):
# 定义表名
__tablename__ = 'article'
# 定义字段
# db.Column 表示是一个字段
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(50), unique=True)
db.drop_all()
db.create_all()
运行,查看数据库表
mysql> use JiaBlog
mysql> show tables;