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)