应用环境:
flask程序建立一个User数据库模型
通过manage.py添加User实例
flask代码:
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
import config
app = Flask(__name__)
app.config.from_object(config)
db=SQLAlchemy(app)
class User(db.Model):
__tablename__="user"
id=db.Column(db.Integer,primary_key=True,autoincrement=True)
username=db.Column(db.String(100),nullable=False)
email=db.Column(db.String(100),nullable=False)
db.create_all()
if __name__ == '__main__':
app.run()
manage.py代码:
from flask_script import Manager
from scriptsdemo import app,User,db
manager=Manager(app)
@manager.option('-n','--username',dest='username')
@manager.option('-e','--email',dest='email')
def add_user(username,email):
user=User(username=username,email=email)
db.session.add(user)
db.session.commit()
print(f'{username}添加成功')
if __name__=='__main__':
manager.run()
命令行添加实例:
结果: