From 640ff61422bc0ee3966941b93d9889ddbbd38d77 Mon Sep 17 00:00:00 2001 From: ckonstanski Date: Thu, 30 Jul 2026 18:17:14 -0600 Subject: more files --- src/dashboard/services/caasqueryservice.py | 31 ++++++++++++++++++++++++++++++ 1 file changed, 31 insertions(+) create mode 100644 src/dashboard/services/caasqueryservice.py (limited to 'src/dashboard/services') diff --git a/src/dashboard/services/caasqueryservice.py b/src/dashboard/services/caasqueryservice.py new file mode 100644 index 0000000..b367c33 --- /dev/null +++ b/src/dashboard/services/caasqueryservice.py @@ -0,0 +1,31 @@ +import json +from django.apps import apps + + +class CaaSQueryService: + def get_clusters(self): + wr_install_schedule = apps.get_model('caas', 'WrInstallSchedule') + installs = list(wr_install_schedule.objects.select_related('cluster') + .values('cluster__cluster_name', + 'date_scheduled', + 'date_completed', + 'date_last_failed', + 'kirke_ticket_number', + 'kirke_ticket_status', + 'kirke_ticket_completed')) + return json.dumps(installs, indent=4, sort_keys=True, default=str) + + def get_firmware_version(self): + firmware_schedule = apps.get_model('caas', 'FirmwareUpgradeSchedule') + query_set = firmware_schedule.objects.select_related('server').order_by('id', 'date_completed') + servers = [] + for server in query_set: + servers.append( + {'id': server.id, + 'oam_hostname': server.server.oam_hostname, + 'ilo_host_address': server.server.ilo_host_address, + 'intel_nic_firmware_version': server.server.intel_nic_firmware_version, + 'date_completed': server.date_completed, + 'date_last_failed': server.date_last_failed}, + ) + return json.dumps(servers, indent=4, sort_keys=True, default=str) -- cgit v1.3