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_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_891(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 = NavigationBar()
time.sleep(2)
page.main_actions_drop_down.click()
time.sleep(2)
page.add_a_booking.click() #STEP1
page = AdminBookingPage()
select = Select(page.activity_list)
select.select_by_visible_text(ActivityName) #STEP2
page.first_tickets_type.send_keys(AdultTickets) #STEP3
time.sleep(5)
page.datepicker_next_month.click()
time.sleep(5)
EventDate = str(random.randint(2, 27)) #STEP4
for i in range(0, len(page.dates)):
if page.dates[i].get_attribute("textContent") == EventDate:
page.dates[i].click()
else:
continue
break
time.sleep(5)
EventTimeHours = str(random.randint(2, 11))
minutes_values = ('00', '15', '30', '45')
EventTimeMinutes = random.choice(minutes_values)
timeday = random.choice(('AM', 'PM'))
EventTimeWithZone = (EventTimeHours + ':' + ''.join(EventTimeMinutes) +
' ' + ''.join(timeday) + ' ' +
''.join(ActivityTimezone))
NextMonthName = (datetime.now() +
relativedelta(months=1)).strftime("%B")
NewFullDate = (NextMonthName + ' ' + ''.join(str(EventDate)))
select = Select(page.time)
select.select_by_visible_text(EventTimeWithZone) #STEP5
time.sleep(5)
page.enter_customer_information_button.click() #STEP6
first_names = ('Ivan-John', 'Peter-Paul', 'John-Alex', 'Bill-Michael',
'Michael-James', 'Sidor-Bob', 'Alex-Ivan', 'James-Tim',
'Bob-Chris', 'Ivan-Jim', 'Tim-Michael', 'Chris-Jim',
'Jim-John', 'Pahom-Sidor', 'Vlad-Vadim', 'Paul-James')
NewFirstName = random.choice(first_names)
page.first_name.send_keys(NewFirstName) #STEP7
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.send_keys(NewLastName)
NewPhone = (''.join(choice(digits) for i in range(15)))
page.phone_number.send_keys(NewPhone)
page.complete_booking_button.click()
time.sleep(7)
select = Select(page.payment_type_list)
PaymentType = "Cash" # STEP8
select.select_by_visible_text(PaymentType)
page.cash_recieved.click()
page.submit_booking_button.click()
time.sleep(5)
page = EventCalendarPage() #STEP10
page.open()
time.sleep(2)
select = Select(page.activity_name)
select.select_by_visible_text(ActivityName)
page.date_picker.click()
time.sleep(2)
page.date_picker_next.click()
for i in range(0, len(page.days_date_picker)):
if page.days_date_picker[i].get_attribute("textContent") == str(
EventDate):
page.days_date_picker[i].click()
else:
continue
break
page.day_button.click()
time.sleep(6)
EventTime = (EventTimeHours + ':' + ''.join(EventTimeMinutes) + ' ' +
''.join(timeday))
assert str(NewFullDate) in page.date_header.get_attribute(
"textContent")
for ticket in page.day_slots: #STEP11
for i in range(0, len(page.day_slots)):
if EventTime in ticket.day_slot_time[i].get_attribute(
'textContent'):
page.day_slots[i].click()
else:
continue
break
time.sleep(6)
assert page.customer_name_link.get_attribute(
'textContent') == NewFullName
assert page.phone_link.get_attribute('pathname') == NewPhone
page.customer_name_link.click() # STEP12
page = CustomerListPage()
assert page.customer_name_info.get_attribute(
'textContent') == NewFullName + "'s"
assert page.phone_info.get_attribute('innerText') == NewPhone
assert page.email_info.get_attribute('innerText') == 'Not Saved'
assert page.zip_info.get_attribute('innerText') == 'Not Saved'
assert page.state_info.get_attribute('innerText') == 'Not Saved'
assert page.address_info.get_attribute('innerText') == 'Not Saved'
assert page.timeline_tickets_title.get_attribute(
'textContent'
) == 'Purchased Tickets for the ' + ''.join(ActivityName)
assert EventTimeWithZone and NewFullDate in page.timeline_event.get_attribute(
'textContent')
assert page.timeline_tickets.get_attribute(
'textContent'
) == AdultTickets + ' Tickets | ' + ''.join(AdultTicketPrice) + ' '
page.activities_tab_link.click()
time.sleep(5)
assert page.activities_tab_title.get_attribute(
'innerText') == ActivityName
assert page.activities_tickets.get_attribute(
'innerText'
) == AdultTickets + ' tickets | ' + ''.join(AdultTicketPrice)
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 TOP 1 * FROM customer ORDER BY customer_id DESC")
row = cursor.fetchone()
CustomerID = row[0]
assert row[1] == 68 #company ID
assert row[2] == NewFirstName
assert row[3] == NewLastName
assert row[4] == None #customer_address_1
assert row[5] == None #customer_address_2
assert row[6] == None #customer_city
assert row[7] == None #customer_state
assert row[8] == None #customer_zipcode
assert row[9] == None #customer_country
assert row[10] == NewPhone #customer_phone_1
assert row[11] == None #customer_phone_2
assert row[12] == None
assert row[17] == NewPhone #CustomerKey
page = NavigationBar()
time.sleep(2)
page.main_actions_drop_down.click()
time.sleep(2)
page.add_a_booking.click() # STEP15
page = AdminBookingPage()
select = Select(page.activity_list)
select.select_by_visible_text(ActivityName2) # STEP16
page.first_tickets_type.send_keys(AdultTickets) # STEP17
time.sleep(5)
page.datepicker_next_month.click()
time.sleep(5)
EventDate2 = str(int(EventDate) + 1) # STEP18
for i in range(0, len(page.dates)):
if page.dates[i].get_attribute("textContent") == EventDate2:
page.dates[i].click()
else:
continue
break
time.sleep(5)
EventTimeHours2 = str(random.randint(2, 11))
minutes_values = ('00', '15', '30', '45')
EventTimeMinutes2 = random.choice(minutes_values)
timeday2 = random.choice(('AM', 'PM'))
EventTimeWithZone2 = (EventTimeHours2 + ':' +
''.join(EventTimeMinutes2) + ' ' +
''.join(timeday2) + ' ' +
''.join(ActivityTimezone2))
NextMonthName = (datetime.now() +
relativedelta(months=1)).strftime("%B")
NewFullDate2 = (NextMonthName + ' ' + ''.join(str(EventDate2)))
select = Select(page.time)
select.select_by_visible_text(EventTimeWithZone2) # STEP19
time.sleep(5)
page.enter_customer_information_button.click() # STEP20
page.first_name.send_keys(NewFirstName) # STEP21
page.last_name.send_keys(NewLastName)
page.phone_number.send_keys(NewPhone)
NewEmail = (''.join(choice(digits)
for i in range(15)) + '@mailinator.com')
page.email_address.send_keys(NewEmail)
page.complete_booking_button.click()
time.sleep(7)
select = Select(page.payment_type_list)
PaymentType = "Credit Card" # STEP22
select.select_by_visible_text(PaymentType)
select = Select(page.credit_card_list)
time.sleep(5)
select.select_by_visible_text('New Card')
time.sleep(5)
get_driver().switch_to.frame(page.stripe)
page.card_number_input.send_keys(CC_Number)
page.card_date_input.send_keys(ExpDate)
page.card_cvc_input.send_keys(CVC)
page.card_zip_input.send_keys(CCZip)
get_driver().switch_to.default_content()
page.submit_booking_button.click()
time.sleep(5)
page = EventCalendarPage() # STEP24
page.open()
time.sleep(2)
select = Select(page.activity_name)
select.select_by_visible_text(ActivityName2)
page.date_picker.click()
time.sleep(2)
page.date_picker_next.click()
for i in range(0, len(page.days_date_picker)):
if page.days_date_picker[i].get_attribute("textContent") == str(
EventDate2):
page.days_date_picker[i].click()
else:
continue
break
page.day_button.click()
time.sleep(6)
EventTime2 = (EventTimeHours2 + ':' + ''.join(EventTimeMinutes2) +
' ' + ''.join(timeday2))
assert str(NewFullDate2) in page.date_header.get_attribute(
"textContent")
for ticket in page.day_slots: # STEP25
for i in range(0, len(page.day_slots)):
if EventTime2 in ticket.day_slot_time[i].get_attribute(
'textContent'):
page.day_slots[i].click()
else:
continue
break
time.sleep(6)
assert page.customer_name_link.get_attribute(
'textContent') == NewFullName
assert page.phone_link.get_attribute('pathname') == NewPhone
assert page.email_link.get_attribute('textContent') == NewEmail
page.close_button.click()
select = Select(page.activity_name) # STEP26
select.select_by_visible_text(ActivityName)
page.date_picker.click()
time.sleep(2)
for i in range(0, len(page.days_date_picker)):
if page.days_date_picker[i].get_attribute("textContent") == str(
EventDate):
page.days_date_picker[i].click()
else:
continue
break
page.day_button.click()
time.sleep(6)
EventTime = (EventTimeHours + ':' + ''.join(EventTimeMinutes) + ' ' +
''.join(timeday))
assert str(NewFullDate) in page.date_header.get_attribute(
"textContent")
for ticket in page.day_slots:
for i in range(0, len(page.day_slots)):
if EventTime in ticket.day_slot_time[i].get_attribute(
'textContent'):
page.day_slots[i].click()
else:
continue
break
time.sleep(6)
assert page.customer_name_link.get_attribute(
'textContent') == NewFullName
assert page.phone_link.get_attribute('pathname') == NewPhone
page.customer_name_link.click() # STEP27
page = CustomerListPage()
assert page.customer_name_info.get_attribute(
'textContent') == NewFullName + "'s"
assert page.phone_info.get_attribute('innerText') == NewPhone
assert page.email_info.get_attribute('innerText') == NewEmail
assert page.zip_info.get_attribute('innerText') == 'Not Saved'
assert page.state_info.get_attribute('innerText') == 'Not Saved'
assert page.address_info.get_attribute('innerText') == 'Not Saved'
assert page.timeline_email_title.get_attribute(
'textContent'
) == 'Purchased Tickets for the ' + ''.join(ActivityName2)
assert EventTimeWithZone2 and NewFullDate2 in page.timeline_event.get_attribute(
'textContent')
assert page.timeline_tickets.get_attribute(
'textContent'
) == AdultTickets + ' Tickets | ' + ''.join(AdultTicketPrice2) + ' '
page.activities_tab_link.click()
time.sleep(5)
assert page.activities_tab_title.get_attribute(
'innerText') == ActivityName2
assert page.activities_tickets.get_attribute(
'innerText'
) == AdultTickets + ' tickets | ' + ''.join(AdultTicketPrice2)
page = CustomerListPage() # STEP29
page.open()
page.search_field.send_keys(NewPhone)
page.search_button.click()
time.sleep(2)
assert page.customer_name_in_list.get_attribute(
'textContent') == NewFullName
assert page.phone_in_list.get_attribute('textContent') == NewPhone
assert page.activity_name_in_list.get_attribute(
'textContent') == ActivityName2
assert page.is_element_present('customer_name_in_list2') == False
cursor.execute(
"SELECT TOP 1 * FROM customer ORDER BY customer_id DESC") #STEP30
row = cursor.fetchone()
assert row[0] == CustomerID
assert row[1] == 68 # company ID
assert row[2] == NewFirstName
assert row[3] == NewLastName
assert row[4] == None #customer_address_1
assert row[5] == None #customer_address_2
assert row[6] == None #customer_city
assert row[7] == None #customer_state
assert row[8] == None #customer_zipcode
assert row[9] == None #customer_country
assert row[10] == NewPhone #customer_phone_1
assert row[11] == None #customer_phone_2
assert row[12] == NewEmail
assert row[17] == NewEmail #CustomerKey
def test_880(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 = NavigationBar()
time.sleep(2)
page.main_actions_drop_down.click()
time.sleep(2)
page.add_a_booking.click() #STEP1
page = AdminBookingPage()
select = Select(page.activity_list)
select.select_by_visible_text(ActivityName) #STEP2
page.first_tickets_type.send_keys(AdultTickets) #STEP3
time.sleep(5)
page.datepicker_next_month.click()
time.sleep(5)
EventDate = str(random.randint(2, 28)) #STEP4
for i in range(0, len(page.dates)):
if page.dates[i].get_attribute("textContent") == EventDate:
page.dates[i].click()
else:
continue
break
time.sleep(5)
EventTimeHours = str(random.randint(2, 11))
minutes_values = ('00', '15', '30', '45')
EventTimeMinutes = random.choice(minutes_values)
timeday = random.choice(('AM', 'PM'))
EventTimeWithZone = (EventTimeHours + ':' + ''.join(EventTimeMinutes) +
' ' + ''.join(timeday) + ' ' +
''.join(ActivityTimezone))
nextMonthDate = (datetime.now() +
relativedelta(months=1)).strftime('%#m')
NextMonthName = (datetime.now() +
relativedelta(months=1)).strftime("%B")
NewFullDate = (NextMonthName + ' ' + ''.join(str(EventDate)))
select = Select(page.time)
select.select_by_visible_text(EventTimeWithZone) #STEP5
time.sleep(5)
page.enter_customer_information_button.click() #STEP6
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.send_keys(NewFirstName) #STEP7
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.send_keys(NewLastName)
page.complete_booking_button.click()
time.sleep(7)
select = Select(page.payment_type_list)
PaymentType = "Cash" #STEP8
select.select_by_visible_text(PaymentType)
page.cash_recieved.click()
page.submit_booking_button.click()
time.sleep(5)
page = EventCalendarPage() #STEP10
page.open()
time.sleep(2)
select = Select(page.activity_name)
select.select_by_visible_text(ActivityName)
page.date_picker.click()
time.sleep(2)
page.date_picker_next.click()
for i in range(0, len(page.days_date_picker)):
if page.days_date_picker[i].get_attribute("textContent") == str(
EventDate):
page.days_date_picker[i].click()
else:
continue
break
page.day_button.click()
time.sleep(6)
EventTime = (EventTimeHours + ':' + ''.join(EventTimeMinutes) + ' ' +
''.join(timeday))
assert str(NewFullDate) in page.date_header.get_attribute(
"textContent")
for ticket in page.day_slots: #STEP11
for i in range(0, len(page.day_slots)):
if EventTime in ticket.day_slot_time[i].get_attribute(
'textContent'):
page.day_slots[i].click()
else:
continue
break
time.sleep(6)
assert page.customer_name_link.get_attribute(
'textContent') == NewFullName
page.customer_name_link.click() # STEP12
page = CustomerListPage()
assert page.customer_name_info.get_attribute(
'textContent') == NewFullName + "'s"
#assert page.phone_info.get_attribute('innerText')=='Not Saved' #BUG 2954
assert page.email_info.get_attribute('innerText') == 'Not Saved'
assert page.zip_info.get_attribute('innerText') == 'Not Saved'
assert page.state_info.get_attribute('innerText') == 'Not Saved'
assert page.address_info.get_attribute('innerText') == 'Not Saved'
assert page.timeline_tickets_title.get_attribute(
'textContent'
) == 'Purchased Tickets for the ' + ''.join(ActivityName)
assert EventTimeWithZone and NewFullDate in page.timeline_event.get_attribute(
'textContent')
assert page.timeline_tickets.get_attribute(
'textContent'
) == AdultTickets + ' Tickets | ' + ''.join(AdultTicketPrice) + ' '
page.activities_tab_link.click()
time.sleep(5)
assert page.activities_tab_title.get_attribute(
'innerText') == ActivityName
assert page.activities_tickets.get_attribute(
'innerText'
) == AdultTickets + ' tickets | ' + ''.join(AdultTicketPrice)
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 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[17] == None #CustomerKey
def test_242(self):
get_driver().maximize_window()
page = loginpage()
page.open()
page.login_field.send_keys(username_list[0]) #STEP1
page.password_field.send_keys(pwd_list[0])
page.button.click()
time.sleep(5)
page = EmployeePage() # STEP2
page.open()
time.sleep(2)
assert page.is_element_present('add_new_user') == True
page = NoPermission()
assert page.is_element_present('no_permission_alert') == False
page = ActivityHubPage() #STEP3
page.open()
time.sleep(2)
assert page.is_element_present('add_activity_button') == True
page = NoPermission()
assert page.is_element_present('no_permission_alert') == False
page = NavigationBar() #STEP 4
page.open()
time.sleep(2)
page = NoPermission()
assert page.is_element_present('no_permission_alert') == False
page = ChannelPage() #STEP 5
page.open()
time.sleep(2)
page = NoPermission()
assert page.is_element_present('no_permission_alert') == False
page = WaiverAddPage() #STEP 6
page.open()
time.sleep(2)
page = NoPermission()
assert page.is_element_present('no_permission_alert') == False
page = DiscountPage() #STEP 7
page.open()
time.sleep(2)
page = NoPermission()
assert page.is_element_present('no_permission_alert') == False
page = GrouponPage() #STEP 8
page.open()
time.sleep(2)
page = NoPermission()
assert page.is_element_present('no_permission_alert') == False
page = CertificatePage() #STEP 9
page.open()
time.sleep(2)
assert page.is_element_present('add_new_certificate_button') == True
page = NoPermission()
assert page.is_element_present('no_permission_alert') == False
page = InvoicePageV2() #STEP 10
page.open()
time.sleep(2)
page = NoPermission()
assert page.is_element_present('no_permission_alert') == False
page = PeopleHubPage() #STEP 11
page.open()
time.sleep(2)
assert page.is_element_present('add_guide_button') == True
page = NoPermission()
assert page.is_element_present('no_permission_alert') == False
page = GuidePayrollPage() # STEP 12
page.open()
time.sleep(2)
assert page.is_element_present('guide_list') == True
page = NoPermission()
assert page.is_element_present('no_permission_alert') == False
page = ChannelPayrollPage() #STEP 13
page.open()
time.sleep(2)
assert page.is_element_present('channel_payment_due') == True
page = NoPermission()
assert page.is_element_present('no_permission_alert') == False
page = EventCalendarPage() #STEP 14
page.open()
time.sleep(2)
assert page.is_element_present('date_picker') == True
page = NoPermission()
assert page.is_element_present('no_permission_alert') == False
page = GuideBulAssignmentPage() #STEP 15
page.open()
time.sleep(2)
page = NoPermission()
assert page.is_element_present('no_permission_alert') == False
page = AddStartingLocationPage() #STEP 16
page.open()
assert page.is_element_present('location_name') == True
page = NoPermission()
assert page.is_element_present('no_permission_alert') == False
page = TaxesReportPage() #STEP 17
page.open()
time.sleep(2)
page = NoPermission()
assert page.is_element_present('no_permission_alert') == False
page = AnalyticsDashboardPage() #STEP 18
page.open()
time.sleep(2)
page = NoPermission()
assert page.is_element_present('no_permission_alert') == False
page = EditCompanyPage() #STEP 19
page.open()
assert page.is_element_present('company_name_field') == True
page = NoPermission()
assert page.is_element_present('no_permission_alert') == False
page = SelfProfilePage() #STEP 20
page.open()
assert page.is_element_present('first_name_field') == True
page = NoPermission()
assert page.is_element_present('no_permission_alert') == False
page = CustomerListPage() #STEP 21
page.open()
assert page.is_element_present('add_customer_button') == True
page = NoPermission()
assert page.is_element_present('no_permission_alert') == False
def test_102(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)
NewPhone = (''.join(choice(digits) for i in range(15)))
page.phone_field.send_keys(NewPhone)
NewEmail = (''.join(choice(digits)
for i in range(15)) + '@mailinator.com')
page.email_field.send_keys(NewEmail)
streets = ('Main Str.', '1St Av.', 'Independence Str', '2nd Str',
'Broadway', 'Bowery', 'Broun', 'Houston Street',
'Maiden Lane', 'Avenue of the Americas')
NewAddress1 = random.choice(streets)
page.address1_field.send_keys(NewAddress1)
NewAddress2 = (''.join(choice(digits) for i in range(3)))
page.address2_field.send_keys(NewAddress2)
cities = ('New York', 'Los Angeles', 'Chicago', 'Phoenix', 'San Jose',
'Austin', 'Columbus', 'Charlotte')
NewCity = random.choice(cities)
page.city_field.send_keys(NewCity)
NewZip = (''.join(choice(digits) for i in range(5)))
page.customer_zip.send_keys(NewZip)
select = Select(page.country_list)
NewCountry = 'United States'
select.select_by_visible_text(NewCountry)
time.sleep(3)
select = Select(page.state_list)
NewState = 'Florida'
select.select_by_visible_text(NewState)
time.sleep(5)
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
assert page.phone_in_list.get_attribute('textContent') == NewPhone
page.edit_button.click()
assert page.customer_name_info.get_attribute(
'textContent') == NewFullName + "'s"
assert page.phone_info.get_attribute('innerText') == NewPhone
assert page.email_info.get_attribute('innerText') == NewEmail
assert page.zip_info.get_attribute('innerText') == NewZip
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[4] == NewAddress1
assert row[5] == NewAddress2
assert row[6] == NewCity
assert row[8] == NewZip
assert row[10] == NewPhone
assert row[12] == NewEmail
assert row[17] == NewEmail #CustomerKey
assert page.state_info.get_attribute(
'innerText') == NewState #BUG 2827
assert page.address_info == NewAddress1 + ' ' + NewAddress2 #BUG 2827
assert row[9] == 'USA' #BUG 2827
assert row[7] == NewState #BUG 2827
def test_102(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 = ('Ivan2321', 'Peter323', 'John4234', 'Bill234',
'Michael1234', 'Sidor1235', 'Alex6546', 'James656',
'Bob3423', 'Ivan1455', 'Tim324', 'Chris324', 'Jim123',
'Pahom545', 'Vlad2344', 'Paul141')
NewFirstName = random.choice(first_names)
page.first_name_field.send_keys(NewFirstName)
last_names = ('Smith-343', 'Baker-3432', 'Petroff-3423',
'Smirnoff-1313', 'Black-32423', 'White-4324',
'Broun-32423', 'Ivanoff-32423', 'Green-1231',
'Clinton-213123', 'Jameson-12312', 'Last-12312',
'Sergeff-12312', 'Madison-3123')
NewLastName = random.choice(last_names)
NewFullName = NewFirstName + ' ' + ''.join(NewLastName)
page.last_name_field.send_keys(NewLastName)
NewPhone = (''.join(choice(digits) for i in range(15)))
page.phone_field.send_keys(NewPhone)
NewEmail = (''.join(choice(digits)
for i in range(15)) + '@mailinator.com')
page.email_field.send_keys(NewEmail)
streets = ('Main Str.', '1St Av.', 'Independence Str', '2nd Str',
'Broadway', 'Bowery', 'Broun', 'Houston Street',
'Maiden Lane', 'Avenue of the Americas')
NewAddress1 = random.choice(streets)
page.address1_field.send_keys(NewAddress1)
NewAddress2 = (''.join(choice(digits) for i in range(3)))
page.address2_field.send_keys(NewAddress2)
cities = ('New York', 'Los Angeles', 'Chicago', 'Phoenix', 'San Jose',
'Austin', 'Columbus', 'Charlotte')
NewCity = random.choice(cities)
page.city_field.send_keys(NewCity)
NewZip = (''.join(choice(digits) for i in range(5)))
page.customer_zip.send_keys(NewZip)
select = Select(page.country_list)
NewCountry = 'United States'
select.select_by_visible_text(NewCountry)
time.sleep(3)
select = Select(page.state_list)
NewState = 'Florida'
select.select_by_visible_text(NewState)
time.sleep(5)
page.cancel_button.click()
time.sleep(5)
page.search_field.send_keys(NewFullName)
page.search_button.click()
time.sleep(5)
assert page.no_matches_list.get_attribute(
'textContent') == '0 Customers matched your search'
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[2] != NewFirstName
assert row[3] != NewLastName
assert row[10] != NewPhone
assert row[12] != NewEmail
assert row[17] != NewEmail #CustomerKey
