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)