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))))
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