def check_twitter_lag_test(venue_id):
psql = """SELECT followers, record_date
FROM social_media_followers
WHERE venue_id = {} AND platform = 'Twitter'
ORDER BY record_date DESC
LIMIT 1""".format(venue_id)
venue_twitter_data = clientdata._get_db_data(psql)
if check_lag(venue_twitter_data, twitter_lag) == True:
return True
else:
return False
def check_facebook_reactions_lag_test(venue_id):
psql = """SELECT pageconsumptions, fromdate
FROM facebookreading
WHERE venue_id = {}
ORDER BY fromdate DESC
LIMIT 1""".format(venue_id)
venue_fb_data = clientdata._get_db_data(psql)
if check_lag(venue_fb_data, facebook_lag) == True:
return True
else:
return False
def check_facebook_engagement_impressions_lag_test(venue_id):
psql = """SELECT postimpressions, fromdate
FROM facebookpostinsightreading
WHERE venue_id = {}
ORDER BY fromdate DESC
LIMIT 1""".format(venue_id)
venue_fb_data = clientdata._get_db_data(psql)
if check_lag(venue_fb_data, facebook_lag) == True:
return True
else:
return False
def check_weather_lag_test(venue_id):
psql = """SELECT temperaturecelsius, timestamp
FROM weatherdatareading
WHERE venue_id = {}
ORDER BY timestamp DESC
LIMIT 1""".format(venue_id)
venue_weather_data = clientdata._get_db_data(psql)
if check_lag(venue_weather_data, weather_lag) == True:
return True
else:
return False
def check_google_analytics_lag_test(venue_id):
psql = """SELECT sessions, record_date
FROM google_analytics_daily
WHERE venue_id = {}
ORDER BY record_date DESC
LIMIT 1""".format(venue_id)
venue_ga_data = clientdata._get_db_data(psql)
if check_lag(venue_ga_data, google_analytics_lag) == True:
return True
else:
return False
def check_google_analytics_data(venue_id,days):
psql = """SELECT sessions, record_date
FROM google_analytics_daily
WHERE venue_id = {}
ORDER BY record_date DESC
LIMIT {}""".format(venue_id,days)
venue_ga_data = clientdata._get_db_data(psql)
ga_date_gaps = check_missing_day_data_gap(venue_ga_data, days,datalags.google_analytics_lag)
if ga_date_gaps == None:
return None
else:
return (ga_date_gaps)
def check_twitter_data(venue_id,days):
psql = """SELECT followers, record_date
FROM social_media_followers
WHERE venue_id = {} AND platform = 'Twitter'
ORDER BY record_date DESC
LIMIT {}""".format(venue_id,days)
venue_twitter_data = clientdata._get_db_data(psql)
twitter_date_gaps = check_missing_day_data_gap(venue_twitter_data, days,datalags.facebook_lag)
if twitter_date_gaps == None:
return None
else:
return (twitter_date_gaps)
def check_instagram_data(venue_id,days):
psql = """SELECT followers, record_date
FROM social_media_followers
WHERE venue_id = {} AND platform = 'Instagram'
ORDER BY record_date DESC
LIMIT {}""".format(venue_id,days)
venue_instagram_data = clientdata._get_db_data(psql)
instagram_date_gaps = check_missing_day_data_gap(venue_instagram_data, days,datalags.instagram_lag)
if instagram_date_gaps == None:
return None
else:
return (instagram_date_gaps)
def check_presence_lag_test(venue_id):
psql = """SELECT dwell_time,record_date
FROM daily_presence_by_zone
WHERE venue_id = {}
ORDER BY record_date DESC
LIMIT 1""".format(venue_id)
venue_presence_data = clientdata._get_db_data(psql)
present_date = datetime.now()
if len(venue_presence_data) == 0:
return True
elif venue_presence_data[0][1] < present_date.date() - timedelta(
days=presence_lag_time):
return True
else:
return False
