def test_assign_projects_from_ticket(self): project = ProjectFactory.create() tickets = MaximoTicket.objects.all()[:5] for ticket in tickets: ticket.project = project ticket.save() TestExcel.create_time_registers(date(2015, 9, 1), date(2015, 9, 30)) updated = MaximoTimeRegister.objects.assign_projects_from_ticket() self.assertEqual(294, updated) registers = MaximoTimeRegister.objects.filter(project__isnull=False) self.assertEqual(149, len(registers))
def test_assign_projects_from_ticket_filter(self): project = ProjectFactory.create() tickets = MaximoTicket.objects.all()[:5] for ticket in tickets: ticket.project = project ticket.save() TestExcel.create_time_registers(date(2015, 9, 1), date(2015, 9, 30)) updated = MaximoTimeRegister.objects.filter(date__range=(date(2015, 9, 1), date(2015, 9, 15))).assign_projects_from_ticket() self.assertEqual(154, updated) registers = MaximoTimeRegister.objects.filter(project__isnull=False) self.assertEqual(79, len(registers))
def test_sum_hours(self): project = ProjectFactory.create() tickets = MaximoTicket.objects.all()[:5] for ticket in tickets: ticket.project = project ticket.save() TestExcel.create_time_registers(date(2015, 9, 1), date(2015, 9, 3)) updated = MaximoTimeRegister.objects.assign_projects_from_ticket() #self.assertEqual(294, updated) total_hours = Decimal(0.0) for tr in MaximoTimeRegister.objects.filter(project=project): total_hours += tr.regular_hours project_with_hours2 = Project.objects.filter(pk=project.pk).sum_regular_hours()[0] project_with_hours = Project.objects.filter(pk=project.pk).sum_regular_hours()[0] self.assertEqual(total_hours, project_with_hours.total_regular_hours) self.assertEqual(120.0, project_with_hours.total_regular_hours)
def test_sum_hours(self): project = ProjectFactory.create() tickets = MaximoTicket.objects.all()[:5] for ticket in tickets: ticket.project = project ticket.save() TestExcel.create_time_registers(date(2015, 9, 1), date(2015, 9, 3)) updated = MaximoTimeRegister.objects.assign_projects_from_ticket() #self.assertEqual(294, updated) total_hours = Decimal(0.0) for tr in MaximoTimeRegister.objects.filter(project=project): total_hours += tr.regular_hours project_with_hours2 = Project.objects.filter( pk=project.pk).sum_regular_hours()[0] project_with_hours = Project.objects.filter( pk=project.pk).sum_regular_hours()[0] self.assertEqual(total_hours, project_with_hours.total_regular_hours) self.assertEqual(120.0, project_with_hours.total_regular_hours)