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)