def test_find_last_thirty_days():
with freeze_time("2019-05-01"):
start_date, end_date = find_last_thirty_days()
assert end_date == datetime.date(2019, 4, 30)
assert start_date == datetime.date(2019, 4, 1)
with freeze_time("2020-03-19"):
start_date, end_date = find_last_thirty_days()
assert end_date == datetime.date(2020, 3, 18)
assert start_date == datetime.date(2020, 2, 18)
def get_transactions_for_tools_request(tool):
start_date, end_date = find_last_thirty_days()
filters = [{
'dimensionName': 'ga:eventCategory',
'operator': 'REGEXP',
'expressions': [tool['event_category_filter']]
}, {
'dimensionName': 'ga:pagePath',
'operator': 'REGEXP',
'expressions': [tool['page_path_filter']]
}]
if 'event_action_filter' in tool:
filters.append({
'dimensionName': 'ga:eventAction',
'operator': 'REGEXP',
'expressions': [tool['event_action_filter']]
})
return {
'viewId':
VADOTGOV_VIEW_ID,
'dateRanges': [{
'startDate': start_date.isoformat(),
'endDate': end_date.isoformat()
}],
'metrics': [{
'expression': 'ga:totalEvents'
}],
'dimensionFilterClauses': [{
'operator': 'AND',
'filters': filters
}]
}
def get_last_month_users_request(page_path):
start_date, end_date = find_last_thirty_days()
return {
"viewId": VADOTGOV_VIEW_ID,
"dateRanges": [
{
"startDate": start_date.isoformat(),
"endDate": end_date.isoformat()
},
{
"startDate": one_year_before(start_date).isoformat(),
"endDate": one_year_before(end_date).isoformat()
}
],
"metrics": [
{
"expression": "ga:users"
}
],
"dimensionFilterClauses": [
{
"filters": [
{
"dimensionName": "ga:pagePath",
"operator": "REGEXP",
"expressions": [
page_path
]
}
]
}
]
}
def get_foresee_items_for_services():
start_date, end_date = find_last_thirty_days()
recent_items = get_measure_data(authenticate(), start_date, end_date)
recent_df = pd.DataFrame(make_table_from_foresee_response(recent_items))
last_year_items = get_measure_data(authenticate(), one_year_before(start_date), one_year_before(end_date))
last_year_df = pd.DataFrame(make_table_from_foresee_response(last_year_items))
return recent_df, last_year_df