def post(self): args = parser.parse_args() db_sess = db_session.create_session() user = User( id=args['id'], surname=args['surname'], name=args['name'], age=args['age'], position=args['position'], speciality=args['speciality'], address=args['address'], email=args['email'], ) db_sess.add(user) db_sess.commit() return {404: 'OK'}
def register(): form = RegisterForm() if form.validate_on_submit(): if form.password.data != form.password_again.data: return render_template('registration.html', title='Регистрация', form=form, message="Пароли не совпадают") if len(form.password.data) < 8: return render_template( 'registration.html', title='Регистрация', form=form, message="Пароль не может быть короче 8 символов") if form.password.data.isalpha(): return render_template( 'registration.html', title='Регистрация', form=form, message="Пароль должен содержать хотя бы одну цифру") if form.password.data.isdigit(): return render_template( 'registration.html', title='Регистрация', form=form, message="Пароль должен содержать хотя бы одну букву") if form.password.data.isalnum(): return render_template( 'registration.html', title='Регистрация', form=form, message= "Пароль должен содержать хотя бы один символ отличный от " "букв и цифр") session = db_session.create_session() if session.query(User).filter(User.email == form.email.data).first(): return render_template('registration.html', title='Регистрация', form=form, message="Такой пользователь уже есть") user = User() user.surname = form.surname.data user.name = form.name.data user.email = form.email.data user.set_password(form.password.data) session.add(user) session.commit() return redirect('/login') return render_template('registration.html', title='Регистрация', form=form)
def main(): db_session.global_init("db/blogs.db") #app.run() user = User() # user.surname = 'Scott' # user.name = 'Ridley' # user.age = 21 # user.position = 'captain' # user.speciality = 'research engineer' # user.address = 'module_1' # user.email = '*****@*****.**' # user.hashed_password = '' # # db_sess = db_session.create_session() # db_sess.add(user) # db_sess.commit() # # user.surname = 'Dibirov' # user.name = 'MshD' # user.age = 41 # user.position = 'marshal' # user.speciality = 'great engineer' # user.address = 'base_module' # user.email = '*****@*****.**' # user.hashed_password = '' # # db_sess.add(user) # db_sess.commit() # # user.surname = 'Radjab' # user.name = 'Gadjiev' # user.age = 15 # user.position = 'junior' # user.speciality = 'stajer' # user.address = 'back_module' # user.email = '*****@*****.**' # user.hashed_password = '' # # db_sess.add(user) # db_sess.commit() db_sess = db_session.create_session() for user in db_sess.query(User).all(): print(user)
def start(update, context): print('go') print(session) users = list(map(lambda x: x.id, session.query(User).all())) id = update.message.from_user.id print('go 1') if id not in users: new = User(id=id, mode='en') session.add(new) session.commit() else: new = session.query(User).filter(User.id == id).first() text = TEXT[new.mode]['start'] update.message.reply_text(text)
def registration(): form = RegistrationForm() if form.validate_on_submit(): db_sess = db_session.create_session() user = User(surname=form.surname.data, name=form.name.data, age=form.age.data, email=form.email.data, hashed_password=form.password.data) db_sess.add(user) db_sess.commit() return redirect("/library/successful_registration") return render_template('registration.html', title='Регистрация', form=form, description='YLibrary')
def register(): form = RegistrationForm() if form.validate_on_submit(): session = db_session.create_session() user = User() user.name = form.name.data user.surname = form.surname.data user.age = form.age.data user.email = form.email.data user.hashed_password = bcrypt.generate_password_hash( form.password.data).decode('utf-8') session.add(user) session.commit() return redirect('login') return render_template('register.html', title='регистрация', form=form)
def start_handler(update, context): logger.info("User {} started bot".format(update.effective_user)) user = User() user.id = update.effective_user["id"] user.name = update.effective_user["username"] user.money = 100 user.parent_id = None db_sess = db_session.create_session() db_sess.add(user) db_sess.commit() update.message.reply_text("User successfully registered!")
def reqister(): form = RegisterForm() if form.validate_on_submit(): if form.password.data != form.password_again.data: return render_template('registration.html', title='Регистрация', form=form, message="Пароли не совпадают") session = db_session.create_session() if session.query(User).filter(User.email == form.email.data).first(): return render_template('registration.html', title='Регистрация', form=form, message="Такой пользователь уже есть") user = User() user.name = form.name.data user.email = form.email.data user.clas = form.clas.data user.occupation = form.occupation.data user.set_password(form.password.data) session.add(user) session.commit() return redirect('/login') return render_template('registration.html', title='Регистрация', form=form)
def sign_in_user(): global visits_count current_user = check_if_user_signed_in(request.cookies, db_sess) if current_user: return redirect("/users/game") else: res = User.authenticate_user(request.form["login"], request.form["password"], db_sess) user = res[0] user_session = res[1] if None == user: return redirect("/sign_in/user_not_found") else: res = make_response(redirect("/")) res.set_cookie("user_secret", str(user_session.value), max_age=60 * 60 * 24 * 365 * 2) return res
def post(self): args = parser.parse_args() session = db_session.create_session() users = User( id=args['id'], name=args['name'], surname=args['surname'], age=args['age'], position=args['position'], speciality=args['speciality'], address=args['address'], email=args['email'], hashed_password=args['hashed_password'], modified_date=datetime.datetime.now() ) session.add(users) session.commit() return jsonify({'success': 'OK'})
def activate(token): session = db_session.create_session() confirm_user = session.query(ConfirmUser).filter(ConfirmUser.token == token).first() if not confirm_user: return 'ошибка 404' username = confirm_user.name email = confirm_user.email password = confirm_user.hashed_password user = User( name=username, email=email, hashed_password=password ) session.add(user) session.delete(confirm_user) session.commit() session.close() return redirect('/login')
def client_login(): form = ClientLoginForm() if form.validate_on_submit(): session = db_session.create_session() user = session.query(User).filter(User.role == 'client').filter( User.phone_number == form.phone_number.data).first() if user: login_user(user, remember=True) return redirect('/') user = User(phone_number=form.phone_number.data, role='client') cart = Order(client=user) cart.update_total_cost() session.add(user) session.add(cart) session.commit() login_user(user, remember=True) return redirect('/') return render_template('login.html', title='Авторизация', form=form)
def register_post(): name = request.form.get("name") email = request.form.get("email") password = request.form.get("password") user = User.query.filter_by(email=email).first() if user: flash("This account already exists.") return redirect("/register") new_user = User(name=name, email=email, password=generate_password_hash(password, method="sha256")) db.session.add(new_user) db.session.commit() return redirect("/login")
def reg(): # регистрация form = RegisterForm() if form.validate_on_submit(): new_user = User() new_user.email = form.email.data new_user.hashed_password = generate_password_hash(form.password.data) new_user.surname = form.surname.data new_user.name = form.name.data new_user.age = form.age.data new_user.address = form.address.data user = db_sess.query(User).filter(User.email == form.email.data).first() if user: return render_template('register.html', message="Существует уже аккаунт", form=form) db_sess.add(new_user) db_sess.commit() return redirect('/') return render_template('register.html', title='Регистрация', form=form)
def registration(): form = RegisterForm() if form.validate_on_submit(): db_sess = create_session() req = db_sess.query(User).filter(User.email == form.mail.data) if len(form.password.data) >= 8 and len(list(req)) < 1: user = User() user.surname = form.surname.data user.name = form.name.data user.email = form.mail.data user.password = hashlib.md5( bytes(form.password.data.encode("utf-8"))).hexdigest() user.modified_date = datetime.now() db_sess.add(user) db_sess.commit() return redirect("/login") return render_template('registration.html', title='Регистрация', form=form)
def create_users(): 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']): return jsonify({'error': 'Bad request'}) elif any(request.json['id'] == item['id'] for item in get( 'http://localhost:5000/api/users').json()['users']): return jsonify({'error': 'Id already exists'}) db_sess = db_session.create_session() users = User(id=request.json['id'], surname=request.json['id'], name=request.json['name'], age=request.json['age'], position=request.json['position'], speciality=request.json['speciality']) db_sess.add(users) db_sess.commit() return jsonify({'success': 'OK'})
def sign_up(): username = request.args.get('username').lower() email = request.args.get('email').lower() password = request.args.get('password').lower() session = db_session.create_session() if session.query(User).filter(User.username == username).first(): return jsonify(error='Сіз жазған логин тіркелген') if session.query(User).filter(User.email == email).first(): return jsonify(error="Бұл e-mail тіркелген") generated_id = id_generator("User") user = User(email=email, username=username, password=generate_password_hash(password), generated_id=generated_id) session.add(user) session.commit() mkdir('users', generated_id) print('You were successfully logged in') return jsonify(error="No error")
def post(self): args = parser.parse_args() session = db_session.create_session() print(session.query(User).filter(User.email == args['email']).first()) if session.query(User).filter(User.email == args['email']).first(): abort(500, message="Пользователь с почтой: {} уже существует".format(args['email'])) user = User( name=args['name'], surname=args['surname'], age=args['age'], about=args['about'], position=args['position'], address=args['address'], speciality=args['speciality'], email=args['email'] ) session.add(user) session.commit() return jsonify({'success': 'OK'})
def create_users(): if not request.json: return jsonify({'error': 'Empty request'}) elif 'name' not in request.json: return jsonify({'error': 'Bad request'}) session = db_session.create_session() user = User( surname=request.json['surname'] if 'surname' in request.json else None, name=request.json['name'], age=request.json['age'] if 'age' in request.json else None, city_from=request.json['city_from'], position=request.json['position'] if 'position' in request.json else None, speciality=request.json['speciality'] if 'speciality' in request.json else None, address=request.json['address'] if 'address' in request.json else None, email=request.json['email'] if 'email' in request.json else None, hashed_password=request.json['hashed_password'] if 'hashed_password' in request.json else None, ) session.add(user) session.commit() return jsonify({'success': 'OK'})
def create_users(): if not request.json: return jsonify({'error': 'Empty request'}) elif not all(key in request.json for key in [ 'name', 'surname', 'age', 'about', 'position', 'address', 'speciality', 'email' ]): return jsonify({'error': 'Bad request'}) session = db_session.create_session() users = User(name=request.json['name'], surname=request.json['surname'], age=request.json['age'], about=request.json['about'], position=request.json['position'], address=request.json['address'], speciality=request.json['speciality'], email=request.json['email']) session.add(users) session.commit() return jsonify({'success': 'OK'})
def reqister(): form = RegisterForm() if form.validate_on_submit(): if not set(form.avatar_source.data.filename.lower()) <=\ set('abcdefghijklmnopqrstuvwxyz0123456789!\'#$' '%&\'()*+,-./:;<=>?@[\]^_`{|}~'): return render_template('register.html', title='Регистрация', form=form, message='Недопустимое название файла') if form.password_new.data != form.password_again.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( name=form.name.data, email=form.email.data, permission=form.permission.data, ) if form.phone_number.data: user.phone_number = form.phone_number.data if form.about.data: user.about = form.about.data if form.surname.data: user.surname = form.surname.data if form.avatar_source.data.filename: user.avatar_source = images.save(form.avatar_source.data) user.set_password(form.password_new.data) session.add(user) session.commit() return redirect('/login') return render_template('register.html', form=form)
def register(): if current_user.is_authenticated: return redirect('/') form = RegistrationForm() if form.validate_on_submit(): try: user = User(login=form.login.data, password=form.password.data) db_sess = db_session.create_session() db_sess.add(user) db_sess.commit() login_user(user, remember=form.remember_me.data) except: return render_template( 'login.html', title='Авторизация', message= "Аккаунт с таким именем уже существует или введены неккоректные данные", form=form) return redirect("/orders") return render_template('login.html', title='Регистрация', form=form)
def main(): if not os.path.exists("db"): os.makedirs("db") if not os.path.exists("uploads"): os.makedirs("uploads") db_session.global_init("db/website.sqlite") db_sess = db_session.create_session() try: admin = User('Admin', 'Admin', '*****@*****.**', 'admin') admin.set_password('admin') db_sess.add(admin) db_sess.commit() except: db_sess.rollback() for user in db_sess.query(User).all(): print(user) return app
def create_user(name: str, email: str, password: str) -> Optional[User]: if find_user_by_email(email): return None user = User() user.name = name user.email = email user.type = 'sme' user.password = hash_text(password) session = db_session.create_session() session.add(user) session.commit() return user
def post(self): args = UsersListResource.parser.parse_args() attributes = ['surname', 'name', 'age', 'address', 'email', 'telegram_name', 'aim'] session = db_session.create_session() exist = session.query(User).filter(User.id == args['id']).first() if exist: return jsonify({"message": "such user already exists"}) user = User( id=args['id'], surname=args['surname'], name=args['name'], age=args['age'], address=args['address'], password=args['password'], email=args['email'], aim=args['aim'], telegram_name=args['telegram_name'], ) session.add(user) session.commit() return jsonify({'success': 'OK - the user has been added'})
def do_some_queries(): print("{:,} projects | {:,} releases | {:,} users".format( Package.objects().count(), Release.objects().count(), User.objects().count() )) name = input("Enter a package name: ").strip().lower() # p = Package.objects(author='hfpython').first() t0 = datetime.datetime.now() p = list(Package.objects(author_email=name))[0] dt = datetime.datetime.now() - t0 print("Time elapsed: {:,} ms".format(dt.total_seconds()*1000)) print(p.id) # p = Package.objects(languages__name='Legacy Python').first() if not p: print("Sorry no package like that!") return
def registration(): form = RegistrationForm() if form.validate_on_submit(): db_sess = db_session.create_session() try: user = User(surname=form.surname.data, name=form.name.data, age=form.age.data, email=form.email.data, hashed_password=form.password.data) db_sess.add(user) db_sess.commit() return redirect("/library/successful_registration") except Exception: return render_template('registration.html', message="Недостаточно данных!", form=form) return render_template('registration.html', title='Регистрация', form=form, description='Регистрация в электронной библиотеке')
def reqister(): form = RegisterForm() if form.validate_on_submit(): if form.password.data != form.password_again.data: return render_template('register.html', title='Register', form=form, message="Passwords don't match") db_session.global_init('db/users_db.db') db_sess = db_session.create_session() if db_sess.query(User).filter(User.email == form.email.data).first(): return render_template('register.html', title='Register', form=form, message="This user already exists") user = User( name=form.name.data, surname=form.surname.data, email=form.email.data, hashed_password=form.password.data ) db_sess.add(user) db_sess.commit() return redirect('/login') return render_template('register.html', title='Регистрация', form=form)
def register(): form = RegisterForm() db_sess = db_session.create_session() if form.validate_on_submit(): new_user = User() if len( db_sess.query(User).filter( User.email == form.email.data).all()) != 0: return render_template("register.html", form=form, title="Register", message="This email already in use") new_user.email = form.email.data new_user.address = form.address.data if form.shortname.data != "": new_user.shortname = form.shortname.data new_user.name = form.name.data new_user.surname = form.surname.data new_user.hashed_password = generate_password_hash(form.password.data) db_sess.add(new_user) db_sess.commit() return redirect(f"/finish/{new_user.id}") return render_template("register.html", form=form, title="Register")
def post(self): args = parser.parse_args() session = db_session.create_session() if args['id'] <= 0: abort(404, message=f"Id must be > 0") may_b = session.query(User).filter(User.id == args['id']).first() if may_b: abort(404, message=f"User with id {args['id']} already exist") user = User(id=args['id'], email=args['email'], name=args['name'], surname=args['surname'], about=args['about'], age=args['age'], position=args['position'], speciality=args['speciality'], address=args['address'], hashed_password=args['hashed_password'], city_from=args['city_from']) session.add(user) session.commit() return jsonify({'success': 'OK'})