import json
import traceback

from db import Database


def save_pan_data(application_id, pan_response):
    try:
        pan_vendor = pan_response.get('panVendor').lower() if pan_response.get('panVendor') else None
        with Database() as db:
            db.execute('update credit_report set panValidation = %s, panVendor = %s where application_id = %s',
                       (json.dumps(pan_response), pan_vendor, application_id))
    except Exception as ex:
        traceback.print_exc()
        raise ex