def populate_analytics(request): '''fixture used to populate guest_tracks to test analytics function ''' site1 = Wifisite.query.filter_by(unifi_id='site1').first() tracks = [] tzinfo = tz.gettz(site1.timezone) day_start = arrow.now(tzinfo).floor('day').to('UTC') ap_mac = randomMAC() #create 20 tracks, starting from day start and spaced 1minutes apart for i in range(20): track = Guesttrack(ap_mac=ap_mac, device_mac=randomMAC(), site=site1, state=GUESTRACK_INIT, orig_url='', track_id=str(uuid.uuid4())) db.session.add(track) track.timestamp = day_start.replace(minutes=+i * 1).naive tracks.append(track) #create device db.session.commit() day_start = arrow.now(tzinfo).floor('day').to('UTC').replace(days=-1) #create 20 tracks, starting from day start and spaced 1minutes apart on previous day for i in range(20): track = Guesttrack(ap_mac=ap_mac, device_mac=randomMAC(), site=site1, state=GUESTRACK_INIT, orig_url='', track_id=str(uuid.uuid4())) db.session.add(track) track.timestamp = day_start.replace(minutes=+i * 1).naive tracks.append(track) #create device db.session.commit() day_start = arrow.now(tzinfo).floor('day').to('UTC').replace(days=+1) #create 20 tracks, starting from day start and spaced 1minutes apart on next day for i in range(20): track = Guesttrack(ap_mac=ap_mac, device_mac=randomMAC(), site=site1, state=GUESTRACK_INIT, orig_url='', track_id=str(uuid.uuid4())) db.session.add(track) track.timestamp = day_start.replace(minutes=+i * 1).naive tracks.append(track) #create device db.session.commit()
def test_update_daily_stat3(session, populate_analytics): '''Check if update_daily_stat is able to gather correct analytics when tracks which are atleast 2hrs apart''' site1 = Wifisite.query.filter_by(id=1).first() tzinfo = tz.gettz(site1.timezone) daydate = arrow.now(tzinfo) starttime = daydate.floor('day').to('UTC') track1 = Guesttrack.query.first() #create similar tracks as track 1 with 3hr timestamp difference for i in range(3): timestamp = starttime.replace(hours=+(3 * i + 3)) track = Guesttrack(ap_mac=track1.ap_mac, device_mac=track1.device_mac, site=site1, state=GUESTRACK_INIT, orig_url='', track_id=str(uuid.uuid4())) db.session.add(track) track.timestamp = timestamp.naive db.session.commit() update_daily_stat(site1.id, daydate) sitestat = Sitestat.query.first() assert 0 == sitestat.get_total_logins( ), 'Num Logins is :%s instead of expected :%s' % ( sitestat.get_total_logins(), 0) assert 23 == sitestat.num_visits, 'Num visits is :%s instead of expected :%s' % ( sitestat.num_visits, 20)
def test_update_daily_stat3(session, populate_analytics): """Check if update_daily_stat is able to gather correct analytics when tracks which are atleast 2hrs apart""" site1 = Wifisite.query.filter_by(id=1).first() tzinfo = tz.gettz(site1.timezone) daydate = arrow.now(tzinfo) starttime = daydate.floor("day").to("UTC") track1 = Guesttrack.query.first() # create similar tracks as track 1 with 3hr timestamp difference for i in range(3): timestamp = starttime.replace(hours=+(3 * i + 3)) track = Guesttrack( ap_mac=track1.ap_mac, device_mac=track1.device_mac, site=site1, state=GUESTRACK_INIT, orig_url="", track_id=str(uuid.uuid4()), ) db.session.add(track) track.timestamp = timestamp.naive db.session.commit() update_daily_stat(site1.id, daydate) sitestat = Sitestat.query.first() assert 0 == sitestat.get_total_logins(), "Num Logins is :%s instead of expected :%s" % ( sitestat.get_total_logins(), 0, ) assert 23 == sitestat.num_visits, "Num visits is :%s instead of expected :%s" % (sitestat.num_visits, 20)
def test_update_daily_stat4(session, populate_analytics): '''Check if update_daily_stat is able to gather correct analytics when tracks different types of tracks are present''' site1 = Wifisite.query.filter_by(id=1).first() tzinfo = tz.gettz(site1.timezone) daydate = arrow.now(tzinfo) starttime = daydate.floor('day').to('UTC') track1 = Guesttrack.query.first() #create 5 SMS tracks with unique MACs for i in range(5): timestamp = starttime.replace(hours=+5, minutes=+5 * i) track = Guesttrack(ap_mac=track1.ap_mac, device_mac=randomMAC(), site=site1, state=GUESTRACK_INIT, orig_url='', track_id=str(uuid.uuid4())) db.session.add(track) track.timestamp = timestamp.naive track.state = GUESTRACK_SMS_AUTH db.session.commit() #create 8 Email tracks with unique MACs for i in range(8): timestamp = starttime.replace(hours=+5, minutes=+5 * i) track = Guesttrack(ap_mac=track1.ap_mac, device_mac=randomMAC(), site=site1, state=GUESTRACK_INIT, orig_url='', track_id=str(uuid.uuid4())) db.session.add(track) track.timestamp = timestamp.naive track.state = GUESTRACK_EMAIL_AUTH db.session.commit() #create 4 Voucher tracks with unique MACs for i in range(4): timestamp = starttime.replace(hours=+5, minutes=+5 * i) track = Guesttrack(ap_mac=track1.ap_mac, device_mac=randomMAC(), site=site1, state=GUESTRACK_INIT, orig_url='', track_id=str(uuid.uuid4())) db.session.add(track) track.timestamp = timestamp.naive track.state = GUESTRACK_VOUCHER_AUTH db.session.commit() #create 11 returning tracks with unique MACs for i in range(11): timestamp = starttime.replace(hours=+5, minutes=+5 * i) track = Guesttrack(ap_mac=track1.ap_mac, device_mac=randomMAC(), site=site1, state=GUESTRACK_INIT, orig_url='', track_id=str(uuid.uuid4())) db.session.add(track) track.timestamp = timestamp.naive track.state = GUESTRACK_PREAUTH db.session.commit() #create 20 FB tracks with unique MACs for i in range(20): timestamp = starttime.replace(hours=+5, minutes=+5 * i) track = Guesttrack(ap_mac=track1.ap_mac, device_mac=randomMAC(), site=site1, state=GUESTRACK_INIT, orig_url='', track_id=str(uuid.uuid4())) db.session.add(track) track.timestamp = timestamp.naive track.state = GUESTRACK_SOCIAL_AUTH db.session.commit() update_daily_stat(site1.id, daydate) sitestat = Sitestat.query.first() assert 48 == sitestat.get_total_logins( ), 'Num Logins is :%s instead of expected :%s' % ( sitestat.get_total_logins(), 48) assert 68 == sitestat.num_visits, 'Num visits is :%s instead of expected :%s' % ( sitestat.num_visits, 68) assert 11 == sitestat.num_repeats, 'num_repeats is :%s instead of expected :%s' % ( sitestat.num_repeats, 11) assert 8 == sitestat.num_emails, 'num_emails is :%s instead of expected :%s' % ( sitestat.num_emails, 8) assert 20 == sitestat.num_fb, 'num_fb is :%s instead of expected :%s' % ( sitestat.num_fb, 20) assert 4 == sitestat.num_vouchers, 'num_vouchers is :%s instead of expected :%s' % ( sitestat.num_vouchers, 20) assert 5 == sitestat.num_phones, 'num_phones is :%s instead of expected :%s' % ( sitestat.num_phones, 5)
def populate_analytics(request): """fixture used to populate guest_tracks to test analytics function """ site1 = Wifisite.query.filter_by(unifi_id="site1").first() tracks = [] tzinfo = tz.gettz(site1.timezone) day_start = arrow.now(tzinfo).floor("day").to("UTC") ap_mac = randomMAC() # create 20 tracks, starting from day start and spaced 1minutes apart for i in range(20): track = Guesttrack( ap_mac=ap_mac, device_mac=randomMAC(), site=site1, state=GUESTRACK_INIT, orig_url="", track_id=str(uuid.uuid4()), ) db.session.add(track) track.timestamp = day_start.replace(minutes=+i * 1).naive tracks.append(track) # create device db.session.commit() day_start = arrow.now(tzinfo).floor("day").to("UTC").replace(days=-1) # create 20 tracks, starting from day start and spaced 1minutes apart on previous day for i in range(20): track = Guesttrack( ap_mac=ap_mac, device_mac=randomMAC(), site=site1, state=GUESTRACK_INIT, orig_url="", track_id=str(uuid.uuid4()), ) db.session.add(track) track.timestamp = day_start.replace(minutes=+i * 1).naive tracks.append(track) # create device db.session.commit() day_start = arrow.now(tzinfo).floor("day").to("UTC").replace(days=+1) # create 20 tracks, starting from day start and spaced 1minutes apart on next day for i in range(20): track = Guesttrack( ap_mac=ap_mac, device_mac=randomMAC(), site=site1, state=GUESTRACK_INIT, orig_url="", track_id=str(uuid.uuid4()), ) db.session.add(track) track.timestamp = day_start.replace(minutes=+i * 1).naive tracks.append(track) # create device db.session.commit()
def test_update_daily_stat4(session, populate_analytics): """Check if update_daily_stat is able to gather correct analytics when tracks different types of tracks are present""" site1 = Wifisite.query.filter_by(id=1).first() tzinfo = tz.gettz(site1.timezone) daydate = arrow.now(tzinfo) starttime = daydate.floor("day").to("UTC") track1 = Guesttrack.query.first() # create 5 SMS tracks with unique MACs for i in range(5): timestamp = starttime.replace(hours=+5, minutes=+5 * i) track = Guesttrack( ap_mac=track1.ap_mac, device_mac=randomMAC(), site=site1, state=GUESTRACK_INIT, orig_url="", track_id=str(uuid.uuid4()), ) db.session.add(track) track.timestamp = timestamp.naive track.state = GUESTRACK_SMS_AUTH db.session.commit() # create 8 Email tracks with unique MACs for i in range(8): timestamp = starttime.replace(hours=+5, minutes=+5 * i) track = Guesttrack( ap_mac=track1.ap_mac, device_mac=randomMAC(), site=site1, state=GUESTRACK_INIT, orig_url="", track_id=str(uuid.uuid4()), ) db.session.add(track) track.timestamp = timestamp.naive track.state = GUESTRACK_EMAIL_AUTH db.session.commit() # create 4 Voucher tracks with unique MACs for i in range(4): timestamp = starttime.replace(hours=+5, minutes=+5 * i) track = Guesttrack( ap_mac=track1.ap_mac, device_mac=randomMAC(), site=site1, state=GUESTRACK_INIT, orig_url="", track_id=str(uuid.uuid4()), ) db.session.add(track) track.timestamp = timestamp.naive track.state = GUESTRACK_VOUCHER_AUTH db.session.commit() # create 11 returning tracks with unique MACs for i in range(11): timestamp = starttime.replace(hours=+5, minutes=+5 * i) track = Guesttrack( ap_mac=track1.ap_mac, device_mac=randomMAC(), site=site1, state=GUESTRACK_INIT, orig_url="", track_id=str(uuid.uuid4()), ) db.session.add(track) track.timestamp = timestamp.naive track.state = GUESTRACK_PREAUTH db.session.commit() # create 20 FB tracks with unique MACs for i in range(20): timestamp = starttime.replace(hours=+5, minutes=+5 * i) track = Guesttrack( ap_mac=track1.ap_mac, device_mac=randomMAC(), site=site1, state=GUESTRACK_INIT, orig_url="", track_id=str(uuid.uuid4()), ) db.session.add(track) track.timestamp = timestamp.naive track.state = GUESTRACK_SOCIAL_AUTH db.session.commit() update_daily_stat(site1.id, daydate) sitestat = Sitestat.query.first() assert 48 == sitestat.get_total_logins(), "Num Logins is :%s instead of expected :%s" % ( sitestat.get_total_logins(), 48, ) assert 68 == sitestat.num_visits, "Num visits is :%s instead of expected :%s" % (sitestat.num_visits, 68) assert 11 == sitestat.num_repeats, "num_repeats is :%s instead of expected :%s" % (sitestat.num_repeats, 11) assert 8 == sitestat.num_emails, "num_emails is :%s instead of expected :%s" % (sitestat.num_emails, 8) assert 20 == sitestat.num_fb, "num_fb is :%s instead of expected :%s" % (sitestat.num_fb, 20) assert 4 == sitestat.num_vouchers, "num_vouchers is :%s instead of expected :%s" % (sitestat.num_vouchers, 20) assert 5 == sitestat.num_phones, "num_phones is :%s instead of expected :%s" % (sitestat.num_phones, 5)