def test_anon_week(self):
"""Test JOB dashboard returns anon active week runs."""
TaskRunFactory.create()
AnonymousTaskRunFactory.create()
dashboard_active_anon_week()
sql = "select * from dashboard_week_anon;"
results = db.session.execute(sql)
for row in results:
assert row.n_users == 1, row.n_users
def test_anon_week(self):
"""Test JOB dashboard returns anon active week runs."""
TaskRunFactory.create()
AnonymousTaskRunFactory.create()
active_anon_week()
sql = "select * from dashboard_week_anon;"
results = db.session.execute(sql).fetchall()
assert results[0].n_users == 1, results[0].n_users
def test_anon_week(self):
"""Test JOB dashboard returns anon active week runs."""
TaskRunFactory.create()
AnonymousTaskRunFactory.create()
active_anon_week()
sql = "select * from dashboard_week_anon;"
results = db.session.execute(sql).fetchall()
assert results[0].n_users == 1, results[0].n_users
def test_active_week(self):
"""Test JOB dashboard returns active users week runs."""
TaskRunFactory.create()
AnonymousTaskRunFactory.create()
active_users_week()
sql = "select * from dashboard_week_users;"
results = db.session.execute(sql)
for row in results:
assert row.n_users == 1, row.n_users
def test_format_users_week(self):
"""Test format users week works."""
TaskRunFactory.create()
active_users_week()
res = format_users_week()
assert len(res['labels']) == 1
day = datetime.utcnow().strftime('%Y-%m-%d')
assert res['labels'][0] == day
assert len(res['series']) == 1
assert res['series'][0][0] == 1, res['series'][0][0]
def test_format_users_week(self):
"""Test format users week works."""
TaskRunFactory.create()
active_users_week()
res = format_users_week()
assert len(res['labels']) == 1
day = datetime.utcnow().strftime('%Y-%m-%d')
assert res['labels'][0] == day
assert len(res['series']) == 1
assert res['series'][0][0] == 1, res['series'][0][0]
def test_format_new_task_runs(self):
"""Test format new task_runs works."""
TaskRunFactory.create()
AnonymousTaskRunFactory.create()
new_task_runs_week()
res = format_new_task_runs()
assert len(res['labels']) == 1
day = datetime.utcnow().strftime('%Y-%m-%d')
assert res['labels'][0] == day, res
assert len(res['series']) == 1
assert res['series'][0][0] == 2, res['series'][0][0]
def test_format_anon_week_empty(self, db_mock):
"""Test format anon week empty works."""
db_mock.slave_session.execute.return_value = []
TaskRunFactory.create()
active_anon_week()
res = format_anon_week()
assert len(res['labels']) == 1
day = datetime.utcnow().strftime('%Y-%m-%d')
assert res['labels'][0] == day
assert len(res['series']) == 1
assert res['series'][0][0] == 0, res['series'][0][0]
def test_returning_users(self):
"""Test JOB dashboard returns number of returning users."""
task_run = TaskRunFactory.create()
day = datetime.utcnow() - timedelta(days=1)
TaskRunFactory.create(finish_time=day.isoformat())
returning_users_week()
sql = "select * from dashboard_week_returning_users;"
results = db.session.execute(sql)
for row in results:
assert row.n_days == 2
assert row.user_id == task_run.user_id
def test_returning_users(self):
"""Test JOB dashboard returns number of returning users."""
task_run = TaskRunFactory.create()
day = datetime.utcnow() - timedelta(days=1)
TaskRunFactory.create(finish_time=day.isoformat())
dashboard_returning_users_week()
sql = "select * from dashboard_week_returning_users;"
results = db.session.execute(sql)
for row in results:
assert row.n_days == 2
assert row.user_id == task_run.user_id
def test_new_task_runs(self):
"""Test JOB dashboard returns new task runs."""
day = datetime.utcnow() - timedelta(days=2)
TaskRunFactory.create(finish_time=day.isoformat())
day = datetime.utcnow() - timedelta(days=1)
TaskRunFactory.create(finish_time=day.isoformat())
new_task_runs_week()
sql = "select * from dashboard_week_new_task_run;"
results = db.session.execute(sql)
for row in results:
assert row.day_task_runs == 1, row.day_task_runs
def test_format_anon_week_empty(self, db_mock):
"""Test format anon week empty works."""
db_mock.slave_session.execute.return_value = []
TaskRunFactory.create()
active_anon_week()
res = format_anon_week()
assert len(res['labels']) == 1
day = datetime.utcnow().strftime('%Y-%m-%d')
assert res['labels'][0] == day
assert len(res['series']) == 1
assert res['series'][0][0] == 0, res['series'][0][0]
def test_format_new_task_runs(self):
"""Test format new task_runs works."""
TaskRunFactory.create()
AnonymousTaskRunFactory.create()
new_task_runs_week()
res = format_new_task_runs()
assert len(res['labels']) == 1
day = datetime.utcnow().strftime('%Y-%m-%d')
assert res['labels'][0] == day, res
assert len(res['series']) == 1
assert res['series'][0][0] == 2, res['series'][0][0]
def test_new_task_runs(self):
"""Test JOB dashboard returns new task runs."""
day = datetime.utcnow() - timedelta(days=2)
TaskRunFactory.create(finish_time=day.isoformat())
day = datetime.utcnow() - timedelta(days=1)
TaskRunFactory.create(finish_time=day.isoformat())
new_task_runs_week()
sql = "select * from dashboard_week_new_task_run;"
results = db.session.execute(sql)
for row in results:
assert row.day_task_runs == 1, row.day_task_runs
def test_format_returning_users_emtpy(self, db_mock):
"""Test format returning users works."""
db_mock.slave_session.execute.return_value = []
TaskRunFactory.create()
day = datetime.utcnow() - timedelta(days=1)
TaskRunFactory.create(finish_time=day.isoformat())
returning_users_week()
res = format_returning_users()
for i in range(1, 8):
if i == 1:
day = '%s day' % i
else:
day = "%s days" % i
err = "%s != %s" % (res['labels'][i - 1], day)
assert res['labels'][i - 1] == day, err
assert res['series'][0][i - 1] == 0, res['series'][i][0]
def test_format_returning_users_emtpy(self, db_mock):
"""Test format returning users works."""
db_mock.slave_session.execute.return_value = []
TaskRunFactory.create()
day = datetime.utcnow() - timedelta(days=1)
TaskRunFactory.create(finish_time=day.isoformat())
dashboard_returning_users_week()
res = format_returning_users()
for i in range(1,8):
if i == 1:
day = '%s day' % i
else:
day = "%s days" % i
err = "%s != %s" % (res['labels'][i - 1], day)
assert res['labels'][i - 1] == day, err
assert res['series'][0][i - 1] == 0, res['series'][i][0]
def test_returning_users(self):
"""Test JOB dashboard returns number of returning users."""
once_only_user = UserFactory.create()
returning_user = UserFactory.create()
TaskRunFactory.create(user=once_only_user)
TaskRunFactory.create(user=returning_user)
task_run = TaskRunFactory.create(user=returning_user)
day = datetime.utcnow() - timedelta(days=1)
TaskRunFactory.create(user=returning_user, finish_time=day.isoformat())
returning_users_week()
sql = "select * from dashboard_week_returning_users;"
results = db.session.execute(sql).fetchall()
assert results[0].n_days == 2
assert results[0].user_id == task_run.user_id
def test_returning_users(self):
"""Test JOB dashboard returns number of returning users."""
once_only_user = UserFactory.create()
returning_user = UserFactory.create()
TaskRunFactory.create(user=once_only_user)
TaskRunFactory.create(user=returning_user)
task_run = TaskRunFactory.create(user=returning_user)
day = datetime.utcnow() - timedelta(days=1)
TaskRunFactory.create(user=returning_user, finish_time=day.isoformat())
returning_users_week()
sql = "select * from dashboard_week_returning_users;"
results = db.session.execute(sql).fetchall()
assert results[0].n_days == 2
assert results[0].user_id == task_run.user_id
def test_format_returning_users(self):
"""Test format returning users works."""
u = UserFactory.create()
TaskRunFactory.create(user=u)
TaskRunFactory.create(user=u)
TaskRunFactory.create(user=u)
TaskRunFactory.create(user=u)
TaskRunFactory.create(user=u)
TaskRunFactory.create(user=u)
day = datetime.utcnow() - timedelta(days=2)
TaskRunFactory.create(user=u, finish_time=day.isoformat())
day = datetime.utcnow() - timedelta(days=1)
TaskRunFactory.create(user=u, finish_time=day.isoformat())
TaskRunFactory.create(user=u, finish_time=day.isoformat())
TaskRunFactory.create(user=u, finish_time=day.isoformat())
TaskRunFactory.create(user=u, finish_time=day.isoformat())
TaskRunFactory.create(user=u, finish_time=day.isoformat())
dashboard_returning_users_week()
res = format_returning_users()
for i in range(1,8):
if i == 1:
day = '%s day' % i
else:
day = "%s days" % i
err = "%s != %s" % (res['labels'][i - 1], day)
assert res['labels'][i - 1] == day, err
if day == '3 days':
assert res['labels'][i - 1] == day, day
assert res['series'][0][i - 1] == 1, res['series'][0][i - 1]
else:
assert res['series'][0][i - 1] == 0, res
def test_format_returning_users(self):
"""Test format returning users works."""
u = UserFactory.create()
TaskRunFactory.create(user=u)
TaskRunFactory.create(user=u)
TaskRunFactory.create(user=u)
TaskRunFactory.create(user=u)
TaskRunFactory.create(user=u)
TaskRunFactory.create(user=u)
day = datetime.utcnow() - timedelta(days=2)
TaskRunFactory.create(user=u, finish_time=day.isoformat())
day = datetime.utcnow() - timedelta(days=1)
TaskRunFactory.create(user=u, finish_time=day.isoformat())
TaskRunFactory.create(user=u, finish_time=day.isoformat())
TaskRunFactory.create(user=u, finish_time=day.isoformat())
TaskRunFactory.create(user=u, finish_time=day.isoformat())
TaskRunFactory.create(user=u, finish_time=day.isoformat())
returning_users_week()
res = format_returning_users()
for i in range(1, 8):
if i == 1:
day = '%s day' % i
else:
day = "%s days" % i
err = "%s != %s" % (res['labels'][i - 1], day)
assert res['labels'][i - 1] == day, err
if day == '3 days':
assert res['labels'][i - 1] == day, day
assert res['series'][0][i - 1] == 1, res['series'][0][i - 1]
else:
assert res['series'][0][i - 1] == 0, res
