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")
