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'