def main():
db_session.global_init("db/blogs.sqlite")
user = users.User()
user.surname = "Scott"
user.name = "Ridley"
user.age = 21
user.position = "captain"
user.speciality = "research engineer"
user.address = "module_1"
user.email = "*****@*****.**"
session = db_session.create_session()
session.add(user)
session.commit()
user = users.User()
user.surname = "Wrong"
user.name = "Lacku"
user.age = 22
user.position = "voyager"
user.speciality = "just engineer"
user.address = "module_2"
user.email = "*****@*****.**"
session.add(user)
session.commit()
user = users.User()
user.surname = "Lisicium"
user.name = "Hocku"
user.age = 20
user.position = "swimmer"
user.speciality = "just resercher"
user.address = "module_3"
user.email = "*****@*****.**"
session.add(user)
session.commit()
app.run()
def reqister():
form = users.RegisterForm()
# проверка на выполнение всех правил регистрации
if form.validate_on_submit():
# проверка на совпадение паролей
if form.password.data != form.password_again.data:
return render_template('register.html', title='Регистрация',
form=form,
message="Пароли не совпадают")
session = db_session.create_session()
# проверяется новый пользователь или уже существует
if session.query(users.User).filter(users.User.email == form.email.data).first():
return render_template('register.html', title='Регистрация',
form=form,
message="Такой пользователь уже есть")
user = users.User(
name=form.name.data,
email=form.email.data,
about=form.about.data
)
user.set_password(form.password.data)
session.add(user)
session.commit()
return redirect('/login')
return render_template('register.html', title='Регистрация', form=form)
def reqister():
form = RegisterForm()
if form.validate_on_submit():
if form.password.data != form.password_again.data:
return render_template('register.html',
title='Регистрация',
form=form,
message="Пароли не совпадают")
session = db_session.create_session()
if session.query(users.User).filter(
users.User.email == form.email.data).first():
return render_template('register.html',
title='Регистрация',
form=form,
message="Такой пользователь уже есть")
user = users.User(surname=form.surname.data,
name=form.name.data,
age=form.age.data,
position=form.position.data,
speciality=form.speciality.data,
address=form.address.data,
email=form.email.data)
user.set_password(form.password.data)
session.add(user)
session.commit()
return redirect('/login')
return render_template('register.html', title='Регистрация', form=form)
def register():
form = registerform.RegisterForm()
db_session.global_init("db/marsians.sqlite")
session = db_session.create_session()
if form.validate_on_submit():
if not form.age.data.isdigit():
return render_template('register.html',
agemassage="Неправильно введён возраст",
form=form)
if not form.password1.data == form.password2.data:
return render_template('register.html',
passwordmassage="Пароли не совпадают",
form=form)
user1 = users.User()
user1.name = form.name.data
user1.surname = form.surname.data
user1.age = int(form.age.data)
user1.position = form.position.data
user1.speciality = form.speciality.data
user1.address = form.address.data
user1.email = form.email.data
user1.hashed_password = form.password1.data
session.add(user1)
session.commit()
return redirect("/login")
return render_template('register.html', title='Регистрация', form=form)
def main():
db_session.global_init("db/online_shop.sqlite")
session = db_session.create_session()
product = products.Product()
product.seller_id = 1
product.seller = "Scott"
product.title = "first product"
product.number = 15
product.description = "description"
product.price = "12"
product.product_type = "Телефон"
product.image = "/static/img/Nope.png"
product.link = "/product_link/1"
product.del_link = "/del_product/1"
product.order_link = "/order_link/1"
session.add(product)
user1 = users.User()
user1.name = "Scott"
user1.email = "*****@*****.**"
user1.hashed_password = 123
session.add(user1)
session.commit()
def register():
form = registerform.RegisterForm()
db_session.global_init("db/Buisness_trips.sqlite")
session = db_session.create_session()
if form.validate_on_submit():
if session.query(users.User).filter(
users.User.email == form.email.data).first():
return render_template('register.html',
emailmassage="Этот email уже используется",
form=form)
if not form.password1.data == form.password2.data:
return render_template('register.html',
passwordmassage="Пароли не совпадают",
form=form)
user1 = users.User()
q = -1
for i in session.query(users.User).all():
q = i
user1.id = q.id + 1
user1.secondname = form.secondname.data
user1.name = form.name.data
user1.email = form.email.data
user1.password = form.password1.data
user1.city = form.city.data
session.add(user1)
session.commit()
user = session.query(
users.User).filter(users.User.email == form.email.data).first()
res = make_response(redirect("/"))
res.set_cookie("user_id", str(user.id), max_age=60 * 60)
return res
return render_template('register.html', title='Регистрация', form=form)
def reqister():
form = register_form.RegisterForm()
if form.validate_on_submit():
if form.password.data != form.password_again.data:
return render_template('register.html',
title='Registration',
form=form,
message="Passwords don't match")
session = db_session.create_session()
if session.query(users.User).filter(
users.User.email == form.email.data).first():
return render_template('register.html',
title='Registration',
form=form,
message="This user already exists")
if session.query(
users.User).filter(users.User.name == form.name.data).first():
return render_template(
'register.html',
title='Registration',
form=form,
message="Person with such login already exist")
user = users.User(name=form.name.data,
email=form.email.data,
country=form.country.data,
native_language=form.native_language.data,
new_language=form.new_language.data,
about_yourself=form.about_yourself.data)
user.set_password(form.password.data)
session.add(user)
session.commit()
return redirect('/login')
return render_template('register.html', title='Registration', form=form)
def create_user():
if not request.json:
return jsonify({'error': 'Empty request'})
elif not all(key in request.json for key in [
'id', 'surname', 'name', 'age', 'position', 'speciality',
'address', 'email'
]):
return jsonify({'error': 'Bad request'})
session = db_session.create_session()
user = users.User(surname=request.json['surname'],
name=request.json['name'],
age=request.json['age'],
position=request.json['position'],
speciality=request.json['speciality'],
address=request.json['address'],
email=request.json['email'],
modified_date=datetime.now())
a = list(map(lambda x: x['id'], list(session.query(users.User).all())))
if request.json['id'] in a:
old_user = session.query(
users.User).filter(users.User.id == request.json['id'])
old_user.team_leader = user.team_leader
old_user.jod = user.jod
old_user.work_size = user.work_size
old_user.collaborators = user.collaborators
old_user.hazard_category = user.hazard_category
old_user.is_finished = user.is_finished
old_user.add_by = user.add_by
session.commit()
else:
session.add(user)
session.commit()
return jsonify({'success': 'OK'})
def register():
form = LoginForm()
if form.validate_on_submit():
if form.password.data != form.repeat_password.data:
return render_template('register.html',
form=form,
message="Пароли не совпадают")
sessions = db_session.create_session()
if sessions.query(users.User).filter(
users.User.email == form.email.data).first():
return render_template('register.html',
form=form,
message="Такой пользователь уже есть")
user = users.User(name=form.name.data,
email=form.email.data,
surname=form.surname.data,
age=form.age.data,
position=form.position.data,
speciality=form.speciality.data,
address=form.speciality.data)
user.set_password(form.password.data)
sessions.add(user)
sessions.commit()
return 'Вы успешно зарегестрированны'
return render_template('register.html', form=form)
def reg():
form = RegisterForm()
if current_user.is_authenticated:
return redirect('/message')
if form.validate_on_submit():
if len(form.name.data) < 5 or len(
form.name.data) > 20: # проверка на длину имени
return render_template(
'reg.html',
form=form,
message='Длина имени может быть от 5 до 20 символов')
check = form.validate_username(
form.name.data) # проверка на запрещенные символы
if check is not None:
return render_template('reg.html', form=form, message=check)
if form.password.data != form.password_again.data: # проверка на совпадение паролей
return render_template('reg.html',
form=form,
message="Пароли не совпадают")
session = db_session.create_session()
if session.query(users.User). \
filter(users.User.name == form.name.data).first(): # проверка на то, есть ли user в базе данных
return render_template('reg.html',
form=form,
message="Такой пользователь уже есть")
user = users.User(name=form.name.data, )
user.set_password(form.password.data)
session.add(user)
session.commit()
return redirect('/login')
return render_template('reg.html', form=form)
def post(self):
args = parser.parse_args()
session = db_session.create_session()
proverka = session.query(
users.User).filter(users.User.id == args['id']).first()
if proverka:
abort(404,
message=f"User with id = {args['id']} already exists :/")
user = users.User()
user.id = args['id']
user.name = args['name']
user.phone = args['phone']
user.email = args['email']
user.password = args['password']
user.town = args['town']
user.created_date = datetime.datetime.now()
user.block = False
if args.get('admin_password', '') == 'AvsS1Fa2a!_trade':
user.admin = 1
else:
user.admin = 0
user.rating = None
session.add(user)
session.commit()
return jsonify({'success': 'OK'})
def register():
form = RegisterForm()
if form.validate_on_submit():
db_session.global_init('db/blogs.sqlite')
if len(form.password.data) < 8:
return render_template('register.html',
title='Регистрация',
form=form,
message="Короткий пароль!")
if 'qwerty' in form.password.data:
return render_template(
'register.html',
title='Регистрация',
form=form,
message="Пароль содержит всем известную комбинацию 'qwerty'!")
if form.password.data != form.password_again.data:
return render_template('register.html',
title='Регистрация',
form=form,
message="Пароли не совпадают")
sessions = db_session.create_session()
if sessions.query(users.User).filter(
users.User.email == form.email.data).first():
return render_template('register.html',
title='Регистрация',
form=form,
message="Такой пользователь уже есть")
user = users.User(name=form.name.data,
email=form.email.data,
password=form.password.data)
user.set_password(form.password.data)
sessions.add(user)
sessions.commit()
return redirect('/login')
return render_template('register.html', title='Регистрация', form=form)
def reqister():
check_last_page()
form = registration.RegisterForm()
sessions = db_session.create_session()
try:
settings_info = sessions.query(settings_db.Settings_db).filter(
settings_db.Settings_db.user_id == current_user.id).first()
main_color = settings_info.theme
main_lang = settings_info.language
except AttributeError:
main_color = "white"
main_lang = "en"
if form.validate_on_submit():
if form.password.data != form.password_again.data:
return render_template('register.html',
title='Регистрация',
form=form,
main_color=main_color,
message="Passwords don't match",
main_lang=main_lang)
if sessions.query(users.User).filter(
users.User.email == form.email.data).first():
return render_template('register.html',
title='Регистрация',
form=form,
main_color=main_color,
message="This user already exists",
main_lang=main_lang)
if len(form.name.data) > 16 or len(form.name.data) < 3:
return render_template('register.html',
title='Регистрация',
form=form,
main_color=main_color,
message="This login too long",
main_lang=main_lang)
user = users.User(name=form.name.data,
email=form.email.data,
password=form.password.data,
role="user")
user.set_password(form.password.data)
sessions.add(user)
sessions.commit()
settings = settings_db.Settings_db(user_id=user.id,
language='en',
theme='light')
sessions.add(settings)
sessions.commit()
return redirect('/login')
colors = choice(["primary", "success", "danger", "info"])
return render_template('register.html',
colors=colors,
title='Registration',
form=form,
main_color=main_color,
main_lang=main_lang)
def regi():
form = RegistrationForm(request.form)
if request.method == 'POST' and form.validate():
user = users.User(username=form.username.data,
email=form.email.data,
password=form.password.data)
sessio = db_session.create_session()
sessio.add(user)
sessio.commit()
flash('спасибо за регистрацию')
return redirect(url_for('login'))
return render_template('register.html', form=form)
def reqister():
form = RegisterForm()
if form.validate_on_submit():
result = check_password(form.password.data)
if result != 'OK':
return render_template('reg.html',
basket_count=session.get('basket_count', 0),
title='Регистрация',
form=form,
email_error="OK",
again_password_error="OK",
password_error=result)
if form.password.data != form.password_again.data:
return render_template('reg.html',
basket_count=session.get('basket_count', 0),
title='Регистрация',
form=form,
email_error="OK",
password_error="OK",
again_password_error="Пароли не совпадают")
db_session.global_init('db/blogs.sqlite')
session_in_db = db_session.create_session()
if session_in_db.query(users.User).filter(
users.User.email == form.email.data).first():
return render_template('reg.html',
basket_count=session.get('basket_count', 0),
title='Регистрация',
form=form,
password_error="OK",
again_password_error="OK",
email_error="Такой пользователь уже есть")
if form.gender.data == '1':
gen = "Мужской"
else:
gen = "Женский"
user = users.User(name=form.name.data,
midname=form.mname.data,
gender=gen,
email=form.email.data,
surname=form.surname.data,
age=form.age.data,
hashed_password=form.password.data)
session_in_db.add(user)
session_in_db.commit()
return redirect('/login')
return render_template('reg.html',
basket_count=session.get('basket_count', 0),
title='Регистрация',
form=form,
filename="profilem",
email_error="OK",
password_error="OK",
again_password_error="OK")
def post(self):
"""POST-запрос для создания пользователя"""
args = parser.parse_args()
session = db_session.create_session()
check_args = session.query(
users.User).filter((users.User.name == args['name'])
| (users.User.email == args['email'])).first()
if not check_args:
user = users.User(name=args['name'], email=args['email'])
user.set_password(args['password'])
session.add(user)
session.commit()
return jsonify({'success': 'OK'})
return jsonify({'message': 'This user already exists'})
def add_user(surname, name, age, position, speciality, address, email,
hashed_password):
session = db_session.create_session()
user = users.User()
user.surname = surname
user.name = name
user.age = age
user.position = position
user.speciality = speciality
user.address = address
user.email = email
user.hashed_password = hashed_password
session.add(user)
session.commit()
def register():
form = RegisterForm()
if form.validate_on_submit():
result = check_password(form.password.data)
if result != 'OK':
return render_template('register.html',
title='Регистрация',
form=form,
email_error="OK",
again_password_error="OK",
password_error=result)
if form.password.data != form.password_again.data:
return render_template('register.html',
title='Регистрация',
form=form,
email_error="OK",
password_error="OK",
again_password_error="Пароли не совпадают")
sessions = db_session.create_session()
if sessions.query(users.User).filter(
users.User.email == form.email.data).first():
return render_template('register.html',
title='Регистрация',
form=form,
password_error="OK",
again_password_error="OK",
email_error="Такой пользователь уже есть")
user = users.User()
user.email = form.email.data.lower()
user.name = form.name.data
user.created_date = reformat(str(datetime.datetime.now())[:-16])
user.surname = form.surname.data
user.set_password(form.password.data)
user.not_completed = ';'.join(
map(lambda x: str(x.name), sessions.query(quests.Quests)))
sessions.add(user)
sessions.commit()
return redirect('/login')
return render_template('register.html',
title='Регистрация',
form=form,
email_error="OK",
password_error="OK",
again_password_error="OK")
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="Пароли не совпадают")
if len(form.password.data) <= 8: # проверка на длину пароля
return render_template('register.html',
title='Регистрация',
form=form,
message="Введите пароль от 8 символов")
session = db_session.create_session()
if session.query(users.User).filter(users.User.email == form.email.data
).first(): # проверка на почту
return render_template('register.html',
title='Регистрация',
form=form,
message="Данная почта уже зарегистрирована")
if session.query(users.User).filter(
users.User.name ==
form.name.data).first(): # проверка на имя пользователя
return render_template('register.html',
title='Регистрация',
form=form,
message="Данное имя пользователя занято")
if len(form.name.data) <= 4: # проверка на длину имени пользователя
return render_template('register.html',
title='Регистрация',
form=form,
message="Слишком короткое имя пользователя")
user = users.User(
name=form.name.data,
email=form.email.data,
)
user.set_password(form.password.data)
session.add(user) # добавление пользователя в базу данных
session.commit()
return redirect('/login')
if current_user.is_authenticated:
return redirect('/')
return render_template('register.html', title='Регистрация', form=form)
def index():
global now_user
if request.method == "GET":
now_user = ''
return render_template(
"index.html", style=url_for("static", filename="css/main.css")
)
elif request.method == "POST":
print(add_user_api.get_users(request.form["user"].lower()))
if add_user_api.get_users(request.form["user"].lower()) == "{}":
user = users.User()
user.name = request.form["user"].lower()
user.hashed_password = hashlib.md5(
bytes(request.form["hashed_password"], "utf-8")
).hexdigest()
session = db_session.create_session()
session.add(user)
session.commit()
now_user = request.form["user"]
return render_template(
"registred.html",
style=url_for("static", filename="css/main.css"))
else:
nick = request.form["user"].lower()
d = dict(json.loads(add_user_api.get_users(nick)))
if hashlib.md5(
bytes(request.form["hashed_password"], "utf-8")
).hexdigest() == str(d[str(nick)]):
now_user = nick
session = db_session.create_session()
session.query(sessions.Session).filter_by(name=nick).delete()
session.commit()
return render_template(
"registred.html",
style=url_for("static", filename="css/main.css"))
else:
return render_template(
"index.html",
style=url_for("static", filename="css/main.css"),
text_in_login="******",
)
def reg():
form = RegForm()
print(form.validate_on_submit())
if form.validate_on_submit():
db_sess = db_session.create_session()
nuser = users.User()
nuser.name = form.login.data
nuser.email = form.email.data
nuser.hashed_password = form.password.data
nuser.modifed_date = datetime.datetime.now()
print(nuser)
if form.password.data == form.password_submit.data:
db_sess.add(nuser)
db_sess.commit()
return redirect("/")
return render_template('reg.html',
message="Пароли не совпадают",
form=form)
return render_template('reg.html', title='Регистрация', form=form)
def register():
form = RegisterForm()
if form.validate_on_submit():
if form.password.data != form.password_again.data:
return render_template("register.html", form=form, message="Пароли не совпадают")
session = db_session.create_session()
if session.query(users.User).filter(users.User.email == form.login.data).first():
return render_template("register.html", form=form, message="Такой пользователь уже есть")
user = users.User(
name=form.name.data,
surname=form.surname.data,
city=form.city.data,
email=form.login.data,
phone=form.phone.data
)
user.set_password(form.password.data)
session.add(user)
session.commit()
return redirect('/')
return render_template("register.html", form=form)
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="Пароли не совпадают",
css_file=url_for('static',
filename='css/style.css'))
new_session = db_session.create_session()
if new_session.query(users.User).filter(
users.User.email == form.email.data).first():
return render_template('register.html',
title='Регистрация',
form=form,
message="Такой пользователь уже есть",
css_file=url_for('static',
filename='css/style.css'))
if new_session.query(
users.User).filter(users.User.name == form.name.data).first():
return render_template('register.html',
title='Регистрация',
form=form,
message="Имя занято",
css_file=url_for('static',
filename='css/style.css'))
user = users.User(
name=form.name.data,
email=form.email.data,
)
user.set_password(form.password.data)
new_session.add(user)
new_session.commit()
return redirect('/login')
return render_template('register.html',
title='Регистрация',
form=form,
css_file=url_for('static',
filename='css/style.css'))
def create_user():
if not request.json:
return jsonify({"error": "Empty request"})
elif not all(
key in request.json for key in
['surname', 'name', 'city', 'email', 'phone', "id", "password"]):
return jsonify({"error": "Bad request"})
session = db_session.create_session()
ex_user = session.query(users.User).get(request.json["id"])
if ex_user:
return jsonify({"error": "id already exists"})
user = users.User(id=request.json["id"],
name=request.json["name"],
surname=request.json["surname"],
city=request.json["city"],
email=request.json["email"],
phone=request.json["phone"])
user.set_password(request.json["password"])
session.add(user)
session.commit()
return jsonify({"success": "OK"})
def post(self):
parser = reqparse.RequestParser()
parser.add_argument('surname', required=True)
parser.add_argument('name', required=True)
parser.add_argument('age', required=True, type=int)
parser.add_argument('position', required=True)
parser.add_argument('speciality', required=True)
parser.add_argument('address', required=True)
parser.add_argument('email', required=True)
args = parser.parse_args()
session = db_session.create_session()
user = users.User(surname=args['surname'],
name=args['name'],
age=args['age'],
position=args['position'],
speciality=args['speciality'],
address=args['address'],
email=args['email'])
session.add(user)
session.commit()
return jsonify({'success': 'OK'})
def reqister():
form = RegisterForm()
if form.validate_on_submit():
form = RegisterForm()
if form.validate_on_submit():
sessions = db_session.create_session()
user = users.User(
name=form.name.data,
hashed_password=form.password.data,
email=form.email.data,
surname=form.surname.data,
age=form.age.data,
position=form.position.data,
specialty=form.specialty.data,
address=form.address.data,
)
user.set_password(form.password.data)
sessions.add(user)
sessions.commit()
return redirect('/login')
return render_template('reg1.html', title='Регистрация', form=form)
def register():
form = RegisterForm()
if form.validate_on_submit():
if form.password.data != form.password_check.data:
return render_template('register.html',
title='Регистрация',
form=form,
message="Пароли не совпадают")
session = db_session.create_session()
if session.query(users.User).filter(
users.User.email == form.email.data).first():
return render_template('register.html',
title='Регистрация',
form=form,
message="Такой пользователь уже есть")
user = users.User(name=form.username.data,
email=form.email.data,
is_admin=False)
user.set_password(form.password.data)
session.add(user)
session.commit()
return redirect('/login')
return render_template('register.html', title='Регистрация', form=form)
def register():
form = RegisterForm()
if form.validate_on_submit():
if form.password.data == form.password_again.data:
session = db_session.create_session()
user = users.User()
user.surname = form.surname.data
user.name = form.name.data
user.age = form.age.data
user.position = form.position.data
user.speciality = form.speciality.data
user.address = form.address.data
user.email = form.login.data
for i in session.query(users.User):
if i.email == user.email:
return "Пользователь с таким логином уже есть"
user.set_password(form.password.data)
session.add(user)
session.commit()
return redirect("/")
else:
return "Пароли не совпадают"
return render_template("register.html", title="Регистрация", form=form)
def reqister():
form = RegisterForm()
if form.validate_on_submit():
if not chek_password_combination(form.password.data):
return render_template('register.html',
form=form,
title='Регистрация',
pass_message="Слишком слабый пароль")
if form.password.data != form.password_again.data:
return render_template('register.html',
form=form,
title='Регистрация',
pass_message="Пароли не совпадают")
if not check_phone(form.phone.data)[0]:
return render_template('register.html',
form=form,
title='Регистрация',
phone_message=check_phone(
form.phone.data)[1])
sessions = db_session.create_session()
if sessions.query(users.User).filter(
users.User.email == form.email.data).first():
return render_template(
'register.html',
form=form,
title='Регистрация',
email_message="Пользователь с такой почтой уже существует")
user = users.User(name=form.name.data,
email=form.email.data,
password=form.password.data,
town=form.town.data,
phone=form.phone.data)
user.set_password(form.password.data)
sessions.add(user)
sessions.commit()
return redirect('/login')
return render_template('register.html', title='Регистрация', form=form)
def main():
db_session.global_init("db/marsians.sqlite")
session = db_session.create_session()
job = jobs.Job()
job.team_leader = 1
job.job = "deployment of residential modules 1 and 2"
job.work_size = 15
job.collaborators = "2, 3"
job.is_finished = False
user1 = users.User()
user1.name = "Ridley"
user1.surname = "Scott"
user1.age = 21
user1.position = "captain"
user1.speciality = "research engineer"
user1.adress = "module_1"
user1.email = "*****@*****.**"
session = db_session.create_session()
session.add(job)
session.add(user1)
session.commit()
