Как в python (Django) выполнить итерации в Json-ответе и сохранить данные в базе данных?

def lipa(request): response = requests.get('https://9b4b-154-159-237-44.in.ngrok.io/others/callback/') data = response.json() if response and response.status_code == 200 else None

# for d in data:

#     print(data)


for d in data.values():
    id = d['ID']
    requestID = d['CheckoutRequestID']
    resultCode = d['ResultCode']
    receiptNumber = d['MpesaReceiptNumber']
    phoneNumber = d['PhoneNumber']
    amount = d['amount']


    # checking if the transaction exists in the database
    if Payment.objects.filter(secondary_key_id = id, tiny_pesa_id = requestID, code = resultCode, msisdn = phoneNumber, amount= amount).exists():
        return JsonResponse({ "id": id})
    else:
        e = Payment.objects.create(secondary_key_id = id, code=resultCode, amount = amount, msisdn = phoneNumber, tiny_pesa_id = requestID, mpesa_transaction_id = receiptNumber)
        e.save()

        d = TinyPesaPayment.objects.create(status=resultCode,msisdn=phoneNumber,amount=amount,mpesa_transaction_id=receiptNumber, tiny_pesa_id=requestID)
        d.save()

        return JsonResponse({ "amount": amount})

Вернуться на верх