def ListEventsHistory(request, pk): context = {} prod_obj = get_object_or_404(Event, pk=pk) api = ApiDomains() url = api.event + "/" + "history" #url = 'https://94q78vev60.execute-api.us-east-1.amazonaws.com/Prod/intellidataeventAPI/history' payload = {'ident': prod_obj.eventid} resp = requests.get(url, params=payload) print(resp.status_code) obj = get_object_or_404(APICodes, http_response_code=resp.status_code) status_message = obj.http_response_message mesg = str(resp.status_code) + " - " + status_message if resp.status_code != 200: # This means something went wrong. #raise ApiError('GET /tasks/ {}'.format(resp.status_code)) #raise APIError(resp.status_code) message = {'messages': mesg} return render(request, "messages.html", context=message) else: json_data = [] dict_data = [] obj_data = [] json_data = resp.json() #print(json_data[0]) #print(json_data[1]) for ix in range(len(json_data)): obj = Event() #dict_data.append(json.loads(json_data[ix])) obj.pk = int(json_data[ix]["LOCAL_ID"]) obj.eventid = json_data[ix]["EVENT_ID"] obj.EventTypeCode = json_data[ix]["EVENT_TYPE_CODE"] obj.EventSubjectId = json_data[ix]["EVENT_SUBJECT_ID"] obj.EventSubjectName = json_data[ix]["EVENT_SUBJECT_NAME"] obj.EventTypeReason = json_data[ix]["EVENT_TYPE_REASON"] obj.creator = User.objects.get(pk=int(json_data[ix]["CREATOR"])) #obj.crerator = get_object_or_404(User, pk=obj.creatorid) obj.EventDate = json_data[ix]["EVENT_DATE"] obj.TransactionDate = json_data[ix]["TRANSACTION_DATE"] obj.backend_SOR_connection = json_data[ix]["CONNECTION"] obj.response = json_data[ix]["RESPONSE"] obj.commit_indicator = json_data[ix]["COMMIT_INDICATOR"] obj.record_status = json_data[ix]["RECORD_STATUS"] obj_data.append(obj) context = {'object_list': obj_data} return render(request, "events/event_list.html", context=context)
def RefreshEvent(request, pk): # fetch the object related to passed id context = {} prod_obj = get_object_or_404(Event, pk=pk) api = ApiDomains() url = api.event + "/" + "refresh" #url = 'https://94q78vev60.execute-api.us-east-1.amazonaws.com/Prod/intellidataeventAPI/history' payload = {'ident': prod_obj.eventid} resp = requests.get(url, params=payload) print(resp.status_code) obj = get_object_or_404(APICodes, http_response_code=resp.status_code) status_message = obj.http_response_message mesg = str(resp.status_code) + " - " + status_message if resp.status_code != 200: # This means something went wrong. #raise ApiError('GET /tasks/ {}'.format(resp.status_code)) #raise APIError(resp.status_code) message = {'messages': mesg} return render(request, "messages.html", context=message) else: json_data = [] json_data = resp.json() obj1 = Event() #OVERRIDE THE OBJECT WITH API data obj1.pk = int(json_data["LOCAL_ID"]) obj1.eventid = json_data["EVENT_ID"] obj1.EventTypeCode = json_data["EVENT_TYPE_CODE"] obj1.EventSubjectId = json_data["EVENT_SUBJECT_ID"] obj1.EventSubjectName = json_data["EVENT_SUBJECT_NAME"] obj1.EventTypeReason = json_data["EVENT_TYPE_REASON"] obj1.creator = User.objects.get(pk=int(json_data["CREATOR"])) #obj.crerator = get_object_or_404(User, pk=obj.creatorid) obj1.EventDate = json_data["EVENT_DATE"] obj1.TransactionDate = json_data["TRANSACTION_DATE"] obj1.backend_SOR_connection = json_data["CONNECTION"] obj1.response = json_data["RESPONSE"] obj1.commit_indicator = json_data["COMMIT_INDICATOR"] obj1.record_status = json_data["RECORD_STATUS"] obj1.save() context = {'event_details': obj1} return render(request, "events/event_detail.html", context=context)
def get_queryset(self, **kwargs): # new query = self.request.GET.get('q', None) object_list = Event.objects.filter( Q(eventid__icontains=query) | Q(EventTypeCode__icontains=query) | Q(EventTypeReason__icontains=query)) #change start for remote SearcheventsForm if not object_list: api = ApiDomains() url = api.event + "/" + "refresh" #url = 'https://94q78vev60.execute-api.us-east-1.amazonaws.com/Prod/intellidataeventAPI/history' payload = {'ident': query} resp = requests.get(url, params=payload) print(resp.status_code) obj = get_object_or_404(APICodes, http_response_code=resp.status_code) status_message = obj.http_response_message mesg = str(resp.status_code) + " - " + status_message if resp.status_code != 200: # This means something went wrong. #raise ApiError('GET /tasks/ {}'.format(resp.status_code)) #raise APIError(resp.status_code) #message={'messages':mesg} #return render(self.request, "messages.html", context=message) print("Status Code: " + str(resp.status_code)) else: json_data = [] json_data = resp.json() obj_data = [] obj1 = Event() #OVERRIDE THE OBJECT WITH API data obj1.pk = int(json_data["LOCAL_ID"]) obj1.eventid = json_data["EVENT_ID"] obj1.EventTypeCode = json_data["EVENT_TYPE_CODE"] obj1.EventSubjectId = json_data["EVENT_SUBJECT_ID"] obj1.EventSubjectName = json_data["EVENT_SUBJECT_NAME"] obj1.EventTypeReason = json_data["EVENT_TYPE_REASON"] obj1.creator = User.objects.get(pk=int(json_data["CREATOR"])) #obj.crerator = get_object_or_404(User, pk=obj.creatorid) obj1.EventDate = json_data["EVENT_DATE"] obj1.TransactionDate = json_data["TRANSACTION_DATE"] obj1.backend_SOR_connection = json_data["CONNECTION"] obj1.response = json_data["RESPONSE"] obj1.commit_indicator = json_data["COMMIT_INDICATOR"] obj1.record_status = json_data["RECORD_STATUS"] obj1.save() #obj_data.append(obj1) #print(obj_data) #context = {'object_list':obj_data} #return render(self.request, "eventevents/event_search_list.html", context=context) object_remote_list = Event.objects.filter(eventid=query) print(object_remote_list) return object_remote_list else: #change end for remote SearcheventsForm return object_list