def edit_user(): form = UserForm() if request.method == 'GET': user_id = request.args.get('user_id') db = OracleDb() user = db.sqlalchemy_session.query(ormUser).filter(ormUser.user_id == user_id).one() form.user_phone.data = user.user_phone form.user_name.data = user.user_name form.user_email.data = user.user_email return render_template('user_form.html', form=form, form_name="Edit user", action="edit_user") else: if form.validate() == False: return render_template('user_form.html', form=form, form_name="Edit user", action="edit_user") else: db = OracleDb() # find user user = db.sqlalchemy_session.query(ormUser).filter(ormUser.user_id == form.user_id.data).one() # update fields from form data user_name.data = user.user_name user_surname.data = user.user_email db.sqlalchemy_session.commit() return redirect(url_for('user'))
def edit_user(): form = UserForm() if request.method == 'GET': user_id =request.args.get('user_id') db = OracleDb() user = db.sqlalchemy_session.query(ormUser).filter(ormUser.user_id == user_id).one() # fill form and send to user form.user_id.data = user.user_id form.user_name.data = user.user_name form.user_department.data = user.user_department form.user_birthday.data = user.user_birthday form.user_email.data = user.user_email form.user_year.data = user.user_year return render_template('user_form.html', form=form, form_name="Edit user", action="edit_user") else: if form.validate() == False: return render_template('user_form.html', form=form, form_name="Edit user", action="edit_user") else: db = OracleDb() # find user user = db.sqlalchemy_session.query(ormUser).filter(ormUser.user_id == form.user_id.data).one() # update fields from form data user.user_department = form.user_department.data user.user_birthday = form.user_birthday.data.strftime("%d-%b-%y") user.user_email = form.user_email.data user.user_name = form.user_name.data user.user_year = form.user_year.data.strftime("%d-%b-%y") db.sqlalchemy_session.commit() return redirect(url_for('user'))
def create_user(): form = UserForm() next_id = None id_zero = db.session.query(OrmUser.user_id).all() if not id_zero: next_id = 1 else: next_id_prep = max(db.session.query(OrmUser.user_id).all()) next_id = next_id_prep[0] + 1 if request.method == 'POST': if form.validate(): try: new_user = OrmUser(user_id=next_id, user_name=form.user_name.data, user_age=form.user_age.data, user_email=form.user_email.data, skin_condition=form.skin_condition.data, eye_color=form.eye_color.data, hair_color=form.hair_color.data, lips_color=form.lips_color.data, skin_tone=form.skin_tone.data) db.session.add(new_user) db.session.commit() return render_template('success.html') except: return render_template('user_form.html', form=form) else: return render_template('user_form.html', form=form) elif request.method == 'GET': return render_template('user_form.html', form=form)
def index(): form = UserForm(request.form) if request.method == 'POST': if form.validate(): email = form.email.data u = User.query.filter_by(email=email).first() if not u: form.email.errors.append('Eamil is incorrect') elif not u.valid_password(form.password.data): form.password.errors.append('Password is incorrect') else: user_login(u) user = User.get(session.get('user_id')) user_id = user.id if user else 1 cats = Category.query.filter_by(user_id=user_id).order_by('title').all() results = [] for c in cats: webs = WebSite.query.filter('category_id=:category_id').params( category_id=c.id).all() if c.title == 'Default': results.insert(0, {c: webs}) else: results.append({c: webs}) step = min(len(results), 5) navis = [[] for i in range(step)] for n, r in enumerate(results): navis[n % step].append(r) return render_template('index.html', navis=navis, user=user, form=form)
def new_user(): form = UserForm() if request.method == 'POST': if form.valemailate() == False: return render_template('user_form.html', form=form, form_name="New user", action="new_user") else: new_user = ormUser( id=form.id.data, full_name=form.full_name.data, ) db = OracleDb() db.sqlalchemy_session.add(new_user) db.sqlalchemy_session.commit() return redirect(url_for('user')) return render_template('user_form.html', form=form, form_name="New user", action="new_user")
def new_user(): form = UserForm() if request.method == 'POST': if form.validate() == False: return render_template('user_form.html', form=form, form_name="New user", action="new_user") else: new_user = ormUser( user_studybook=form.user_studybook.data, user_birthday=form.user_birthday.data.strftime("%d-%b-%y"), user_email=form.user_email.data, user_name=form.user_name.data, user_year=form.user_year.data.strftime("%d-%b-%y")) db = OracleDb() db.sqlalchemy_session.add(new_user) db.sqlalchemy_session.commit() return redirect(url_for('user')) return render_template('user_form.html', form=form, form_name="New user", action="new_user")
def edit_user(): form = UserForm() if request.method == 'GET': email =request.args.get('email') db = OracleDb() user = db.sqlalchemy_session.query(ormUser).filter(ormUser.email == email).one() form.email.data = user.email form.full_name.data = user.full_name form.id.data = user.id return render_template('user_form.html', form=form, form_name="Edit user", action="edit_user") else: if form.valemailate() == False: return render_template('user_form.html', form=form, form_name="Edit user", action="edit_user") else: db = OracleDb() # find user user = db.sqlalchemy_session.query(ormUser).filter(ormUser.email == form.email.data).one() # update fields from form data user.id = form.id.data user.full_name = form.full_name.data db.sqlalchemy_session.commit() return redirect(url_for('user'))
def index(): form = UserForm(request.form) if request.method == 'POST': if form.validate(): email = form.email.data u = User.query.filter_by(email=email).first() if not u: form.email.errors.append('Eamil is incorrect') elif not u.valid_password(form.password.data): form.password.errors.append('Password is incorrect') else: user_login(u) user = User.get(session.get('user_id')) user_id = user.id if user else 1 cats = Category.query.filter_by(user_id=user_id).order_by('title').all() results = [] for c in cats: webs = WebSite.query.filter('category_id=:category_id').params(category_id=c.id).all() if c.title == 'Default': results.insert(0, {c: webs}) else: results.append({c: webs}) step = min(len(results), 5) navis = [[] for i in range(step)] for n, r in enumerate(results): navis[n % step].append(r) return render_template('index.html', navis=navis, user=user, form=form)
def create_user(): form = UserForm() if request.method == 'POST': if form.validate() and form.validate_date(): new_user = OrmUser( user_name=form.user_name.data, user_birthday=form.user_birthday.data.strftime("%Y-%m-%d"), user_email=form.user_email.data, user_phone=form.user_phone.data, user_location=form.user_location.data, user_employment=form.user_employment.data) db.session.add(new_user) db.session.commit() return render_template('success.html') else: if not form.validate_date(): form.user_birthday.errors = ['year should be more than 1900'] return render_template('user_form.html', form=form) elif request.method == 'GET': return render_template('user_form.html', form=form)
def root(): if login.isLogged: if login.isAdmin: return render_template('index.html') else: db = PostgresDb() user = db.sqlalchemy_session.query(Users).filter( Users.name == login.name, Users.password == login.password).all() tasks = db.sqlalchemy_session.query(Student_Task).filter( Student_Task.student_name == user[0].name, Student_Task.student_group == user[0].sgroup).all() return render_template('Student_index.html', tasks=tasks) else: form = UserForm() if request.method == 'GET': return render_template('login_form.html', form=form, form_name="Login", action="") else: if not form.validate(): return render_template('login_form.html', form=form, form_name="Login", action="") db = PostgresDb() # find professor user = db.sqlalchemy_session.query(Users).filter( Users.name == form.name.data, Users.password == form.password.data).all() if user: login.Login(name=user[0].name, password=user[0].password) tasks = db.sqlalchemy_session.query(Student_Task).filter( Student_Task.student_name == user[0].name, Student_Task.student_group == user[0].sgroup).all() return render_template('Student_index.html', tasks=tasks) elif form.name.data == 'admin' and form.password.data == 'admin': login.Login(name='admin', password='******', isAdmin=True) return render_template('index.html') else: return render_template('login_form.html', form=form, form_name="Login", action="")
def user_edit(id): if request.method == 'GET': user = get_data_by_id(Person, id) result = get_data(Person) form = UserForm() form.id.data = user.id form.first_name.data = user.first_name form.second_name.data = user.second_name form.birthday.data = user.birthday form.city.data = user.city return render_template('users.html', users=result, form=form)
def create_user(): form = UserForm() if request.method == 'POST': if form.validate(): try: new_user = OrmParameter( user_email=form.user_email.data, user_name=form.user_name.data, user_age=form.user_age.data, user_university=form.user_university.data) db.session.add(new_user) db.session.commit() return render_template('success.html') except: return render_template('user_form.html', form=form) else: return render_template('user_form.html', form=form) elif request.method == 'GET': return render_template('user_form.html', form=form)
def edit_user(): form = UserForm() if request.method == 'GET': user_id = request.args.get('user_id') db = OracleDb() user = db.sqlalchemy_session.query(OrmUser).filter( OrmUser.user_id == user_id).one() # fill form and send to user form.user_name.data = user.user_name form.user_login.data = user.user_login return render_template('user_form.html', form=form, form_name="Edit user", action="edit_user") else: if not form.validate(): return render_template('user_form.html', form=form, form_name="Edit user", action="edit_user") else: db = OracleDb() # find user user = db.sqlalchemy_session.query(OrmUser).filter( OrmUser.user_id == form.user_id.data).one() # update fields from form data user.user_id = form.user_id.data user.user_name = form.user_name.data user.user_login = form.user_login.data db.sqlalchemy_session.commit() return redirect(url_for('index_user'))
def create_user(): form = UserForm() if request.method == 'POST': new_user = OrmUser(user_id=form.user_id.data, user_name=form.user_name.data, user_age=form.user_age.data, skin_condition=form.skin_condition.data) db.session.add(new_user) db.session.commit() return render_template('success.html') elif request.method == 'GET': return render_template('user_form.html', form=form)
def new_user(): form = UserForm() if request.method == 'POST': if not form.validate(): return render_template('user_form.html', form=form, form_name="New user", action="new_user") else: user_obj = OrmUser(user_name=form.user_name.data, user_login=form.user_login.data) db = OracleDb() db.sqlalchemy_session.add(user_obj) db.sqlalchemy_session.commit() return redirect(url_for('index_user')) return render_template('user_form.html', form=form, form_name="New user", action="new_user")
def user_edit(): form = UserForm(request.form) data = form.data token = data.pop('csrf_token', None) if request.method == 'POST' and form.validate(): db = OracleDb() user_id = data.pop('user_id', None) if user_id: db.sqlalchemy_session.query(ormUser).filter_by( user_id=user_id).update(data) print(ormUser()) else: new_user = ormUser(**data) db.sqlalchemy_session.add(new_user) db.sqlalchemy_session.commit() return jsonify({'successed': True}) else: form_errors = {} errors = {} for key, value in form.errors.items(): errors[key] = ' '.join(value) form_errors['errors'] = errors return jsonify(form_errors)
def edit_user(id): form = UserForm() result = db.session.query(OrmUser).filter(OrmUser.user_id == id).one() if request.method == 'GET': form.user_name.data = result.user_name form.user_age.data = result.user_age form.user_email.data = result.user_email form.skin_condition.data = result.skin_condition form.eye_color.data = result.eye_color form.hair_color.data = result.hair_color form.lips_color.data = result.lips_color form.skin_tone.data = result.skin_tone return render_template('user_form.html', form=form, form_name='edit user') elif request.method == 'POST': if form.validate(): try: result.user_name = form.user_name.data result.user_age = form.user_age.data result.user_email = form.user_email.data result.skin_condition = form.skin_condition.data result.eye_color = form.eye_color.data result.hair_color = form.hair_color.data result.lips_color = form.lips_color.data result.skin_tone = form.skin_tone.data db.session.commit() return redirect('/users') except: return render_template('user_form.html', form=form) else: return render_template('user_form.html', form=form)
def create_user(): form = UserForm() if request.method == 'POST': new_user = OrmUser( user_name=form.user_name.data, user_birthday=form.user_birthday.data.strftime("%Y-%m-%d"), user_email=form.user_email.data, user_phone=form.user_phone.data, user_location=form.user_location.data, user_employment=form.user_employment.data) db.session.add(new_user) db.session.commit() return render_template('success.html') elif request.method == 'GET': return render_template('user_form.html', form=form)
def edit_user(id): form = UserForm() result = db.session.query(OrmUser).filter(OrmUser.user_id == id).one() if request.method == 'GET': form.user_id.data = result.user_id form.user_name.data = result.user_name form.user_age.data = result.user_age form.skin_condition.data = result.skin_condition return render_template('edit_user.html', form=form, form_name='edit user') elif request.method == 'POST': result.user_name = form.user_name.data result.user_age = form.user_age.data result.skin_condition = form.skin_condition.data db.session.commit() return redirect('/users')
def user(): result = get_data(Person) form = UserForm(request.form) if request.method == 'POST': print(form.id.data) if (form.id.data == ''): user = Person(int(random.getrandbits(31)), first_name=form.first_name.data, second_name=form.second_name.data, birthday=form.birthday.data, city=form.city.data) insert_data(user) else: user = Person(id=int(form.id.data), first_name=form.first_name.data, second_name=form.second_name.data, birthday=form.birthday.data, city=form.city.data) update_data(user, Person) save() return redirect('/user') return render_template('users.html', users=result, form=form)
def new_user(): form = UserForm() if request.method == 'POST':
def edit_user(): form = UserForm() if request.method == 'GET':