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