def test_update_projects_week(self):
"""Test JOB update projects week works."""
p = ProjectFactory.create()
p.name = 'NewNameName'
project_repository = ProjectRepository(db)
project_repository.update(p)
update_projects_week()
sql = "select * from dashboard_week_project_update;"
results = db.session.execute(sql)
for row in results:
assert row.id == p.id
assert row.name == p.name
assert row.owner_id == p.owner_id
assert row.u_name == p.owner.name
assert row.email_addr == p.owner.email_addr
def test_update_projects_week(self):
"""Test JOB update projects week works."""
p = ProjectFactory.create()
p.name = 'NewNameName'
project_repository = ProjectRepository(db)
project_repository.update(p)
update_projects_week()
sql = "select * from dashboard_week_project_update;"
results = db.session.execute(sql)
for row in results:
assert row.id == p.id
assert row.name == p.name
assert row.owner_id == p.owner_id
assert row.u_name == p.owner.name
assert row.email_addr == p.owner.email_addr
def test_format_updated_projects(self):
"""Test format updated projects works."""
p = ProjectFactory.create()
p.name = 'NewNewNew'
project_repo = ProjectRepository(db)
project_repo.update(p)
update_projects_week()
res = format_update_projects()
day = datetime.utcnow().strftime('%Y-%m-%d')
res = res[0]
assert res['day'].strftime('%Y-%m-%d') == day, res['day']
assert res['id'] == p.id
assert res['short_name'] == p.short_name
assert res['p_name'] == p.name
assert res['email_addr'] == p.owner.email_addr
assert res['owner_id'] == p.owner.id
assert res['u_name'] == p.owner.name
def test_format_updated_projects(self):
"""Test format updated projects works."""
p = ProjectFactory.create()
p.name = 'NewNewNew'
project_repo = ProjectRepository(db)
project_repo.update(p)
update_projects_week()
res = format_update_projects()
day = datetime.utcnow().strftime('%Y-%m-%d')
res = res[0]
assert res['day'].strftime('%Y-%m-%d') == day, res['day']
assert res['id'] == p.id
assert res['short_name'] == p.short_name
assert res['p_name'] == p.name
assert res['email_addr'] == p.owner.email_addr
assert res['owner_id'] == p.owner.id
assert res['u_name'] == p.owner.name
def test_materialized_view_created(self, db_mock):
"""Test JOB dashboard materialized view is created."""
result = MagicMock()
result.exists = False
results = [result]
db_mock.slave_session.execute.return_value = results
res = update_projects_week()
assert db_mock.session.commit.called
assert res == 'Materialized view created'
def test_admin_dashboard_admin_user_data(self):
"""Test ADMIN dashboard admins can access it with data"""
url = '/admin/dashboard/'
self.register()
self.new_project()
self.new_task(1)
import pybossa.dashboard.jobs as dashboard
dashboard.active_anon_week()
dashboard.active_users_week()
dashboard.new_users_week()
dashboard.new_tasks_week()
dashboard.new_task_runs_week()
dashboard.new_projects_week()
dashboard.update_projects_week()
dashboard.returning_users_week()
res = self.app.get(url, follow_redirects=True)
err_msg = "It should return 200"
assert res.status_code == 200, err_msg
assert "No data" not in res.data, res.data
assert "New Users" in res.data, res.data
def test_admin_dashboard_admin_user_data(self):
"""Test ADMIN dashboard admins can access it with data"""
url = '/admin/dashboard/'
self.register()
self.new_project()
self.new_task(1)
import pybossa.dashboard.jobs as dashboard
dashboard.active_anon_week()
dashboard.active_users_week()
dashboard.new_users_week()
dashboard.new_tasks_week()
dashboard.new_task_runs_week()
dashboard.new_projects_week()
dashboard.update_projects_week()
dashboard.returning_users_week()
res = self.app.get(url, follow_redirects=True)
err_msg = "It should return 200"
assert res.status_code == 200, err_msg
assert "No data" not in res.data, res.data
assert "New Users" in res.data, res.data
