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 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 vacancy_edit(id):
if request.method == 'GET':
vacancy = get_data_by_id(Vacancy, id)
professions = get_data(Profession)
result = get_data(Vacancy)
form = VacancyForm()
form.id.data = vacancy.id
form.name.data = vacancy.name
form.description.data = vacancy.description
form.duties.data = vacancy.duties
form.salary.data = vacancy.salary
form.profession_id.data = vacancy.profession_id
form.profession_id.choices = [(profession.id, profession.name)
for profession in professions]
return render_template('tags.html', vacancies=result, form=form)
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 skill_edit(id):
if request.method == 'GET':
skill = get_data_by_id(Skill, id)
result = get_data(Skill)
form = SkillForm()
form.id.data = skill.id
form.name.data = skill.name
return render_template('code.html', skills=result, form=form)
def userskill_edit(id):
if request.method == 'GET':
userskill = get_data_by_id(UserSkill, id)
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]
form.id.data = userskill.id
form.skill_id.data = userskill.skill_id
form.user_id.data = userskill.user_id
return render_template('user_has_code.html',
userskills=userskills,
form=form)
def profession_skill_edit(id):
if request.method == 'GET':
professionskill = get_data_by_id(ProfessionSkill, id)
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]
form.id.data = professionskill.id
form.skill_id.data = professionskill.skill_id
form.profession_id.data = professionskill.profession_id
return render_template('image_has_code.html',
professionskills=professionskills,
form=form)
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 profession_edit(id):
if request.method == 'GET':
profession = get_data_by_id(Profession, id)
result = get_data(Profession)
form = ProfessionForm()
form.id.data = profession.id
form.name.data = profession.name
form.minimal_work_expirience.data = profession.minimal_work_expirience
form.minimal_education.data = profession.minimal_education
form.category.data = profession.category
return render_template('image.html', professions=result, 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 classification():
vacancies = get_data(Vacancy)
vacanciesWithCategory = classificate_vacancy_by_salary(vacancies)
return render_template('statistics.html', vacancies=vacanciesWithCategory)
