def trail(self):
"""
Get all visitors by IP and then list the pages they visited in order.
"""
inner = (self.get_query().select(PageView.ip, PageView.url).order_by(
PageView.timestamp))
return (PageView.select(
PageView.ip,
fn.array_agg(PageView.url).coerce(False).alias('urls')).from_(
inner.alias('t1')).group_by(PageView.ip))
def get_query(self):
query = PageView.select().where(PageView.account == self.account)
if self.date_range:
query = query.where(PageView.timestamp.between(*self.date_range))
return query
def get_query(self):
query = PageView.select().where(PageView.account == self.account)
if self.date_range:
query = query.where(PageView.timestamp.between(*self.date_range))
return query
