def get_daily_data_by_platform(app_id, end, n_days, versions, platform): start = end - timezone.timedelta(days=n_days) event_name = "request:{}:{}:{}" days = [start + timezone.timedelta(days=x) for x in range(0, n_days + 1)] data = [(v, [[ day.strftime("%Y-%m-%dT00:%M:%S.%fZ"), len(DayEvents.from_date(event_name.format(app_id, platform, v), day)) ] for day in days]) for v in versions] data = filter( lambda version_data: sum([data[1] for data in version_data[1]]), data) return dict(data)
def get_daily_data_by_platform(app_id, end, n_days, versions, platform, channel): def build_event_name(app_id, platform, channel, v): if channel: return "request:{}:{}:{}:{}".format(app_id, platform, channel, v) else: return "request:{}:{}:{}".format(app_id, platform, v) start = end - timezone.timedelta(days=n_days) days = [start + timezone.timedelta(days=x) for x in range(0, n_days+1)] data = [(v, [[day.strftime("%Y-%m-%dT00:%M:%S.%fZ"), len(DayEvents.from_date(build_event_name(app_id, platform, channel, v), day))] for day in days]) for v in versions] data = filter(lambda version_data: sum([data[1] for data in version_data[1]]), data) return dict(data)
def get_daily_data_by_platform(app_id, end, n_days, versions, platform, channel): def build_event_name(app_id, platform, channel, v): if channel: return "request:{}:{}:{}:{}".format(app_id, platform, channel, v) else: return "request:{}:{}:{}".format(app_id, platform, v) start = end - timezone.timedelta(days=n_days) days = [start + timezone.timedelta(days=x) for x in range(0, n_days+1)] data = [(v, [[day.strftime("%Y-%m-%dT00:%M:%S.%fZ"), len(DayEvents.from_date(build_event_name(app_id, platform, channel, v), day))] for day in days]) for v in versions] data = [version_data for version_data in data if sum([data[1] for data in version_data[1]])] return dict(data)
def test_add_app_statistics(self): now = datetime.utcnow() next_month = now.replace(month=now.month + 1) userid = 1 channel = DEFAULT_CHANNEL platform = "win" app_kwargs = dict(appid="{F97917B1-20AB-48C1-9802-CEF305B10804}", version="30.0.123.1234") success_app = create_app_xml(events=fixtures.event_install_success, **app_kwargs) error_app = create_app_xml(events=fixtures.event_install_error, **app_kwargs) appid = app_kwargs.get("appid") version = app_kwargs.get("version") events_request_appid = lambda date=now: DayEvents.from_date("request:%s" % appid, date) events_new_appid = lambda date=now: DayEvents.from_date("new_install:%s" % appid, date) events_request_appid_version = lambda date=now: DayEvents.from_date( "request:{}:{}".format(appid, version), date ) events_request_appid_platform = lambda date=now: DayEvents.from_date( "request:{}:{}".format(appid, platform), date ) events_new_appid_platform = lambda date=now: DayEvents.from_date( "new_install:{}:{}".format(appid, platform), date ) events_request_appid_channel = lambda date=now: DayEvents.from_date( "request:{}:{}".format(appid, channel), date ) events_request_appid_platform_version = lambda date=now: DayEvents.from_date( "request:{}:{}:{}".format(appid, platform, version), date ) self.assertEqual(len(events_new_appid()), 0) self.assertEqual(len(events_request_appid()), 0) self.assertEqual(len(events_request_appid_version()), 0) self.assertEqual(len(events_request_appid_platform()), 0) self.assertEqual(len(events_new_appid_platform()), 0) self.assertEqual(len(events_request_appid_channel()), 0) self.assertEqual(len(events_request_appid_platform_version()), 0) add_app_statistics(userid, platform, error_app) self.assertEqual(len(events_new_appid()), 0) self.assertEqual(len(events_request_appid()), 0) self.assertEqual(len(events_request_appid_version()), 0) self.assertEqual(len(events_request_appid_platform()), 0) self.assertEqual(len(events_new_appid_platform()), 0) self.assertEqual(len(events_request_appid_channel()), 0) self.assertEqual(len(events_request_appid_platform_version()), 0) add_app_statistics(userid, platform, success_app) self.assertEqual(len(events_new_appid()), 1) self.assertEqual(len(events_request_appid()), 0) self.assertEqual(len(events_request_appid_version()), 1) self.assertEqual(len(events_new_appid_platform()), 1) self.assertEqual(len(events_request_appid_platform()), 0) self.assertEqual(len(events_request_appid_channel()), 1) self.assertEqual(len(events_request_appid_platform_version()), 1) self.assertIn(userid, events_new_appid()) self.assertIn(userid, events_request_appid_version()) self.assertIn(userid, events_new_appid_platform()) self.assertIn(userid, events_request_appid_channel()) self.assertIn(userid, events_request_appid_platform_version()) add_app_statistics(userid, platform, success_app) self.assertEqual(len(events_new_appid()), 1) self.assertEqual(len(events_request_appid()), 0) self.assertEqual(len(events_request_appid_version()), 1) self.assertEqual(len(events_new_appid_platform()), 1) self.assertEqual(len(events_request_appid_platform()), 0) self.assertEqual(len(events_request_appid_channel()), 1) self.assertEqual(len(events_request_appid_platform_version()), 1) with freeze_time(next_month): add_app_statistics(userid, platform, error_app) self.assertEqual(len(events_request_appid(next_month)), 0) self.assertEqual(len(events_request_appid_platform(next_month)), 0) with freeze_time(next_month): add_app_statistics(userid, platform, success_app) self.assertEqual(len(events_request_appid(next_month)), 1) self.assertEqual(len(events_request_appid_platform(next_month)), 1) self.assertEqual(len(events_new_appid(next_month)), 0) self.assertEqual(len(events_request_appid_version(next_month)), 1) self.assertEqual(len(events_new_appid_platform(next_month)), 0) self.assertEqual(len(events_request_appid_channel()), 1) self.assertEqual(len(events_request_appid_platform_version()), 1) self.assertIn(userid, events_request_appid(next_month)) self.assertIn(userid, events_request_appid_platform(next_month))
def test_add_app_statistics(self): now = datetime.utcnow() next_month = now.replace(month=now.month + 1) userid = 1 channel = DEFAULT_CHANNEL platform = 'win' app_kwargs = dict(appid='{2882CF9B-D9C2-4edb-9AAF-8ED5FCF366F7}', nextversion='0.0.0.1') success_app = create_app_xml(events=fixtures.event_install_success, **app_kwargs) error_app = create_app_xml(events=fixtures.event_install_error, **app_kwargs) appid = app_kwargs.get('appid') version = app_kwargs.get('nextversion') events_request_appid = lambda date=now: DayEvents.from_date( 'request:%s' % appid, date) events_new_appid = lambda date=now: DayEvents.from_date( 'new_install:%s' % appid, date) events_request_appid_version = lambda date=now: DayEvents.from_date( 'request:{}:{}'.format(appid, version), date) events_request_appid_platform = lambda date=now: DayEvents.from_date( 'request:{}:{}'.format(appid, platform), date) events_new_appid_platform = lambda date=now: DayEvents.from_date( 'new_install:{}:{}'.format(appid, platform), date) events_request_appid_channel = lambda date=now: DayEvents.from_date( 'request:{}:{}'.format(appid, channel), date) events_request_appid_platform_version = lambda date=now: DayEvents.from_date( 'request:{}:{}:{}'.format(appid, platform, version), date) events_request_appid_platform_channel_version = lambda date=now: DayEvents.from_date( 'request:{}:{}:{}:{}'.format(appid, platform, channel, version), date) self.assertEqual(len(events_new_appid()), 0) self.assertEqual(len(events_request_appid()), 0) self.assertEqual(len(events_request_appid_version()), 0) self.assertEqual(len(events_request_appid_platform()), 0) self.assertEqual(len(events_new_appid_platform()), 0) self.assertEqual(len(events_request_appid_channel()), 0) self.assertEqual(len(events_request_appid_platform_version()), 0) self.assertEqual(len(events_request_appid_platform_channel_version()), 0) add_app_statistics(userid, platform, error_app) self.assertEqual(len(events_new_appid()), 0) self.assertEqual(len(events_request_appid()), 0) self.assertEqual(len(events_request_appid_version()), 0) self.assertEqual(len(events_request_appid_platform()), 0) self.assertEqual(len(events_new_appid_platform()), 0) self.assertEqual(len(events_request_appid_channel()), 0) self.assertEqual(len(events_request_appid_platform_version()), 0) self.assertEqual(len(events_request_appid_platform_channel_version()), 0) add_app_statistics(userid, platform, success_app) self.assertEqual(len(events_new_appid()), 1) self.assertEqual(len(events_request_appid()), 0) self.assertEqual(len(events_request_appid_version()), 1) self.assertEqual(len(events_new_appid_platform()), 1) self.assertEqual(len(events_request_appid_platform()), 0) self.assertEqual(len(events_request_appid_channel()), 1) self.assertEqual(len(events_request_appid_platform_version()), 1) self.assertEqual(len(events_request_appid_platform_channel_version()), 1) self.assertIn(userid, events_new_appid()) self.assertIn(userid, events_request_appid_version()) self.assertIn(userid, events_new_appid_platform()) self.assertIn(userid, events_request_appid_channel()) self.assertIn(userid, events_request_appid_platform_version()) self.assertIn(userid, events_request_appid_platform_channel_version()) add_app_statistics(userid, platform, success_app) self.assertEqual(len(events_new_appid()), 1) self.assertEqual(len(events_request_appid()), 0) self.assertEqual(len(events_request_appid_version()), 1) self.assertEqual(len(events_new_appid_platform()), 1) self.assertEqual(len(events_request_appid_platform()), 0) self.assertEqual(len(events_request_appid_channel()), 1) self.assertEqual(len(events_request_appid_platform_version()), 1) with freeze_time(next_month): add_app_statistics(userid, platform, error_app) self.assertEqual(len(events_request_appid(next_month)), 0) self.assertEqual(len(events_request_appid_platform(next_month)), 0) with freeze_time(next_month): add_app_statistics(userid, platform, success_app) self.assertEqual(len(events_request_appid(next_month)), 1) self.assertEqual(len(events_request_appid_platform(next_month)), 1) self.assertEqual(len(events_new_appid(next_month)), 0) self.assertEqual(len(events_request_appid_version(next_month)), 1) self.assertEqual(len(events_new_appid_platform(next_month)), 0) self.assertEqual(len(events_request_appid_channel(next_month)), 1) self.assertEqual( len(events_request_appid_platform_version(next_month)), 1) self.assertEqual( len(events_request_appid_platform_channel_version(next_month)), 1) self.assertIn(userid, events_request_appid(next_month)) self.assertIn(userid, events_request_appid_platform(next_month))
def test_add_app_statistics(self): now = datetime.utcnow() next_month = now.replace(month=now.month + 1) userid = 1 platform = 'mac' appid = '{F97917B1-19AB-48C1-9802-CEF305B10804}' version = '0.0.0.1' channel = 'test' test_app = dict(appid=appid, version=version, tag=channel) events_request_appid = lambda date=now: DayEvents.from_date('request:%s' % appid, date) events_new_appid = lambda date=now: DayEvents.from_date('new_install:%s' % appid, date) events_request_appid_version = lambda date=now: DayEvents.from_date('request:{}:{}'.format(appid, version), date) events_request_appid_platform = lambda date=now: DayEvents.from_date('request:{}:{}'.format(appid, platform), date) events_new_appid_platform = lambda date=now: DayEvents.from_date('new_install:{}:{}'.format(appid, platform), date) events_request_appid_channel = lambda date=now: DayEvents.from_date('request:{}:{}'.format(appid, channel), date) events_request_appid_platform_version = lambda date=now: DayEvents.from_date( 'request:{}:{}:{}'.format(appid, platform, version), date) events_request_appid_platform_channel_version = lambda date=now: DayEvents.from_date( 'request:{}:{}:{}:{}'.format(appid, platform, channel, version), date) self.assertEqual(len(events_new_appid()), 0) self.assertEqual(len(events_request_appid()), 0) self.assertEqual(len(events_request_appid_version()), 0) self.assertEqual(len(events_request_appid_platform()), 0) self.assertEqual(len(events_new_appid_platform()), 0) self.assertEqual(len(events_request_appid_channel()), 0) self.assertEqual(len(events_request_appid_platform_version()), 0) self.assertEqual(len(events_request_appid_platform_channel_version()), 0) add_app_statistics(userid, platform, test_app) self.assertEqual(len(events_new_appid()), 1) self.assertEqual(len(events_request_appid()), 0) self.assertEqual(len(events_request_appid_version()), 1) self.assertEqual(len(events_new_appid_platform()), 1) self.assertEqual(len(events_request_appid_platform()), 0) self.assertEqual(len(events_request_appid_channel()), 1) self.assertEqual(len(events_request_appid_platform_version()), 1) self.assertEqual(len(events_request_appid_platform_channel_version()), 1) self.assertIn(userid, events_new_appid()) self.assertIn(userid, events_request_appid_version()) self.assertIn(userid, events_new_appid_platform()) self.assertIn(userid, events_request_appid_channel()) self.assertIn(userid, events_request_appid_platform_version()) self.assertIn(userid, events_request_appid_platform_channel_version()) add_app_statistics(userid, platform, test_app) self.assertEqual(len(events_new_appid()), 1) self.assertEqual(len(events_request_appid()), 0) self.assertEqual(len(events_request_appid_version()), 1) self.assertEqual(len(events_new_appid_platform()), 1) self.assertEqual(len(events_request_appid_platform()), 0) self.assertEqual(len(events_request_appid_channel()), 1) self.assertEqual(len(events_request_appid_platform_version()), 1) self.assertEqual(len(events_request_appid_platform_channel_version()), 1) with freeze_time(next_month): add_app_statistics(userid, platform, test_app) self.assertEqual(len(events_request_appid(next_month)), 1) self.assertEqual(len(events_request_appid_platform(next_month)), 1) self.assertEqual(len(events_new_appid(next_month)), 0) self.assertEqual(len(events_request_appid_version(next_month)), 1) self.assertEqual(len(events_new_appid_platform(next_month)), 0) self.assertEqual(len(events_request_appid_channel(next_month)), 1) self.assertEqual(len(events_request_appid_platform_version(next_month)), 1) self.assertEqual(len(events_request_appid_platform_channel_version(next_month)), 1) self.assertIn(userid, events_request_appid(next_month)) self.assertIn(userid, events_request_appid_platform(next_month)) self.assertIn(userid, events_request_appid_platform_channel_version(next_month))
def test_add_app_statistics(self): now = datetime.utcnow() next_month = now.replace(month=now.month + 1) userid = 1 channel = DEFAULT_CHANNEL platform = 'win' app_kwargs = dict(appid='{2882CF9B-D9C2-4edb-9AAF-8ED5FCF366F7}', nextversion='0.0.0.1') success_app = create_app_xml(events=fixtures.event_install_success, **app_kwargs) error_app = create_app_xml(events=fixtures.event_install_error, **app_kwargs) appid = app_kwargs.get('appid') version = app_kwargs.get('nextversion') events_request_appid = lambda date=now: DayEvents.from_date('request:%s' % appid, date) events_new_appid = lambda date=now: DayEvents.from_date('new_install:%s' % appid, date) events_request_appid_version = lambda date=now: DayEvents.from_date('request:{}:{}'.format(appid, version), date) events_request_appid_platform = lambda date=now: DayEvents.from_date('request:{}:{}'.format(appid, platform), date) events_new_appid_platform = lambda date=now: DayEvents.from_date('new_install:{}:{}'.format(appid, platform), date) events_request_appid_channel = lambda date=now: DayEvents.from_date('request:{}:{}'.format(appid, channel), date) events_request_appid_platform_version = lambda date=now: DayEvents.from_date( 'request:{}:{}:{}'.format(appid, platform, version), date) events_request_appid_platform_channel_version = lambda date=now: DayEvents.from_date( 'request:{}:{}:{}:{}'.format(appid, platform, channel, version), date) self.assertEqual(len(events_new_appid()), 0) self.assertEqual(len(events_request_appid()), 0) self.assertEqual(len(events_request_appid_version()), 0) self.assertEqual(len(events_request_appid_platform()), 0) self.assertEqual(len(events_new_appid_platform()), 0) self.assertEqual(len(events_request_appid_channel()), 0) self.assertEqual(len(events_request_appid_platform_version()), 0) self.assertEqual(len(events_request_appid_platform_channel_version()), 0) add_app_statistics(userid, platform, error_app) self.assertEqual(len(events_new_appid()), 0) self.assertEqual(len(events_request_appid()), 0) self.assertEqual(len(events_request_appid_version()), 0) self.assertEqual(len(events_request_appid_platform()), 0) self.assertEqual(len(events_new_appid_platform()), 0) self.assertEqual(len(events_request_appid_channel()), 0) self.assertEqual(len(events_request_appid_platform_version()), 0) self.assertEqual(len(events_request_appid_platform_channel_version()), 0) add_app_statistics(userid, platform, success_app) self.assertEqual(len(events_new_appid()), 1) self.assertEqual(len(events_request_appid()), 0) self.assertEqual(len(events_request_appid_version()), 1) self.assertEqual(len(events_new_appid_platform()), 1) self.assertEqual(len(events_request_appid_platform()), 0) self.assertEqual(len(events_request_appid_channel()), 1) self.assertEqual(len(events_request_appid_platform_version()), 1) self.assertEqual(len(events_request_appid_platform_channel_version()), 1) self.assertIn(userid, events_new_appid()) self.assertIn(userid, events_request_appid_version()) self.assertIn(userid, events_new_appid_platform()) self.assertIn(userid, events_request_appid_channel()) self.assertIn(userid, events_request_appid_platform_version()) self.assertIn(userid, events_request_appid_platform_channel_version()) add_app_statistics(userid, platform, success_app) self.assertEqual(len(events_new_appid()), 1) self.assertEqual(len(events_request_appid()), 0) self.assertEqual(len(events_request_appid_version()), 1) self.assertEqual(len(events_new_appid_platform()), 1) self.assertEqual(len(events_request_appid_platform()), 0) self.assertEqual(len(events_request_appid_channel()), 1) self.assertEqual(len(events_request_appid_platform_version()), 1) with freeze_time(next_month): add_app_statistics(userid, platform, error_app) self.assertEqual(len(events_request_appid(next_month)), 0) self.assertEqual(len(events_request_appid_platform(next_month)), 0) with freeze_time(next_month): add_app_statistics(userid, platform, success_app) self.assertEqual(len(events_request_appid(next_month)), 1) self.assertEqual(len(events_request_appid_platform(next_month)), 1) self.assertEqual(len(events_new_appid(next_month)), 0) self.assertEqual(len(events_request_appid_version(next_month)), 1) self.assertEqual(len(events_new_appid_platform(next_month)), 0) self.assertEqual(len(events_request_appid_channel(next_month)), 1) self.assertEqual(len(events_request_appid_platform_version(next_month)), 1) self.assertEqual(len(events_request_appid_platform_channel_version(next_month)), 1) self.assertIn(userid, events_request_appid(next_month)) self.assertIn(userid, events_request_appid_platform(next_month))