def test_repeated_seminations_v3(self):
# файл с более поздними осеменениями. По факту узи есть в файле нет.
wb = open_workbook('../data/seminations2.xls')
rows = import_farm.get_semenation_rows(wb)
shmigina = staff_testings.create_employee('ШМЫГИ')
seminated_list, already_seminated_in_tour, sows_in_another_tour, proholost_list = \
import_farm.create_semination_lists(rows, shmigina)
self.assertEqual(Sow.objects.filter(tour__week_number=6).count(), 75)
self.assertEqual(Sow.objects.filter(tour__week_number=7).count(), 75)
# We have done usound by hand. Then FARM update file.
# sow.farm_id = 20095 - usound - false by hand. file updated. tour 7
sow = Sow.objects.filter(farm_id=20095).first()
Ultrasound.objects.create_ultrasound(sow=sow,
result=False,
initiator=shmigina)
wb = open_workbook('../data/seminations2_custom_uzi.xls')
rows = import_farm.get_semenation_rows(wb)
shmigina = staff_testings.create_employee('ШМЫГИ')
seminated_list, already_seminated_in_tour, sows_in_another_tour, proholost_list = \
import_farm.create_semination_lists(rows, shmigina)
self.assertEqual(Sow.objects.filter(tour__week_number=6).count(), 75)
self.assertEqual(Sow.objects.filter(tour__week_number=7).count(), 74)
self.assertEqual(Ultrasound.objects.filter(sow=sow).count(), 1)
def test_get_seminator_by_farm_name(self):
shmigina = staff_testings.create_employee('ШМЫГИ')
ivanov = staff_testings.create_employee('ИВАНО')
s***n = staff_testings.create_employee('СЕМЕН')
boris = staff_testings.create_employee('БОРИС')
user = WorkShopEmployee.objects.get_seminator_by_farm_name('ШМЫГИ')
self.assertEqual(user, shmigina)
def setUp(self):
self.client = APIClient()
locations_testing.create_workshops_sections_and_cells()
sows_testing.create_statuses()
piglets_testing.create_piglets_statuses()
sows_events_testings.create_types()
self.user = staff_testing.create_employee()
self.client.force_authenticate(user=self.user)
self.tour1 = Tour.objects.get_or_create_by_week_in_current_year(
week_number=1)
self.tour2 = Tour.objects.get_or_create_by_week_in_current_year(
week_number=2)
self.loc_ws3 = Location.objects.get(workshop__number=3)
self.loc_ws3_cells = Location.objects.filter(
sowAndPigletsCell__isnull=False)
self.ops_dict = gen_operations_dict()
operations = dict()
for op_key in self.ops_dict.keys():
operations[op_key] = False
self.request_json = {
'operations': operations,
'filters': {
'start_date': None,
'end_date': None,
'farm_id': None
},
'target': None
}
def setUp(self):
self.client = APIClient()
locations_testing.create_workshops_sections_and_cells()
sows_testing.create_statuses()
sows_testing.create_boars()
sows_events_testing.create_types()
piglets_testing.create_piglets_statuses()
staff_testing.create_svinbin_users()
self.user = staff_testing.create_employee()
self.brig3 = User.objects.get(username='******')
self.tour1 = Tour.objects.get_or_create_by_week_in_current_year(1)
def test_culling_brig2(self):
self.client.force_authenticate(user=self.brig2)
sow = sows_testing.create_sow_and_put_in_workshop_one()
semination_employee = staff_testing.create_employee()
response = self.client.post('/api/workshoponetwo/sows/%s/culling/' %
sow.pk, {'culling_type': 'padej', 'reason': 'test reason', 'weight': 150})
self.assertEqual(response.data['culling']['reason'], 'test reason')
self.assertEqual(response.data['sow']['status'], 'Брак')
self.client.logout()
def test_repeated_seminations_v4(self):
# файл с более поздними осеменениями. По факту узи есть в файле нет.
wb = open_workbook('../data/seminations2.xls')
rows = import_farm.get_semenation_rows(wb)
shmigina = staff_testings.create_employee('ШМЫГИ')
seminated_list, already_seminated_in_tour, sows_in_another_tour, proholost_list = \
import_farm.create_semination_lists(rows, shmigina)
self.assertEqual(Sow.objects.filter(tour__week_number=6).count(), 75)
self.assertEqual(Sow.objects.filter(tour__week_number=7).count(), 75)
sow = Sow.objects.filter(farm_id=20095).first().delete()
wb = open_workbook('../data/seminations2.xls')
rows = import_farm.get_semenation_rows(wb)
shmigina = staff_testings.create_employee('ШМЫГИ')
seminated_list, already_seminated_in_tour, sows_in_another_tour, proholost_list = \
import_farm.create_semination_lists(rows, shmigina)
def test_repeated_seminations(self):
wb = open_workbook('../data/seminations2.xls')
rows = import_farm.get_semenation_rows(wb)
shmigina = staff_testings.create_employee('ШМЫГИ')
seminated_list, already_seminated_in_tour, sows_in_another_tour, proholost_list = \
import_farm.create_semination_lists(rows, shmigina)
self.assertEqual(Sow.objects.filter(tour__week_number=6).count(), 75)
sow = Sow.objects.get(farm_id=19403)
self.assertEqual(sow.birth_id, 'A0278')
def test_double_semination_or_not(self):
sow = Sow.objects.create_new_and_put_in_workshop_one(1)
shmigina = staff_testings.create_employee('ШМЫГИ')
ivanov = staff_testings.create_employee('ИВАНО')
boar1 = Boar.objects.get_or_create_boar(123)
boar2 = Boar.objects.get_or_create_boar(124)
date = timezone.now()
tour = Tour.objects.get_or_create_by_week_in_current_year(50)
sow, seminated = Semination.objects.double_semination_or_not(
sow=sow,
tour=tour,
date=date,
boar1=boar1,
boar2=boar2,
semination_employee1=shmigina,
semination_employee2=ivanov,
initiator=None)
self.assertEqual(seminated, True)
is_there_semination1 = Semination.objects.is_there_semination(
sow, tour)
self.assertEqual(is_there_semination1, True)
self.assertEqual(
Semination.objects.filter(sow=sow, tour=tour).count(), 2)
# already seminated in tour
sow, seminated = Semination.objects.double_semination_or_not(
sow=sow,
tour=tour,
date=date,
boar1=boar1,
boar2=boar2,
semination_employee1=shmigina,
semination_employee2=ivanov,
initiator=None)
self.assertEqual(seminated, False)
def setUp(self):
self.client = APIClient()
locations_testing.create_workshops_sections_and_cells()
sows_testing.create_statuses()
sows_events_testing.create_types()
piglets_testing.create_piglets_statuses()
self.user = staff_testing.create_employee()
self.client.force_authenticate(user=self.user)
self.tour1 = Tour.objects.get_or_create_by_week_in_current_year(
week_number=1)
self.tour2 = Tour.objects.get_or_create_by_week_in_current_year(
week_number=2)
self.tour3 = Tour.objects.get_or_create_by_week_in_current_year(
week_number=3)
self.loc_ws3 = Location.objects.get(workshop__number=3)
self.piglets = piglets_testing.create_new_group_with_metatour_by_one_tour(
self.tour1, self.loc_ws3, 101)
location1 = Location.objects.filter(
sowAndPigletsCell__number=1).first()
sow1 = sows_testing.create_sow_with_semination_usound(
location=location1, week=1)
location2 = Location.objects.filter(
sowAndPigletsCell__number=2).first()
sow2 = sows_testing.create_sow_with_semination_usound(
location=location2, week=1)
location3 = Location.objects.filter(
sowAndPigletsCell__number=3).first()
sow3 = sows_testing.create_sow_with_semination_usound(
location=location3, week=1)
SowFarrow.objects.create_sow_farrow(sow=sow1, alive_quantity=10)
SowFarrow.objects.create_sow_farrow(sow=sow2, alive_quantity=10)
SowFarrow.objects.create_sow_farrow(sow=sow3, alive_quantity=10)
location8 = Location.objects.filter(
pigletsGroupCell__isnull=False).first()
Piglets.objects.init_piglets_by_farrow_date('2020-01-01', location8,
20)
location9 = Location.objects.filter(pigletsGroupCell__isnull=False)[1]
Piglets.objects.init_piglets_by_farrow_date('2020-01-02', location9,
21)
location10 = Location.objects.filter(
pigletsGroupCell__section__number=2).first()
Piglets.objects.init_piglets_by_farrow_date('2020-01-02', location10,
53)
def setUp(self):
self.client = APIClient()
locations_testing.create_workshops_sections_and_cells()
sows_testing.create_statuses()
sows_testing.create_boars()
sows_events_testing.create_types()
staff_testing.create_svinbin_users()
self.boar = Boar.objects.all().first()
self.user = staff_testing.create_employee() # is_seminator = True
self.brig1 = User.objects.get(username='******')
self.brig2 = User.objects.get(username='******')
self.brig3 = User.objects.get(username='******')
self.brig4 = User.objects.get(username='******')
self.brig5 = User.objects.get(username='******')
def setUp(self):
self.client = APIClient()
locations_testing.create_workshops_sections_and_cells()
sows_testing.create_statuses()
piglets_testing.create_piglets_statuses()
sows_events_testings.create_types()
self.user = staff_testing.create_employee()
self.client.force_authenticate(user=self.user)
self.tour1 = Tour.objects.get_or_create_by_week_in_current_year(
week_number=1)
self.tour2 = Tour.objects.get_or_create_by_week_in_current_year(
week_number=2)
self.tour3 = Tour.objects.get_or_create_by_week_in_current_year(
week_number=3)
def setUp(self):
self.client = APIClient()
locations_testing.create_workshops_sections_and_cells()
sows_testing.create_statuses()
piglets_testing.create_piglets_statuses()
sows_events_testings.create_types()
staff_testing.create_svinbin_users()
self.tour1 = Tour.objects.get_or_create_by_week_in_current_year(week_number=1)
self.tour2 = Tour.objects.get_or_create_by_week_in_current_year(week_number=2)
self.tour3 = Tour.objects.get_or_create_by_week_in_current_year(week_number=3)
self.tour4 = Tour.objects.get_or_create_by_week_in_current_year(week_number=4)
self.loc_ws1 = Location.objects.get(workshop__number=1)
self.loc_ws2 = Location.objects.get(workshop__number=2)
self.loc_ws3 = Location.objects.get(workshop__number=3)
self.loc_ws3_sec1 = Location.objects.get(section__workshop__number=3, section__number=1)
self.loc_ws3_sec2 = Location.objects.get(section__workshop__number=3, section__number=2)
self.loc_ws4 = Location.objects.get(workshop__number=4)
self.loc_ws4_cell1 = Location.objects.filter(pigletsGroupCell__isnull=False)[0]
self.loc_ws4_cell2 = Location.objects.filter(pigletsGroupCell__isnull=False)[1]
self.loc_ws8 = Location.objects.get(workshop__number=8)
self.loc_ws5 = Location.objects.get(workshop__number=5)
self.loc_ws6 = Location.objects.get(workshop__number=6)
self.loc_ws7 = Location.objects.get(workshop__number=7)
# self.user = staff_testing.create_employee()
# self.client.force_authenticate(user=self.user)
self.brig1 = staff_testing.create_employee(workshop=self.loc_ws1.workshop)
self.brig2 = staff_testing.create_employee(workshop=self.loc_ws2.workshop)
self.brig3 = staff_testing.create_employee(workshop=self.loc_ws3.workshop)
self.brig4 = staff_testing.create_employee(workshop=self.loc_ws4.workshop)
self.brig5 = staff_testing.create_employee(workshop=self.loc_ws5.workshop)
self.brig6 = staff_testing.create_employee(workshop=self.loc_ws6.workshop)
self.brig7 = staff_testing.create_employee(workshop=self.loc_ws7.workshop)
self.brig8 = staff_testing.create_employee(workshop=self.loc_ws8.workshop)
self.admin = User.objects.get(username='******')
def setUp(self):
self.client = APIClient()
locations_testing.create_workshops_sections_and_cells()
sows_testing.create_statuses()
piglets_testing.create_piglets_statuses()
self.user = staff_testing.create_employee()
self.client.force_authenticate(user=self.user)
self.tour1 = Tour.objects.get_or_create_by_week_in_current_year(week_number=1)
self.tour2 = Tour.objects.get_or_create_by_week_in_current_year(week_number=2)
self.tour3 = Tour.objects.get_or_create_by_week_in_current_year(week_number=3)
self.tour4 = Tour.objects.get_or_create_by_week_in_current_year(week_number=4)
self.loc_ws3 = Location.objects.get(workshop__number=3)
self.loc_ws3_sec1 = Location.objects.get(section__workshop__number=3, section__number=1)
self.loc_ws3_sec2 = Location.objects.get(section__workshop__number=3, section__number=2)
self.loc_ws4 = Location.objects.get(workshop__number=4)
self.loc_ws4_cell1 = Location.objects.filter(pigletsGroupCell__isnull=False)[0]
self.loc_ws4_cell2 = Location.objects.filter(pigletsGroupCell__isnull=False)[1]
def setUp(self):
self.client = APIClient()
locations_testing.create_workshops_sections_and_cells()
sows_testing.create_statuses()
piglets_testing.create_piglets_statuses()
sows_events_testings.create_types()
self.user = staff_testing.create_employee()
self.client.force_authenticate(user=self.user)
self.tour1 = Tour.objects.get_or_create_by_week_in_current_year(
week_number=1)
self.tour2 = Tour.objects.get_or_create_by_week_in_current_year(
week_number=2)
self.loc_ws4 = Location.objects.get(workshop__number=4)
self.loc_ws5_cells = Location.objects.filter(
pigletsGroupCell__workshop__number=5)
self.loc_ws3_cells = Location.objects.filter(
sowAndPigletsCell__workshop__number=3)
def setUp(self):
locations_testing.create_workshops_sections_and_cells()
sows_testing.create_statuses()
sows_events_testings.create_types()
piglets_testing.create_piglets_statuses()
staff_testing.create_svinbin_users()
self.client = APIClient()
self.user = staff_testing.create_employee()
self.brig1 = User.objects.get(username='******')
self.brig2 = User.objects.get(username='******')
self.brig3 = User.objects.get(username='******')
self.brig4 = User.objects.get(username='******')
self.brig5 = User.objects.get(username='******')
self.loc_ws1 = Location.objects.get(workshop__number=1)
self.loc_ws2 = Location.objects.get(workshop__number=2)
self.loc_ws3 = Location.objects.get(workshop__number=3)
self.loc_ws3_sec1 = Location.objects.get(section__workshop__number=3,
section__number=1)
self.loc_ws3_sec2 = Location.objects.get(section__workshop__number=3,
section__number=2)
def setUp(self):
self.client = APIClient()
locations_testing.create_workshops_sections_and_cells()
sows_testing.create_statuses()
sows_testing.create_boars()
sows_events_testing.create_types()
piglets_testing.create_piglets_statuses()
staff_testing.create_svinbin_users()
self.user = staff_testing.create_employee()
self.boar = Boar.objects.all().first()
self.tour1 = Tour.objects.get_or_create_by_week_in_current_year(week_number=1)
self.tour2 = Tour.objects.get_or_create_by_week_in_current_year(week_number=2)
self.tour3 = Tour.objects.get_or_create_by_week_in_current_year(week_number=3)
self.tour4 = Tour.objects.get_or_create_by_week_in_current_year(week_number=4)
self.loc_ws1 = Location.objects.get(workshop__number=1)
self.loc_ws2 = Location.objects.get(workshop__number=2)
self.loc_ws3 = Location.objects.get(workshop__number=3)
self.loc_ws3_sec1 = Location.objects.get(section__workshop__number=3, section__number=1)
self.loc_ws3_sec2 = Location.objects.get(section__workshop__number=3, section__number=2)
self.loc_ws4 = Location.objects.get(workshop__number=4)
self.loc_ws4_cell1 = Location.objects.filter(pigletsGroupCell__isnull=False)[0]
self.loc_ws4_cell2 = Location.objects.filter(pigletsGroupCell__isnull=False)[1]
self.loc_ws8 = Location.objects.get(workshop__number=8)
self.loc_ws5 = Location.objects.get(workshop__number=5)
self.loc_ws6 = Location.objects.get(workshop__number=6)
self.loc_ws7 = Location.objects.get(workshop__number=7)
self.brig1 = User.objects.get(username='******')
self.brig2 = User.objects.get(username='******')
self.brig3 = User.objects.get(username='******')
self.brig4 = User.objects.get(username='******')
self.brig5 = User.objects.get(username='******')
def test_create_semination_lists(self):
shmigina = staff_testings.create_employee('ШМЫГИ')
ivanov = staff_testings.create_employee('ИВАНО')
s***n = staff_testings.create_employee('СЕМЕН')
boris = staff_testings.create_employee('БОРИС')
# all new sows
rows1 = [
[1, '1a', 1, '1924',
timezone.now(), 1, 'ШМЫГИ', 2, 'ШМЫГИ'],
[2, '2a', 1, '1924',
timezone.now(), 12, 'БОРИС', 23, 'БОРИС'],
[3, '3a', 1, '1924',
timezone.now(), 13, 'СЕМЕН', 24, 'СЕМЕН'],
[4, '4a', 1, '1924',
timezone.now(), 14, 'ШМЫГИ', 25, 'ШМЫГИ'],
]
seminated_list, already_seminated_in_tour, sows_in_another_tour, proholost_list = \
import_farm.create_semination_lists(rows1, shmigina)
monday_24_week = Tour.objects.get_monday_date_by_week_number(
week_number=24, year=2019)
self.assertEqual(seminated_list[0].tour.week_number, 24)
self.assertEqual(len(seminated_list), 4)
self.assertEqual(len(already_seminated_in_tour), 0)
self.assertEqual(len(sows_in_another_tour), 0)
# sows already seminated in tour
rows2 = [
[1, '1a', 1, '1924',
timezone.now(), 1, 'ШМЫГИ', 2, 'ШМЫГИ'],
[2, '2a', 1, '1924',
timezone.now(), 12, 'БОРИС', 23, 'БОРИС'],
[3, '3a', 1, '1924',
timezone.now(), 13, 'СЕМЕН', 24, 'СЕМЕН'],
[4, '4a', 1, '1924',
timezone.now(), 14, 'ШМЫГИ', 25, 'ШМЫГИ'],
]
seminated_list, already_seminated_in_tour, sows_in_another_tour, proholost_list = \
import_farm.create_semination_lists(rows2, shmigina)
self.assertEqual(len(seminated_list), 0)
self.assertEqual(len(already_seminated_in_tour), 4)
self.assertEqual(len(sows_in_another_tour), 0)
# sows in another tour still
rows3 = [
[1, '1a', 1, '1923',
timezone.now(), 1, 'ШМЫГИ', 2, 'ШМЫГИ'],
[2, '2a', 1, '1923',
timezone.now(), 12, 'БОРИС', 23, 'БОРИС'],
[3, '3a', 1, '1923',
timezone.now(), 13, 'СЕМЕН', 24, 'СЕМЕН'],
[4, '4a', 1, '1923',
timezone.now(), 14, 'ШМЫГИ', 25, 'ШМЫГИ'],
]
seminated_list, already_seminated_in_tour, sows_in_another_tour, proholost_list = \
import_farm.create_semination_lists(rows3, shmigina)
self.assertEqual(len(seminated_list), 0)
self.assertEqual(len(already_seminated_in_tour), 0)
self.assertEqual(len(sows_in_another_tour), 4)
# mixed
rows4 = [
[1, '1a', 1, '1924',
timezone.now(), 1, 'ШМЫГИ', 2, 'ШМЫГИ'],
[2, '2a', 1, '1924',
timezone.now(), 12, 'БОРИС', 23, 'БОРИС'],
[3, '3a', 1, '1924',
timezone.now(), 13, 'СЕМЕН', 24, 'СЕМЕН'],
[4, '4a', 1, '1923',
timezone.now(), 14, 'ШМЫГИ', 25, 'ШМЫГИ'],
[5, '5a', 1, '1924',
timezone.now(), 14, 'ШМЫГИ', 25, 'ШМЫГИ'],
]
seminated_list, already_seminated_in_tour, sows_in_another_tour, proholost_list = \
import_farm.create_semination_lists(rows4, shmigina)
self.assertEqual(len(seminated_list), 1)
self.assertEqual(len(already_seminated_in_tour), 3)
self.assertEqual(len(sows_in_another_tour), 1)
