Example #1
0
def init():
    # 创建数据库
    create_db_sql = 'CREATE DATABASE IF NOT EXISTS {0} DEFAULT CHARACTER SET utf8'.format(config[config_name].DB_DATABASE)
    # print create_db_sql
    ret = subprocess.call(
        [
            'mysql', '-u', config[config_name].DB_USERNAME,
            '-p{0}'.format(config[config_name].DB_PASSWORD),
            '-e', create_db_sql,
        ]
    )
    if not ret:
        print '数据库创建成功'
    else:
        print '数据库创建失败'
        return 

    db.drop_all()
    db.create_all()
    print '数据表创建成功'
    init_manufacturers_and_products(db.session)
    init_questions_and_answers(db.session)
    # init_home(db.session)
    # init_post(db.session)
    # init_member(db.session)
    # print '数据初始化成功'
    print '请输入管理员邮箱:'
    email = raw_input()
    print '请输入管理员密码:'
    password = raw_input()
    print '请输入管理员昵称:'
    nickname = raw_input()
    init_user(db.session, email, password, nickname)
    print '管理员账户初始化成功'
Example #2
0
 def tearDown(self):
     db.session.remove()
     db.drop_all()
     self.app_context.pop()