from rest_framework import generics
from rest_framework import serializers
from rest_framework.response import Response
from rest_framework.views import APIView
from crashreports.permissions import (
    HasRightsOrIsDeviceOwnerDeviceCreation, HasStatsAccess)
from django.db import connection
from . import raw_querys
from crashreport_stats.models import *
import zipfile
from crashreports.models import *
from django.db.models.expressions import F
import django_filters
from rest_framework import filters

def dictfetchall(cursor):
    "Returns all rows from a cursor as a dict"
    desc = cursor.description
    return [
        dict(zip([col[0] for col in desc], row))
        for row in cursor.fetchall()
    ]

class DeviceUpdateHistory(APIView):
    permission_classes = (HasRightsOrIsDeviceOwnerDeviceCreation, )
    def get(self, request, uuid, format=None):
        cursor = connection.cursor()
        raw_querys.execute_device_update_history_query(
            cursor,
            {
                'uuid': uuid
            })
        res = dictfetchall(cursor)
        return Response(res)

class DeviceReportHistory(APIView):
    permission_classes = (HasRightsOrIsDeviceOwnerDeviceCreation, )
    def get(self, request, uuid, format=None):
        cursor = connection.cursor()
        raw_querys.execute_device_report_history(
            cursor,
            {
                'uuid': uuid
            })
        res = dictfetchall(cursor)
        return Response(res)

class Status(APIView):
    permission_classes = (HasStatsAccess,)
    def get(self, request, format=None, ):
        num_devices = Device.objects.count()
        num_crashreports = Crashreport.objects.count()
        num_heartbeats = HeartBeat.objects.count()
        return Response( {
                'devices': num_devices,
                'crashreports': num_crashreports,
                'heartbeats': num_heartbeats
        })

class DeviceStat(APIView):
    permission_classes = (HasRightsOrIsDeviceOwnerDeviceCreation, )
    def get(self, request, uuid, format=None, ):
        device          = Device.objects.filter(uuid=uuid)
        last_active     = HeartBeat.objects.filter(device=device).order_by('-date')[0].date
        heartbeats      = HeartBeat.objects.filter(device=device).count()
        crashreports    = Crashreport.objects.filter(device=device).filter(boot_reason__in=Crashreport.CRASH_BOOT_REASONS).count()
        crashes_per_day = crashreports*1.0/heartbeats if heartbeats > 0 else 0
        smpls           = Crashreport.objects.filter(device=device).filter(boot_reason__in=Crashreport.SMPL_BOOT_REASONS).count()
        smpl_per_day    = smpls*1.0/heartbeats if heartbeats > 0 else 0
        return Response(
            {
                'uuid'            : uuid,
                'last_active'     : last_active,
                'heartbeats'      : heartbeats,
                'crashreports'    : crashreports,
                'crashes_per_day' : crashes_per_day,
                'smpls'           : smpls,
                'smpl_per_day'    : smpl_per_day,
                'board_date'      : device[0].board_date,
            })

class LogFileDownload(APIView):
    permission_classes = (HasRightsOrIsDeviceOwnerDeviceCreation, )
    def get(self, request, id, format=None):
        try:
            logfile = LogFile.objects.get(id=id)
        except:
            raise NotFound(detail="Logfile does not exist.")
        zf = zipfile.ZipFile(logfile.logfile.path)
        ret = {}
        for f in zf.filelist:
            fo = zf.open(f)
            ret[f.filename] = fo.read()
        return Response(ret)


class _VersionStatsFilter(filters.FilterSet):
    first_seen_before = django_filters.DateFilter(name="first_seen_on", lookup_expr='lte')
    first_seen_after = django_filters.DateFilter(name="first_seen_on", lookup_expr='gte')
    released_before = django_filters.DateFilter(name="released_on", lookup_expr='lte')
    released_after = django_filters.DateFilter(name="released_on", lookup_expr='gte')

class _VersionStatsSerializer(serializers.ModelSerializer):
    permission_classes = (HasStatsAccess,)

class _VersionStatsListView(generics.ListAPIView):
    permission_classes = (HasStatsAccess,)
    filter_backends = (filters.DjangoFilterBackend,)

class _DailyVersionStatsFilter(filters.FilterSet):
    date_start = django_filters.DateFilter(name="date", lookup_expr='gte')
    date_end = django_filters.DateFilter(name="date", lookup_expr='lte')

class _DailyVersionStatsSerializer(serializers.ModelSerializer):
    permission_classes = (HasStatsAccess,)

class _DailyVersionStatsListView(generics.ListAPIView):
    permission_classes = (HasStatsAccess,)
    filter_backends = (filters.DjangoFilterBackend,)


class VersionSerializer(_VersionStatsSerializer):
    class Meta:
        model = Version
        fields = '__all__'

class VersionFilter(_VersionStatsFilter):
    class Meta:
        model = Version
        fields = '__all__'

class VersionListView(_VersionStatsListView):
    queryset = Version.objects.all().order_by('-heartbeats')
    filter_class = VersionFilter
    serializer_class = VersionSerializer

class VersionDailyFilter(_DailyVersionStatsFilter):
    version__build_fingerprint = django_filters.CharFilter()
    version__is_official_release = django_filters.BooleanFilter()
    version__is_beta_release = django_filters.BooleanFilter()

    class Meta:
        model = VersionDaily
        fields = '__all__'

class VersionDailySerializer(_DailyVersionStatsSerializer):
    build_fingerprint = serializers.CharField()

    class Meta:
        model = VersionDaily
        fields = '__all__'

class VersionDailyListView(_DailyVersionStatsListView):
    queryset = (
        VersionDaily.objects
            .annotate(build_fingerprint=F('version__build_fingerprint'))
            .all()
            .order_by('date')
    )
    filter_class = VersionDailyFilter
    filter_fields = (
        'version__build_fingerprint',
        'version__is_official_release',
        'version__is_beta_release',
    )
    serializer_class = VersionDailySerializer


class RadioVersionSerializer(_VersionStatsSerializer):
    class Meta:
        model = RadioVersion
        fields = '__all__'

class RadioVersionFilter(_VersionStatsFilter):
    class Meta:
        model = RadioVersion
        fields = '__all__'

class RadioVersionListView(_VersionStatsListView):
    queryset = RadioVersion.objects.all().order_by('-heartbeats')
    serializer_class = RadioVersionSerializer
    filter_class = RadioVersionFilter

class RadioVersionDailyFilter(_DailyVersionStatsFilter):
    version__radio_version = django_filters.CharFilter()
    version__is_official_release = django_filters.BooleanFilter()
    version__is_beta_release = django_filters.BooleanFilter()

    class Meta:
        model = RadioVersionDaily
        fields = '__all__'

class RadioVersionDailySerializer(_DailyVersionStatsSerializer):
    radio_version = serializers.CharField()

    class Meta:
        model = RadioVersionDaily
        fields = '__all__'

class RadioVersionDailyListView(_DailyVersionStatsListView):
    queryset = (
        RadioVersionDaily.objects
            .annotate(radio_version=F('version__radio_version'))
            .all()
            .order_by('date')
    )
    filter_class = RadioVersionDailyFilter
    filter_fields = (
        'version__radio_version',
        'version__is_official_release',
        'version__is_beta_release',
    )
    serializer_class = RadioVersionDailySerializer