class TestFaceRecognition:
datas = DoExcel('face_info_add').get_data(
dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('人脸信息管理--访客新增功能')
def test_add_face_info(self, data, enter_the_homepage):
enter_the_homepage.goto_face_info_manage().add_face_info(
add_type=data['add_type'],
employee=data['employee'],
name=data['name'],
gender=data['gender'],
telephone_number=data['telephone_number'],
id_card_number=data['id_card_number'],
company=data['company'],
dirpath=data['dirpath'],
smartwatch=data['smartwatch'])
assert '成功' in enter_the_homepage.get_success_save_tip()
datas = DoExcel('face_info_modify').get_data(
dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('人脸信息管理--访客修改功能')
def test_modify_face_info(self, data, enter_the_homepage):
enter_the_homepage.goto_face_info_manage().modify_face_info(
modify_face_info=data['modify_face_info'],
add_type=data['add_type'],
employee=data['employee'],
name=data['name'],
gender=data['gender'],
telephone_number=data['telephone_number'],
id_card_number=data['id_card_number'],
company=data['company'],
dirpath=data['dirpath'],
smartwatch=data['smartwatch'])
assert '成功' in enter_the_homepage.get_success_save_tip()
datas = DoExcel('set_customer_level').get_data(
dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('人脸信息管理--访客等级管理')
def test_set_customer_level(self, data, enter_the_homepage):
enter_the_homepage.goto_face_info_manage().set_customer_level(
customer=data['customer'], level=data['level'])
assert '成功' in enter_the_homepage.get_success_save_tip()
datas = DoExcel('face_info_delete').get_data(
dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('人脸信息管理--删除功能')
def test_delete_face_info(self, data, enter_the_homepage):
enter_the_homepage.goto_face_info_manage().delete_face_info(
delete_face_info=data['delete_face_info'])
time.sleep(0.5)
enter_the_homepage.switch_iframe_to_new_tab()
assert '成功' in enter_the_homepage.get_success_save_tip()
class TestHallGateway:
add_datas = DoExcel('hall_gateway_add').get_data(
dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', add_datas) # 参数化
@allure.title('网络通道管理--新增功能')
def test_add_hall_gateway(
self, data, enter_the_homepage
): # 传入enter_the_homepage，并使用其返回值，返回值为conftest--》enter_the_homepage中的homepage
# 在网络通道新增界面，在各输入框中输入数据
enter_the_homepage.goto_hall_gateway().add_hall_gateway(
name=data['hall_gateway_name'],
ip=data['hall_gateway_ip'],
portAmount=data['hall_gateway_port_amount'],
portStart=data['hall_gateway_port_start'],
remarks=data['remarks'])
# 断言--》界面中新增的网络通道名称是否与输入的名称一致，且‘保存网络通道成功’提示信息是否存在，两者都符合则用例通过，任意一个不符合则用例失败
assert '成功' in enter_the_homepage.get_success_save_tip()
modify_datas = DoExcel('hall_gateway_modify').get_data(
dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', modify_datas)
@allure.title('网络通道管理--修改功能')
def test_modify_hall_gateway(self, data, enter_the_homepage):
enter_the_homepage.goto_hall_gateway().modify_hall_gateway(
modify_hall_gateway=data['modify_hall_gateway'],
name=data['hall_gateway_name'],
ip=data['hall_gateway_ip'],
portAmount=data['hall_gateway_port_amount'],
portStart=data['hall_gateway_port_start'],
remarks=data['remarks'])
assert '成功' in enter_the_homepage.get_success_save_tip()
delete_datas = DoExcel('hall_gateway_delete').get_data(
dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', delete_datas)
@allure.title('网络通道管理--删除功能')
def test_delete_hall_gateway(self, data, enter_the_homepage):
enter_the_homepage.goto_hall_gateway().delete_hall_gateway(
delete_hall_gateway=data['delete_hall_gateway'])
assert '成功' in enter_the_homepage.get_success_delete_tip()
@pytest.mark.parametrize('data', add_datas) # 参数化
@allure.title('网络通道管理--新增已删除的网络通道')
def test_add_hall_gateway_delete(
self, data, enter_the_homepage
): # 传入enter_the_homepage，并使用其返回值，返回值为conftest--》enter_the_homepage中的homepage
# 在网络通道新增界面，在各输入框中输入数据
enter_the_homepage.goto_hall_gateway().add_hall_gateway(
name=data['hall_gateway_name'],
ip=data['hall_gateway_ip'],
portAmount=data['hall_gateway_port_amount'],
portStart=data['hall_gateway_port_start'],
remarks=data['remarks'])
# 断言--》界面中新增的网络通道名称是否与输入的名称一致，且‘保存网络通道成功’提示信息是否存在，两者都符合则用例通过，任意一个不符合则用例失败
assert '成功' in enter_the_homepage.get_success_save_tip()
class TestMediaOrWelcomePlanSend:
add_datas = DoExcel('plan_add').get_data(dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', add_datas)
@allure.title('媒体下发计划--新增媒体下发计划')
def test_add_plan(self, data, enter_the_homepage):
enter_the_homepage.goto_media_or_welcome_paln_send().add_plan(
add_type=data['add_type'],
plan_name=data['plan_name'],
sucai=data['sucai'],
start_date=data['start_date'],
end_date=data['end_date'],
start_time=data['start_time'],
end_time=data['end_time'],
equipment=data['equipment']
)
assert '成功' in enter_the_homepage.get_success_save_tip()
datas = DoExcel('plan_modify').get_data(dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('媒体下发计划--修改媒体下发计划')
def test_modify_plan(self, data, enter_the_homepage):
enter_the_homepage.goto_media_or_welcome_paln_send().modify_plan(
plan_modify=data['plan_modify'],
plan_name=data['plan_name'],
sucai=data['sucai'],
start_date=data['start_date'],
end_date=data['end_date'],
start_time=data['start_time'],
end_time=data['end_time'],
equipment=data['equipment']
)
assert '成功' in enter_the_homepage.get_success_save_tip()
datas = DoExcel('plan_delete').get_data(dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('媒体下发计划--删除媒体下发计划')
def test_delete_plan(self, data, enter_the_homepage):
enter_the_homepage.goto_media_or_welcome_paln_send().delete_plan(plan_delete=data['plan_delete'])
assert '成功' in enter_the_homepage.get_success_delete_tip()
@pytest.mark.parametrize('data', add_datas)
@allure.title('媒体下发计划--新增已删除的媒体下发计划')
def test_add_plan_delete(self, data, enter_the_homepage):
enter_the_homepage.goto_media_or_welcome_paln_send().add_plan(
add_type=data['add_type'],
plan_name=data['plan_name'],
sucai=data['sucai'],
start_date=data['start_date'],
end_date=data['end_date'],
start_time=data['start_time'],
end_time=data['end_time'],
equipment=data['equipment']
)
assert '成功' in enter_the_homepage.get_success_save_tip()
class TestHallControl:
add_datas = DoExcel('hall_control_add').get_data(dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', add_datas)
@allure.title('测控管理--新增功能')
def test_add_hall_control(self, data, enter_the_homepage):
enter_the_homepage.goto_hall_control().add_hall_control(
hall_gateway=data['hall_gateway'],
hall_gateway_port=data['hall_gateway_port'],
hall_control_name=data['hall_control_name'],
hall_control_amount=data['hall_control_amount'],
hall_control_start_address=data['hall_control_start_address'],
remarks=data['remarks']
)
assert '成功' in enter_the_homepage.get_success_save_tip()
delete_datas = DoExcel('hall_control_modify').get_data(dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', delete_datas)
@allure.title('测控管理--修改功能')
def test_modify_hall_control(self, data, enter_the_homepage):
enter_the_homepage.goto_hall_control().modify_hall_control(
modify_hall_control=data['modify_hall_control'],
hall_gateway=data['hall_gateway'],
hall_gateway_port=data['hall_gateway_port'],
hall_control_name=data['hall_control_name'],
hall_control_amount=data['hall_control_amount'],
hall_control_start_address=data['hall_control_start_address'],
remarks=data['remarks']
)
assert '成功' in enter_the_homepage.get_success_save_tip()
delete_datas = DoExcel('hall_control_delete').get_data(dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', delete_datas)
@allure.title('测控管理--删除功能')
def test_delete_hall_control(self, data, enter_the_homepage):
enter_the_homepage.goto_hall_control().delete_hall_control(delete_hall_control=data['delete_hall_control'])
assert '成功' in enter_the_homepage.get_success_delete_tip()
@pytest.mark.parametrize('data', add_datas)
@allure.title('测控管理--新增已删除的测控')
def test_add_hall_control_delete(self, data, enter_the_homepage):
enter_the_homepage.goto_hall_control().add_hall_control(
hall_gateway=data['hall_gateway'],
hall_gateway_port=data['hall_gateway_port'],
hall_control_name=data['hall_control_name'],
hall_control_amount=data['hall_control_amount'],
hall_control_start_address=data['hall_control_start_address'],
remarks=data['remarks']
)
assert '成功' in enter_the_homepage.get_success_save_tip()
class TestMediaOrTemplateManage:
add_datas = DoExcel('sucai_add').get_data(dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', add_datas)
@allure.title('媒体素材管理--新增素材')
def test_add_sucai(self, data, enter_the_homepage):
enter_the_homepage.goto_sucai_manage().add_sucai(
sucai_name=data['sucai_name'],
dirpath=data['dirpath'],
sucai_type=data['sucai_type'],
remarks=data['remarks']
)
assert '成功' in enter_the_homepage.get_success_save_tip()
datas = DoExcel('sucai_modify').get_data(dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('媒体素材管理--修改素材')
def test_modify_sucai(self, data, enter_the_homepage):
enter_the_homepage.goto_sucai_manage().modify_sucai(
sucai_modify=data['sucai_modify'],
sucai_name=data['sucai_name'],
dirpath=data['dirpath'],
sucai_type=data['sucai_type'],
remarks=data['remarks']
)
assert '成功' in enter_the_homepage.get_success_save_tip()
datas = DoExcel('sucai_delete').get_data(dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('媒体素材管理--删除素材')
def test_delete_sucai(self, data, enter_the_homepage):
enter_the_homepage.goto_sucai_manage().delete_sucai(sucai_delete=data['sucai_delete'])
assert '成功' in enter_the_homepage.get_success_delete_tip()
@pytest.mark.parametrize('data', add_datas)
@allure.title('媒体素材管理--新增已删除的素材')
def test_add_sucai_delete(self, data, enter_the_homepage):
enter_the_homepage.goto_sucai_manage().add_sucai(
sucai_name=data['sucai_name'],
dirpath=data['dirpath'],
sucai_type=data['sucai_type'],
remarks=data['remarks']
)
assert '成功' in enter_the_homepage.get_success_save_tip()
class TestTerminalManage:
datas = DoExcel('terminal_add').get_data(dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('终端管理--新增摄像头')
def test_add_teiminal(self, data, enter_the_homepage):
enter_the_homepage.goto_terminal_manage().add_terminal(
terminal_name=data['terminal_name'],
terminal_type=data['terminal_type'],
terminal_ip=data['terminal_ip'],
terminal_port=data['terminal_port'],
terminal_username=data['terminal_username'],
terminal_password=data['terminal_password'],
area=data['area'],
push=data['push'])
assert '成功' in enter_the_homepage.get_success_save_tip()
datas = DoExcel('terminal_modify').get_data(
dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('终端管理--修改摄像头')
def test_modify_teiminal(self, data, enter_the_homepage):
enter_the_homepage.goto_terminal_manage().modify_terminal(
terminal_modify=data['terminal_modify'],
terminal_name=data['terminal_name'],
terminal_type=data['terminal_type'],
terminal_ip=data['terminal_ip'],
terminal_port=data['terminal_port'],
terminal_username=data['terminal_username'],
terminal_password=data['terminal_password'],
area=data['area'],
push=data['push'])
assert '成功' in enter_the_homepage.get_success_save_tip()
datas = DoExcel('terminal_delete').get_data(
dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('终端管理--删除摄像头')
def test_delete_teiminal(self, data, enter_the_homepage):
enter_the_homepage.goto_terminal_manage().delete_terminal(
terminal_delete=data['terminal_delete'])
assert '成功' in enter_the_homepage.get_success_delete_tip()
class TestWelcomeManage:
add_datas = DoExcel('welcome_word_add').get_data(dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', add_datas)
@allure.title('欢迎词管理--新增欢迎词')
def test_add_welcome_word(self, data, enter_the_homepage):
enter_the_homepage.goto_welcome_manage().add_welcome_word(
welcome_template=data['welcome_template'],
title=data['title'],
content=data['content']
)
assert '成功' in enter_the_homepage.get_success_save_tip()
datas = DoExcel('welcome_word_modify').get_data(dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('欢迎词管理--修改欢迎词')
def test_modify_welcome_word(self, data, enter_the_homepage):
enter_the_homepage.goto_welcome_manage().modify_welcome_word(
welcome_modify=data['welcome_modify'],
welcome_template=data['welcome_template'],
title=data['title'],
content=data['content']
)
assert '成功' in enter_the_homepage.get_success_save_tip()
datas = DoExcel('welcome_word_delete').get_data(dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('欢迎词管理--删除欢迎词')
def test_delete_welcome_word(self, data, enter_the_homepage):
enter_the_homepage.goto_welcome_manage().delete_welcome_word(welcome_delete=data['welcome_delete'])
assert '成功' in enter_the_homepage.get_success_delete_tip()
@pytest.mark.parametrize('data', add_datas)
@allure.title('欢迎词管理--新增已删除的欢迎词')
def test_add_welcome_word_delete(self, data, enter_the_homepage):
enter_the_homepage.goto_welcome_manage().add_welcome_word(
welcome_template=data['welcome_template'],
title=data['title'],
content=data['content']
)
assert '成功' in enter_the_homepage.get_success_save_tip()
def test_auth_GetNodeList(self, before_after_request, case):
self.log_ob.debug('第 {} 条用例'.format(case.case_id))
self.log_ob.debug('用例名称：{}'.format(case.case_name))
resp = before_after_request.http_request(case.method, case.url,
case.data)
self.result = resp.json()
row = case.case_id + 1
result = str(self.result)
try:
assert self.result['code'] == eval(case.expected)['code']
DoExcel(contants.case_file,
'GetNodeList').write_case(row, result, 'pass')
self.log_ob.debug("成功用例回写EXCEL成功")
except:
DoExcel(contants.case_file,
'GetNodeList').write_case(row, result, 'failed')
self.log_ob.debug("失败用例回写EXCEL成功")
assert self.result['code'] == eval(case.expected)['code']
class TestAreaManage:
datas = DoExcel('area').get_data(dir_config.archives_data_excel_path)
@allure.title('区域管理--新增功能')
@pytest.mark.parametrize('data', datas)
def test_add_area(self, data, enter_the_homepage):
AreaManagePage(enter_the_homepage).add_area(
area_name=data['area_name'],
area_code=data['area_code'],
remark=data['remark'])
assert '成功' in HomePage(enter_the_homepage).get_success_save_tip()
class TestHallAreaBgManage:
datas = DoExcel('hall_area_bg_add').get_data(
dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('区域分布图管理--新增功能')
def test_add_hall_area_bg(self, data, enter_the_homepage):
enter_the_homepage.goto_hall_area_bg_manage().add_hall_area_bg(
dirpath=data['dirpath'], remarks=data['remarks'])
assert '成功' in enter_the_homepage.get_hall_area_bg_success_save_tip()
datas = DoExcel('hall_area_bg_modify').get_data(
dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('区域分布图管理--修改功能')
def test_modify_hall_area_bg(self, data, enter_the_homepage):
enter_the_homepage.goto_hall_area_bg_manage().modify_hall_area_bg(
dirpath=data['dirpath'], remarks=data['remarks'])
assert '成功' in enter_the_homepage.get_hall_area_bg_success_save_tip()
class TestDataPointManage:
datas = DoExcel('alarm_set').get_data(dir_config.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('智能网关告警设置--新增功能')
def test_add_alarm_set(self, data, enter_the_homepage):
AlarmSetPage(enter_the_homepage).add_alarm_set(room=data['room_name'], monitoring=data['monitoring_name'], node_position=data['node_position'],
cabinet_or_transformer=data['cabinet_or_transformer'], alarm_type=data['alarm_type'],
alarm_data=data['alarm_data'], value_feedback_point=data['value_feedback_point'],
upper_limit=data['upper_limit'], remark=data['remark'])
assert '成功' in HomePage(enter_the_homepage).get_success_save_tip()
class TestCabinetArchiveMmanage:
datas = DoExcel('cabinet').get_data(dir_config.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('开关柜档案管理--新增功能')
def test_add_cabinet(self, data, enter_the_homepage):
CabinetArchiveMmanagementPage(enter_the_homepage).add_cabinet(
room=data['room_name'],
cabinet_name=data['cabinet_name'],
cabinet_type=data['cabinet_type'],
remark=data['remark'])
assert "成功" in HomePage(enter_the_homepage).get_success_save_tip()
class TestCameraManage:
datas = DoExcel('camera').get_data(dir_config.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('摄像头节点--新增功能')
def test_add_camera(self, data, enter_the_homepage):
CameraManage(enter_the_homepage).add_camera(
room=data['room_name'],
NVR=data['NVR'],
camera_name=data['camera_name'],
channel_number=data['channel_number'],
whether_control=data['whether_control'])
assert '成功' in HomePage(enter_the_homepage).get_success_save_tip()
class TestHallManage:
add_datas = DoExcel('area_add').get_data(dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', add_datas)
@allure.title('区域管理--新增功能')
def test_add_hall_area(self, data, enter_the_homepage):
enter_the_homepage.goto_hall_area_manage().add_hall_area(
hall_area_name=data['hall_area_name'])
assert '成功' in enter_the_homepage.get_success_save_tip()
modify_datas = DoExcel('area_modify').get_data(
dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', modify_datas)
@allure.title('区域管理--修改功能')
def test_modify_hall_area(self, data, enter_the_homepage):
enter_the_homepage.goto_hall_area_manage().modify_hall_area(
hall_area_modify=data['hall_area_modify'],
hall_area_name=data['hall_area_name'])
assert '成功' in enter_the_homepage.get_success_save_tip()
delete_datas = DoExcel('area_delete').get_data(
dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', delete_datas)
@allure.title('区域管理--删除功能')
def test_delete_hall_area(self, data, enter_the_homepage):
enter_the_homepage.goto_hall_area_manage().delete_hall_area(
hall_area_delete=data['hall_area_delete'])
assert '成功' in enter_the_homepage.get_success_delete_tip()
@pytest.mark.parametrize('data', add_datas)
@allure.title('区域管理--新增已删除的区域')
def test_add_hall_area_delete(self, data, enter_the_homepage):
enter_the_homepage.goto_hall_area_manage().add_hall_area(
hall_area_name=data['hall_area_name'])
assert '成功' in enter_the_homepage.get_success_save_tip()
class TestDataPointManage:
datas = DoExcel('control_point').get_data(
dir_config.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('控制节点管理--新增功能')
def test_add_data_point(self, data, enter_the_homepage):
ControlPointManagePage(enter_the_homepage).add_control_point(
room=data['room_name'],
monitoring=data['monitoring_name'],
data_type=data['data_type'],
status_feedback_point=data['status_feedback_point'],
control_point_name=data['control_point_name'],
channel_number=data['channel_number'])
assert '成功' in HomePage(enter_the_homepage).get_success_save_tip()
class TestTransformerArchiveManage:
datas = DoExcel('transformer').get_data(
dir_config.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('变压器档案管理--新增功能')
def test_add_transformer(self, data, enter_the_homepage):
TransformerArchiveManagePage(enter_the_homepage).add_transformer(
room=data['room_name'],
transformer_name=data['transformer_name'],
voltage_level_high=data['voltage_level_high'],
voltage_level_low=data['voltage_level_low'],
capacity=data['capacity'],
remark=data['remark'])
assert "成功" in HomePage(enter_the_homepage).get_success_save_tip()
class TestAddUser:
datas = DoExcel('user').get_data(dir_config.archives_data_excel_path)
@allure.title('用户管理--新增功能')
@pytest.mark.parametrize('data', datas)
def test_add_user(self, data, enter_the_homepage):
UserManagePage(enter_the_homepage).add_user(
name=data['name'],
user_name=data['user_name'],
password=data['password'],
confirm_password=data['confirm_password'],
email=data['email'],
phone=data['phone'],
role=data['role'],
manage_room=data['manage_room'],
remark=data['remark'])
assert "成功" in HomePage(enter_the_homepage).get_success_save_tip()
class TestDataPointManage:
datas = DoExcel('data_point').get_data(dir_config.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('数据节点管理--新增功能')
def test_add_data_point(self, data, enter_the_homepage):
DataPointManagePage(enter_the_homepage).add_data_point(
room=data['room_name'],
monitoring=data['monitoring_name'],
node_position=data['node_position'],
cabinet_or_transformer=data['cabinet_or_transformer'],
data_type=data['data_type'],
signal_type=data['signal_type'],
data_point_name=data['data_point_name'],
channel_number=data['channel_number'],
data_unit=data['data_unit'],
decimal_point_number=data['decimal_point_number'],
upper_limit=data['upper_limit'],
remark=data['remark'])
assert '成功' in HomePage(enter_the_homepage).get_success_save_tip()
class TestMonitoringEquipmentManage:
datas = DoExcel('monitoring').get_data(dir_config.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('监控设备管理--新增功能')
def test_add_monitor(self, data, enter_the_homepage):
MonitoringEquipmentManagePage(enter_the_homepage).add_monitoring(
room=data['room_name'],
monitoring_name=data['monitoring_name'],
monitoring_type=data['monitoring_type'],
mailing_address=data['mailing_address'],
network_connection_mode=data['network_connection_mode'],
network_ip=data['network_ip'],
network_port=data['network_port'],
domain_name=data['domainName'],
login_username=data['login_username'],
login_password=data['login_password'],
remark=data['remark'])
HomePage(enter_the_homepage).switch_iframe_to_new_tab()
assert "成功" in HomePage(enter_the_homepage).get_success_save_tip()
class TestDoctor(unittest.TestCase):
cases = DoExcel(excel_path).read_excel("doctor")
@classmethod
def setUpClass(cls):
cls.hr = HttpRequests("api", "pre_url")
@data(*cases)
def test_doctor(self, case):
load_my_logging_cfg("医师").info("excel传入的数据：{}".format(case.data))
if case.url == '/am/v2/doctor/syn':
case.data = json.loads(case.data)
doctorname = nameRandomGenerator()
phone = phoneNORandomGenerator()
uid = CreateIDCard()
depart = department()
doctortype = doctor_id_type()
doctitle = doc_title()
doccode = doc_title_code()
case.data["body"]["doctorName"] = doctorname
case.data["body"]["phone"] = phone
case.data["body"]["doctorId"] = phone
case.data["body"]["uid"] = uid
case.data["body"]["department"] = depart
case.data["body"]["doctorIdType"] = doctortype
case.data["body"]["title"] = doctitle
case.data["body"]["titleCode"] = doccode
load_my_logging_cfg("医师").info("传入接口中的数据：{}".format(case.data))
res = self.hr.http_request(case.method, case.url, data=case.data)
# 日志
print("响应", res)
acture = res["message"]
expect = case.expect
self.assertEqual(expect, acture)
# 连接数据库
setattr(Context, "openid", res["data"]["openId"])
else:
class GetRouteList_auth:
doexcel_ob = DoExcel(contants.case_file, 'GetRouteList')
log_ob = MyLog(__name__).my_log()
@pytest.mark.parametrize('case', doexcel_ob.get_cases())
def test_auth_GetRouteList(self, before_after_request, case):
self.log_ob.debug('第 {} 条用例'.format(case.case_id))
self.log_ob.debug('用例名称：{}'.format(case.case_name))
resp = before_after_request.http_request(case.method, case.url,
case.data)
self.result = resp.json()
row = case.case_id + 1
result = str(self.result)
try:
assert self.result['code'] == eval(case.expected)['code']
DoExcel(contants.case_file,
'GetRouteList').write_case(row, result, 'pass')
self.log_ob.debug("成功用例回写EXCEL成功")
except:
DoExcel(contants.case_file,
'GetRouteList').write_case(row, result, 'failed')
self.log_ob.debug("失败用例回写EXCEL成功")
assert self.result['code'] == eval(case.expected)['code']
class TestHallEquipment:
add_datas = DoExcel('hall_equipment_add').get_data(dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', add_datas)
@allure.title('设备管理--新增功能')
def test_add_hall_equipment(self, data, enter_the_homepage):
enter_the_homepage.goto_hall_equipment().add_hall_equipment(
hall_equipment_name=data['hall_equipment_name'],
hall_equipment_type=data['hall_equipment_type'],
hall_equipment_child_type=data['hall_equipment_child_type'],
equipment_code=data['equipment_code'],
mac_address=data['mac_address'],
protocol_address=data['protocol_address'],
area=data['area'],
remarks=data['remarks'],
equipment_gateway_parent=data['equipment_gateway_parent'],
equipment_gateway_parent_port=data['equipment_gateway_parent_port'],
equipment_gateway_protocol=data['equipment_gateway_protocol']
)
assert '成功' in enter_the_homepage.get_success_save_tip()
datas = DoExcel('hall_equipment_modify').get_data(dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('设备管理--修改功能')
def test_modify_hall_equipment(self, data, enter_the_homepage):
enter_the_homepage.goto_hall_equipment().modify_hall_equipment(
modify_hall_equipment=data['modify_hall_equipment'],
hall_equipment_name=data['hall_equipment_name'],
hall_equipment_type=data['hall_equipment_type'],
hall_equipment_child_type=data['hall_equipment_child_type'],
equipment_code=data['equipment_code'],
mac_address=data['mac_address'],
protocol_address=data['protocol_address'],
area=data['area'],
remarks=data['remarks'],
equipment_gateway_parent=data['equipment_gateway_parent'],
equipment_gateway_parent_port=data['equipment_gateway_parent_port'],
equipment_gateway_protocol=data['equipment_gateway_protocol']
)
assert '成功' in enter_the_homepage.get_success_save_tip()
datas = DoExcel('hall_equipment_delete').get_data(dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('设备管理--删除功能')
def test_delete_hall_equipment(self, data, enter_the_homepage):
enter_the_homepage.goto_hall_equipment().delete_hall_equipment(delete_hall_equipment=data['delete_hall_equipment'])
assert '成功' in enter_the_homepage.get_success_delete_tip()
@pytest.mark.parametrize('data', add_datas)
@allure.title('设备管理--新增已删除的设备')
def test_add_hall_equipment_delete(self, data, enter_the_homepage):
enter_the_homepage.goto_hall_equipment().add_hall_equipment(
hall_equipment_name=data['hall_equipment_name'],
hall_equipment_type=data['hall_equipment_type'],
hall_equipment_child_type=data['hall_equipment_child_type'],
equipment_code=data['equipment_code'],
mac_address=data['mac_address'],
protocol_address=data['protocol_address'],
area=data['area'],
remarks=data['remarks'],
equipment_gateway_parent=data['equipment_gateway_parent'],
equipment_gateway_parent_port=data['equipment_gateway_parent_port'],
equipment_gateway_protocol=data['equipment_gateway_protocol']
)
assert '成功' in enter_the_homepage.get_success_save_tip()
HomePage(self.driver).whether_need_click_next_page_button(
eval(delete_button_replace))
# 点击删除按钮
self.click_element(eval(delete_button_replace))
# 切换到默认iframe
self.back_to_default_content()
time.sleep(0.5)
# 在弹出的提示框中点击确定按钮
self.click_element(loc_home.confirm_button)
if __name__ == '__main__':
from selenium import webdriver
from PageObjects.login_page import LoginPage
from PageLocators.login_page_locators import LoginPageLocator as loc_1
from Common import dir_config
from Common.do_excel import DoExcel
import time
driver = webdriver.Chrome()
driver.get('http://172.17.46.198:9080/IDRMS')
LoginPage(driver).input_text(loc_1.username_ele, "idrmstest")
LoginPage(driver).input_text(loc_1.password_ele, "fu123456")
time.sleep(10)
LoginPage(driver).click_element(loc_1.click_button)
test_datas = DoExcel('area').get_data(
dir_config.archives_data_excel_path)[0]
AreaManagePage(driver).add_area(test_datas['area_name'],
test_datas['area_code'],
test_datas['remark'])
from config.Log import Log
from Common.http_requests import HttpRequest
from Common.pro_path import *
from Common import globalvar
from Common.do_excel import DoExcel
from Common.my_logger import MyLogger
import ddt, unittest, json, sys
import traceback
# 定义一个全局变量
dic = {}
# 读取excel表的内容返回一个[{},{}]格式的值
d = DoExcel()
r = d.read_excel(data_path + '\\control_tower测试用例.xlsx', "登录")
r1_air = d.read_excel(data_path + '\\control_tower测试用例.xlsx',
"AirExceptList_API")
r1_sea = d.read_excel(data_path + '\\control_tower测试用例.xlsx',
"SeaExceptList_API")
r2 = d.read_excel(data_path + '\\control_tower测试用例.xlsx', "邓天苹")
r.extend(r1_air)
r.extend(r1_sea)
r.extend(r2)
@ddt.ddt
class Test1(unittest.TestCase):
def setUp(self):
self.log = Log()
@ddt.data(*r)
# 登录
class TestHallScene:
add_datas = DoExcel('hall_scene_add').get_data(
dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', add_datas)
@allure.title('场景设置--新增功能')
def test_add_hall_equipment(self, data, enter_the_homepage):
enter_the_homepage.goto_hall_scence().add_hall_scene(
hall_scene_name=data['hall_scene_name'],
hall_scene_remarks=data['hall_scene_remarks'],
add_type=data['add_type'],
equipment=data['equipment'],
execute_order=data['execute_order'],
parameter=data['parameter'],
action_execute_sequence=data['action_execute_sequence'],
delay_execute_sequence=data['delay_execute_sequence'],
delay_time=data['delay_time'])
assert '成功' in enter_the_homepage.get_success_save_tip()
datas = DoExcel('hall_scene_modify').get_data(
dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('场景设置--修改功能')
def test_modify_hall_equipment(self, data, enter_the_homepage):
enter_the_homepage.goto_hall_scence().modify_hall_scene(
modify_hall_scene=data['modify_hall_scene'],
hall_scene_name=data['hall_scene_name'],
hall_scene_remarks=data['hall_scene_remarks'],
add_type=data['add_type'],
equipment=data['equipment'],
execute_order=data['execute_order'],
parameter=data['parameter'],
action_execute_sequence=data['action_execute_sequence'],
delay_execute_sequence=data['delay_execute_sequence'],
delay_time=data['delay_time'])
assert '成功' in enter_the_homepage.get_success_save_tip()
datas = DoExcel('disuse_or_use_hall_scene').get_data(
dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('场景设置--禁用功能')
def test_disuse_hall_scene(self, data, enter_the_homepage):
enter_the_homepage.goto_hall_scence().disuse_hall_scene(
disuse_hall_scene=data['disuse_hall_scene'])
assert '成功' in enter_the_homepage.get_success_save_tip()
@pytest.mark.parametrize('data', datas)
@allure.title('场景设置--启用功能')
def test_use_hall_scene(self, data, enter_the_homepage):
enter_the_homepage.goto_hall_scence().use_hall_scene(
use_hall_scene=data['use_hall_scene'])
assert '成功' in enter_the_homepage.get_success_save_tip()
datas = DoExcel('hall_scene_delete').get_data(
dir_path.archives_data_excel_path)
@pytest.mark.parametrize('data', datas)
@allure.title('场景设置--删除功能')
def test_delete_hall_equipment(self, data, enter_the_homepage):
enter_the_homepage.goto_hall_scence().delete_hall_scene(
delete_hall_scene=data['delete_hall_scene'])
assert '成功' in enter_the_homepage.get_success_delete_tip()
@pytest.mark.parametrize('data', add_datas)
@allure.title('场景设置--新增已删除的场景')
def test_add_hall_equipment_delete(self, data, enter_the_homepage):
enter_the_homepage.goto_hall_scence().add_hall_scene(
hall_scene_name=data['hall_scene_name'],
hall_scene_remarks=data['hall_scene_remarks'],
add_type=data['add_type'],
equipment=data['equipment'],
execute_order=data['execute_order'],
parameter=data['parameter'],
action_execute_sequence=data['action_execute_sequence'],
delay_execute_sequence=data['delay_execute_sequence'],
delay_time=data['delay_time'])
assert '成功' in enter_the_homepage.get_success_save_tip()
