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