Пример #1
0
 def populate(self):
     all = self.get_query().order_by(self.criteria).all()
     if self.criteria_name == 'spent_time':
         self.chart.x_labels = [
             "<1s", "1s", "2s", "5s", "10s", "20s",
             "30s", "1min", "2min", "5min",  ">10min"]
     else:
         self.chart.x_labels = list(map(str, map(int, cut(all, 0))))
     self.chart.add(labelize(self.criteria_name, self.lang),
                    list(map(float, cut(all, 1))))
Пример #2
0
    def populate(self):
        all = (self.filter(self.db
               .query(Visit.day, count(1), count(distinct(Visit.uuid))))
               .group_by(Visit.day)
               .order_by(Visit.day)
               .all())

        self.chart.x_labels = list(map(
            lambda x: x.strftime('%Y-%m-%d'), cut(all, 0)))
        self.chart.add(labelize('all', self.lang), cut(all, 1))
        self.chart.add(labelize('unique', self.lang), cut(all, 2))

        new = (self.filter(
            self.db
            .query(count(distinct(Visit.uuid))))
            .filter(Visit.last_visit == None)
            .group_by(Visit.day)
            .order_by(Visit.day)
            .all())
        self.chart.add(labelize('new', self.lang), cut(new, 0))
        self.chart.x_label_rotation = 45