python flask SQLAlchemy ORM模型创建和表的建立和删除
python flask SQLAlchemy ORM模型创建和表的建立和删除
from flask import Flask # 导入SQLAlchemy from flask_sqlalchemy import SQLAlchemy app = Flask(__name__) app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://root:root@127.0.0.1:3306/yu?charset=utf8' app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = True # 1、绑定到Flask对象 db = SQLAlchemy(app) # 2、ORM模型创建 class User(db.Model): # 3、指定表名称 __tablename__ = 'stu_user' # 4、表字段 id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(64), nullable=False) password = db.Column(db.String(64), nullable=False) # 4、手动创建表 >>>db.create_all() # 5、手动删除表 >>>db.drop_all() @app.route('/') def hello_world(): return 'Hello World!' if __name__ == '__main__': app.run()