import sys sys.path.append("..") from migrate.versioning import api from config import SQLALCHEMY_DATABASE_URI from config import SQLALCHEMY_MIGRATE_REPO from manager import db import os.path # print SQLALCHEMY_MIGRATE_REPO if not os.path.exists(SQLALCHEMY_MIGRATE_REPO): api.create(SQLALCHEMY_MIGRATE_REPO, 'database repository') api.version_control(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO) else: # print api api.version_control(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO, api.version(SQLALCHEMY_MIGRATE_REPO)) db.create_all() import sys sys.path.append("..") from manager import db, app from admin.admin_models import Role from admin.admin_models import Manager from flask_security import SQLAlchemyUserDatastore from flask_security.utils import encrypt_password import key with app.app_context(): user_role = Role(name='user') super_user_role = Role(name='superuser')
def reset_all_db(): # db.drop_all() db.create_all()
#coding=utf-8 ####################################################### # 这个文件的作用是做一些数据库初始化的工作 # 用法 python db_create.py ####################################################### from manager import db # 主函数 if __name__ == '__main__': # 创建所有表 db.create_all() db.session.commit() print('finished')
def reset(): db.drop_all() dbt.drop_all() db.create_all() dbt.create_all() return 'True'