def get_frontpage_pageviews(date): sr_name = DefaultSR.name traffic_cls = PageviewsBySubredditAndPath q = (Session.query(traffic_cls.srpath, traffic_cls.pageview_count).filter( traffic_cls.interval == 'day').filter(traffic_cls.date == date).filter( traffic_cls.srpath == '%s-GET_listing' % sr_name)) r = list(q) return r[0][1]
def get_frontpage_pageviews(date): sr_name = DefaultSR.name traffic_cls = PageviewsBySubredditAndPath q = (Session.query(traffic_cls.srpath, traffic_cls.pageview_count) .filter(traffic_cls.interval == 'day') .filter(traffic_cls.date == date) .filter(traffic_cls.srpath == '%s-GET_listing' % sr_name)) r = list(q) return r[0][1]
def get_campaign_pageviews(date, sr_name=''): # ads go live at hour=5 start = datetime.datetime(date.year, date.month, date.day, 5, 0) hours = [start + datetime.timedelta(hours=i) for i in xrange(24)] traffic_cls = TargetedImpressionsByCodename codename_string = PC_PREFIX + '_%' q = (Session.query(traffic_cls.codename, sa_sum(traffic_cls.pageview_count).label('daily')) .filter(traffic_cls.subreddit == sr_name) .filter(traffic_cls.codename.like(codename_string)) .filter(traffic_cls.interval == 'hour') .filter(traffic_cls.date.in_(hours)) .group_by(traffic_cls.codename)) pageviews = dict(q) return pageviews