def vacancy_edit(vac_id):
form = VacancyForm()
result = db.session.query(OrmVacancy).filter(
OrmVacancy.vacancy_id == int(vac_id)).one()
if request.method == 'GET':
form.vacancy_name.data = result.vacancy_name
form.vacancy_company.data = result.vacancy_company
form.vacancy_location.data = result.vacancy_location
form.vacancy_employment.data = result.vacancy_employment
form.vacancy_salary.data = result.vacancy_salary
return render_template('vacancy_form.html',
form=form,
form_name='edit vacancy')
elif request.method == 'POST':
if form.validate():
result.vacancy_name = form.vacancy_name.data
result.vacancy_company = form.vacancy_company.data,
result.vacancy_location = form.vacancy_location.data
result.vacancy_employment = form.vacancy_employment.data
result.vacancy_salary = form.vacancy_salary.data
db.session.commit()
return redirect('/vacancies')
else:
if not form.validate_salary():
form.vacancy_salary.errors = ['minimum salary has to be 500']
return render_template('vacancy_form.html',
form=form,
form_name='edit vacancy')
def create_vacancy():
form = VacancyForm()
if request.method == 'POST':
if form.validate() and form.validate_salary():
try:
new_vacancy = OrmVacancy(
vacancy_company=form.vacancy_company.data,
vacancy_name=form.vacancy_name.data,
vacancy_location=form.vacancy_location.data,
vacancy_employment=form.vacancy_employment.data,
vacancy_salary=form.vacancy_salary.data,
vacancy_id=uuid.uuid1().clock_seq_hi_variant
)
db.session.add(new_vacancy)
db.session.commit()
return render_template('success.html')
except:
return render_template('vacancy_form.html', form=form)
else:
if not form.validate_salary():
form.vacancy_salary.errors = ['minimum salary has to be 500']
return render_template('vacancy_form.html', form=form)
elif request.method == 'GET':
return render_template('vacancy_form.html', 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('/vacancy')
return render_template('vacancy.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('vacancy.html', vacancies=result, form=form)
def create_vacancy():
form = VacancyForm()
if request.method == 'POST':
new_vacancy = OrmVacancy(
vacancy_company=form.vacancy_company.data,
vacancy_name=form.vacancy_name.data,
vacancy_location=form.vacancy_location.data,
vacancy_employment=form.vacancy_employment.data,
vacancy_salary=form.vacancy_salary.data,
vacancy_id=uuid.uuid1().clock_seq_hi_variant)
db.session.add(new_vacancy)
db.session.commit()
return render_template('success.html')
elif request.method == 'GET':
return render_template('vacancy_form.html', form=form)