Produits Entr'ouvert » Passerelle

from django.db import connection

from passerelle.base.models import ResourceStatus

last_down = None

downtimes = []

for r in ResourceStatus.objects.order_by('resource_pk', 'resource_type_id', 'start_timestamp'):

    if r.status == 'down':

        if last_down:

            if (last_down.resource_type, last_down.resource_pk) == (r.resource_type, r.resource_pk):

                continue

        last_down = r

    else:

        if last_down:

           if (last_down.resource_type, last_down.resource_pk) == (r.resource_type, r.resource_pk):

               downtimes.append((r.resource_type, r.resource_pk, last_down.start_timestamp, r.start_timestamp - last_down.start_timestamp))

           last_down = None

if downtimes:

    print connection.tenant.domain_url

    resource = None

    grouped = {}

    for rt, rpk, timestamp, duration in downtimes:

        resource = rt.model_class().objects.get(pk=rpk)

        grouped.setdefault(resource, []).append((timestamp, duration))

    for resource in grouped:

        print resource, 'downtimes :'

        for timestamp, duration in grouped[resource]:

            hours = duration.total_seconds() // 3600

            minutes = duration.total_seconds() // 60

            if hours > 1:

                human = '%d heures' % hours

            elif minutes > 1:

                human = '%d minutes' % minutes

            else:

                human = '%d secondes' % duration.total_seconds()

            print timestamp, 'pendant', human