def get_claims(): with contextlib.closing(make_session()) as session: claims = session.query(Claim).all() return [(json_decode(claim.claimant_information), json_decode(claim.employee_record), claim.submitted_at) for claim in claims]
def claims_against_company(employer_id): with contextlib.closing(make_session()) as session: claims = session.query(Claim)\ .filter(Claim.employer_id == employer_id).all() return [(json_decode(claim.claimant_information), json_decode(claim.employee_record)) for claim in claims]
def update_claim(claim_id, claimant_information=None, employee_record=None): with contextlib.closing(make_session()) as session: claim = _multiple_results_hack( session.query(Claim).filter(Claim.claim_id == claim_id)) if claimant_information: updated_claimant_info = dict( json_decode(claim.claimant_information), **claimant_information ) claim.claimant_information = json_encode(updated_claimant_info) if employee_record: updated_employee_record = dict( json_decode(claim.employee_record), **employee_record ) claim.employee_record = json_encode(updated_employee_record) session.commit()
def employee_via_nino(nino): nino = nino.upper() with contextlib.closing(make_session()) as session: try: employee = _multiple_results_hack( session.query(Employee).filter( Employee.nino == nino)) return json_decode(employee.hstore) except NoResultFound: pass
def get_rp1_form(): with contextlib.closing(make_session()) as session: claimant = _multiple_results_hack( session.query(Claimant)) return json_decode(claimant.hstore)
def get_claim(claim_id): with contextlib.closing(make_session()) as session: claim = _multiple_results_hack( session.query(Claim).filter(Claim.claim_id == claim_id)) return (json_decode(claim.claimant_information), json_decode(claim.employee_record), claim.submitted_at)