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':
