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 = "*****@*****.**" user.hashed_password = "******" db_sess = db_session.create_session() db_sess.add(user) db_sess.commit() user = User() user.surname = "Stepanova" user.name = "Darya" user.age = 16 user.position = "the second captain" user.speciality = "main system programmer" user.address = "module_1" user.email = "*****@*****.**" user.hashed_password = "******" db_sess = db_session.create_session() db_sess.add(user) db_sess.commit() user = User() user.surname = "Ononas" user.name = "Ray" user.age = 19 user.position = "captain" user.speciality = "gravity engineer" user.address = "module_4" user.email = "*****@*****.**" user.hashed_password = "******" db_sess = db_session.create_session() db_sess.add(user) db_sess.commit() user = User() user.surname = "Lightwood" user.name = "Jeffrey" user.age = 29 user.position = "main soldier" user.speciality = "weapon checker" user.address = "module_5" user.email = "*****@*****.**" user.hashed_password = "******" db_sess = db_session.create_session() db_sess.add(user) db_sess.commit()
def main(): db_session.global_init("db/blogs.db") session = 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 = '*****@*****.**' col1 = User() col1.surname = 'Derkach' col1.name = 'Dima' col1.age = '23' col1.position = 'polomoishik' col1.speciality = 'research engineer' col1.address = 'module_1' col1.email = '*****@*****.**' col2 = User() col2.surname = 'Kaha' col2.name = 'Sergo' col2.age = '26' col2.position = 'polomoishik' col2.speciality = 'research engineer' col2.address = 'module_1' col2.email = '*****@*****.**' col3 = User() col3.surname = 'Alex' col3.name = 'Boiko' col3.age = '21' col3.position = 'pilot' col3.speciality = 'research engineer' col3.address = 'module_1' col3.email = '*****@*****.**' job1 = Jobs() job1.team_leader = 1 job1.job = 'deployment of residential modules 1 and 2' job1.work_size = 15 job1.collaborators = '2, 3' session.add(user) session.add(col1) session.add(col2) session.add(col3) session.add(job1) session.commit() app.run(port=8080, host='127.0.0.1')
def main(): db_session.global_init("db/mars_explorer.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 = "*****@*****.**" user.hashed_password = "******" db_sess = db_session.create_session() db_sess.add(user) db_sess.commit() user2 = User() user2.surname = "John" user2.name = "Gastings" user2.age = 30 user2.position = "coock" user2.speciality = "coocks food" user2.address = "module_2" user2.email = "*****@*****.**" user2.hashed_password = "******" db_sess = db_session.create_session() db_sess.add(user2) db_sess.commit() user3 = User() user3.surname = "Majer" user3.name = "Bambula" user3.age = 25 user3.position = "security captain" user3.speciality = "security" user3.address = "module_3" user3.email = "*****@*****.**" user3.hashed_password = "******" db_sess = db_session.create_session() db_sess.add(user3) db_sess.commit() user4 = User() user4.surname = "Arthur" user4.name = "Reigan" user4.age = 54 user4.position = "chemist" user4.speciality = "chemist" user4.address = "module_4" user4.email = "*****@*****.**" user4.hashed_password = "******" db_sess = db_session.create_session() db_sess.add(user4) db_sess.commit()
def main(): db_session.global_init("db/blogs.sqlite") captain = User() captain.surname = 'Scott' captain.name = 'Ridley' captain.age = 21 captain.position = 'captain' captain.speciality = 'research engineer' captain.address = 'module_1' captain.email = '*****@*****.**' user1 = User() user1.surname = 'Max' user1.name = 'Riddel' user1.age = 47 user1.position = 'ex-captain' user1.speciality = 'physic engineer' user1.address = 'module_7' user1.email = '*****@*****.**' user2 = User() user2.surname = 'Scaut' user2.name = 'Cherly' user2.age = 31 user2.position = 'high enginer' user2.speciality = 'theory engineer' user2.address = 'module_4' user2.email = '*****@*****.**' user3 = User() user3.surname = 'Presnyakov' user3.name = 'Nikita' user3.age = 28 user3.position = 'mechanic' user3.speciality = 'mechanic' user3.address = 'module_2' user3.email = '*****@*****.**' job1 = Jobs() job1.team_leader = 1 job1.job = 'deployment of residential modules 1 and 2' job1.work_size = 15 job1.collaborators = '2, 3' job1.start_date = '(now)' job1.is_finished = False session = db_session.create_session() session.add(captain) session.add(user1) session.add(user2) session.add(user3) session.add(job1) session.commit() app.run()
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 = "*****@*****.**" db_sess = db_session.create_session() db_sess.add(user) user2 = User() user2.surname = 'Nastya' user2.name = "Peace" user2.age = "13" user2.position = 'serjant' user2.speciality = 'research engineer' user2.address = 'module_2' user2.email = "*****@*****.**" db_sess = db_session.create_session() db_sess.add(user2) user3 = User() user3.surname = 'Ivan' user3.name = "Ivanov" user3.age = "19" user3.position = 'cap' user3.speciality = 'research engineer' user3.address = 'module_3' user3.email = "*****@*****.**" db_sess = db_session.create_session() db_sess.add(user3) user4 = User() user4.surname = 'Nyton' user4.name = "Zendea" user4.age = "24" user4.position = 'op op' user4.speciality = 'research engineer' user4.address = 'module_4' user4.email = "*****@*****.**" db_sess = db_session.create_session() db_sess.add(user4) db_sess.commit()
def create_user(): session = db_session.create_session() 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', 'city_from', 'password']): return jsonify({'error': 'Missing some keys to create, you need keys to create:' 'id, surname, name, age, position, speciality, address, email, city_from, password'}) if session.query(User).get(request.json.get('id')): print('Id already exists') session = db_session.create_session() user = User() user.id = request.json.get('id') user.surname = request.json.get('surname') user.name = request.json.get('name') user.age = request.json.get('age') user.position = request.json.get('position') user.speciality = request.json.get('speciality') user.address = request.json.get('address') user.email = request.json.get('email') user.city_from = request.json.get('city_from') user.set_passwor(request.json.get('password')) session.add(user) session.commit() return jsonify({'success': 'OK'})
def register(): if request.method == 'GET': return render_template('register_form.html', title='Register form', warning='') elif request.method == 'POST': session = db_session.create_session() user = User() user.surname = request.form['surname'] user.name = request.form['name'] user.age = int(request.form['age']) user.position = request.form['position'] user.speciality = request.form['speciality'] user.address = request.form['address'] user.email = request.form['email'] user.set_password(request.form['password']) if request.form['password'] != request.form['repeat']: return render_template('register_form.html', title='Register form', warning='Passwords are different!') session.add(user) session.commit() return 'Sent<br>' + str(user)
def login(): form = LoginForm() if request.method == 'GET': if form.validate_on_submit(): return redirect('/success') return render_template('login.html', title='Авторизация', form=form) elif request.method == 'POST': db_session.global_init('db/mars_explorer.sqlite') session = db_session.create_session() data = [i.email for i in session.query(User).all()] if form.email.data in data: return 'Error email' if form.password_first.data != form.password_second.data: return 'Error password' user = User() user.email = form.email.data user.name = form.name.data user.surname = form.surname.data user.age = form.age.data user.position = form.position.data user.speciality = form.speciality.data user.address = form.address.data user.hashed_password = form.password_second.data session.add(user) session.commit() return 'OK'
def reqister(): db_session.global_init("db/information.sqlite") 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(User).filter(User.email == form.email.data).first(): return render_template('register.html', title='Регистрация', form=form, message="Такой пользователь уже есть") user = User() user.email = form.email.data user.set_password(form.password.data) 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.modifed_date = datetime.datetime.now() session = db_session.create_session() session.add(user) session.commit() return '<h1>Данные сохранены!</h1>' return render_template('register.html', title='Регистрация', form=form)
def add_user(): password = False email = False form = RegisterForm() if form.hashed_password.data != form.confirm_password.data: password = True db_sess = db_session.create_session() emails = [] for user in db_sess.query(User).all(): emails.append(user.email) if form.email.data in emails: email = True if form.validate_on_submit() and not password and not email: user = 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.email.data user.set_password(form.hashed_password.data) db_sess.add(user) db_sess.commit() login_user(user) return redirect('/') return render_template('register.html', title='Регистрация', password=password, email=email, form=form)
def register(): form = RegisterForm() if form.validate_on_submit(): session = database_session.create_session() if session.query(User).filter(User.email == form.email.data).first(): params = { "title": "Регистрация", "form": form, "message": "Такой пользователь уже есть" } return render_template('register.html', **params) user = 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['email'].data user.set_password(form['password'].data) session.add(user) session.commit() return redirect('/login') params = {"title": "Регистрация", "form": form, "message": False} return render_template("register.html", **params)
def register(): if request.method == "GET": form = RegisterForm() return render_template("register.html", form=form) else: email = request.form["email"] password = request.form["password"] repeat_password = request.form["repeat_password"] surname = request.form["surname"] name = request.form["name"] age = request.form["age"] position = request.form["position"] speciality = request.form["speciality"] address = request.form["address"] if password != repeat_password: return "You didn't enter the same password" db_session.global_init("db/blogs.sqlite") session = db_session.create_session() user = User() user.email = email user.hashed_password = sha1(password.encode()).hexdigest() user.surname = surname user.name = name user.age = age user.position = position user.speciality = speciality user.address = address session.add(user) session.commit() return redirect("/success")
def register(): form = RegistrationForm() if form.validate_on_submit(): email = request.form.get('email') pasword = request.form.get('password') Repeat_password = request.form.get('Repeat_password') surname = request.form.get('surname') name = request.form.get('name') age = request.form.get('age') if pasword == Repeat_password: user = User() user.name = name user.surname = surname user.email = email user.age = age user.hashed_password = hashlib.md5( pasword.encode('utf-8')).hexdigest() db_session.global_init("db/olymp.sqlite") session = db_session.create_session() count = 0 for user in session.query(User).filter(User.email == email): count += 1 if count == 0: session.add(user) session.commit() return redirect('/login') return render_template('login.html', title='Авторизация', form=form)
def register_user(): if current_user.is_authenticated: return redirect('/') form = RegisterForm() if form.validate_on_submit(): user = User() us = db_sess.query(User).filter(User.login == form.login.data).all() if us: render_template( 'register.html', title='User registration', form=form, message="Пользователь с таким логином уже существует") else: user.login = form.login.data if form.pwd.data != form.pwd_sec.data: form.pwd_sec.errors = ['Пароли не совпадают'] return render_template('register.html', title='Registration', form=form) user.set_password(form.pwd.data) user.surname = form.surname.data user.name = form.name.data user.age = form.age.data user.description = form.description.data db_sess.add(user) db_sess.commit() login_user(user) return redirect('/') return render_template('register.html', title='Registration', form=form)
def register(): # регистрация form = RegisterForm() if form.validate_on_submit(): db_sess = db_session.create_session() # проверка почты на уникальность if check_email(db_sess, form.email.data): return render_template( 'register.html', registerform=form, message= "Пользователь с таким почтовым адресом уже зарегистрирован", title='Регистрация') # Создание нового пользователя в базе данный user = User() user.surname = form.surname.data user.name = form.name.data user.email = form.email.data user.set_password(form.password.data) user.age = form.age.data user.about = form.about.data db_sess.add(user) db_sess.commit() login_user(user, remember=form.remember_me.data) # сохраняем дефолтную картинку как аватар пользователя default_path = 'static/img/default_person_img.png' copy(default_path, f'static/img/profile_img/{current_user.id}.png') return redirect("/") return render_template('register.html', registerform=form, title='Регистрация')
def register(): form = RegisterForm() if form.validate_on_submit(): session = db_session.create_session() user = session.query(User).filter( User.email == form.email.data).first() if not user and form.password and form.password_repeat.data == form.password.data: user = User() user.name = form.name.data user.email = form.email.data user.hashed_password = form.password.data user.surname = form.surname.data user.position = form.position.data user.speciality = form.speciality.data user.age = form.age.data user.address = form.address.data user.city_form = form.city.data user.modified_date = datetime.datetime.now() session.add(user) session.commit() return redirect("/") return render_template( 'register.html', message="несовпадение паролей или пользователь уже зарегистрирован", form=form) return render_template('register.html', title='Регистрация', form=form, text='Наше приложение')
def register(): form = RegisterForm() if form.validate_on_submit(): db_session.global_init("db/mars.db") db_sess = db_session.create_session() user = db_sess.query(User).filter( User.email == form.login_or_mail.data).first() if user: return render_template('register_form.html', form=form, message='Колонист с такой почтой уже есть!') if form.repeat_password.data != form.password.data: return render_template('register_form.html', form=form, message='Введенные пароли не совпадают!') user = 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_or_mail.data user.set_password(form.password.data) db_sess.add(user) db_sess.commit() return redirect('/register') return render_template('register_form.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="Пароли не совпадают") 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="Такой пользователь уже есть") user = 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.email.data user.set_password(form.password.data) db_sess.add(user) db_sess.commit() return redirect('/') return render_template('register.html', title='Регистрация', form=form)
def post(self): args = parser.parse_args() if not all( key in args for key in ['id', 'surname', 'name', 'age', 'nickname', 'email', 'password']): raise_error('Missing some keys to create, you need keys to create:' 'id, surname, name, age, nickname, email, password') session = db_session.create_session() if session.query(User).get(args['id']): raise_error('Id already exists') if session.query(User).filter(User.email == args['email']).first(): raise_error("This email already exists") if session.query(User).filter(User.email == args['nickname']).first(): raise_error("This nickname already exists") res = check_password(args['password']) if not res[0]: raise_error(res[1]) user = User() user.id = args['id'] user.name = args['name'] user.surname = args['surname'] user.age = args['age'] user.nickname = args['nickname'] user.status = 0 user.email = args['email'] user.background_image_id = 0 user.set_password(args['password']) user.created_date = datetime.datetime.now() session.add(user) session.commit() return jsonify({'success': f'User {args["email"]} created'})
def register(): form = RegisterForm() if form.validate_on_submit(): db_sess = db_session.create_session() user = User() user.surname = form.surname.data user.name = form.name.data user.email = form.email.data user.set_password(form.password.data) user.age = form.age.data user.about = form.about.data db_sess.add(user) db_sess.commit() login_user(user, remember=form.remember_me.data) default_path = 'static/img/default_person_img.png' copy(default_path, f'static/img/profile_img/{current_user.id}.png') mini_path = f'static/img/profile_img/{current_user.id}_mini.png' copy(default_path, mini_path) img = Image.open(mini_path) resize_img = img.resize((100, 100)) resize_img.save(mini_path) return redirect("/") return render_template('register.html', registerform=form, title='Регистрация', saying=choice(SAYINGS))
def add_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', 'password', 'email', 'city_from']): return jsonify({'error': 'Bad request'}) session = db_session.create_session() if session.query(User).filter(User.id == request.json['id']).first(): return jsonify({'error': 'Id already exists'}) user = User() user.id = request.json['id'] user.surname = request.json['surname'] user.name = request.json['name'] user.age = request.json['age'] user.position = request.json['position'] user.speciality = request.json['speciality'] user.address = request.json['address'] user.email = request.json['email'] user.city_from = request.json['city_from'] user.set_password(request.json['password']) session.add(user) session.commit() return jsonify({'success': 'OK'})
def main(): db_session.global_init("db/blogs.db") info = [[ "Scott", "Ridley", 21, "captain", "research engineer", "module_1", "*****@*****.**" ], [ "Jack", "PewDiePie", 35, "corporal", "programmer", "module_2", "*****@*****.**" ], [ "Jack", "Levi", 34, "corporal", "strategist", "module_3", "*****@*****.**" ]] for surname, name, age, position, speciality, address, email in info: user = User() user.surname = surname user.name = name user.age = age user.position = position user.speciality = speciality user.address = address user.email = email db_sess = db_session.create_session() db_sess.add(user) db_sess.commit()
def register(): session = db_session.create_session() form = RegisterForm(request.form) if request.method == "POST" and form.validate_on_submit(): if session.query(User).filter(User.email == form.login.data).first(): flash("Error with input Login: Invalid login") else: user = User() user.address = form.address.data user.position = form.position.data user.speciality = form.speciality.data user.surname = form.surname.data user.name = form.name.data user.email = form.login.data user.age = int(form.age.data) user.modified_date = datetime.datetime.now() user.set_password(form.password.data) session.add(user) session.commit() return redirect("/login") if form.errors: for k, v in form.errors.items(): flash(f"Error with input {k}: {v[0]}") return render_template("standart.html", base_title="Регистрация", st_title="Register", form=form, current_user=current_user, stpath=onepath)
def get_users(): session = db_session.create_session() if request.method == "GET": return jsonify([get_user(i).json for i in range(1, session.query(User).count() + 1)]) elif request.method == "POST": if not request.json: return jsonify({'error': 'Empty request'}) elif not all(key in (rj := request.json) for key in {'address', 'position', 'speciality', 'surname', 'name', 'login', 'age', 'password', 'city_from'}): return jsonify({'error': 'Bad request'}) elif session.query(Jobs).get(request.json['job_id']): return jsonify(error="Id already exists") user = User() user.address = request.json['address'] user.position = request.json['position'] user.speciality = request.json['speciality'] user.surname = request.json['surname'] user.name = request.json['name'] user.email = request.json['login'] user.city_from = request.json['city_from'] user.age = int(request.json['age']) user.modified_date = datetime.datetime.now() user.set_password(request.json['password']) session.add(user) session.commit() return jsonify(success="OK")
def reqister(): db_session.global_init("db/info.sqlite") form = RegisterForm() if request.method == 'POST' and 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(User).filter(User.email == form.email.data).first(): return render_template('register.html', title='Регистрация', form=form, message="Такой пользователь уже есть") user = User() user.name = form.name.data user.surname = form.surname.data user.email = form.email.data user.address = form.address.data user.age = int(form.age.data) user.set_password(form.password.data) session.add(user) session.commit() return redirect('/login') return render_template('register.html', title='Регистрация', form=form)
def main(): db_session.global_init("db/mars_explorer.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 = '*****@*****.**' db_sess = db_session.create_session() db_sess.add(user) db_sess.commit() user1 = User() user1.surname = 'Scott' user1.name = 'Mark' user1.age = 18 user1.position = 'navigator' user1.speciality = 'engineer' user1.address = 'module_2' user1.email = '*****@*****.**' db_sess = db_session.create_session() db_sess.add(user1) db_sess.commit() user2 = User() user2.surname = 'Smith' user2.name = 'Ellis' user2.age = 18 user2.position = 'doctor' user2.speciality = 'doctor' user2.address = 'module_3' user2.email = '*****@*****.**' db_sess = db_session.create_session() db_sess.add(user2) db_sess.commit() user3 = User() user3.surname = 'Smith' user3.name = 'Jane' user3.age = 20 user3.position = 'scientist' user3.speciality = 'scientist' user3.address = 'module_4' user3.email = '*****@*****.**' db_sess = db_session.create_session() db_sess.add(user3) db_sess.commit()
def main(): db_session.global_init("db/mars_explorer.db") captain = User() captain.surname = "Scott" captain.name = "Ridley" captain.age = 21 captain.position = "captain" captain.speciality = "research engineer" captain.address = "module_1" captain.email = "*****@*****.**" nurse = User() nurse.surname = "Ilusa" nurse.name = "Mary" nurse.age = 24 nurse.position = "colonist" nurse.speciality = "nurse" nurse.address = "module_4" nurse.email = "*****@*****.**" engineer = User() engineer.surname = "Shelly" engineer.name = "Smith" engineer.age = 36 engineer.position = "colonist" engineer.speciality = "engineer" engineer.address = "module_2" engineer.email = "*****@*****.**" cooker = User() cooker.surname = "Hanks" cooker.name = "Tom" cooker.age = 30 cooker.position = "colonist" cooker.speciality = "cooker" cooker.address = "module_8" cooker.email = "*****@*****.**" db_sess = db_session.create_session() db_sess.add(captain) db_sess.add(nurse) db_sess.add(engineer) db_sess.add(cooker) db_sess.commit()
def older_main(): db_session.global_init("mars_explorer.sqlite") session = db_session.create_session() user = User() user.surname = "Scott" user.name = 'Ridley' user.age = 21 user.position = 'captain' user.address = 'module_1' user.email = '*****@*****.**' session.add(user) user = User() user.surname = "Scott" user.name = 'Mark' user.age = 21 user.position = 'captain_helper' user.address = 'module_2' user.email = '*****@*****.**' session.add(user) user = User() user.surname = "DOCTOR" user.name = 'WHO' user.age = 1821 user.position = 'solder' user.address = 'TARDIS' user.email = '*****@*****.**' session.add(user) user = User() user.surname = "MASK" user.name = 'ILON' user.age = 31 user.position = 'sponser' user.address = 'Earth' user.email = '*****@*****.**' session.add(user) job = Jobs() job.team_leader = 1 job.job = 'deployment of residential modules 1 and 2' job.work_size = 15 job.collaborators = '2, 3' job.start_date = datetime.datetime.now() job.is_finished = False session.add(job) session.commit()
def main(): db_session.global_init("db/mars.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 = '*****@*****.**' user2 = User() user2.surname = "ќлег" user2.name = "≈ремичев" user2.age = 21 user2.position = 'captain' user2.speciality = "research engineer" user2.address = "module_1" user2.email = '*****@*****.**' user3 = User() user3.surname = "ќлег2" user3.name = "≈ремичев2" user3.age = 21 user3.position = 'captain' user3.speciality = "research engineer" user3.address = "module_1" user3.email = '*****@*****.**' user4 = User() user4.surname = "ќлег3" user4.name = "≈ремичев3" user4.age = 21 user4.position = 'captain' user4.speciality = "research engineer" user4.address = "module_1" user4.email = '*****@*****.**' db_sess = db_session.create_session() db_sess.add(user) db_sess.add(user2) db_sess.add(user3) db_sess.add(user4) db_sess.commit()
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 = "*****@*****.**" user1 = User() user1.surname = "Elton" user1.name = "Jhon" user1.age = 73 user1.position = "passenger" user1.speciality = "singer" user1.address = "module_4A" user1.email = "*****@*****.**" user2 = User() user2.surname = "Uzumaki" user2.name = "Naruto" user2.age = 33 user2.position = "VIP-guest" user2.speciality = "hokage" user2.address = "module_2" user2.email = "*****@*****.**" user3 = User() user3.surname = "Drawde" user3.name = "Nedwons" user3.age = 37 user3.position = "passenger" user3.speciality = "refugee" user3.address = "module_4B" user3.email = "*****@*****.**" db_sess = db_session.create_session() db_sess.add(user) db_sess.add(user2) db_sess.add(user1) db_sess.add(user3) db_sess.commit()