class TestCase02UserManageAddUserException1(unittest.TestCase):
# 测试用户管理新增用户功能异常情况
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.user_center = UserCenter(self.driver, self.base_url)
self.user_management = UserManagement(self.driver, self.base_url)
self.log_in_page_read_csv = LogInPageReadCsv()
self.user_center_read_csv = UserCenterReadCsv()
self.user_management_read_csv = UserManagementReadCsv()
self.driver.set_window_max()
self.connect_sql = ConnectSql()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
# 打开风控首页-登录页
self.base_page.open_page()
sleep(1)
# 登录账号
self.login_page.test_user_login()
def tearDown(self):
self.driver.quit_browser()
def test_add_user_exception1(self):
# 通过csv测试新增用户功能异常情况
# 获取当前登录账户
log_in_account = self.user_center.get_login_account()
print(log_in_account)
csv_file = self.user_management_read_csv.read_csv('add_user_exception1.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
add_user_exception = {
"add_user_name": row[0],
"add_login_user": row[1],
"add_login_passwd": row[2],
"add_user_phone": row[3],
"add_user_role":row[4],
"exception_text": row[5],
}
# 点击进入用户管理
self.user_management.click_user_manage()
# 点击新增用户
self.user_management.click_add_user()
# 切入内层frame
self.user_management.switch_to_2_frame()
# 输入新增用户名
self.user_management.input_add_user_name(add_user_exception['add_user_name'])
# 输入登陆账号
self.user_management.input_add_login_user(add_user_exception['add_login_user'])
# 输入登录密码
self.user_management.input_add_login_passwd(add_user_exception['add_login_passwd'])
# 输入手机号码
self.user_management.input_add_user_phone(add_user_exception['add_user_phone'])
# 判断分配用户角色
if add_user_exception['add_user_role'] == '1':
self.user_management.input_add_user_role()
# 选择所属公司部门
self.user_management.choose_add_user_org()
# 点击保存按钮
self.user_management.click_add_user_save()
# 获取异常提示
text = self.user_management.get_add_user_exception1()
self.assertEqual(add_user_exception['exception_text'], text)
# 关闭新增用户框
self.user_management.click_add_user_close()
# 跳出最外层frame
self.user_management.switch_to_default_content()
# 从数据库查询验证新增失败
new_user_name = self.user_management.get_add_user_by_sql(log_in_account)
self.assertNotEqual(new_user_name, add_user_exception['add_user_name'])
self.driver.wait(1)
csv_file.close()
# 退出登录
self.user_center.logout()
class TestCase01LoanCustomerInput(unittest.TestCase):
# 贷款客户信息录入
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.user_center = UserCenter(self.driver, self.base_url)
self.loan_customer = LoanCustomer(self.driver, self.base_url)
self.log_in_page_read_csv = LogInPageReadCsv()
self.user_center_read_csv = UserCenterReadCsv()
self.loan_customer_read_csv = LoanCustomerReadCsv()
self.driver.set_window_max()
self.connect_sql = ConnectSql()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_user_center_modify_info(self):
# 通过csv测试贷款客户信息录入
csv_file = self.loan_customer_read_csv.read_csv('loan_customer_input_info.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
loan_customer_input_info = {
"name": row[0],
"tel": row[1],
"type": row[2],
"ID": row[3],
"sex": row[4],
"com": row[5],
"car_num": row[6],
"model": row[7],
"engi_num": row[8],
"frame_num": row[9],
"car_type": row[10],
"loan_money": row[11],
"loan_deadline": row[12],
"current_balance": row[13],
"pay_type": row[14],
"pay_date": row[15],
"contract_number": row[16],
"imei": row[17],
"install_address": row[18],
"install_person": row[19],
}
# 打开风控首页-登录页
self.base_page.open_page()
sleep(1)
# 登录账号
self.login_page.test_user_login()
# 获取当前登录账号
log_in_account = self.user_center.get_login_account()
print(log_in_account)
# 从数据库获取登录账号的客户名称、电话
account_info = self.user_center.get_account_info_by_sql(log_in_account)
print(account_info)
# 获取修改资料里面的信息
user_info = self.user_center.get_user_info()
# 断言
self.assertEqual(log_in_account, user_info['login_account'])
self.assertEqual(account_info[1], user_info['name'])
self.assertEqual(account_info[2], user_info['tel'])
# 点击进入贷款客户录入
self.loan_customer.click_loan_customer_input()
# 切入外层frame
self.loan_customer.switch_to_1_frame()
# 录入车主信息
# 录入车主姓名
self.loan_customer.input_owner_name(loan_customer_input_info['name'])
# 录入车主电话
self.loan_customer.input_owner_tel(loan_customer_input_info['tel'])
# 选择车主证件类型
self.loan_customer.choose_owner_ID_type(loan_customer_input_info['type'])
# 输入车主证件号
self.loan_customer.input_owner_ID(loan_customer_input_info['ID'])
# 选择车主性别
self.loan_customer.choose_owner_sex(loan_customer_input_info['sex'])
# 选择车主贷款单位
self.loan_customer.choose_owner_loan_com(loan_customer_input_info['com'])
# 保存
self.loan_customer.save_owner_info()
# 验证是否保存成功
# 录入车辆信息
# 输入车牌号
self.loan_customer.input_car_num(loan_customer_input_info['car_num'])
# 输入车型
self.loan_customer.input_car_model(loan_customer_input_info['model'])
# 输入发动机号
self.loan_customer.input_car_engi_num(loan_customer_input_info['engi_num'])
# 输入车架号
self.loan_customer.input_car_frame_num(loan_customer_input_info['frame_num'])
# 选择车辆类型
self.loan_customer.choose_car_type(loan_customer_input_info['car_type'])
# 保存车辆信息
self.loan_customer.save_car_info()
# 验证是否保存成功
# 录入贷款信息
# 输入贷款日期
self.loan_customer.input_loan_date()
# 输入贷款金额
self.loan_customer.input_loan_money(loan_customer_input_info['loan_money'])
# 输入贷款期限
self.loan_customer.input_loan_deadline(loan_customer_input_info['loan_deadline'])
# 输入应还金额
self.loan_customer.input_current_balance(loan_customer_input_info['current_balance'])
# 选择还款方式
self.loan_customer.choose_pay_type(loan_customer_input_info['pay_type'])
# 选择还款日
self.loan_customer.choose_pay_date(loan_customer_input_info['pay_date'])
# 输入合同编号
self.loan_customer.input_contract_number(loan_customer_input_info['contract_number'])
# 保存贷款信息
self.loan_customer.save_loan_info()
# 验证是否保存成功
# 录入安装设备
# 点击安装设备
self.loan_customer.click_install_dev()
# 输入Imei
self.loan_customer.input_dev_imei(loan_customer_input_info['imei'])
# 选择安装时间
self.loan_customer.choose_install_time()
# 输入安装地址
self.loan_customer.input_install_address(loan_customer_input_info['install_address'])
# 输入安装人员
self.loan_customer.input_install_person(loan_customer_input_info['install_person'])
# 保存安装信息
self.loan_customer.save_install_info()
# 跳出frame1
self.loan_customer.switch_out_frame1()
# 验证是否保存成功
# 退出登录
self.user_center.logout()
csv_file.close()
class TestCase04AccountLog(unittest.TestCase):
# 账号管理记录
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.user_center = UserCenter(self.driver, self.base_url)
self.operation_log = OperationLog(self.driver, self.base_url)
self.log_in_page_read_csv = LogInPageReadCsv()
self.user_center_read_csv = UserCenterReadCsv()
self.operation_log_read_csv = OperationLogReadCsv()
self.driver.set_window_max()
self.connect_sql = ConnectSql()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_account_log(self):
# 测试账号管理记录
# 打开风控首页-登录页
self.base_page.open_page()
sleep(1)
# 登录账号
self.login_page.test_log_login_user_normal()
# 获取当前登录账号
log_in_account = self.user_center.get_login_account()
print(log_in_account)
# 从数据库获取登录账号的客户名称、电话
account_info = self.user_center.get_account_info_by_sql(log_in_account)
print(account_info)
# 获取修改资料里面的信息
user_info = self.user_center.get_user_info()
# 断言
self.assertEqual(log_in_account, user_info['login_account'])
self.assertEqual(account_info[1], user_info['name'])
self.assertEqual(account_info[2], user_info['tel'])
# 点击设置
self.operation_log.click_setup()
# 点击进入操作日志
self.operation_log.click_operation_log()
# 切入frame
self.operation_log.switch_to_myframe()
# 点击账号管理记录
self.operation_log.click_account_log()
csv_file = self.operation_log_read_csv.read_csv('account_log.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
account_log = {
"start_time": row[0],
"end_time": row[1],
"type": row[2],
}
# 输入时间段
self.operation_log.account_input_time(account_log['start_time'],
account_log['end_time'])
# 选择类型
self.operation_log.account_choose_type(account_log['type'])
# 点击搜索
self.operation_log.account_click_search()
'''# 获取搜索结果
result_info = self.operation_log.get_account_log_search_result()
print(result_info)
# 获取数据库查询结果
info = self.operation_log.get_account_log_search_result_by_sql(log_in_account,account_log['start_time'],account_log['end_time'])
# 验证搜索结果是否一致
self.assertEqual(result_info,info)'''
# 点击重置
self.operation_log.account_click_reset()
# 跳出frame
self.operation_log.switch_default()
# 退出登录
self.user_center.logout()
class TestCase03OrgManageAddOrgException2(unittest.TestCase):
# 测试部门管理新增公司部门功能异常情况-部门名称已存在
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.user_center = UserCenter(self.driver, self.base_url)
self.organize_management = OrganizeManagement(self.driver,
self.base_url)
self.log_in_page_read_csv = LogInPageReadCsv()
self.user_center_read_csv = UserCenterReadCsv()
self.organize_management_read_csv = OrganizeManagementReadCsv()
self.driver.set_window_max()
self.connect_sql = ConnectSql()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
# 打开风控首页-登录页
self.base_page.open_page()
sleep(1)
# 登录账号
self.login_page.test_user_login()
def tearDown(self):
self.driver.quit_browser()
def test_add_org_exception2(self):
# 通过csv测试新增公司部门功能异常情况-部门名称已存在
# 获取当前登录账户
log_in_account = self.user_center.get_login_account()
print(log_in_account)
csv_file = self.user_center_read_csv.read_csv(
'add_org_info_exception2.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
add_org_info_exception = {
"add_org_name": row[0],
"add_org_tel": row[1],
"exception_text": row[2],
}
# 点击进入部门管理
self.organize_management.click_org_manage()
# 点击新增公司部门
self.organize_management.click_add_org()
# 验证上级部门是否显示正确
sup_org_name = self.organize_management.get_sup_org_name()
# 数据库查询当前登录账户的上级部门
sup_org_name_by_aql = self.organize_management.get_user_sup_org_by_sql(
log_in_account)
self.assertEqual(sup_org_name, sup_org_name_by_aql)
# 选择上级部门
self.organize_management.choose_sup_org()
# 填写新增部门名称
self.organize_management.input_add_org_name(
add_org_info_exception['add_org_name'])
# 填写联系方式
self.organize_management.input_add_org_tel(
add_org_info_exception['add_org_tel'])
# 点击保存按钮
self.organize_management.click_add_org_save()
# 跳出最外层frame
self.organize_management.switch_to_default_content()
# 获取名称重复异常提示
text = self.organize_management.get_add_org_exception2()
self.assertEqual(add_org_info_exception['exception_text'], text)
# 切入外层frame
self.organize_management.switch_to_1_frame()
# 切入内层frame
self.organize_management.switch_to_2_frame()
# 关闭新增公司部门框
self.organize_management.click_add_org_close()
# 跳出最外层frame
self.organize_management.switch_to_default_content()
# 从数据库查询验证新增失败
new_org_name = self.organize_management.get_add_org_by_sql(
log_in_account)
self.assertNotEqual(new_org_name,
add_org_info_exception['add_org_name'])
self.driver.wait(1)
csv_file.close()
# 退出登录
self.user_center.logout()
class TestCase02LoanReport(unittest.TestCase):
# 逾期还款统计
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.user_center = UserCenter(self.driver, self.base_url)
self.statistics_report = StatisticsReport(self.driver, self.base_url)
self.log_in_page_read_csv = LogInPageReadCsv()
self.user_center_read_csv = UserCenterReadCsv()
self.statistics_report_read_csv = StatisticsReportReadCsv()
self.driver.set_window_max()
self.connect_sql = ConnectSql()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_loan_report(self):
# 测试逾期还款统计
# 打开风控首页-登录页
self.base_page.open_page()
sleep(1)
# 登录账号
self.login_page.test_statistics_login_user_normal()
# 获取当前登录账号
log_in_account = self.user_center.get_login_account()
print(log_in_account)
# 从数据库获取登录账号的客户名称、电话
account_info = self.user_center.get_account_info_by_sql(log_in_account)
print(account_info)
# 获取修改资料里面的信息
user_info = self.user_center.get_user_info()
# 断言
self.assertEqual(log_in_account, user_info['login_account'])
self.assertEqual(account_info[1], user_info['name'])
self.assertEqual(account_info[2], user_info['tel'])
# 点击统计报表
self.statistics_report.click_statistics_report()
# 点击进入逾期还款报表
self.statistics_report.click_loan()
# 切入frame
self.statistics_report.switch_to_myframe()
csv_file = self.statistics_report_read_csv.read_csv('loan_info.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
loan_info = {
"times": row[0],
}
# 勾选包含下级车主
self.statistics_report.click_contain_lower()
# 选择逾期次数
self.statistics_report.choose_loan_times(loan_info['times'])
# 点击搜索
self.statistics_report.click_loan_search()
# 获取搜索结果
result_info = self.statistics_report.get_loan_search_result()
print(result_info)
# 获取数据库查询结果
info = self.statistics_report.get_loan_search_result_by_sql(
log_in_account)
print(info)
# 验证搜索结果是否一致
self.assertEqual(result_info, info)
# 跳出frame
self.statistics_report.switch_default()
# 退出登录
self.user_center.logout()
class TestCase05OrgManageEditOrgException(unittest.TestCase):
# 测试部门管理修改公司部门异常情况
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.user_center = UserCenter(self.driver, self.base_url)
self.organize_management = OrganizeManagement(self.driver, self.base_url)
self.log_in_page_read_csv = LogInPageReadCsv()
self.user_center_read_csv = UserCenterReadCsv()
self.organize_management_read_csv = OrganizeManagementReadCsv()
self.driver.set_window_max()
self.connect_sql = ConnectSql()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_edit_org_exception(self):
# 通过csv测试修改公司部门功能异常情况
# 打开风控首页-登录页
self.base_page.open_page()
sleep(1)
# 登录账号
self.login_page.test_user_login()
# 获取当前登录账户
log_in_account = self.user_center.get_login_account()
print(log_in_account)
# 点击进入部门管理
self.organize_management.click_org_manage()
# 查找test00000部门
search_key = '00000'
self.organize_management.search_org(search_key)
# 获取页面查找结果
search_org_name_01 = self.organize_management.get_search_result_one()
# 查询数据库获取搜索结果
org_info_00 = self.organize_management.get_search_result_by_sql(log_in_account,
search_key)
org_name_00 = org_info_00[0]
sup_org_name_00 = org_info_00[1]
org_tel_00 = org_info_00[2]
self.assertEqual(search_org_name_01, org_name_00)
csv_file = self.user_center_read_csv.read_csv('edit_org_info_exception.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
edit_org_info_exception = {
"edit_org_name": row[0],
"edit_org_tel": row[1],
"exception_text": row[2],
}
# 点击修改
self.organize_management.click_edit_org()
# 切入内层frame
self.organize_management.switch_to_2_frame()
# 获取当前显示的部门名称是否与未修改前一致
current_org_name_01 = self.organize_management.get_current_org_name()
self.assertEqual(search_org_name_01, current_org_name_01)
# 获取显示的所属上级是否与未修改前一致
current_sup_org = self.organize_management.get_current_sup_org_name()
self.assertEqual(sup_org_name_00, current_sup_org)
# 获取显示的联系方式是否与未修改前一致
current_org_tel = self.organize_management.get_current_org_tel()
self.assertEqual(org_tel_00, current_org_tel)
# 修改部门名称
self.organize_management.edit_org_name(edit_org_info_exception['edit_org_name'])
# 修改联系方式
self.organize_management.edit_org_tel(edit_org_info_exception['edit_org_tel'])
# 跳出内层frame
self.organize_management.switch_to_parent_content()
# 修改(保存)
self.organize_management.click_org_modify_button()
# 获取异常提示语
exception_text = self.organize_management.get_edit_org_exception_text()
self.assertEqual(edit_org_info_exception['exception_text'],exception_text)
# 数据库查询是否修改失败
org_info = self.organize_management.get_search_result_by_sql(log_in_account,
search_key)
org_name = org_info[0]
org_tel = org_info[2]
self.assertNotEqual(edit_org_info_exception['edit_org_name'], org_name)
self.assertNotEqual(edit_org_info_exception['edit_org_tel'], org_tel)
# 跳出内层frame
self.organize_management.switch_to_parent_content()
# 关闭
self.organize_management.click_org_modify_close()
csv_file.close()
# 跳出外层frame
self.organize_management.switch_to_default_content()
# 退出登录
self.user_center.logout()
class TestCase06OrgManageViewOrg(unittest.TestCase):
# 测试部门管理查看公司部门
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.user_center = UserCenter(self.driver, self.base_url)
self.organize_management = OrganizeManagement(self.driver,
self.base_url)
self.log_in_page_read_csv = LogInPageReadCsv()
self.user_center_read_csv = UserCenterReadCsv()
self.organize_management_read_csv = OrganizeManagementReadCsv()
self.driver.set_window_max()
self.connect_sql = ConnectSql()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_view_org(self):
# 通过csv测试查看公司部门功能
# 打开风控首页-登录页
self.base_page.open_page()
sleep(1)
# 登录账号
self.login_page.test_user_login()
# 获取当前登录账户
log_in_account = self.user_center.get_login_account()
print(log_in_account)
# 点击进入部门管理
self.organize_management.click_org_manage()
csv_file = self.user_center_read_csv.read_csv('view_org_info.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
view_org_info = {
"view_org_name": row[0],
"view_org_tel": row[1],
}
# 点击查看公司部门
self.organize_management.click_view_org()
# 切入内层frame
self.organize_management.switch_to_2_frame()
# 验证所属上级是否显示正确
sup_org_name = self.organize_management.get_current_sup_org_name()
# 数据库查询当前登录账户的上级部门
sup_org_name_by_aql = self.organize_management.get_belong_to_superior_org_by_sql(
log_in_account)
self.assertEqual(sup_org_name, sup_org_name_by_aql)
# 编辑公司/部门名称
self.organize_management.edit_org_name(
view_org_info['view_org_name'])
# 编辑联系方式
self.organize_management.edit_org_tel(
view_org_info['view_org_tel'])
# 跳出内层frame
self.organize_management.switch_to_parent_content()
# 取消
self.organize_management.click_org_modify_dismiss()
# 从数据库查询验证未修改成功
current_org_info_01 = self.organize_management.get_current_org_info_by_sql(
log_in_account)
edit_org_name_01 = current_org_info_01[0]
edit_org_tel_01 = current_org_info_01[1]
self.assertNotEqual(edit_org_name_01,
view_org_info['view_org_name'])
self.assertNotEqual(edit_org_tel_01, view_org_info['view_org_tel'])
self.driver.wait(1)
# 点击查看公司部门
self.organize_management.click_view_org()
# 切入内层frame
self.organize_management.switch_to_2_frame()
# 验证所属上级是否显示正确
sup_org_name = self.organize_management.get_current_sup_org_name()
# 数据库查询当前登录账户的上级部门
sup_org_name_by_aql = self.organize_management.get_belong_to_superior_org_by_sql(
log_in_account)
self.assertEqual(sup_org_name, sup_org_name_by_aql)
# 编辑公司/部门名称
self.organize_management.edit_org_name(
view_org_info['view_org_name'])
# 编辑联系方式
self.organize_management.edit_org_tel(
view_org_info['view_org_tel'])
# 跳出内层frame
self.organize_management.switch_to_parent_content()
# 关闭
self.organize_management.click_org_modify_close()
# 从数据库查询验证未修改成功
current_org_info_02 = self.organize_management.get_current_org_info_by_sql(
log_in_account)
edit_org_name_02 = current_org_info_02[0]
edit_org_tel_02 = current_org_info_02[1]
self.assertNotEqual(edit_org_name_02,
view_org_info['view_org_name'])
self.assertNotEqual(edit_org_tel_02, view_org_info['view_org_tel'])
self.driver.wait(1)
# 点击查看公司部门
self.organize_management.click_view_org()
# 切入内层frame
self.organize_management.switch_to_2_frame()
# 验证所属上级是否显示正确
sup_org_name = self.organize_management.get_current_sup_org_name()
# 数据库查询当前登录账户的上级部门
sup_org_name_by_aql = self.organize_management.get_belong_to_superior_org_by_sql(
log_in_account)
self.assertEqual(sup_org_name, sup_org_name_by_aql)
# 编辑公司/部门名称
self.organize_management.edit_org_name(
view_org_info['view_org_name'])
# 编辑联系方式
self.organize_management.edit_org_tel(
view_org_info['view_org_tel'])
# 跳出内层frame
self.organize_management.switch_to_parent_content()
# 修改(保存)
self.organize_management.click_org_modify_button()
# 从数据库查询验证修改成功
current_org_info_03 = self.organize_management.get_current_org_info_by_sql(
log_in_account)
edit_org_name_03 = current_org_info_03[0]
edit_org_tel_03 = current_org_info_03[1]
self.assertEqual(edit_org_name_03, view_org_info['view_org_name'])
self.assertEqual(edit_org_tel_03, view_org_info['view_org_tel'])
self.driver.wait(1)
# 跳出外层frame
self.organize_management.switch_to_default_content()
csv_file.close()
# 退出登录
self.user_center.logout()
class TestCase08OrgManageDeleteOrg(unittest.TestCase):
# 测试部门管理删除公司部门
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.user_center = UserCenter(self.driver, self.base_url)
self.organize_management = OrganizeManagement(self.driver,
self.base_url)
self.log_in_page_read_csv = LogInPageReadCsv()
self.user_center_read_csv = UserCenterReadCsv()
self.organize_management_read_csv = OrganizeManagementReadCsv()
self.driver.set_window_max()
self.connect_sql = ConnectSql()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_delete_org(self):
# 通过csv测试删除公司部门功能
# 打开风控首页-登录页
self.base_page.open_page()
sleep(1)
# 登录账号
self.login_page.test_user_login()
# 获取当前登录账户
log_in_account = self.user_center.get_login_account()
print(log_in_account)
# 点击进入部门管理
self.organize_management.click_org_manage()
csv_file = self.user_center_read_csv.read_csv('delete_org.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
delete_org = {
"org_name": row[0],
}
# 按名称查找部门
self.organize_management.search_org(delete_org['org_name'])
# 点击删除
self.organize_management.click_delete_org()
# 跳出frame
self.organize_management.switch_to_default_content()
# 取消
self.organize_management.delete_org_dismiss()
# 切入frame
self.organize_management.switch_to_1_frame()
# 点击删除
self.organize_management.click_delete_org()
# 跳出frame
self.organize_management.switch_to_default_content()
# 关闭
self.organize_management.delete_org_close()
# 切入frame
self.organize_management.switch_to_1_frame()
# 点击删除
self.organize_management.click_delete_org()
# 跳出frame
self.organize_management.switch_to_default_content()
# 确认
self.organize_management.delete_org_accept()
# 数据库查找验证部门是否删除成功
# 数据库查找部门
org_name_after_delete = self.organize_management.get_search_result_orgname_by_sql(
log_in_account, '')
self.assertNotIn(delete_org['org_name'], org_name_after_delete)
# 切入frame
self.organize_management.switch_to_1_frame()
csv_file.close()
# 跳出frame
self.organize_management.switch_to_default_content()
# 退出登录
self.user_center.logout()
class TestCase01UserCenterModifyInfo(unittest.TestCase):
# 测试个人中心修改资料
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.user_center = UserCenter(self.driver, self.base_url)
self.log_in_page_read_csv = LogInPageReadCsv()
self.user_center_read_csv = UserCenterReadCsv()
self.driver.set_window_max()
self.connect_sql = ConnectSql()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_user_center_modify_info(self):
# 通过csv测试修改资料功能
csv_file = self.user_center_read_csv.read_csv(
'user_to_modify_info.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
user_to_modify_info = {
"username": row[0],
"phone": row[1],
}
# 打开风控首页-登录页
self.base_page.open_page()
sleep(1)
# 登录账号
self.login_page.test_user_login()
# 获取当前登录账号
log_in_account = self.user_center.get_login_account()
print(log_in_account)
# 从数据库获取登录账号的客户名称、电话
account_info = self.user_center.get_account_info_by_sql(
log_in_account)
print(account_info)
# 获取修改资料里面的信息
user_info = self.user_center.get_user_info()
# 断言
self.assertEqual(log_in_account, user_info['login_account'])
self.assertEqual(account_info[1], user_info['name'])
self.assertEqual(account_info[2], user_info['tel'])
# 编辑客户名称、电话后点击取消
self.user_center.edit_user_info_not_save(
user_to_modify_info['username'], user_to_modify_info['phone'])
# 从数据库获取登录账号的客户名称、电话
account_info1 = self.user_center.get_account_info_by_sql(
log_in_account)
print(account_info1)
self.assertEqual(account_info, account_info1)
# 获取修改资料里面的信息
user_info1 = self.user_center.get_user_info()
# 断言
self.assertEqual(log_in_account, user_info1['login_account'])
self.assertEqual(account_info1[1], user_info1['name'])
self.assertEqual(account_info1[2], user_info1['tel'])
# 编辑客户名称、电话后点击关闭按钮
self.user_center.edit_user_info_close(
user_to_modify_info['username'], user_to_modify_info['phone'])
# 从数据库获取登录账号的客户名称、电话
account_info2 = self.user_center.get_account_info_by_sql(
log_in_account)
print(account_info2)
self.assertEqual(account_info, account_info2)
# 获取修改资料里面的信息
user_info2 = self.user_center.get_user_info()
# 断言
self.assertEqual(log_in_account, user_info2['login_account'])
self.assertEqual(account_info2[1], user_info2['name'])
self.assertEqual(account_info2[2], user_info2['tel'])
# 编辑客户名称、电话后保存
print(user_to_modify_info['username'],
user_to_modify_info['phone'])
self.user_center.edit_user_info_exception(
user_to_modify_info['username'], user_to_modify_info['phone'])
# 从数据库获取登录账号的客户名称、电话
account_info3 = self.user_center.get_account_info_by_sql(
log_in_account)
print(account_info3)
web_data = [
log_in_account, user_to_modify_info['username'],
user_to_modify_info['phone']
]
self.assertEqual(account_info3, web_data)
# 获取修改资料里面的信息
user_info3 = self.user_center.get_user_info()
# 断言
self.assertEqual(log_in_account, user_info3['login_account'])
self.assertEqual(account_info3[1], user_info3['name'])
self.assertEqual(account_info3[2], user_info3['tel'])
# 退出登录
self.user_center.logout()
csv_file.close()
class TestCase02RoleManageAddRoleException1(unittest.TestCase):
# 测试角色管理新增角色功能异常情况
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.login_page = LoginPage(self.driver, self.base_url)
self.user_center = UserCenter(self.driver, self.base_url)
self.role_management = RoleManagement(self.driver, self.base_url)
self.log_in_page_read_csv = LogInPageReadCsv()
self.user_center_read_csv = UserCenterReadCsv()
self.role_management_read_csv = RoleManagementReadCsv()
self.driver.set_window_max()
self.connect_sql = ConnectSql()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
# 打开风控首页-登录页
self.base_page.open_page()
sleep(1)
# 登录账号
self.login_page.test_user_login()
def tearDown(self):
self.driver.quit_browser()
def test_add_role_exception1(self):
# 通过csv测试新增角色功能异常情况
# 获取当前登录账户
log_in_account = self.user_center.get_login_account()
print(log_in_account)
csv_file = self.role_management_read_csv.read_csv(
'add_role_exception1.csv')
csv_data = csv.reader(csv_file)
for row in csv_data:
add_role_exception = {
"add_role_name": row[0],
"add_role_description": row[1],
"add_role_limit": row[2],
"exception_text": row[3],
}
# 点击进入角色管理
self.role_management.click_role_manage()
# 点击创建角色
self.role_management.click_add_role()
# 切入内层frame
self.role_management.switch_to_2_frame()
# 输入角色名称
self.role_management.input_add_role_name(
add_role_exception['add_role_name'])
# 输入角色描述
self.role_management.input_add_role_description(
add_role_exception['add_role_description'])
# 选择角色权限
self.role_management.choose_add_role_limit(
add_role_exception['add_role_limit'])
# 点击保存按钮
self.role_management.click_add_role_save()
# 获取异常提示
text = self.role_management.get_add_role_exception1()
self.assertEqual(add_role_exception['exception_text'], text)
# 关闭创建角色框
self.role_management.click_add_role_close()
# 跳出最外层frame
self.role_management.switch_to_default_content()
# 从数据库查询验证新增失败
new_role_name = self.role_management.get_add_role_by_sql(
log_in_account)
self.assertNotEqual(new_role_name,
add_role_exception['add_role_name'])
self.driver.wait(1)
csv_file.close()
# 退出登录
self.user_center.logout()