def editCaseData(id):
# Initialize form from forms.py
form = CaseForm()
# get values for this row from the database
sql = f"SELECT * FROM case_no WHERE case_id = '{id}'"
res = db.query(sql)
# if form is sent back (POST) to the server
if form.validate_on_submit():
# capture data from form
form_data = form.data
# build SQL query to update case table
qry = db.case_update_sql(form_data)
# update table with new data
try:
db.insert(qry)
except:
flash('Not able to update case record', 'warning')
return render_template(f'edit-case-data.html',
template_form=form,
id=id)
# redirect user to case updated page
return redirect(f'/case_updated/{form.case_id.data}')
# populate values to the form
form.case_id.data = res[0][0]
form.patient_id.data = res[0][1]
form.county_id.data = res[0][2]
form.hospital_id.data = res[0][3]
form.status.data = res[0][4]
form.hospital_name.data = res[0][5]
return render_template('edit-case-data.html', template_form=form, id=id)
def case_create():
global db
case_form_create = CaseForm()
if case_form_create.validate_on_submit():
form_data = case_form_create.data
qry = db.case_insert_sql(form_data)
db.insert(qry)
return redirect(f'/case_created/{case_form_create.case_id.data}')
return render_template('case_create.html', template_form=case_form_create)
