flask_scripts 用manager 控制子脚本

1.子脚本 db_scripts.py

from flask_script import Manager
'''
'''
db_manager=Manager()

@db_manager.command
def init():
    print('迁移参数创建完毕')

@db_manager.command
def revision():
    print('迁移脚本生成成功')

@db_manager.command
def upgrade():
    print('脚本映射到数据库成功')

2.manage.py 

from flask_script import Manager
from scriptsdemo import app,User,db
from db_script import db_manager

manager=Manager(app)
#子命令
manager.add_command('db',db_manager)

3.命令行应用

python manage.py db init

python manage.py db revision

python manage.py db upgrade

  result = self._query(query)
迁移脚本生成成功

C:\Users\Administrator\Desktop\scripts>python manage.py db upgrade
C:\ProgramData\Anaconda3\lib\site-packages\flask_sqlalchemy\__init__.py:794: FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead an
d will be disabled by default in the future.  Set it to True or False to suppress this warning.
  'SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and '
C:\ProgramData\Anaconda3\lib\site-packages\pymysql\cursors.py:170: Warning: (1366, "Incorrect string value: '\\xD6\\xD0\\xB9\\xFA\\xB1\\xEA...' for column 'VAR
IABLE_VALUE' at row 480")
  result = self._query(query)
脚本映射到数据库成功