python 按天 小时统计_python项目篇-如何按天 小时等查询统计？

from django.db import connection

from django.db.models import Sum,Count

#alarm_sum_group_items = models.FILE_PROTECT_ALARM.objects.filter(**condition).values('customer_id').annotate(alarm_sum=Sum('cmn_merge_count'))

select = {'day': connection.ops.date_trunc_sql('day', 'cmn_alert_time')}

alarm_sum_group_items = models.FILE_PROTECT_ALARM.objects.filter(**condition).extra(select=select).values('day').annotate(sum=Sum('cmn_merge_count'))

#serializer = serializers.FILE_PROTECT_ALARM_Serializer(file_protect_alarm_list, many=True)

#data = {}

#data['items'] = serializer.data

'''for item in data['items']:

item['svc_profile_list'] = json.loads(item['svc_profile_list'])

#item['info'] = json.loads(item['info'])&#