def test_728(self): get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() page = ActivityHubPage() page.open() page.add_location_button.click() page = AddStartingLocationPage() select = Select(page.location_Country) select.select_by_visible_text('United States') select = Select(page.location_state) time.sleep(3) select.select_by_visible_text('Florida') page.location_zipcode.send_keys('54321') State = select.first_selected_option.text Zip = page.location_zipcode.get_attribute('value') select = Select(page.location_Country) select.select_by_visible_text('Canada') time.sleep(3) select = Select(page.location_state) assert select.first_selected_option.text == State assert page.location_zipcode.get_attribute('value') == Zip select = Select(page.location_Country) select.select_by_visible_text('Mexico') time.sleep(3) assert page.location_zipcode.get_attribute('value') == Zip select = Select(page.location_Country) select.select_by_visible_text('United States') time.sleep(3) select = Select(page.location_state) assert select.first_selected_option.text == State assert page.location_zipcode.get_attribute('value') == Zip
def test_113(self): #DELETE BRANCH get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() page = BranchPage() page.open() for i in range(0, len(page.branch_names)): if page.branch_names[i].get_attribute( 'textContent') == BranchEditedNameList[0]: page.delete_buttons[i - 1].click() else: continue break time.sleep(3) branch_list = [] for i in range(0, len(page.branch_names)): branch_list.append( page.branch_names[i].get_attribute('textContent')) assert BranchEditedNameList[0] not in branch_list page = CustomerBranchPage() page.open() customer_branch_list = [] for i in range(0, len(page.branch_tickets)): customer_branch_list.append( page.branch_tickets[i].get_attribute('textContent')) assert BranchEditedNameList[0] not in customer_branch_list
def test_923(self): get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() page = EditCompanyPage() page.open() time.sleep(5) if page.viator_checkbox.is_selected() == False: page.viator_checkbox.click() page.save_button.click() page.open() else: pass assert page.viator_checkbox.is_selected() == True SupplierID = page.viator_supplierID.get_attribute('value') SupplierIDlist.append(SupplierID) page.viator_checkbox.click() assert page.viator_checkbox.is_selected() == False assert page.is_element_present('viator_supplierID') == False page.save_button.click() cnxn = pyodbc.connect( 'DRIVER={ODBC Driver 17 for SQL Server};SERVER=' + server + ';DATABASE=' + database + ';UID=' + username + ';PWD=' + password) # STEP 14 cursor = cnxn.cursor() cursor.execute( "SELECT company_viator_useAPI FROM company WHERE company_id = 68") row = cursor.fetchone() assert row[0] == 0
def test_731(self): get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() time.sleep(5) page = EmployeePage() page.open() time.sleep(5) page.search_field.send_keys(user_name) time.sleep(2) page.edit_user_button.click() time.sleep(2) select = Select(page.state_list) State = select.first_selected_option.text Zip = page.user_zip.get_attribute('value') select = Select(page.country_list) select.select_by_visible_text('Canada') time.sleep(3) select = Select(page.state_list) assert select.first_selected_option.text == State assert page.user_zip.get_attribute('value') == Zip select = Select(page.country_list) select.select_by_visible_text('Mexico') time.sleep(3) assert page.user_zip.get_attribute('value') == Zip select = Select(page.country_list) select.select_by_visible_text('United States') time.sleep(3) select = Select(page.state_list) assert select.first_selected_option.text == State assert page.user_zip.get_attribute('value') == Zip
def test_723(self): #ADD BRANCH get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() page = EditCompanyPage() page.open() select = Select(page.state_list) State = select.first_selected_option.text Zip = page.zip_field.get_attribute('value') select = Select(page.country_list) select.select_by_visible_text('Canada') time.sleep(3) select = Select(page.state_list) assert select.first_selected_option.text == State assert page.zip_field.get_attribute('value') == Zip select = Select(page.country_list) select.select_by_visible_text('Mexico') time.sleep(3) select = Select(page.state_list) assert page.zip_field.get_attribute('value') == Zip select = Select(page.country_list) select.select_by_visible_text('United States') time.sleep(3) select = Select(page.state_list) assert select.first_selected_option.text == State assert page.zip_field.get_attribute('value') == Zip
def test_16(self): get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() page = GuidePayrollPage() page.open() select = Select(page.guide_list) select.select_by_visible_text(GuideName) time.sleep(6) for i in range(0, len(page.check)): if page.check[i].is_displayed(): page.check[i].click() else: continue break time.sleep(2) for i in range(0, len(page.check_number)): if page.check_number[i].is_displayed(): page.check_number[i].send_keys(CheckNumber) else: continue break time.sleep(6) for i in range(0, len(page.pay_button)): if page.pay_button[i].is_displayed(): page.pay_button[i].click() else: continue break time.sleep(6) alert = get_driver().switch_to_alert() assert (guide_flat_due+' to '+''.join(GuideName)) in alert.text alert.accept() time_and_date = datetime.now(AT).strftime('%#m/%#d/%Y %#I:%M') print(time_and_date) time.sleep(2) page.OK_button.click() time.sleep(15) select = Select(page.show_entries) select.select_by_visible_text('100') time.sleep(5) # try: # page.next_button.click() # except WebDriverException: # print("Less than 100 Entries") # time.sleep(4) L=[] # for i in range(0, len(page.payment_entry)): # L.append(page.payment_entry[i].get_attribute('textContent')) for i in range(0, len(page.payment_entry)): #until fixing 2904 Incorrect sorting of Recent Payments by date on guide_payroll.aspx if time_and_date in page.payment_entry[i].get_attribute('textContent'): L.append(page.payment_entry[i].get_attribute('textContent')) assert GuideName and guide_flat_due in page.payment_entry[i].get_attribute('textContent') else: continue break assert len(L) ==1 #until fixing 2904 Incorrect sorting of Recent Payments by date on guide_payroll.aspx
def test_363(self): get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() page = ActivityHubPage() page.open() InactiveActivity = 'Sometimes inactive activity' page.search_activity_field.send_keys(InactiveActivity) page.show_inactive.click() time.sleep(5) page.activity_actions.click() page.edit_activity.click() page = AddEditActivityPage() time.sleep(10) select = Select(page.activity_status) NewActivityStatus = "Inactive" select.select_by_visible_text(NewActivityStatus ) page.save_button.click() page = NavigationBar() time.sleep(8) page.main_actions_drop_down.click() page.add_a_booking.click() time.sleep(8) page = AdminBookingPage() page.activity_list.click() L=[] for i in range(0, len(page.activities_in_list)): L.append(page.activities_in_list[i].get_attribute("textContent")) assert InactiveActivity not in L
def test_124(self): get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() page = ActivityHubPage() page.open() page.add_location_button.click() page = AddStartingLocationPage() OldLocationNamePart = "AutoTestLoc" page.search_location.send_keys(OldLocationNamePart) page = LocationLink() for i in range(0, len(page.location_links)): if OldLocationNamePart in page.location_links[i].get_attribute( "textContent"): if page.location_links[i].is_displayed(): page.location_links[i].click() page = AddStartingLocationPage() ExistedLocationName = page.location_name.get_attribute('value') get_driver().back() page.location_name.send_keys(ExistedLocationName) time.sleep(4) assert page.is_element_present('alert_message') == True assert page.save_button.is_enabled() == False
def test_402(self): get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() time.sleep(5) page = EmployeePage() page.open() page.add_new_user.click() NewUserName = ("autotest402_" + ''.join(choice(digits) for i in range(4))) page.username_field.send_keys(NewUserName) NewUserPassword = ('' + ''.join(choice(digits) for i in range(8)) + 'qwer') page.password_field.send_keys(NewUserPassword) first_names = ('Ivan', 'Peter', 'John', 'Bill', 'Michael', 'Sidor', 'Alex', 'James') NewFirstName = random.choice(first_names) page.first_name_field.send_keys(NewFirstName) last_names = ('Smith', 'Baker', 'Petroff', 'Smirnoff', 'Black', 'White', 'Broun', 'Ivanoff') NewLastName = random.choice(last_names) page.last_name_field.send_keys(NewLastName) NewPhone1 = ('' + ''.join(choice(digits) for i in range(10))) page.phone1_field.send_keys(NewPhone1) NewEmail = ('' + ''.join(choice(digits) for i in range(10)) + '@mailinator.com') page.email_field.send_keys(NewEmail) select = Select(page.role_list) NewRole = "Office Staff" select.select_by_visible_text(NewRole) select = Select(page.payroll_type_list) NewPayrollType = "weekly" select.select_by_visible_text(NewPayrollType) NewSalaryAmount = '100' page.amount_field.send_keys(NewSalaryAmount) page.status_checkbox.click() page.save_button.click() time.sleep(6) page.search_field.clear() page.search_field.send_keys(NewEmail) time.sleep(6) page.edit_user_button.click() time.sleep(2) assert page.username_readonly_field.get_attribute( 'value') == NewUserName assert page.first_name_field.get_attribute('value') == NewFirstName assert page.last_name_field.get_attribute('value') == NewLastName assert page.phone1_field.get_attribute('value') == NewPhone1 assert page.email_field.get_attribute('value') == NewEmail select = Select(page.role_list) assert select.first_selected_option.text == NewRole select = Select(page.payroll_type_list) assert select.first_selected_option.text == NewPayrollType assert page.amount_field.get_attribute('value') == NewSalaryAmount assert page.status_checkbox.get_attribute('checked') == 'true'
def test_118(self): get_driver().maximize_window() page = GuidePage() page.profile_dropdown.click() wait = WebDriverWait(get_driver(), 15) wait.until(lambda driver: page.is_element_present('logout_button')) page.logout_button.click() page = loginpage() assert page.url == get_driver().current_url
def test_780(self): get_driver().maximize_window() page = loginpage() page.open() page.button.click() time.sleep(5) assert get_driver().current_url == page.url assert page.error_login.is_displayed() assert page.error_login.get_attribute( 'textContent') == "ERROR: Your login was incorrect"
def test_117(self): get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(guide1_login) page.password_field.send_keys(guide1_password) page.button.click() time.sleep(5) page = GuidePage() assert page.url == get_driver().current_url
def test_116(self): get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() page = ActivityHubPage() page.open() activity_partnames = ('AutoTest', 'test1', '3110', '25102017', 'TESTEDIT', 'REGRESSION', 'Regr') activity_partname = random.choice(activity_partnames) page.search_activity_field.send_keys(activity_partname) time.sleep(5) page.activity_actions.click() page.edit_activity.click() page = AddEditActivityPage() time.sleep(15) ActivityName = page.activity_name.get_attribute('value') page.ticket_maximum.clear() page.ticket_maximum.send_keys('50') page.ticket_minimum.clear() page.ticket_minimum.send_keys('51') page.ticket_maximum.click() assert page.ticket_maximum.get_attribute('value') == '50' assert page.ticket_minimum.get_attribute('value') == '51' time.sleep(5) assert page.is_element_present('ticket_maximum_alert') == True assert page.ticket_maximum_alert.is_displayed() page.save_button.click() time.sleep(5) assert page.ticket_maximum_alert.is_displayed() page.ticket_maximum.clear() page.ticket_maximum.send_keys('10') page.ticket_minimum.clear() page.ticket_minimum.send_keys('9') assert page.ticket_maximum.get_attribute('value') == '10' assert page.ticket_minimum.get_attribute('value') == '9' time.sleep(5) assert page.is_element_present('ticket_maximum_alert') == False page.save_button.click() page.save_button.click() time.sleep(5) page = ActivityHubPage() get_driver().refresh() page.search_activity_field.send_keys(ActivityName) time.sleep(5) page.activity_actions.click() page.edit_activity.click() page = AddEditActivityPage() time.sleep(15) assert page.ticket_maximum.get_attribute('value') == '10' assert page.ticket_minimum.get_attribute('value') == '9' assert page.is_element_present('ticket_maximum_alert') == False
def test_314(self): get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() page=ActivityHubPage() page.open() activity_partnames = ('test1', '3110', '25102017', 'TESTEDIT', 'REGRESSION', 'Regr') activity_partname = random.choice(activity_partnames) page.search_activity_field.send_keys(activity_partname) time.sleep(5) page.activity_actions.click() page.edit_activity.click() page = AddEditActivityPage() time.sleep(15) ActivityName = page.activity_name.get_attribute('value') page.first_ticket_price.clear() page.first_ticket_price.send_keys('-100') assert page.first_ticket_price.get_attribute('value')=='100' page.first_ticket_price.clear() page.first_ticket_price.send_keys('abc') assert page.first_ticket_price.get_attribute('value')=='' page.first_ticket_price.clear() page.first_ticket_price.send_keys('0.01') assert page.first_ticket_price.get_attribute('value')=='0.01' page.save_button.click() time.sleep(5) page = ActivityHubPage() get_driver().refresh() page.search_activity_field.send_keys(ActivityName) time.sleep(5) page.activity_actions.click() page.edit_activity.click() page = AddEditActivityPage() time.sleep(15) assert page.first_ticket_price.get_attribute('value') == '0.01' page.first_ticket_price.clear() page.first_ticket_price.send_keys('0.9') assert page.first_ticket_price.get_attribute('value') == '0.9' page.save_button.click() time.sleep(5) page = ActivityHubPage() get_driver().refresh() page.search_activity_field.send_keys(ActivityName) time.sleep(5) page.activity_actions.click() page.edit_activity.click() page = AddEditActivityPage() time.sleep(15) assert page.first_ticket_price.get_attribute('value') == '0.9'
def test_121(self): get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() page = ActivityHubPage() page.open() page.show_inactive.click() page.search_activity_field.send_keys('TestEdit') ExistedActivityName = page.activity_title.get_attribute("textContent") page.add_activity_button.click() time.sleep(10) page = AddEditActivityPage() page.activity_name.send_keys(ExistedActivityName) page.activity_url.click() time.sleep(5) assert page.is_element_present('alert_message') == True select = Select(page.activity_status) NewActivityStatus = "Active" select.select_by_visible_text(NewActivityStatus) select = Select(page.branch) NewActivityBranch = "First branch" select.select_by_visible_text(NewActivityBranch) select = Select(page.starting_location) NewActivityLocation = "Hotel California" select.select_by_visible_text(NewActivityLocation) select = Select(page.time_zone) NewActivityTimezone = "Central" select.select_by_visible_text(NewActivityTimezone) NewActivityCancellationPolicy = 'We can cancel an event any time we want.' page.cancellation_policy.send_keys(NewActivityCancellationPolicy) NewActivityDurationDays = '0' page.activity_duration_days.send_keys(NewActivityDurationDays) NewActivityDurationHours = '2' page.activity_duration_hours.send_keys(NewActivityDurationHours) NewActivityDurationMinutes = '15' page.activity_duration_minutes.send_keys(NewActivityDurationMinutes) page.stop_booking_sold.click() select = Select(page.stop_booking_sold) NewActivityStopbookingSold = "1h 30 m" select.select_by_visible_text(NewActivityStopbookingSold) NewActivityFirstTicketType = "Adult" page.first_ticket_type.send_keys(NewActivityFirstTicketType) NewActivityFirstTicketPrice = '9.99' page.first_ticket_price.send_keys(NewActivityFirstTicketPrice) page.save_button.click() time.sleep(5) assert page.is_element_present( 'alert_message') == True #failed - bug 2432 assert get_driver().current_url == page.url #failed - bug 2432
def test_778(self): get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) invalid_pwd = (''.join(choice(digits) for i in range(7))) page.password_field.send_keys(invalid_pwd) page.button.click() time.sleep(5) assert get_driver().current_url == page.url assert page.error_login.is_displayed() assert page.error_login.get_attribute( 'textContent') == "ERROR: Your login was incorrect"
def test_3(self): get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() page = logoutpage() page.profile_dropdown.click() wait = WebDriverWait(get_driver(), 15) wait.until(lambda driver: page.is_element_present('logout_button')) page.logout_button.click() assert get_driver().current_url == 'https://dev.godo.io/login.aspx' get_driver().quit()
def test_123(self): #2 BRANCHES WITH THE SAME NAME get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() page = BranchPage() page.open() branch_list = [] for i in range(0, len(page.branch_names)): branch_list.append( page.branch_names[i].get_attribute('textContent')) time.sleep(3) page.add_branch_button.click() BranchName = branch_list[-1] page.branch_name_field.send_keys(BranchName) BranchNewNameList.append(BranchName) select = Select(page.timezone_list) NewBranchTimeZone = "Atlantic" select.select_by_visible_text(NewBranchTimeZone) NewBranchAddress1 = "test012" page.branch_address1.send_keys(NewBranchAddress1) NewBranchAddress2 = "test012" page.branch_address2.send_keys(NewBranchAddress2) select = Select(page.country_list) NewBranchCountry = "United States" select.select_by_visible_text(NewBranchCountry) time.sleep(6) select = Select(page.state_list) NewBranchState = "Washington" select.select_by_visible_text(NewBranchState) NewBranchCity = "Seattle" page.branch_city.send_keys(NewBranchCity) NewBranchZip = "12341" page.branch_zip.send_keys(NewBranchZip) NewBranchEmail = "*****@*****.**" page.branch_email.send_keys(NewBranchEmail) NewBranchPhone1 = "(206)624-3287" page.branch_phone1.send_keys(NewBranchPhone1) NewBranchPhone2 = "(206)624-3287" page.branch_phone2.send_keys(NewBranchPhone2) page.save_button.click() time.sleep(3) assert page.is_element_present('alert_message') == True branch_list1 = [] for i in range(0, len(page.branch_names)): branch_list1.append( page.branch_names[i].get_attribute('textContent')) assert len(branch_list1) == len(branch_list)
def test_4(self): get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_hourly_login) page.password_field.send_keys(admin_hourly_password) page.button.click() page = NavigationBar() time.sleep(6) page.time_tracker.click() time.sleep(tracked_time_seconds) page.time_tracker_checked.click() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() page = EmployeePayrollPage() page.open() time.sleep(3) page.employee_payment_due_hourly.click() L = [] for i in range(0, len(page.hourly_payment_due_enties)): if admin_hourly_name in page.hourly_payment_due_enties[ i].get_attribute("textContent"): L.append( page.hourly_employee_payment_due_amounts[i].get_attribute( "textContent")) else: continue break time.sleep(3) assert len(L) == 1 payment_due_amount_number = float("{0:.1f}".format( float(re.sub("[^\d\.]", "", L[0])))) assert payment_due_amount_number == amount_tracked
def test_510(self): get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() page = ActivityHubPage() page.open() page.search_activity_field.send_keys(Activity1) time.sleep(5) page.activity_actions.click() page.edit_activity.click() page = AddEditActivityPage() time.sleep(15) if page.is_element_present('remove_fourth_linked_activity') == True: page.remove_fourth_linked_activity.click() if page.is_element_present('remove_third_linked_activity') == True: page.remove_third_linked_activity.click() if page.is_element_present('remove_second_linked_activity') == True: page.remove_second_linked_activity.click() if page.is_element_present('remove_first_linked_activity') == True: page.remove_first_linked_activity.click() time.sleep(7) select = Select(page.first_linked_activity) time.sleep(5) select.select_by_visible_text(Activity2) page.save_button.click() page = ActivityHubPage() page.search_activity_field.send_keys(Activity1) time.sleep(5) page.activity_actions.click() page.edit_activity.click() page = AddEditActivityPage() time.sleep(15) select = Select(page.first_linked_activity) assert select.first_selected_option.text == Activity2 page.cancel_button.click() page = ActivityHubPage() page.search_activity_field.send_keys(Activity2) time.sleep(5) text = page.activity_title.get_attribute("textContent") page.activity_actions.click() page.edit_activity.click() page = AddEditActivityPage() time.sleep(15) select = Select(page.first_linked_activity) assert select.first_selected_option.text == Activity1
def test_781(self): get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() page = ChannelPage() page.open() time.sleep(5) page.search_field.send_keys(ChannelName) time.sleep(2) page.table_channel_editbutton.click() select = Select(page.comission_type_list) if select.first_selected_option.text == 'Percentage': pass else: select.select_by_visible_text('Percentage') if page.comission_amount.get_attribute('value') == Amount: pass else: page.comission_amount.clear() page.comission_amount.send_keys(Amount) page.save_button.click() time.sleep(5) page.search_field.send_keys(ChannelName) time.sleep(2) page.table_channel_editbutton.click() select = Select(page.comission_type_list) NewComissionType = 'Dollar Amount' select.select_by_visible_text(NewComissionType) page.save_button.click() time.sleep(5) page.search_field.send_keys(ChannelName) time.sleep(2) assert page.table_channel_comission.get_attribute( 'textContent') == '$' + ''.join(Amount) page.table_channel_editbutton.click() time.sleep(2) select = Select(page.comission_type_list) assert select.first_selected_option.text == 'Dollar Amount' select.select_by_visible_text('Percentage') page.save_button.click() time.sleep(5) page.search_field.send_keys(ChannelName) time.sleep(2) assert page.table_channel_comission.get_attribute( 'textContent') == Amount + '%'
def test_877(self): get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() page = CustomerListPage() page.open() page.add_customer_button.click() first_names = ('Ivan', 'Peter', 'John', 'Bill', 'Michael', 'Sidor', 'Alex', 'James', 'Bob', 'Ivan', 'Tim', 'Chris', 'Jim', 'Pahom', 'Vlad', 'Paul') NewFirstName = random.choice(first_names) page.first_name_field.send_keys(NewFirstName) last_names = ('Smith', 'Baker', 'Petroff', 'Smirnoff', 'Black', 'White', 'Broun', 'Ivanoff', 'Green', 'Clinton', 'Jameson', 'Last', 'Sergeff', 'Madison') NewLastName = random.choice(last_names) NewFullName = NewFirstName + ' ' + ''.join(NewLastName) page.last_name_field.send_keys(NewLastName) NewEmail = (''.join(choice(digits) for i in range(15)) + '@mailinator.com') page.email_field.send_keys(NewEmail) page.save_button.click() time.sleep(5) page.search_field.send_keys(NewFullName) page.search_button.click() time.sleep(5) assert page.customer_name_in_list.get_attribute( 'textContent') == NewFullName assert page.email_in_list.get_attribute('textContent') == NewEmail page.edit_button.click() assert page.customer_name_info.get_attribute( 'textContent') == NewFullName + "'s" assert page.email_info.get_attribute('innerText') == NewEmail cnxn = pyodbc.connect( 'DRIVER={ODBC Driver 17 for SQL Server};SERVER=' + server + ';DATABASE=' + database + ';UID=' + username + ';PWD=' + password) cursor = cnxn.cursor() cursor.execute( "SELECT TOP 1 * FROM customer ORDER BY customer_id DESC") row = cursor.fetchone() assert row[1] == 68 #company ID assert row[2] == NewFirstName assert row[3] == NewLastName assert row[12] == NewEmail assert row[17] == NewEmail #CustomerKey
def test_790(self): get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() page = ChannelPage() page.open() time.sleep(2) page.search_field.send_keys(ChannelName) time.sleep(2) page.table_channel_editbutton.click() time.sleep(5) select = Select(page.country_list) if select.first_selected_option.text == 'United States': pass else: select.select_by_visible_text('United States') select = Select(page.state_list) if select.first_selected_option.text == 'California': pass else: select.select_by_visible_text('California') if page.zip_code.get_attribute('value') == '45355': pass else: page.zip_code.clear() page.zip_code.send_keys('45355') State = select.first_selected_option.text Zip = page.zip_code.get_attribute('value') select = Select(page.country_list) select.select_by_visible_text('Canada') time.sleep(3) select = Select(page.state_list) assert select.first_selected_option.text == State #Bug2952 assert page.zip_code.get_attribute('value') == Zip select = Select(page.country_list) select.select_by_visible_text('Mexico') time.sleep(3) assert page.zip_code.get_attribute('value') == Zip select = Select(page.country_list) select.select_by_visible_text('United States') time.sleep(3) select = Select(page.state_list) assert select.first_selected_option.text == State assert page.zip_code.get_attribute('value') == Zip
def test_595(self): get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() page = WaiverAddPage() page.open() page.add_waiver_button.click() page.ok_confirm_button.click() time.sleep(7) page.logo_checkbox.click() NewWaiverName = ("AutoTest_" + ''.join(choice(digits) for i in range(4))) page.waiver_title.send_keys(NewWaiverName) NewWaiverHeader = "TestHeader" page.text_fields[0].send_keys(NewWaiverHeader) page.next_button.click() # select = Select(page.field_add) # NewFieldAdd = "Date of Signing" # select.select_by_visible_text(NewFieldAdd) # page.insert_button.click() time.sleep(8) page.text_fields[1].send_keys( 'By signing this waiver agreement, _________________ agrees to the following terms: Assumption of Risk. PandaTip: This waiver agreement template protects you by ensuring that your client understands that they are participating in your event at their own risk, and that all risk and liability rests with them. The Client agrees that their participation in [Event.Name] is voluntary. Furthermore, the Client agrees to assume any risk associated with participating in the event, and releases [Sender.Company] from any and all claims of loss or damage that may arise during the Client’s participation. Such releases are without limitation, and include attorneys’ fees, personal injury, property damage, and any other losses or damages suffered by the Client.' ) page.next1_button.click() NewWaiverRefer = "Dear Friends" page.refer_field.send_keys(NewWaiverRefer) page.save_button.click() time.sleep(10) select = Select(page.entries_per_page) select.select_by_visible_text('100') time.sleep(2) L = [] for i in range(0, len(page.waiver_names)): L.append(page.waiver_names[i].get_attribute("textContent")) assert (NewWaiverName + ' ') in L for i in range(0, len(page.waiver_entries)): if (NewWaiverName + ' ') in page.waiver_name[i].get_attribute("textContent"): assert page.count_value[i].get_attribute("textContent") == '0'
def test_726(self): get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() page=PeopleHubPage() page.open() time.sleep(2) page.your_customer_button.click() time.sleep(2) page = CustomerListPage() page.add_customer_button.click() time.sleep(3) select = Select(page.country_list) select.select_by_visible_text('United States') select = Select(page.state_list) time.sleep(3) select.select_by_visible_text('Florida') page.customer_zip.send_keys('54321') State = select.first_selected_option.text Zip = page.customer_zip.get_attribute('value') select = Select(page.country_list) select.select_by_visible_text('Canada') time.sleep(5) select = Select(page.state_list) assert select.first_selected_option.text == State assert page.customer_zip.get_attribute('value') == Zip select = Select(page.country_list) select.select_by_visible_text('Mexico') time.sleep(3) assert page.customer_zip.get_attribute('value') == Zip select = Select(page.country_list) select.select_by_visible_text('United States') time.sleep(3) select = Select(page.state_list) assert select.first_selected_option.text == State assert page.customer_zip.get_attribute('value') == Zip
def test_947(self): #ADD BRANCH get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() page = BranchPage() page.open() for i in range(0, len(page.branch_names)): if 'Ghost City Tourss Main Branch' == page.branch_names[ i].get_attribute('textContent'): page.branch_edit_buttons[i].click() else: continue break time.sleep(3) select = Select(page.state_list) State = select.first_selected_option.text Zip = page.branch_zip.get_attribute('value') select = Select(page.country_list) select.select_by_visible_text('Canada') time.sleep(3) select = Select(page.state_list) assert select.first_selected_option.text == State assert page.branch_zip.get_attribute('value') == Zip select = Select(page.country_list) select.select_by_visible_text('Mexico') time.sleep(3) assert page.branch_zip.get_attribute('value') == Zip select = Select(page.country_list) select.select_by_visible_text('United States') time.sleep(3) select = Select(page.state_list) assert select.first_selected_option.text == State assert page.branch_zip.get_attribute('value') == Zip
def test_729(self): get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() page = ActivityHubPage() page.open() page.add_location_button.click() page = AddStartingLocationPage() page.search_location.send_keys('Chris Falvey') page = LocationLink() for i in range(0, len(page.location_links)): if page.location_links[i].is_displayed(): page.location_links[i].click() page = AddStartingLocationPage() select = Select(page.location_state) State = select.first_selected_option.text Zip = page.location_zipcode.get_attribute('value') select = Select(page.location_Country) select.select_by_visible_text('Canada') time.sleep(3) select = Select(page.location_state) assert select.first_selected_option.text == State assert page.location_zipcode.get_attribute('value') == Zip select = Select(page.location_Country) select.select_by_visible_text('Mexico') time.sleep(3) assert page.location_zipcode.get_attribute('value') == Zip select = Select(page.location_Country) select.select_by_visible_text('United States') time.sleep(3) select = Select(page.location_state) assert select.first_selected_option.text == State assert page.location_zipcode.get_attribute('value') == Zip
def test_186(self): get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() time.sleep(5) page = EmployeePage() page.open() page.add_new_user.click() NewUserName = ("autotest_" + ''.join(choice(digits) for i in range(4))) page.username_field.send_keys(NewUserName) NewUserPassword = ('' + ''.join(choice(digits) for i in range(8)) + 'qwer') page.password_field.send_keys(NewUserPassword) first_names = ('Ivan', 'Peter', 'John', 'Bill', 'Michael', 'Sidor', 'Alex', 'James') NewFirstName = random.choice(first_names) page.first_name_field.send_keys(NewFirstName) last_names = ('Smith', 'Baker', 'Petroff', 'Smirnoff', 'Black', 'White', 'Broun', 'Ivanoff') NewLastName = random.choice(last_names) page.last_name_field.send_keys(NewLastName) NewFullName = NewFirstName + ' ' + ''.join(NewLastName) fullname_list.append(NewFullName) NewPhone1 = ('' + ''.join(choice(digits) for i in range(10))) page.phone1_field.send_keys(NewPhone1) NewPhone2 = ('' + ''.join(choice(digits) for i in range(10))) page.phone2_field.send_keys(NewPhone2) NewEmail = ('' + ''.join(choice(digits) for i in range(10)) + '@mailinator.com') page.email_field.send_keys(NewEmail) email_list.append(NewEmail) select = Select(page.role_list) NewRole = "Office Staff" select.select_by_visible_text(NewRole) select = Select(page.payroll_type_list) NewPayrollType = "weekly" select.select_by_visible_text(NewPayrollType) NewSalaryAmount = '100' page.amount_field.send_keys(NewSalaryAmount) page.status_checkbox.click() NewHireDate = '09/25/2018' page.hire_date_field.send_keys(NewHireDate) NewEndDate = '09/25/2020' page.end_date_field.send_keys(NewEndDate) time.sleep(5) NewUserHouseNumber = '' + ''.join(choice(digits) for i in range(2)) page.house_number_field.send_keys(NewUserHouseNumber) NewUserStreet = 'Main Street' page.street_field.send_keys(NewUserStreet) NewUserCity = 'Boston' page.city_field.send_keys(NewUserCity) NewUserCountry = "United States" select = Select(page.country_list) select.select_by_visible_text(NewUserCountry) NewUserState = 'Florida' select = Select(page.state_list) time.sleep(3) select.select_by_visible_text(NewUserState) NewUserZip = '54321' page.user_zip.send_keys('54321') select = Select(page.branch_list) NewBranch = "AlexeyBranch" select.select_by_visible_text(NewBranch) NewAccountOwnerName = 'TestAccountOwner' page.name_account_owner_field.send_keys(NewAccountOwnerName) NewBankName = 'BSB Bank' page.bank_name_field.send_keys(NewBankName) time.sleep(5) NewRoutingNumber = '' + ''.join(choice(digits) for i in range(8)) page.routing_number_field.send_keys(NewRoutingNumber) NewAccountNumber = '' + ''.join(choice(digits) for i in range(8)) page.account_number_field.send_keys(NewAccountNumber) NewEmergencyContact = '' + ''.join(choice(digits) for i in range(8)) page.em_contact_field.send_keys(NewEmergencyContact) NewEmergencyPhone = '' + ''.join(choice(digits) for i in range(8)) page.em_phone_field.send_keys(NewEmergencyPhone) L = [] for i in range(0, len(page.permission_entries)): if page.permission_checkbox[i].get_attribute('checked') == 'true': L.append(page.permission_entries[i].get_attribute('outerText')) else: continue page.save_button.click() time.sleep(6) page.search_field.clear() page.search_field.send_keys(NewEmail) time.sleep(6) page.edit_user_button.click() time.sleep(2) assert page.username_readonly_field.get_attribute( 'value') == NewUserName assert page.first_name_field.get_attribute('value') == NewFirstName assert page.last_name_field.get_attribute('value') == NewLastName assert page.phone1_field.get_attribute('value') == NewPhone1 assert page.phone2_field.get_attribute('value') == NewPhone2 assert page.email_field.get_attribute('value') == NewEmail select = Select(page.role_list) assert select.first_selected_option.text == NewRole select = Select(page.payroll_type_list) assert select.first_selected_option.text == NewPayrollType assert page.amount_field.get_attribute('value') == NewSalaryAmount assert page.status_checkbox.get_attribute('checked') == 'true' assert page.hire_date_field.get_attribute('value') == NewHireDate assert page.end_date_field.get_attribute('value') == NewEndDate assert page.house_number_field.get_attribute( 'value') == NewUserHouseNumber assert page.street_field.get_attribute('value') == NewUserStreet assert page.city_field.get_attribute('value') == NewUserCity select = Select(page.country_list) assert select.first_selected_option.text == NewUserCountry select = Select(page.state_list) assert select.first_selected_option.text == NewUserState assert page.user_zip.get_attribute('value') == NewUserZip select = Select(page.branch_list) assert select.first_selected_option.text == NewBranch assert page.name_account_owner_field.get_attribute( 'value') == NewAccountOwnerName assert page.bank_name_field.get_attribute('value') == NewBankName assert page.routing_number_field.get_attribute( 'value') == NewRoutingNumber assert page.account_number_field.get_attribute( 'value') == NewAccountNumber L1 = [] for i in range(0, len(page.permission_entries)): if page.permission_checkbox[i].get_attribute('checked') == 'true': L1.append( page.permission_entries[i].get_attribute('outerText')) else: continue assert L == L1
def test_600(self): get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() page=ActivityHubPage() #STEP1 page.open() page.add_activity_button.click() #STEP2 page=AddEditActivityPage() time.sleep(15) assert page.switchers1[0].get_attribute("outerHTML") == switcher_OFF page.stop_no_sales.send_keys('-1')#STEP3 page.minimum_not_met_alert.click() assert page.stop_no_sales.get_attribute('value')=='0' page.stop_no_sales.send_keys('10000001')#STEP4 page.minimum_not_met_alert.click() assert page.stop_no_sales.get_attribute('value')=='100' page.stop_no_sales.clear()#STEP5 page.stop_no_sales.send_keys('1') page.minimum_not_met_alert.click() assert page.stop_no_sales.get_attribute('value')=='1' NewActivityName = ("AutoTest600_" + ''.join(choice(digits) for i in range(4))) page.activity_name.send_keys(NewActivityName) select = Select(page.activity_status) NewActivityStatus = "Inactive" select.select_by_visible_text(NewActivityStatus) select = Select(page.branch) NewActivityBranch = "AlexeyBranch" select.select_by_visible_text(NewActivityBranch) select = Select(page.starting_location) NewActivityLocation = "Hotel California" select.select_by_visible_text(NewActivityLocation) select = Select(page.time_zone) NewActivityTimezone = "Pacific" select.select_by_visible_text(NewActivityTimezone) NewActivityCancellationPolicy = 'We can cancel an event any time we want.' page.cancellation_policy.send_keys(NewActivityCancellationPolicy) NewActivityDurationMinutes = '15' page.activity_duration_minutes.send_keys(NewActivityDurationMinutes) page.ticket_maximum.clear() NewActivityMaxTickets = '100' page.ticket_maximum.send_keys(NewActivityMaxTickets) NewActivityFirstTicketType = "Adult" page.first_ticket_type.send_keys(NewActivityFirstTicketType) NewActivityFirstTicketPrice = '9.99' page.first_ticket_price.send_keys(NewActivityFirstTicketPrice) page.stop_booking_sold.click() select = Select(page.stop_booking_sold) NewActivityStopbookingSold = "15 m" select.select_by_visible_text(NewActivityStopbookingSold) page.save_button.click() time.sleep(5) page = ActivityHubPage() time.sleep(5) page.show_inactive.click() page.search_activity_field.send_keys(NewActivityName) # STEP6 time.sleep(5) page.activity_actions.click() page.edit_activity.click() page = AddEditActivityPage() time.sleep(15) assert page.switchers1[0].get_attribute("outerHTML") == switcher_OFF assert page.stop_no_sales.get_attribute('value') == '1' cnxn = pyodbc.connect( 'DRIVER={ODBC Driver 17 for SQL Server};SERVER=' + server + ';DATABASE=' + database + ';UID=' + username + ';PWD=' + password)# STEP7 cursor = cnxn.cursor() cursor.execute("SELECT TOP 1 activity_stopbooking_hoursbefore, activity_stopbooking_midnightbefore, activity_name FROM activity ORDER BY activity_id DESC") row = cursor.fetchone() assert row[0] == 1 assert row[1] == 0 assert row[2] == NewActivityName page.switchers1[0].click()#STEP8 assert page.switchers1[0].get_attribute("outerHTML") != switcher_OFF assert page.stop_no_sales.get_attribute('value') == '' assert page.stop_no_sales.is_enabled()==False page.save_button.click()#STEP9 time.sleep(5) page = ActivityHubPage() time.sleep(5) page.show_inactive.click() page.search_activity_field.send_keys(NewActivityName) time.sleep(5) page.activity_actions.click() page.edit_activity.click() page = AddEditActivityPage() time.sleep(15) assert page.switchers1[0].get_attribute("outerHTML") != switcher_OFF assert page.stop_no_sales.is_enabled() == False cursor.execute("SELECT TOP 1 activity_stopbooking_hoursbefore, activity_stopbooking_midnightbefore, activity_name FROM activity ORDER BY activity_id DESC")#STEP10 row = cursor.fetchone() assert row[0] == 0 assert row[1] == 1 assert row[2] == NewActivityName
def test_81(self): get_driver().maximize_window() page = loginpage() page.open() page.login_field.send_keys(admin_login) page.password_field.send_keys(admin_password) page.button.click() page = ActivityHubPage() page.open() page.add_activity_button.click() page = AddEditActivityPage() time.sleep(5) NewActivityName = ("AutoTest81_" + ''.join(choice(digits) for i in range(4))) ActivityNameList.append(NewActivityName) page.activity_name.send_keys(NewActivityName) select = Select(page.activity_status) NewActivityStatus = "Active" select.select_by_visible_text(NewActivityStatus) select = Select(page.branch) NewActivityBranch = "AlexeyBranch" select.select_by_visible_text(NewActivityBranch) select = Select(page.starting_location) NewActivityLocation = "Hotel California" select.select_by_visible_text(NewActivityLocation) select = Select(page.time_zone) NewActivityTimezone = "Pacific" select.select_by_visible_text(NewActivityTimezone) NewActivityCancellationPolicy = 'We can cancel an event any time we want.' page.cancellation_policy.send_keys(NewActivityCancellationPolicy) NewActivityDurationMinutes = '15' page.activity_duration_minutes.send_keys(NewActivityDurationMinutes) page.ticket_maximum.clear() NewActivityMaxTickets = '100' page.ticket_maximum.send_keys(NewActivityMaxTickets) NewActivityFirstTicketType = "Adult" page.first_ticket_type.send_keys(NewActivityFirstTicketType) NewActivityFirstTicketPrice = '9.99' page.first_ticket_price.send_keys(NewActivityFirstTicketPrice) page.stop_booking_sold.click() select = Select(page.stop_booking_sold) NewActivityStopbookingSold = "15 m" select.select_by_visible_text(NewActivityStopbookingSold) page.save_button.click() time.sleep(5) page = ActivityHubPage() page.search_activity_field.send_keys(NewActivityName) time.sleep(5) page.activity_actions.click() text = page.activity_title.get_attribute("textContent") assert text == NewActivityName page.edit_activity.click() page = AddEditActivityPage() time.sleep(15) assert page.activity_name.get_attribute('value') == NewActivityName select = Select(page.activity_status) assert select.first_selected_option.text == NewActivityStatus select = Select(page.branch) assert select.first_selected_option.text == NewActivityBranch select = Select(page.starting_location) assert select.first_selected_option.text == NewActivityLocation select = Select(page.time_zone) assert select.first_selected_option.text == NewActivityTimezone assert page.cancellation_policy.get_attribute( 'value') == NewActivityCancellationPolicy assert page.activity_duration_minutes.get_attribute( 'value') == NewActivityDurationMinutes assert page.ticket_maximum.get_attribute( 'value') == NewActivityMaxTickets assert page.first_ticket_type.get_attribute( 'value') == NewActivityFirstTicketType assert page.first_ticket_price.get_attribute( 'value') == NewActivityFirstTicketPrice for i in range(0, len(page.switchers1)): assert page.switchers1[i].get_attribute( "outerHTML") == switcher_OFF for i in range(0, len(page.switchers2)): assert page.switchers2[i].get_attribute( "outerHTML") == switcher_OFF assert page.switcher_minimum_enforce.get_attribute( "outerHTML") == switcher_OFF select = Select(page.stop_booking_sold) assert select.first_selected_option.text == NewActivityStopbookingSold cnxn = pyodbc.connect( 'DRIVER={ODBC Driver 17 for SQL Server};SERVER=' + server + ';DATABASE=' + database + ';UID=' + username + ';PWD=' + password) #STEP8 cursor = cnxn.cursor() cursor.execute( "SELECT TOP 1 * FROM activity ORDER BY activity_id DESC") row = cursor.fetchone() assert row[1] == 68 #company id assert row[2] == 47 #location_id assert row[3] == 386 #branch_id assert row[4] == 9 #timezone_id assert row[6] == NewActivityName assert row[11] == NewActivityCancellationPolicy assert row[14] == 0 #Firstsalecloseevent assert row[15] == 0 # StopBookingNoSales assert row[16] == 15 # StopBookingSold assert row[17] == 0 # StopBookingMidBefore assert row[21] == 15 #Duration assert row[32] == True #GuideUponSellout assert row[33] == 1 #ActivityStatus assert row[36] == 0 #Tickets Minimum Enforce assert row[37] == 0 # Viator assert row[39] == 0 # 2-step Check In