diff options
author | Joey Hagedorn <hagedorn@mcs.anl.gov> | 2007-06-26 21:05:19 +0000 |
---|---|---|
committer | Joey Hagedorn <hagedorn@mcs.anl.gov> | 2007-06-26 21:05:19 +0000 |
commit | 197aa7c0997ae91b8b1210b81daf952d6c681cb2 (patch) | |
tree | 27e21db1ae081e7c1190ff42a602300b508255ba /src/lib/Server/Reports/reports/views.py | |
parent | 83d43c6957a5e392cc7d82f14329f8305ef3ca79 (diff) | |
download | bcfg2-197aa7c0997ae91b8b1210b81daf952d6c681cb2.tar.gz bcfg2-197aa7c0997ae91b8b1210b81daf952d6c681cb2.tar.bz2 bcfg2-197aa7c0997ae91b8b1210b81daf952d6c681cb2.zip |
updates reporting system to filter out 'expired' clients--allowing retired machines to disappear from reports
git-svn-id: https://svn.mcs.anl.gov/repos/bcfg/trunk/bcfg2@3373 ce84e21b-d406-0410-9b95-82705330c041
Diffstat (limited to 'src/lib/Server/Reports/reports/views.py')
-rw-r--r-- | src/lib/Server/Reports/reports/views.py | 32 |
1 files changed, 18 insertions, 14 deletions
diff --git a/src/lib/Server/Reports/reports/views.py b/src/lib/Server/Reports/reports/views.py index 1d7fabe52..3f58fb0d8 100644 --- a/src/lib/Server/Reports/reports/views.py +++ b/src/lib/Server/Reports/reports/views.py @@ -27,7 +27,7 @@ def config_item_modified(request, eyedee =None, timestamp = 'now'): "WHERE reports_client.current_interaction_id = reports_modified_interactions.interaction_id "+ "AND reports_modified_interactions.interaction_id = reports_interaction.id "+ "AND reports_modified_interactions.modified_id = %s", [eyedee]) - associated_client_list = Client.objects.filter(id__in=[x[0] for x in cursor.fetchall()]) + associated_client_list = Client.objects.active(timestamp).filter(id__in=[x[0] for x in cursor.fetchall()]) else: interact_queryset = Interaction.objects.interaction_per_client(timestamp) interactionlist = [] @@ -37,7 +37,7 @@ def config_item_modified(request, eyedee =None, timestamp = 'now'): "WHERE reports_modified_interactions.interaction_id IN %s "+ "AND reports_modified_interactions.interaction_id = reports_interaction.id "+ "AND reports_modified_interactions.modified_id = %s", [interactionlist, eyedee]) - associated_client_list = Client.objects.filter(id__in=[x[0] for x in cursor.fetchall()]) + associated_client_list = Client.objects.active(timestamp).filter(id__in=[x[0] for x in cursor.fetchall()]) else: associated_client_list = [] @@ -62,7 +62,7 @@ def config_item_bad(request, eyedee = None, timestamp = 'now'): "WHERE reports_client.current_interaction_id = reports_bad_interactions.interaction_id "+ "AND reports_bad_interactions.interaction_id = reports_interaction.id "+ "AND reports_bad_interactions.bad_id = %s", [eyedee]) - associated_client_list = Client.objects.filter(id__in=[x[0] for x in cursor.fetchall()]) + associated_client_list = Client.objects.active(timestamp).filter(id__in=[x[0] for x in cursor.fetchall()]) else: interact_queryset = Interaction.objects.interaction_per_client(timestamp) interactionlist = [] @@ -72,7 +72,7 @@ def config_item_bad(request, eyedee = None, timestamp = 'now'): "WHERE reports_bad_interactions.interaction_id IN %s "+ "AND reports_bad_interactions.interaction_id = reports_interaction.id "+ "AND reports_bad_interactions.bad_id = %s", [interactionlist, eyedee]) - associated_client_list = Client.objects.filter(id__in=[x[0] for x in cursor.fetchall()]) + associated_client_list = Client.objects.active(timestamp).filter(id__in=[x[0] for x in cursor.fetchall()]) else: associated_client_list = None @@ -94,8 +94,7 @@ def bad_item_index(request, timestamp = 'now'): if timestamp == 'now': bad_kinds = dict([(x,x.kind) for x in Bad.objects.filter(interactions__in= [c.current_interaction - for c in Client.objects.all()]).distinct()]) - #this will need expiration support + for c in Client.objects.active(timestamp)]).distinct()]) kinds = list(Set(bad_kinds.values())) item_list_dict = dict([(x,[]) for x in kinds]) for obj in bad_kinds: @@ -104,8 +103,7 @@ def bad_item_index(request, timestamp = 'now'): else: #this isn't done yet bad_kinds = dict([(x,x.kind) for x in Bad.objects.filter(interactions__in= [c.current_interaction - for c in Client.objects.all()]).distinct()]) - #this will need expiration support + for c in Client.objects.active(timestamp)]).distinct()]) kinds = list(Set(bad_kinds.values())) item_list_dict = dict([(x,[]) for x in kinds]) for obj in bad_kinds: @@ -128,7 +126,7 @@ def modified_item_index(request, timestamp = 'now'): if timestamp == 'now': mod_kinds = dict([(x,x.kind) for x in Modified.objects.filter(interactions__in= [c.current_interaction - for c in Client.objects.all()]).distinct()]) + for c in Client.objects.active(timestamp)]).distinct()]) #this will need expiration support kinds = list(Set(mod_kinds.values())) item_list_dict = dict([(x,[]) for x in kinds]) @@ -138,7 +136,7 @@ def modified_item_index(request, timestamp = 'now'): else: #this isn't done yet mod_kinds = dict([(x,x.kind) for x in Modified.objects.filter(interactions__in= [c.current_interaction - for c in Client.objects.all()]).distinct()]) + for c in Client.objects.active(timestamp)]).distinct()]) #this will need expiration support kinds = list(Set(mod_kinds.values())) item_list_dict = dict([(x,[]) for x in kinds]) @@ -156,12 +154,18 @@ def modified_item_index(request, timestamp = 'now'): 'timestamp_time' : timestamp[11:19]}) -def client_index(request): - client_list = Client.objects.all().order_by('name') +def client_index(request, timestamp = 'now'): + timestamp = timestamp.replace("@"," ") + client_list = Client.objects.active(timestamp).order_by('name') client_list_a = client_list[:len(client_list)/2] client_list_b = client_list[len(client_list)/2:] + if timestamp == 'now': + timestamp = datetime.now().isoformat('@') return render_to_response('clients/index.html', {'client_list_a': client_list_a, - 'client_list_b': client_list_b}) + 'client_list_b': client_list_b, + 'timestamp' : timestamp, + 'timestamp_date' : timestamp[:10], + 'timestamp_time' : timestamp[11:19]}) def client_detail(request, hostname = None, pk = None): #SETUP error pages for when you specify a client or interaction that doesn't exist @@ -212,7 +216,7 @@ def display_timing(request, timestamp = 'now'): #+------+-------+----------------+-----------+---------+----------------+-------+ #| name | parse | probe download | inventory | install | cfg dl & parse | total | #+------+-------+----------------+-----------+---------+----------------+-------+ - client_list = Client.objects.all().order_by('name') + client_list = Client.objects.active(timestamp.replace("@"," ")).order_by('name') stats_list = [] if not timestamp == 'now': |