def profession():
result = get_data(Profession)
form = ProfessionForm(request.form)
if request.method == 'POST':
print(form.id.data)
if (form.id.data == ''):
print(form.name.data)
profession = Profession(
int(random.getrandbits(31)),
name=form.name.data,
minimal_work_expirience=int(form.minimal_work_expirience.data),
minimal_education=form.minimal_education.data,
category=form.category.data)
insert_data(profession)
else:
profession = Profession(
id=int(form.id.data),
name=form.name.data,
minimal_work_expirience=form.minimal_work_expirience.data,
minimal_education=form.minimal_education.data,
category=form.category.data)
update_data(profession, Profession)
save()
return redirect('/image')
return render_template('image.html', professions=result, form=form)
def profession_skill():
professions = get_data(Profession)
skills = get_data(Skill)
req = req4(Profession, ProfessionSkill, Skill)
professionskills = [ProfessionSkillDTO(i[0], i[1], i[2]) for i in req]
form = ProfessionSkillForm(request.form)
form.skill_id.choices = [(skill.id, skill.name) for skill in skills]
form.profession_id.choices = [(profession.id, profession.name)
for profession in professions]
if request.method == 'POST':
if form.id.data == '':
professionskill = ProfessionSkill(int(random.getrandbits(31)),
form.profession_id.data,
form.skill_id.data)
insert_data(professionskill)
else:
professionskill = ProfessionSkill(int(form.id.data),
form.profession_id.data,
form.skill_id.data)
update_data(professionskill, ProfessionSkill)
save()
return redirect('/image_code')
return render_template('image_has_code.html',
professionskills=professionskills,
form=form)
def vacancy():
result = get_data(Vacancy)
form = VacancyForm(request.form)
professions = get_data(Profession)
form.profession_id.choices = [(profession.id, profession.name)
for profession in professions]
if request.method == 'POST':
print(form.id.data)
if (form.id.data == ''):
vacancy = Vacancy(int(random.getrandbits(31)),
name=form.name.data,
duties=form.duties.data,
salary=form.salary.data,
created_at=datetime.now(),
description=form.description.data,
profession_id=form.profession_id.data)
insert_data(vacancy)
else:
vacancy = Vacancy(id=int(form.id.data),
name=form.name.data,
duties=form.duties.data,
salary=form.salary.data,
created_at=datetime.now(),
description=form.description.data,
profession_id=form.profession_id.data)
update_data(vacancy, Vacancy)
save()
return redirect('/tags')
return render_template('tags.html', vacancies=result, form=form)
def userskill():
users = get_data(Person)
skills = get_data(Skill)
req = req2(Person, UserSkill, Skill)
userskills = [UserSkillDTO(i[0], i[1], i[3]) for i in req]
form = UserSkillForm(request.form)
form.skill_id.choices = [(skill.id, skill.name) for skill in skills]
form.user_id.choices = [(user.id, user.first_name) for user in users]
if request.method == 'POST':
print(form.id.data)
if form.id.data == '':
userskill = UserSkill(int(random.getrandbits(31)),
form.user_id.data, form.skill_id.data)
insert_data(userskill)
else:
userskill = UserSkill(int(form.id.data), form.user_id.data,
form.skill_id.data)
update_data(userskill, UserSkill)
save()
return redirect('/usercode')
return render_template('user_has_code.html',
userskills=userskills,
form=form)
def skill():
result = get_data(Skill)
form = SkillForm(request.form)
if request.method == 'POST':
print(form.id.data)
''''''
if (form.id.data == ''):
skill = Skill(int(random.getrandbits(31)), form.name.data)
insert_data(skill)
else:
skill = Skill(int(form.id.data), form.name.data)
update_data(skill, Skill)
save()
return redirect('/code')
return render_template('code.html', skills=result, form=form)
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 user_delete(id):
delete_data(Person, id)
save()
return redirect('/user')
def profession_skill_delete(id):
delete_data(ProfessionSkill, id)
save()
return redirect('/profession_skill')
def vacancy_delete(id):
delete_data(Vacancy, id)
save()
return redirect('/tags')
def profession_delete(id):
delete_data(Profession, id)
save()
return redirect('/image')
def userskill_delete(id):
delete_data(UserSkill, id)
save()
return redirect('/usercode')
def skill_delete(id):
delete_data(Skill, id)
save()
return redirect('/code')
