Flask_script是一个在flask应用外部编写脚本的扩展
常用功能:1、运行一个开发的服务器。2、Python shell 中操作数据库。3、命令行任务
manage.py:
from flask_script import Manager
from app import app
import sqlite3
from models import User
manager = Manager(app)
# python manege.py hello
@manager.command
def hello():
print('hello world')
@manager.option('-m', '--msg', dest='msg_val', default='world')
def hello_world(msg_val):
print('hello' + msg_val)
@manager.command
def init_db():
sql = 'create table users(id INT,name TEXT)'
conn = sqlite3.connect('test.db')
cursor = conn.cursor()
cursor.execute(sql)
conn.commit()
cursor.close()
conn.close()
@manager.command
def save():
user = User(1, 'useless')
user.save()
@manager.command
def query_all():
users = User.query()
for user i