示例#1
0
def execute_adding_data():
    words_count = Word.query.count()
    users_count = User.query.count()
    if words_count > 0:
        print('initial words loaded in database')
    else:
        for item in lexicon:
            term = item.get("term")
            meaning = item.get("meaning")
            pronunciation = item.get("pronunciation")
            category = item.get("category")
            mnemonic_phrase = item.get("mnemonic_phrase")

            new_word = Word(term, meaning, pronunciation, category,
                            mnemonic_phrase)
            new_word.add()
        print('words_added')

    if users_count > 0:
        print('initial users loaded in database')
    else:
        for item in users:
            name = item.get("name")
            lastname = item.get("lastname")
            email = item.get("email")
            password_user = item.get("password")
            password = generate_password_hash(password_user, method='sha256')
            avatar = create_avatar(name, lastname)

            new_user = User(name, lastname, email, password, avatar)
            new_user.add()
        print('users_added')