def keys(): """List the auth keys""" keys = Keys.query.order_by(Keys.host, Keys.key).all() hosts = (db.session .query(distinct(Visit.host).label('host')) .all()) return render_template('keys.jinja2', keys=keys, hosts=hosts)
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
def process_data(site, graph, criteria, from_date, to_date, step, stamp, lang): rq = (db.session.query( Visit.day.label("key"), count(distinct(Visit.uuid)).label("count") if criteria == 'unique' else count(1).label("count")).filter(on(site)).filter( between(from_date, to_date))) if criteria == 'new': rq = rq.filter(Visit.last_visit == None) results = rq.group_by(Visit.day).order_by(Visit.day).all() return make_time_serie(results, criteria, from_date, to_date, lang)
def process_data(site, graph, criteria, from_date, to_date, step, stamp, lang): rq = (db.session .query(Visit.day.label("key"), count(distinct(Visit.uuid)).label("count") if criteria == 'unique' else count(1).label("count")) .filter(on(site)) .filter(between(from_date, to_date))) if criteria == 'new': rq = rq.filter(Visit.last_visit == None) results = rq.group_by(Visit.day).order_by(Visit.day).all() return make_time_serie(results, criteria, from_date, to_date, lang)