def test_create_time_to_x_day_totals(): execute_sql(c.create_time_to_x_day_totals) df_test = pd.read_sql("""SELECT * FROM time_to_x_day_totals WHERE \ distinct_id = '681CFA45-B526-4FE4-A2DF-F73F2D0CF674' AND "story id"='4b8a78d7-9a1b-45fc-9a39-a8c7e4209569'""", engine) n.assert_equal(len(df_test), 5) n.assert_equal( df_test[ (df_test.date == "2015-02-25") & ( df_test["story completion"] == '10')]["day_time_total"].values[0], 94) n.assert_equal( df_test[ (df_test.date == "2015-02-25") & ( df_test["story completion"] == '10')]["day_count"].values[0], 2) n.assert_equal( df_test[ (df_test.date == "2015-02-25") & ( df_test["story completion"] == '10')]["day_time_avg"].values[0], 47) df_test = pd.read_sql("""SELECT distinct date FROM time_to_x_day_totals WHERE \ distinct_id = '681CFA45-B526-4FE4-A2DF-F73F2D0CF674' """, engine) n.assert_equal(len(df_test), 38) # equal to dates during users life
def test_create_time_to_x_agg_day_stats(): execute_sql(c.create_time_to_x_agg_day_stats) df_test = pd.read_sql("""SELECT * FROM time_to_10_agg_day_stats WHERE distinct_id = '681CFA45-B526-4FE4-A2DF-F73F2D0CF674'""", engine) n.assert_equal(len(df_test), 1) n.assert_equal(round(df_test['agg_day_time_total'].values[0]), 4860) n.assert_equal(df_test['agg_day_time_avg'].values[0], 200) n.assert_equal(df_test['agg_day_count'].values[0], 25) n.assert_equal(df_test['agg_day_count_avg'].values[0], 0.6578) check_one_row_per_user("time_to_10_agg_day_stats")
def test_create_time_to_x_day_stats(): execute_sql(c.create_time_to_x_day_stats) df_test = pd.read_sql("""SELECT * FROM time_to_10_day_stats WHERE distinct_id = '681CFA45-B526-4FE4-A2DF-F73F2D0CF674' AND "story id"='4b8a78d7-9a1b-45fc-9a39-a8c7e4209569'""", engine) n.assert_equal(len(df_test), 1) n.assert_equal(round(df_test['agg_day_time_total'].values[0]), 94) n.assert_equal(df_test['agg_day_time_avg'].values[0], 47) n.assert_equal(df_test['agg_day_count'].values[0], 2) n.assert_equal( df_test['agg_day_count_avg'].values[0], 2) # read it in one day
def test_create_all_day_story_stats(): execute_sql(c.create_all_day_story_stats) df_test = pd.read_sql("""SELECT * FROM story_4368f127_e34b_44d7_807e_5f1a72638a79_day_stats WHERE distinct_id = '681CFA45-B526-4FE4-A2DF-F73F2D0CF674' """, engine) n.assert_equal(len(df_test), 1) n.assert_equal(round(df_test['agg_day_time_total'].values[0]), 3000) n.assert_equal(df_test['agg_day_time_avg'].values[0], 3000) n.assert_equal(df_test['agg_day_count'].values[0], 1) n.assert_equal(df_test['agg_day_count_avg'].values[0], 1) check_one_row_per_user( "story_4368f127_e34b_44d7_807e_5f1a72638a79_day_stats")