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)
