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