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)
