django操作集合

models如下

class RepBizDay(models.Model):
    biz_id = models.IntegerField('商户ID')
    biz_name = models.CharField(max_length=50, verbose_name='商户名')
    activity_num = models.IntegerField('创建活动数量', default=0)
    visit_num = models.IntegerField('访问总量', default=0)
    join_num = models.IntegerField('参与总量', default=0)
    share_num = models.IntegerField('分享总量', default=0)
    income = models.IntegerField('收入总额', default=0)
    expenses = models.IntegerField('支出总额', default=0)
    pay_num = models.IntegerField('支付订单数据', default=0)
    create_num = models.IntegerField('创建订单数量', default=0)
    date = models.DateField('数据所属日期', db_column='the_date')
    time_create = models.DateTimeField('统计时间', auto_now_add=True)

class  BizStatistics(models.Model):
    register_num = models.IntegerField('新注册量',default=0)
    income = models.IntegerField('收入',default=0)
    visit_num = models.IntegerField('访问量', default=0, null=True)
    join_num = models.IntegerField('参与量',default=0,null=True)
    date = models.DateField('数据所属日期')
    time_create = models.DateTimeField('统计时间', auto_now_add=True)

一段时间内某个商家的收入总和,参与人数总和

 # 排行
    start = request.GET.get('start') or (datetime.datetime.now() + datetime.timedelta(days=-1)).strftime('%Y-%m-%d')
    end = request.GET.get('end') or (datetime.datetime.now() + datetime.timedelta(days=-1)).strftime('%Y-%m-%d')

    lazy = RepBizDay.objects.filter(date__range=(start, end)).filter(biz_id=1).values('biz_name','biz_id').annotate(income=Sum('income'),join_num=Sum('join_num'))
print lazy

得到如下

<QuerySet [{'join_num': 9, 'biz_id': 10103L, 'income': 6569700, 'biz_name': u'\u9571\u6811\u513f\u7ae5\u6444\u5f71\u5de5\u4f5c\u5ba4'}]>

所有的总和

 day_all = BizStatistics.objects.filter(date__range=(start, end)).aggregate(Sum('register_num'),
                                                                                        Sum('income'),
                                                                                        Sum('visit_num'),
                                                                                        Sum('join_num'))
print day_all

得到如下

{'register_num__sum': 4, 'visit_num__sum': 14252, 'income__sum': 2522890, 'join_num__sum': 1320}

一张表里要得到一个新的数据,是表里两个字段运算得到的

class RepBizWeek(models.Model):
    biz_id = models.IntegerField('商户ID')
    biz_name = models.CharField(max_length=50, verbose_name='商户名')
    activity_num = models.IntegerField('创建活动数量', default=0)
    visit_num = models.IntegerField('访问总量', default=0)
    join_num = models.IntegerField('参与总量', default=0)
    share_num = models.IntegerField('分享总量', default=0)
    income = models.IntegerField('收入总额', default=0)
    expenses = models.IntegerField('支出总额', default=0)
    pay_num = models.IntegerField('支付订单数据', default=0)
    create_num = models.IntegerField('创建订单数量', default=0)
    date = models.DateField('数据所属日期', db_column='the_date')
    time_create = models.DateTimeField('统计时间', auto_now_add=True)

    def __str__(self):
        return self.biz_id

    class Meta:
        db_table = 'rep_biz_week'
        managed = False
        verbose_name_plural = '商户-周统计数据'
        verbose_name = verbose_name_plural

转换率
    @property
    def conversion_rate(self):
        _conversion_rate = (self.join_num / float(self.visit_num))
        conversion_rate = " %.2f%%" % (_conversion_rate * 100)
        return conversion_rate

4删库重来
删除库里django_makemigrations,再删除django 里migrations里除了init这个文件，再执行python manage.py migrate--fake-initial