def test_extended_search_a(self): main_page = DonorsModuleRegistryPage() main_page.clear_localstorage() main_page.open() main_page.extended_search_click('open') assert main_page.is_extended_search_button_disable() == 'true'
def test_extended_search_by_donation_barcode_a(self, barcode, expected_result, test_data_set_number): main_page = DonorsModuleRegistryPage() main_page.clear_localstorage() main_page.open() main_page.extended_search_click('open') aistium.fill(barcode, elements=main_page.extended_donation_barcode) assert main_page.get_barcode_from_extended_search() == expected_result
def test_extended_search_by_gender_a(self): main_page = DonorsModuleRegistryPage() main_page.clear_localstorage() main_page.open() main_page.extended_search_click('open') assert main_page.get_genders_listbox_from_extended_search() == [ 'Пол', 'Женский', 'Мужской' ]
def test_extended_search_by_document_type_a(self): main_page = DonorsModuleRegistryPage() main_page.clear_localstorage() main_page.open() main_page.extended_search_click('open') assert main_page.get_document_types_listbox_from_extended_search() == [ '', 'Паспорт РФ', 'Военный билет', 'Загранпаспорт РФ', 'Паспорт СССР', 'Иные документы', 'Св-во о рождении' ]
def test_gender_validation_messages(self, middlename, expected_result, test_data_set_number): main_page = DonorsModuleRegistryPage() main_page.open() main_page.newdonor_click() main_page.ndp_filling_first_page("Сидоров", "Кирилл", middlename, "01.06.1980", "8910", "650231") aistium.click_on(elements=main_page.next_step_ndp) assert main_page.get_validation_message_text() == expected_result
def test_reset_search_filters_a(self): main_page = DonorsModuleRegistryPage() main_page.clear_localstorage() main_page.open() assert main_page.reset_filters_is_not_on_page() == True
def test_ndp_validation_of_document_type_default(self, expected_result, test_data_set_number): main_page = DonorsModuleRegistryPage() main_page.open() main_page.newdonor_click() assert main_page.ndp_get_document_type_value() == expected_result
def test_ndp_validation_of_document_type_list(self): main_page = DonorsModuleRegistryPage() main_page.open() main_page.newdonor_click() assert main_page.ndp_get_document_type_listbox() == [ 'Паспорт РФ', 'Военный билет', 'Загранпаспорт РФ', 'Паспорт СССР', 'Иные документы', 'Св-во о рождении' ]
def test_to_list_of_directed(self): main_page = DonorsModuleRegistryPage() main_page.open() main_page.list_of_directed_button_click() list_of_directed = DonorsListOfDirected() list_of_directed.get_title() == 'Список направленных' list_of_directed.get_directed_date_value() == datetime.date.today( ).strftime('%d.%m.%Y')
def test_simple_search_f(self, string, expected_result, test_data_set_number): main_page = DonorsModuleRegistryPage() main_page.clear_localstorage() main_page.open() aistium.fill(string, elements=main_page.quick_search_field) assert aistium.get_value( locators_list=locators, element_name='quick_search_field') == expected_result
def test_transfer_from_quick_search_to_ndpr(self, search_line, expected_result1, expected_result2, expected_result3, test_data_set_number): main_page = DonorsModuleRegistryPage() main_page.open() aistium.fill(search_line, elements=main_page.quick_search_field) main_page.newdonor_click() assert aistium.get_value( locators_list=locators, element_name='last_name_field_ndp') == expected_result1 assert aistium.get_value( locators_list=locators, element_name='first_name_field_ndp') == expected_result2 assert aistium.get_value( locators_list=locators, element_name='middle_name_field_ndp') == expected_result3
def test_extended_search_by_next_donation_date_validation_messages( self, next_donation_date_from, next_donation_date_to, expected_result, test_data_set_number): main_page = DonorsModuleRegistryPage() main_page.clear_localstorage() main_page.open() main_page.extended_search_click('open') aistium.fill(next_donation_date_from, elements=main_page.extended_preregistration_from) aistium.fill(next_donation_date_to, elements=main_page.extended_preregistration_to) aistium.click_on(elements=main_page.extended_search_button) main_page.loading_is_completed() assert main_page.get_alert_text() == expected_result
def test_extended_search_b(self): main_page = DonorsModuleRegistryPage() full_query = sql_query(''' select top (1) PerC.LastName, PerC.FirstName, PerC.MiddleName, case when PerC.Gender = '1' then 'Мужской 'when PerC.Gender = '2' then 'Женский' end Gender, PerAd.FiasRegion, PerAd.FiasCity, PerAd.FiasStreet, PerAd.FiasHouse, PerC.UniqueId, Don.Barcode, convert(varchar, dateadd(day, -1, PerC.BirthDate), 104) BirthDateS, convert(varchar, dateadd(day, 1, PerC.BirthDate), 104) BirthDatePo, convert(varchar, dateadd(day, -1, ApD.NextDonationDate), 104) NextDonationDateS, convert(varchar, dateadd(day, 1, ApD.NextDonationDate), 104) NextDonationDatePo, case when IDoc.DocType = 1 then 'Паспорт РФ' when IDoc.DocType = 2 then 'Военный билет' when IDoc.DocType = 3 then 'Загранпаспорт РФ' when IDoc.DocType = 4 then 'Паспорт СССР' when IDoc.DocType = 5 then 'Иные документы' when IDoc.DocType = 6 then 'Св-во о рождении' end DocType, IDoc.Serie, IDoc.Number from PersonCards PerC join AppointedDonationTypes ApD on PerC.UniqueId = ApD.DonorId join IdentityDocs IDoc on PerC.IdentityDocId = IDoc.UniqueId join Donations Don on PerC.UniqueId = Don.DonorId join PersonAddresses PerAd on PerC.RegAddressId = PerAd.UniqueId where PerC.IsDeleted != 1 and PerC.LastName not like '%[a-zA-Z0-9?!_+=*\/%()}{<>^]%' and PerC.FirstName not like '%[a-zA-Z0-9?!_+=*\/%()}{<>^]%' and PerC.MiddleName not like '%[a-zA-Z0-9?!_+=*\/%()}{<>^]%' and PerC.Gender in ('1','2') and PerAd.FiasRegion is not null and PerAd.FiasArea is null and PerAd.FiasCity is not null and PerAd.FiasInnerArea is null and PerAd.FiasSettlement is null and PerAd.FiasStreet is not null and PerAd.FiasHouse is not null and ApD.NextDonationDate > dateadd(year, -10, getdate()) and ApD.NextDonationDate < dateadd(year, 10, getdate()) ''') lastname, firstname, middlename, gender, region, city, street, house, donorid, barcode, birthdate_from, birthdate_to, next_donation_from, next_donation_to, document_type, document_serie, document_number = ( full_query[0][0], full_query[0][1], full_query[0][2], full_query[0][3], full_query[0][4], full_query[0][5], full_query[0][6], full_query[0][7], str(full_query[0][8]), full_query[0][9], full_query[0][10], full_query[0][11], full_query[0][12], full_query[0][13], full_query[0][14], full_query[0][15], full_query[0][16]) main_page.clear_localstorage() main_page.open() main_page.extended_search_click('open') main_page.filling_fio_in_extended_search(lastname, firstname, middlename) main_page.filling_gender_in_extended_search(gender) main_page.filling_region_in_extended_search(region) main_page.ndp_filling_city_in_extended_search(city) main_page.ndp_filling_street_in_extended_search(street) aistium.fill(house, elements=main_page.extended_fias_address_house) aistium.fill(donorid, elements=main_page.extended_registry_number) aistium.fill(barcode, elements=main_page.extended_donation_barcode) aistium.fill(birthdate_from, elements=main_page.extended_birthdate_from) aistium.fill(birthdate_to, elements=main_page.extended_birthdate_to) aistium.fill(next_donation_from, elements=main_page.extended_preregistration_from) aistium.fill(next_donation_to, elements=main_page.extended_preregistration_to) main_page.filling_doc_type_in_extended_search(document_type) main_page.filling_doc_serie_in_extended_search(document_serie) main_page.filling_doc_number_in_extended_search(document_number) aistium.click_on(elements=main_page.extended_search_button) main_page.loading_is_completed() assert main_page.get_grid_values('UniqueId', 'active_cell', main_page.main_grid) == donorid main_page.extended_search_click('open') main_page.filling_doc_number_in_extended_search(document_number[::-1]) aistium.click_on(elements=main_page.extended_search_close) assert main_page.is_extended_search_closed() == True assert main_page.get_grid_values( 'Document', 1, main_page.main_grid).split(' ')[-1] == document_number main_page.extended_search_click('open') aistium.click_on(elements=main_page.extended_search_clear_button) assertions = [ main_page.get_lastname_from_extended_search(), main_page.get_firstname_from_extended_search(), main_page.get_middlename_from_extended_search(), main_page.get_region_from_extended_search(), main_page.get_donorid_from_extended_search(), main_page.get_barcode_from_extended_search(), main_page.get_birth_date_from_from_extended_search(), main_page.get_birth_date_to_from_extended_search(), main_page.get_next_donation_from_from_extended_search(), main_page.get_next_donation_to_from_extended_search(), main_page.get_document_serie_from_extended_search(), main_page.get_document_number_from_extended_search(), main_page.get_document_type_from_extended_search() ] for assertion in assertions: assert assertion == '' assert main_page.get_gender_from_extended_search() == 'Пол' assert main_page.is_extended_search_button_disable() == 'true'
def test_job_place_select_value(self): main_page = DonorsModuleRegistryPage() main_page.open() place_ent = str(sql_query("select top (1) lower(substring(PerC.JobInfo, 2, 6)) Ent from PersonCards PerC where len(PerC.JobInfo) > 10 and PerC.JobInfo not like '%[a-zA-Z0-9?!_+=*\/%()}{<>^%]'"))[3:-5] places_s = [] main_page.newdonor_click() main_page.ndp_filling_first_page('Сидоров', "Анатолий", "", "01.06.1980", "2910", "650231") main_page.select_gender('male') aistium.click_on(elements=main_page.next_step_ndp) main_page.loading_is_completed() main_page.if_donor_is_in_local_cabinet() main_page.ndp_second_page_loaded() aistium.fill(place_ent, elements=main_page.ndp_job_place_field) for place_s in main_page.ndp_place_list_on_form(): places_s.append(str(place_s)) job_place_need = places_s[0] aistium.fill(Keys.ENTER, elements=main_page.ndp_job_place_field) job_place = aistium.get_value(locators_list=locators, element_name='job_place') assert job_place == job_place_need
def test_ndp_job_position(self, job_position, expected_result, test_data_set_number): main_page = DonorsModuleRegistryPage() main_page.clear_localstorage() main_page.open() main_page.newdonor_click() main_page.ndp_filling_first_page("Сидоров", "Кирилл", "", "01.06.1980", "8910", "650231") main_page.select_gender('male') aistium.click_on(elements=main_page.next_step_ndp) main_page.loading_is_completed() main_page.if_donor_is_in_local_cabinet() main_page.ndp_second_page_loaded() main_page.ndp_filling_region('Москва г') main_page.ndp_filling_street('Перовская ул') aistium.fill('4', elements=main_page.reg_fias_address_house) aistium.fill(job_position, elements=main_page.job_position) main_page.ndp_save_new_donor('success') main_page.loading_is_completed() grid_donor_id = main_page.get_grid_values('UniqueId', 'active_cell', main_page.main_grid) donors_card_title_page = DonorsCardTitle(grid_donor_id) donors_card_title_page.open() assert donors_card_title_page.job() == expected_result
def test_ndp_moving_between_pages_first_step(self): main_page = DonorsModuleRegistryPage() main_page.clear_localstorage() main_page.open() main_page.newdonor_click() main_page.ndp_filling_first_page('Сидоров', 'Кирилл', '', '01.06.1980', '8910', '650231') main_page.select_gender('male') aistium.click_on(elements=main_page.next_step_ndp) main_page.loading_is_completed() main_page.if_donor_is_in_local_cabinet() main_page.ndp_second_page_loaded() main_page.ndp_filling_region('Москва г') main_page.ndp_filling_street('Перовская ул') aistium.fill('46', elements=main_page.reg_fias_address_house) aistium.click_on(elements=main_page.previous_step_ndp) main_page.ndp_first_page_check_values_of_mandatory_fields( 'Сидоров', 'Кирилл', '01.06.1980', '8910', '650231') aistium.click_on(elements=main_page.next_step_ndp) main_page.loading_is_completed() main_page.if_donor_is_in_local_cabinet() main_page.ndp_second_page_loaded() main_page.ndp_second_page_check_values_of_mandatory_fields() == ( 'Москва г', '', 'Перовская ул', '46') main_page.ndp_save_new_donor('success') main_page.loading_is_completed() assert aistium.get_text( elements=main_page.fio_minicard) == 'Сидоров Кирилл' assert main_page.get_gender_from_minicard() == 'М' assert main_page.get_birthdate_from_minicard() == '01.06.1980' assert main_page.get_document_serie_and_number( ) == '8910' + ' ' + '650231' assert main_page.get_accurate_address( ) == 'Москва г, Перовская ул, д.46'
def test_filling_birthdate(self, birthdate, expected_result, test_data_set_number): main_page = DonorsModuleRegistryPage() main_page.open() main_page.newdonor_click() main_page.ndp_filling_first_page("Сидоров", "Кирилл", "", birthdate, "8910", "650231") main_page.select_gender('male') aistium.click_on(elements=main_page.next_step_ndp) main_page.loading_is_completed() main_page.if_donor_is_in_local_cabinet() main_page.ndp_second_page_loaded() aistium.click_on(elements=main_page.previous_step_ndp) if 'today' in expected_result: assert aistium.get_value( locators_list=locators, element_name='birthdate_field_ndp') == date_calculation( expected_result) else: assert aistium.get_value( locators_list=locators, element_name='birthdate_field_ndp') == expected_result
def test_donor_minicard_diseases_grid_create_date(self, query, test_data_set_number): main_page = DonorsModuleRegistryPage() main_page.clear_localstorage() full_query = sql_query(query) donorid = str(full_query[0][0]) expected_result = str(full_query[0][1]) main_page.open() aistium.fill(donorid, elements=main_page.quick_search_field) main_page.quick_search('click') main_page.loading_is_completed() ind = sql_query( "select Main.Nmb from (select row_number() over (order by PerC.BirthDate desc) Nmb, PerC.UniqueId from PersonCards PerC left join IdentityDocs IDoc on PerC.IdentityDocId = IDoc.UniqueId where PerC.IsDeleted != 1 and (PerC.UniqueId = '" + donorid + "' or IDoc.Number = '" + donorid + "')) Main where Main.UniqueId = '" + donorid + "'")[0][0] main_page.get_grid_values('№', ind, 'click') main_page.loading_is_completed() aistium.click_on(elements=main_page.diseases_button) main_page.loading_is_completed() assert main_page.get_grid_values( 'CreateDate', 1, main_page.diseases_grid) == expected_result
def test_ndp_checking_donor_by_fic_fullname_a(self, query, row_index): main_page = DonorsModuleRegistryPage() main_page.clear_localstorage() change_donor_settings(UseFicDonorSearch='true') main_page.open() query = sql_query( query, stand= "DRIVER={SQL Server};SERVER=10.36.200.79;DATABASE=aistdb_fic;UID=sa;PWD=Mos111222" ) document_serie = query[0][0] document_number = query[0][1] expected = query[0][2] main_page.newdonor_click() main_page.ndp_filling_first_page("Сидоров", "Кирилл", '', "01.06.1980", document_serie, document_number) main_page.select_gender('male') aistium.click_on(elements=main_page.next_step_ndp) main_page.loading_is_completed() main_page.if_donor_is_in_local_cabinet() main_page.ndp_results_by_fic_is_on_the_page() assert main_page.ndp_results_by_fic_get_grid_values( 'ФИО', int(row_index)) == expected
def test_deferral_type_color_and_type(self, expected_color, expected_type, test_data_set_number): main_page = DonorsModuleRegistryPage() main_page.open() main_page.newdonor_click() main_page.ndp_filling_first_page('Сидоров', "Алексей", "", "05.06.1980", "8914", "650235") main_page.select_gender('male') aistium.click_on(elements=main_page.next_step_ndp) main_page.loading_is_completed() main_page.if_donor_is_in_local_cabinet() main_page.ndp_second_page_loaded() if expected_type == 'Временный': main_page.ndp_filling_deferral( str( sql_query( "select top(1) DefT.Code+' '+DefT.Name Otvod from ref.DeferralTypes DefT join ref.DeferralTypeParams DefTP on DefT.UniqueId = DefTP.DeferralTypeId where DefTP.IsActive = 1 and DefT.BaseType = 3" ))[3:-5]) assert aistium.get_value( locators_list=locators, element_name='ndp_deferral_type') == expected_type assert convert_to_hex( main_page.ndp_get_deferral_type_color()) == expected_color elif expected_type == 'Контроль': main_page.ndp_filling_deferral( str( sql_query( "select top(1) DefT.Code+' '+DefT.Name Otvod from ref.DeferralTypes DefT join ref.DeferralTypeParams DefTP on DefT.UniqueId = DefTP.DeferralTypeId where DefTP.IsActive = 1 and DefT.BaseType = 2" ))[3:-5]) assert aistium.get_value( locators_list=locators, element_name='ndp_deferral_type') == expected_type assert convert_to_hex( main_page.ndp_get_deferral_type_color()) == expected_color elif expected_type == 'Абсолютный': main_page.ndp_filling_deferral( str( sql_query( "select top(1) DefT.Code+' '+DefT.Name Otvod from ref.DeferralTypes DefT join ref.DeferralTypeParams DefTP on DefT.UniqueId = DefTP.DeferralTypeId where DefTP.IsActive = 1 and DefT.BaseType = 1" ))[3:-5]) assert aistium.get_value( locators_list=locators, element_name='ndp_deferral_type') == expected_type assert convert_to_hex( main_page.ndp_get_deferral_type_color()) == expected_color
def test_ndp_moving_between_pages_second_step(self): main_page = DonorsModuleRegistryPage() main_page.clear_localstorage() change_general_settings(WorkWithSocialStatus='true') main_page.newdonor_click() main_page.ndp_filling_first_page('Сидоров', 'Иван', 'Петрович', '15.06.1980', '8933', '650245') main_page.select_gender('male') main_page.filling_identity_document_issue_date('20.11.2000') aistium.fill('А', elements=main_page.identity_document_issued_by) aistium.fill('19133561060', elements=main_page.snils_field) main_page.ndp_filling_birth_place('Б') aistium.click_on(elements=main_page.next_step_ndp) main_page.loading_is_completed() main_page.if_donor_is_in_local_cabinet() main_page.ndp_second_page_loaded() main_page.ndp_filling_region('Москва г') main_page.ndp_filling_street('Перовская ул') aistium.fill('52', elements=main_page.reg_fias_address_house) main_page.ndp_filling_contacts('123456789', '123456789', '*****@*****.**') aistium.fill('Работа', elements=main_page.ndp_job_place_field) aistium.fill('К', elements=main_page.job_position) aistium.fill('Рабочие', main_page.social_status_field) main_page.ndp_filling_deferral( str( sql_query( "select top(1) DefT.Code+' '+DefT.Name Otvod from ref.DeferralTypes DefT join ref.DeferralTypeParams DefTP on DefT.UniqueId = DefTP.DeferralTypeId where DefTP.IsActive = 1 and DefT.BaseType = 1" ))[3:-5]) main_page.ndp_filling_donation_type( str( sql_query( "select top(1) DonT.Code+' '+DonT.Name from ref.DonationTypes DonT join ref.DonationTypeParams DonTP on DonT.UniqueId = DonTP.DonationTypeId where DonTP.IsActive = 1 and DonT.DonationParams not like '%4%' and DonT.ComponentType = 1" ))[3:-5]) aistium.click_on(elements=main_page.previous_step_ndp) main_page.ndp_first_page_clear() main_page.ndp_select_document_type('Загранпаспорт РФ') main_page.select_gender('female') main_page.ndp_filling_first_page('Сидорова', 'Иванка', 'Петровна', '15.08.1980', '89', '6502455') main_page.filling_identity_document_issue_date('20.11.2002') aistium.fill('Б', elements=main_page.identity_document_issued_by) aistium.fill('24559224384', elements=main_page.snils_field) main_page.ndp_filling_birth_place('3') aistium.click_on(elements=main_page.next_step_ndp) main_page.loading_is_completed() main_page.if_donor_is_in_local_cabinet() main_page.ndp_second_page_loaded() main_page.ndp_fias_address_clear() main_page.ndp_contacts_clear() main_page.ndp_job_or_study_place_clear() aistium.click_on(elements=main_page.ndp_deferral_clear_button) main_page.ndp_donation_type_clear() main_page.ndp_filling_region('Москва г') main_page.ndp_filling_street('Кленовый б-р') aistium.fill('28', elements=main_page.reg_fias_address_house) main_page.ndp_filling_contacts('123456785', '123456783', '*****@*****.**') main_page.filling_job_or_study_place('Работа 2', 'К', 'Служащие') main_page.ndp_filling_deferral( str( sql_query( "select top(1) DefT.Code+' '+DefT.Name Otvod from ref.DeferralTypes DefT join ref.DeferralTypeParams DefTP on DefT.UniqueId = DefTP.DeferralTypeId where DefTP.IsActive = 1 and DefT.BaseType = 2" ))[3:-5]) main_page.ndp_filling_donation_type( str( sql_query( "select top(1) DonT.Code+' '+DonT.Name from ref.DonationTypes DonT join ref.DonationTypeParams DonTP on DonT.UniqueId = DonTP.DonationTypeId where DonTP.IsActive = 1 and DonT.DonationParams not like '%4%' and DonT.ComponentType = 2" ))[3:-5]) aistium.click_on(elements=main_page.previous_step_ndp) main_page.ndp_first_page_check_values_of_mandatory_fields( 'Сидорова', 'Иванка', '15.08.1980', '89', '6502455') aistium.get_value(locators_list=locators, element_name='middle_name_field_ndp') == 'Петровна' aistium.get_value( locators_list=locators, element_name='identity_document_issue_date') == '20.11.2002' aistium.get_value(locators_list=locators, element_name='identity_document_issued_by') == 'Б' aistium.get_value(locators_list=locators, element_name='ndp_birth_place') == '3' aistium.get_value(locators_list=locators, element_name='snils_field') == '24559224384' main_page.identity_document_issued_by_clear() aistium.fill('Бв', elements=main_page.identity_document_issued_by) aistium.click_on(elements=main_page.next_step_ndp) main_page.loading_is_completed() main_page.if_donor_is_in_local_cabinet() main_page.ndp_second_page_loaded() main_page.ndp_get_contacts_values() == ('123456785', '123456783', '*****@*****.**') main_page.ndp_second_page_check_values_of_mandatory_fields() == ( 'Москва г', '', 'Кленовый б-р', '28') main_page.ndp_get_job_information() == ('Работа 2', 'К', 'Служащие') assert aistium.get_value( locators_list=locators, element_name='ndp_deferral_field' ) == str( sql_query( "select top(1) DefT.Code+' '+DefT.Name Otvod from ref.DeferralTypes DefT join ref.DeferralTypeParams DefTP on DefT.UniqueId = DefTP.DeferralTypeId where DefTP.IsActive = 1 and DefT.BaseType = 2" ))[3:-5] main_page.ndp_get_donation_type() == str( sql_query( "select top(1) DonT.Code+' '+DonT.Name from ref.DonationTypes DonT join ref.DonationTypeParams DonTP on DonT.UniqueId = DonTP.DonationTypeId where DonTP.IsActive = 1 and DonT.DonationParams not like '%4%' and DonT.ComponentType = 2" ))[3:-5] main_page.ndp_phone_clear() main_page.ndp_filling_contacts('', '123456788', '') main_page.ndp_save_new_donor('success') assert aistium.get_text( elements=main_page.fio_minicard) == 'Сидорова Иванка Петровна' assert aistium.get_text( elements=main_page.minicard_phone) == '123456788' grid_donor_id = main_page.get_grid_values('UniqueId', 'active_cell', main_page.main_grid) donors_card_title_page = DonorsCardTitle(grid_donor_id) donors_card_title_page.open() donors_card_title_page.issued_by() == 'Бв 20.11.2002'
def test_transfer_from_search_fields_to_ndp(self, search_line, lastname, firstname, middlename, expected_result1, expected_result2, expected_result3, test_data_set_number): main_page = DonorsModuleRegistryPage() main_page.open() aistium.fill(search_line, elements=main_page.quick_search_field) main_page.extended_search_click('open') main_page.filling_fio_in_extended_search(lastname, firstname, middlename) main_page.extended_search_click('close') main_page.newdonor_click() assert aistium.get_value( locators_list=locators, element_name='last_name_field_ndp') == expected_result1 assert aistium.get_value( locators_list=locators, element_name='first_name_field_ndp') == expected_result2 assert aistium.get_value( locators_list=locators, element_name='middle_name_field_ndp') == expected_result3
def test_grid_document(self, query, test_data_set_number): main_page = DonorsModuleRegistryPage() full_query = sql_query(query) donorid, document = str(full_query[0][0]), full_query[0][1] main_page.clear_localstorage() main_page.open() main_page.filling_quick_search(donorid) main_page.quick_search('click') main_page.loading_is_completed() ind = sql_query( "select Main.Nmb from (select row_number() over (order by PerC.BirthDate desc) Nmb, PerC.UniqueId from PersonCards PerC left join IdentityDocs IDoc on PerC.IdentityDocId = IDoc.UniqueId where PerC.IsDeleted != 1 and (PerC.UniqueId = '" + donorid + "' or IDoc.Number = '" + donorid + "')) Main where Main.UniqueId = '" + donorid + "'")[0][0] assert main_page.get_grid_values('Document', ind, main_page.main_grid) == document
def test_ndp_homephone(self, homephone, expected_result, test_data_set_number): main_page = DonorsModuleRegistryPage() main_page.clear_localstorage() main_page.open() main_page.newdonor_click() main_page.ndp_filling_first_page("Сидоров", "Кирилл", "", "01.06.1980", "8910", "650231") main_page.select_gender('male') aistium.click_on(elements=main_page.next_step_ndp) main_page.loading_is_completed() main_page.if_donor_is_in_local_cabinet() main_page.ndp_second_page_loaded() main_page.ndp_filling_contacts("", homephone, "") main_page.ndp_filling_region('Москва г') main_page.ndp_filling_street('Перовская ул') aistium.fill('4', elements=main_page.reg_fias_address_house) main_page.ndp_save_new_donor('success') assert aistium.get_text(elements=main_page.minicard_phone) == expected_result
def test_ndp_checking_donor_by_fic_fullname_b(self): main_page = DonorsModuleRegistryPage() main_page.clear_localstorage() change_donor_settings(UseFicDonorSearch='true') main_page.open() query = sql_query( '''select top (1) PerC.IdentityDocSerie, PerC.IdentityDocNumber, PerC.LastName + ' ' + PerC.FirstName + ' ' + PerC.MiddleName OR1 from aistdb_fic.dbo.PersonCards PerC where len(PerC.LastName) > 0 and len(PerC.FirstName) > 0 and len(PerC.MiddleName) > 0 and len(PerC.IdentityDocSerie) > 0 and len(PerC.IdentityDocNumber) > 0''', stand= "DRIVER={SQL Server};SERVER=10.36.200.79;DATABASE=aistdb_fic;UID=sa;PWD=Mos111222" ) document_serie = query[0][0] document_number = query[0][1] expected = query[0][2] main_page.newdonor_click() main_page.ndp_filling_first_page("Сидоров", "Кирилл", '', "01.06.1980", document_serie, document_number) main_page.select_gender('male') aistium.click_on(elements=main_page.next_step_ndp) main_page.loading_is_completed() main_page.if_donor_is_in_local_cabinet() main_page.ndp_results_by_fic_is_on_the_page() main_page.ndp_results_by_fic_get_grid_values('ФИО', 0, mode='click') Driver.get().switch_to.window(Driver.get().window_handles[1]) assert main_page.query_to_fic_get_fullname() == expected
def test_extended_search_by_document_serie_a(self, document_type, document_serie, expected_result, test_data_set_number): main_page = DonorsModuleRegistryPage() main_page.clear_localstorage() main_page.open() main_page.extended_search_click('open') main_page.filling_doc_type_in_extended_search(document_type) main_page.filling_doc_serie_in_extended_search(document_serie) assert main_page.get_document_serie_from_extended_search( ) == expected_result
def test_gender_validation(self, middlename, gender, expected_result, test_data_set_number): main_page = DonorsModuleRegistryPage() main_page.open() main_page.newdonor_click() main_page.ndp_filling_first_page("Сидоров", "Кирилл", middlename, "01.06.1980", "8910", "650231") main_page.select_gender(gender) aistium.click_on(elements=main_page.next_step_ndp) main_page.loading_is_completed() main_page.if_donor_is_in_local_cabinet() assert main_page.check_saved_gender(expected_result) == expected_result
def test_extended_search_by_document_serie_b(self, document_type, query, test_data_set_number): main_page = DonorsModuleRegistryPage() full_query = sql_query(query) donorid = str(full_query[0][0]) document_serie = str(full_query[0][1]) ind = sql_query( "select Main.Nmb from (select row_number() over (order by PerC.BirthDate desc) Nmb, PerC.UniqueId from PersonCards PerC join IdentityDocs IDoc on PerC.IdentityDocId = IDoc.UniqueId where PerC.IsDeleted != 1 and IDoc.Serie = '" + document_serie + "' and cast(IDoc.DocType as varchar) like case when '" + document_type + "' = '' then '%' when '" + document_type + "' = 'Паспорт РФ' then '1' when '" + document_type + "' = 'Военный билет' then '2' when '" + document_type + "' = 'Загранпаспорт РФ' then '3' when '" + document_type + "' = 'Паспорт СССР' then '4' when '" + document_type + "' = 'Иные документы' then '5' when '" + document_type + "' = 'Св-во о рождении' then '6' end) Main where Main.UniqueId = '" + donorid + "'")[0][0] main_page.clear_localstorage() main_page.open() main_page.extended_search_click('open') main_page.filling_doc_type_in_extended_search(document_type) main_page.filling_doc_serie_in_extended_search(document_serie) aistium.click_on(elements=main_page.extended_search_button) main_page.loading_is_completed() assert main_page.get_grid_values(' UniqueId', ind, main_page.main_grid) == donorid assert main_page.number_of_entities_at_grid_including_hidden( ) == sql_query( "select count ( * ) Q from PersonCards PerC join IdentityDocs IDoc on PerC.IdentityDocId = IDoc.UniqueId where PerC.IsDeleted != 1 and IDoc.Serie = '" + document_serie + "' and cast(IDoc.DocType as varchar) like case when '" + document_type + "' = '' then '%' when '" + document_type + "' = 'Паспорт РФ' then '1' when '" + document_type + "' = 'Военный билет' then '2' when '" + document_type + "' = 'Загранпаспорт РФ' then '3' when '" + document_type + "' = 'Паспорт СССР' then '4' when '" + document_type + "' = 'Иные документы' then '5' when '" + document_type + "' = 'Св-во о рождении' then '6' end")[0][0]
def test_document_serie_validation(self, document_type, document_serie, document_number, expected_result, test_data_set_number): main_page = DonorsModuleRegistryPage() main_page.open() main_page.newdonor_click() main_page.ndp_select_document_type(document_type) main_page.ndp_filling_first_page("Сидоров", "Кирилл", '', "01.06.1980", document_serie, document_number) main_page.select_gender('male') assert aistium.get_value( locators_list=locators, element_name='document_serie_field_ndp') == expected_result aistium.click_on(elements=main_page.next_step_ndp) main_page.loading_is_completed() main_page.if_donor_is_in_local_cabinet() main_page.ndp_second_page_loaded()
def test_lastname_validation_message(self, lastname, expected_result, test_data_set_number): main_page = DonorsModuleRegistryPage() main_page.open() main_page.newdonor_click() main_page.ndp_filling_first_page(lastname, "Кирилл", "", "01.06.1980", "8910", "650231") main_page.select_gender('male') aistium.click_on(elements=main_page.next_step_ndp) main_page.loading_is_completed() assert main_page.get_validation_message_text() == expected_result