def main():
db_session.global_init("db/blogs.db")
user = User()
user.surname = "Scott"
user.name = "Ridley"
user.age = "21"
user.position = "captain"
user.speciality = "research engineer"
user.address = "module_1"
user.email = "*****@*****.**"
db_sess = db_session.create_session()
db_sess.add(user)
user = User()
user.surname = "Surn"
user.name = "Na"
user.age = "123"
user.position = "cook"
user.speciality = "aboltus"
user.address = "55.5, 66.6"
user.email = "*****@*****.**"
db_sess = db_session.create_session()
db_sess.add(user)
user = User()
user.surname = "Sun"
user.name = "Ame"
user.age = "277"
user.position = "assistant"
user.speciality = "aboltus"
user.address = "module_0"
user.email = "*****@*****.**"
db_sess = db_session.create_session()
db_sess.add(user)
user = User()
user.surname = "Urn"
user.name = "Nam"
user.age = "A12"
user.position = "assistant"
user.speciality = "aboltus"
user.address = "module_777"
user.email = "*****@*****.**"
db_sess = db_session.create_session()
db_sess.add(user)
db_sess.commit()
app.run()
def create_test_user(name, email, hashed_pw, active_status):
u = User()
u.name = name
u.email = email
u.hashed_pw = hashed_pw
u.is_active = active_status
return u
def register():
form = RegisterForm()
if form.validate_on_submit():
if form.password.data != form.password_again.data:
return render_template('register.html',
title='Регистрация',
form=form,
message="Пароли не совпадают")
db_sess = db_session.create_session()
if db_sess.query(User).filter(User.email == form.email.data).first():
return render_template(
'register.html',
title='Регистрация',
form=form,
message="Пользователь с таким Email уже зарегистрирован!")
user = User()
if not db_sess.query(User).count():
user.is_admin = True
user.email = form.email.data
user.set_password(form.password.data)
db_sess.add(user)
db_sess.commit()
login_user(user, remember=True)
return redirect("/")
return render_template('register.html', form=form)
def create_user(name: str, email: str) -> User:
user = User()
user.name = name
user.email = email
user.save()
return user
def register():
form = RegisterForm()
if form.validate_on_submit():
if form.password.data != form.password2.data:
return render_template('register.html',
title='Регистрация',
form=form,
message="Пароли не совпадают")
session = db_session.create_session()
if session.query(User).filter(User.email == form.email.data).first():
return render_template('register.html',
title='Регистрация',
form=form,
message="Такой пользователь уже есть")
user = User()
user.rank = form.rank.data
user.name = form.name.data
user.email = form.email.data
user.nick = form.nick.data
user.set_password(form.password.data)
user.owned = ''
session.add(user)
session.commit()
return redirect('/login')
return render_template("register.html", form=form, title='Регистрация')
def register():
form = RegisterForm()
if form.validate_on_submit():
if form.password.data != form.password_again.data:
params = {
'title': 'Регистрация',
'form': form,
'message': 'Пароли не совпадают'
}
return render_template('register.html', **params)
db_sess = db_session.create_session()
if db_sess.query(User).filter(User.email == form.email.data).first():
params = {
'title': 'Регистрация',
'form': form,
'message': 'Пользователь с такой почтой уже существует'
}
return render_template('register.html', **params)
user = User()
user.username = form.username.data
user.email = form.email.data
user.set_password(form.password.data)
db_sess.add(user)
db_sess.commit()
login_user(user, remember=True)
return redirect('/')
params = {
'title': 'Регистрация',
'form': form,
}
return render_template('register.html', **params)
def register_user(data) -> User:
user = User()
user._id = UserModel.getcounter()
user.email = data['email']
user.username = data['username']
user.password = encrypt_password(data['password'])
user.role = data['role']
user.save()
return user
def main():
db_session.global_init("db/mars.db")
cap = User()
cap.surname = 'Scott'
cap.name = 'Ridley'
cap.age = 21
cap.position = 'captain'
cap.speciality = 'research engineer'
cap.address = 'module_1'
cap.email = '*****@*****.**'
db_sess = db_session.create_session()
db_sess.add(cap)
user1 = User()
user1.surname = 'Black'
user1.name = 'Adam'
user1.age = 19
user1.position = 'user'
user1.speciality = 'doctor'
user1.address = 'module_3'
user1.email = '*****@*****.**'
db_sess.add(user1)
user2 = User()
user2.surname = 'Green'
user2.name = 'Jereme'
user2.age = 25
user2.position = 'user'
user2.speciality = 'scientist'
user2.address = 'module_1'
user2.email = '*****@*****.**'
db_sess.add(user2)
user3 = User()
user3.surname = 'Braun'
user3.name = 'Simon'
user3.age = 22
user3.position = 'user'
user3.speciality = 'cooker'
user3.address = 'module_2'
user3.email = '*****@*****.**'
db_sess.add(user3)
db_sess.commit()
async def create_account(name: str, email: str, password: str) -> User:
user = User()
user.email = email
user.name = name
user.hash_password = crypto.hash(password, rounds=172_434)
async with db_session.create_async_session() as session:
session.add(user)
await session.commit()
return user
def create_user(name: str, email: str) -> Optional[User]:
if find_user_by_email(email):
return None
user = User()
user.name = name
user.email = email
user.save()
return user
def create_account(name: str, email: str, password: str):
session = db_session.create_session()
try:
user = User()
user.email = email
user.name = name
user.hash_password = crypto.hash(password, rounds=172_434)
session.add(user)
session.commit()
return user
finally:
session.close()
def reg():
form = RegForm()
if form.validate_on_submit():
db_session.global_init('db/blogs.db')
db_sess = db_session.create_session()
user = User()
user.id = int(form.id.data)
user.surname = form.surname.data
user.name = form.name.data
user.age = int(form.age.data)
user.email = form.email.data
user.hashed_password = form.password.data
login_user(user)
db_sess.add(user)
db_sess.commit()
return redirect("/tab1")
return render_template('reg.html', form=form)
def main():
form = RegisterForm()
if request.method == 'POST':
user = User()
user.email = request.form['login_email']
user.hashed_password = request.form['password']
user.surname = request.form['surname']
user.name = request.form['name']
user.age = request.form['age']
user.position = request.form['position']
user.speciality = request.form['specialty']
user.address = request.form['address']
session = db_session.create_session()
session.add(user)
session.commit()
return 'Пользователь добавлен в базу данных.'
return render_template('register.html',
title='Форма регистрации',
form=form)
def do_user_import(user_lookup: Dict[str, str]) -> Dict[str, User]:
print("Importing users ... ", flush=True)
with progressbar.ProgressBar(max_value=len(user_lookup)) as bar:
for idx, (email, name) in enumerate(user_lookup.items()):
session = db_session.create_session()
session.expire_on_commit = False
user = User()
user.email = email
user.name = name
session.add(user)
session.commit()
bar.update(idx)
print()
sys.stderr.flush()
sys.stdout.flush()
session = db_session.create_session()
return {u.email: u for u in session.query(User)}
def create_user(name, email, password, security, is_active=False):
# todo: validation
if find_user_by_email(email):
return None
user = User()
user.name = name
user.email = email
user.hashed_pw = hash_text(password)
user.is_active = is_active
user.security_class = security
session = db_session.create_session()
session.expire_on_commit = False
session.add(user)
try:
session.add(user)
session.commit()
finally:
session.close()
return user
def login():
form = LoginForm()
if form.validate_on_submit():
db_session.global_init("db/mars.db")
# db_session.global_init(name)
db_sess = db_session.create_session()
print(form.surname.data, form.name.data, form.address.data)
user = User()
user.surname = form.surname.data
user.name = form.name.data
user.address = form.address.data
user.age = int(form.age.data)
user.position = form.position.data
user.speciality = form.speciality.data
user.hashed_password = form.password.data
user.email = form.username.data
db_sess.add(user)
db_sess.commit()
return redirect('/success')
return render_template('form.html', title='Авторизация', form=form)
from data import db_session
from data.user import User
from data.jobs import Jobs
db_session.global_init("db/mars_explorer.db")
db = db_session.create_session()
user = User()
user.surname = "Scott"
user.name = "Ridley"
user.age = 21
user.position = "captain"
user.speciality = "research engineer"
user.address = "module_1"
user.email = "*****@*****.**"
user1 = User()
user1.surname = "Scott 1"
user1.name = "Ridley"
user1.age = 21
user1.position = "colonist"
user1.speciality = "research engineer"
user1.address = "module_1"
user1.email = "*****@*****.**"
user2 = User()
user2.surname = "Scott 2"
user2.name = "Ridley"
user2.age = 21
user2.position = "colonist"
