Exemplo n.º 1
0
 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'}
Exemplo n.º 2
0
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)
Exemplo n.º 3
0
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)
Exemplo n.º 4
0
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)
Exemplo n.º 5
0
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')
Exemplo n.º 6
0
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)
Exemplo n.º 7
0
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!")
Exemplo n.º 8
0
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)
Exemplo n.º 9
0
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
Exemplo n.º 10
0
 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'})
Exemplo n.º 11
0
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')
Exemplo n.º 12
0
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)
Exemplo n.º 13
0
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")
Exemplo n.º 14
0
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)
Exemplo n.º 15
0
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)
Exemplo n.º 16
0
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'})
Exemplo n.º 17
0
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")
Exemplo n.º 18
0
 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'})
Exemplo n.º 20
0
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'})
Exemplo n.º 21
0
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)
Exemplo n.º 22
0
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)
Exemplo n.º 23
0
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
Exemplo n.º 24
0
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
Exemplo n.º 25
0
 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
Exemplo n.º 27
0
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='Регистрация в электронной библиотеке')
Exemplo n.º 28
0
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)
Exemplo n.º 29
0
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")
Exemplo n.º 30
0
 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'})