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 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")
