def __init__(self, driver):
self.driver = driver
self.log = log()
self.data = dataFileName()
self.cmf = commonFun(driver)
self.acproval = Accapproval(driver)
self.loginElem = loginPage(self.driver)
self.authElem = AuthorizationPage(self.driver)
self.flow = Flowcontrol(self.driver)
def __init__(self, driver):
self.driver = driver
self.log = log()
self.data = dataFileName()
self.cmf = commonFun(driver)
self.double = Dobapproval(driver)
self.comsuit = CommonSuiteData(self.driver)
self.loginElem = loginPage(self.driver)
self.authElem = AuthorizationPage(self.driver)
self.acproval = Accapproval(driver)
self.flow = Flowcontrol(self.driver)
self.frameElem = frameElement(self.driver)
def __init__(self, driver): self.driver = driver self.log = log() self.data = dataFileName() self.cmf = commonFun(driver) self.acproval = Accapproval(driver) self.comsuit = CommonSuiteData(self.driver) self.loginElem = loginPage(self.driver) self.authElem = AuthorizationPage(self.driver) self.flow = Flowcontrol(self.driver)
class testAccapproval(object):
def __init__(self, driver):
self.driver = driver
self.log = log()
self.data = dataFileName()
self.cmf = commonFun(driver)
self.acproval = Accapproval(driver)
self.loginElem = loginPage(self.driver)
self.authElem = AuthorizationPage(self.driver)
self.flow = Flowcontrol(self.driver)
u'''获取测试数据
Parameters:
- sheetname:sheet名称
return：表格数据
'''
def get_accapproval_data(self, sheetname):
dataFile = dataFileName()
acpPath = dataFile.get_accapproval_test_data_url()
acpData = dataFile.get_data(acpPath, sheetname)
return acpData
u'''添加访问审批'''
def add_access_approvel_001(self):
#日志开始记录
self.log.log_start("add_access_approvel")
#获取访问审批的数据
acpData = self.get_accapproval_data("add_access_approvel")
for dataRow in range(len(acpData)):
data = acpData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow != 0:
if dataRow == 1:
self.acproval.click_access_approval_button(data[2])
#设置开关状态
self.authElem.set_switch_on()
self.authElem.click_add_approval_level()
self.authElem.click_add_approval(data[3])
#添加审批人
self.authElem.set_select_user_search_button()
self.acproval.check_user(data[4])
self.authElem.set_ok_button()
#设置审批级别中的通过审批人个数
self.acproval.select_approval_num(data[3], data[5])
except Exception as e:
print("add_access_approvell fail: ") + str(e)
self.log.log_detail(u"添加访问审批成功", True)
#点击保存
self.authElem.approval_save_button()
self.cmf.click_login_msg_button()
#点击返回
self.authElem.approval_back_button()
self.log.log_end("add_access_approvel")
u'''访问审批通过流程控制拒绝审批'''
def access_deny_approvel_002(self):
#日志开始记录
self.log.log_start("access_deny_approvel")
#获取访问审批申请的数据
appData = self.get_accapproval_data("access_approvel_sso")
#获取访问审批审批的数据
acpData = self.get_accapproval_data("deny_approvel")
for dataRow in range(len(appData)):
data = appData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow != 0:
list = [data[9], data[10], data[11], data[12], data[13]]
self.loginElem.quit()
self.loginElem.login(list)
self.cmf.select_role_by_text(u"运维操作员")
self.acproval.send_access_approval_applicant(data)
number = self.acproval.get_new_process_number()
self.loginElem.quit()
self.acproval.approval_by_approver(acpData, number)
except Exception as e:
print("access_deny_approvel fail: ") + str(e)
self.log.log_end("access_deny_approvel")
u'''访问审批通过流程控制同意审批'''
def access_agree_approvel_003(self):
#日志开始记录
self.log.log_start("access_agree_approvel")
#获取访问审批申请的数据
appData = self.get_accapproval_data("access_approvel_sso")
#获取访问审批审批的数据
acpData = self.get_accapproval_data("agree_approvel")
for dataRow in range(len(appData)):
data = appData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow != 0:
list = [data[9], data[10], data[11], data[12], data[13]]
self.loginElem.login(list)
self.cmf.select_role_by_text(u"运维操作员")
self.acproval.send_access_approval_applicant(data)
number = self.acproval.get_new_process_number()
self.loginElem.quit()
self.acproval.approval_by_approver(acpData, number)
except Exception as e:
print("access_agree_approvel fail: ") + str(e)
self.log.log_end("access_agree_approvel")
u'''紧急运维通过流程控制拒绝审批'''
def urgent_deny_approvel_004(self):
#日志开始记录
self.log.log_start("urgent_deny_approvel")
#获取访问审批申请的数据
appData = self.get_accapproval_data("urgent_approvel")
#获取访问审批审批的数据
acpData = self.get_accapproval_data("deny_approvel")
for dataRow in range(len(appData)):
data = appData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow != 0:
list = [data[4], data[5], data[6], data[7], data[8]]
self.loginElem.login(list)
self.cmf.select_role_by_text(u"运维操作员")
self.acproval.send_urgent_operation_applicant(data)
number = self.acproval.get_new_process_number()
self.loginElem.quit()
self.acproval.approval_by_approver(acpData, number)
except Exception as e:
print("urgent_deny_approvel fail: ") + str(e)
self.log.log_end("urgent_deny_approvel")
u'''紧急运维通过流程控制同意审批'''
def urgent_agree_approvel_005(self):
#日志开始记录
self.log.log_start("urgent_agree_approvel")
#获取访问审批申请的数据
appData = self.get_accapproval_data("urgent_approvel")
#获取访问审批审批的数据
acpData = self.get_accapproval_data("agree_urgent")
for dataRow in range(len(appData)):
data = appData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow != 0:
list = [data[4], data[5], data[6], data[7], data[8]]
self.loginElem.login(list)
self.cmf.select_role_by_text(u"运维操作员")
self.acproval.send_urgent_operation_applicant(data)
number = self.acproval.get_new_process_number()
self.loginElem.quit()
self.acproval.approval_by_approver(acpData, number)
except Exception as e:
print("urgent_agree_approvel fail: ") + str(e)
self.log.log_end("urgent_agree_approvel")
u'''访问审批流程任务查询'''
def access_query_process_task_006(self):
#日志开始记录
self.log.log_start("access_query_process_task")
#获取流程任务查询的数据
taskData = self.get_accapproval_data("process_task")
for dataRow in range(len(taskData)):
data = taskData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow != 0:
if dataRow == 1:
self.acproval.user_login(data[1])
self.flow.query_process_task(data)
self.log.log_detail(data[0], True)
except Exception as e:
print("access_query_process_task fail: ") + str(e)
self.log.log_end("access_query_process_task")
u'''访问审批个人历史查询'''
def access_query_personal_history_007(self):
#日志开始记录
self.log.log_start("access_query_personal_history")
#获取个人历史查询的数据
perData = self.get_accapproval_data("personal_history")
for dataRow in range(len(perData)):
data = perData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow != 0:
self.flow.query_personal_history(data)
self.log.log_detail(data[0], True)
except Exception as e:
print("access_query_personal_history fail: ") + str(e)
self.loginElem.quit()
self.log.log_end("access_query_personal_history")
u'''访问审批申请历史查询'''
def access_query_apply_history_008(self):
#日志开始记录
self.log.log_start("access_query_apply_history")
#获取申请历史查询的数据
applyData = self.get_accapproval_data("apply_history")
for dataRow in range(len(applyData)):
data = applyData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow != 0:
if dataRow == 1:
self.acproval.user_login(data[9])
self.flow.query_apply_history(data)
self.log.log_detail(data[0], True)
except Exception as e:
print("access_query_apply_history fail: ") + str(e)
self.loginElem.quit()
self.log.log_end("access_query_apply_history")
u'''访问审批全部历史查询'''
def access_query_all_history_009(self):
#日志开始记录
self.log.log_start("access_query_all_history")
#获取全部历史查询的数据
allData = self.get_accapproval_data("all_history")
for dataRow in range(len(allData)):
data = allData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow != 0:
if dataRow == 1:
self.acproval.user_login(data[1])
self.flow.query_all_history(data)
self.log.log_detail(data[0], True)
except Exception as e:
print("access_query_all_history fail: ") + str(e)
self.log.log_end("access_query_all_history")
class testDobapproval(object):
def __init__(self, driver):
self.driver = driver
self.log = log()
self.data = dataFileName()
self.cmf = commonFun(driver)
self.double = Dobapproval(driver)
self.comsuit = CommonSuiteData(self.driver)
self.loginElem = loginPage(self.driver)
self.authElem = AuthorizationPage(self.driver)
self.acproval = Accapproval(driver)
self.flow = Flowcontrol(self.driver)
self.frameElem = frameElement(self.driver)
u'''获取测试数据
Parameters:
- sheetname:sheet名称
return：表格数据
'''
def get_double_data(self, sheetname):
dataFile = dataFileName()
dobPath = dataFile.get_double_license_test_data_url()
dobData = dataFile.get_data(dobPath, sheetname)
return dobData
u'''添加双人授权'''
def add_double_license_001(self):
#日志开始记录
self.log.log_start("add_double_license")
#获取双人授权的数据
dobData = self.get_double_data("add_double_license")
for dataRow in range(len(dobData)):
data = dobData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow != 0:
self.double.click_double_license_button(data[1])
self.authElem.click_all_approver()
self.authElem.click_all_candidate()
self.authElem.click_start_association()
self.authElem.click_create_relate()
self.cmf.click_login_msg_button()
#点击返回
self.authElem.click_child_page_back_button()
self.log.log_detail(u"添加双人授权成功", True)
except Exception as e:
print("add_double_license fail: ") + str(e)
self.log.log_end("add_double_license")
u'''双人审批同终端审批'''
def same_termina_approvel_002(self):
self.cmf.select_role_by_text(u"运维操作员")
#日志开始记录
self.log.log_start("same_termina_approvel")
#获取双人审批申请的数据
dobData = self.get_double_data("double_license_sso")
for dataRow in range(len(dobData)):
data = dobData[dataRow]
try:
#如果是第1行,读取数据
if dataRow == 1:
self.double.send_double_license_applicant(data)
self.double.check_ico_len(data[1])
self.loginElem.quit()
except Exception as e:
print("same_termina_approvel fail: ") + str(e)
self.log.log_end("same_termina_approvel")
u'''双人审批申请人已下线审批过期'''
def termina_expired_approvel_003(self):
self.comsuit.use_new_user_login()
#日志开始记录
self.log.log_start("Expired_approvel")
#获取双人审批申请的数据
dobData = self.get_double_data("double_license_sso")
expData = self.get_double_data("termina_approvel")
for dataRow in range(len(dobData)):
data = dobData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow == 2:
self.double.send_double_license_applicant(data)
number = self.acproval.get_new_process_number()
self.loginElem.quit()
self.double.approver_by_process_approval(expData, number)
except Exception as e:
print("Expired_approvel fail: ") + str(e)
self.log.log_end("Expired_approvel")
u'''双人审批审批人拒绝申请'''
def termina_deny_approvel_004(self):
self.comsuit.use_new_user_login()
#日志开始记录
self.log.log_start("deny_double_approvel")
#获取双人审批申请的数据
dobData = self.get_double_data("double_license_sso")
expData = self.get_double_data("deny_approvel")
for dataRow in range(len(dobData)):
data = dobData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow == 2:
self.double.send_double_license_applicant(data)
number = self.acproval.get_new_process_number()
self.double.approver_remote_approval(expData, number)
self.cmf.select_menu(u"运维操作", u"SSO")
self.double.check_ico_len(data[1])
self.loginElem.quit()
except Exception as e:
print("deny_double_approvel fail: ") + str(e)
self.log.log_end("deny_double_approvel")
u'''双人审批审批人同意申请'''
def termina_agree_approvel_005(self):
self.comsuit.use_new_user_login()
#日志开始记录
self.log.log_start("agree_double_approvel")
#获取双人审批申请的数据
dobData = self.get_double_data("double_license_sso")
expData = self.get_double_data("agree_approvel")
for dataRow in range(len(dobData)):
data = dobData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow == 2:
self.double.send_double_license_applicant(data)
number = self.acproval.get_new_process_number()
self.double.approver_remote_approval(expData, number)
self.cmf.select_menu(u"运维操作", u"SSO")
self.double.check_ico_len(data[1])
self.loginElem.quit()
except Exception as e:
print("agree_double_approvel fail: ") + str(e)
self.log.log_end("agree_double_approvel")
u'''访问审批流程任务查询'''
def double_query_process_task_006(self):
#日志开始记录
self.log.log_start("double_query_process_task")
#获取流程任务查询的数据
taskData = self.get_double_data("process_task")
for dataRow in range(len(taskData)):
data = taskData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow != 0:
if dataRow == 1:
self.acproval.user_login(data[1])
self.flow.query_process_task(data)
self.log.log_detail(data[0], True)
except Exception as e:
print("double_query_process_task fail: ") + str(e)
self.log.log_end("double_query_process_task")
u'''访问审批个人历史查询'''
def double_query_personal_history_007(self):
#日志开始记录
self.log.log_start("double_query_personal_history")
#获取个人历史查询的数据
perData = self.get_double_data("personal_history")
for dataRow in range(len(perData)):
data = perData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow != 0:
self.flow.query_personal_history(data)
self.log.log_detail(data[0], True)
except Exception as e:
print("double_query_personal_history fail: ") + str(e)
self.loginElem.quit()
self.log.log_end("double_query_personal_history")
u'''访问审批申请历史查询'''
def double_query_apply_history_008(self):
self.comsuit.use_new_user_login()
#日志开始记录
self.log.log_start("double_query_apply_history")
#获取申请历史查询的数据
applyData = self.get_double_data("apply_history")
for dataRow in range(len(applyData)):
data = applyData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow != 0:
self.flow.query_apply_history(data)
self.log.log_detail(data[0], True)
except Exception as e:
print("double_query_apply_history fail: ") + str(e)
self.log.log_end("double_query_apply_history")
u'''访问审批全部历史查询'''
def double_query_all_history_009(self):
self.comsuit.dep_switch_to_sys()
#日志开始记录
self.log.log_start("double_query_all_history")
#获取全部历史查询的数据
allData = self.get_double_data("all_history")
for dataRow in range(len(allData)):
data = allData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow != 0:
self.flow.query_all_history(data)
self.log.log_detail(data[0], True)
except Exception as e:
print("double_query_all_history fail: ") + str(e)
self.log.log_end("double_query_all_history")
u'''访问审批部门历史查询'''
def double_query_department_history_010(self):
self.comsuit.sys_switch_to_dep()
#日志开始记录
self.log.log_start("double_query_department_history")
#获取流程任务查询的数据
deprtData = self.get_double_data("department_history")
for dataRow in range(len(deprtData)):
data = deprtData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow != 0:
self.flow.query_department_history(data)
self.log.log_detail(data[0], True)
except Exception as e:
print("double_query_department_history fail: ") + str(e)
self.log.log_end("double_query_department_history")
class testAccapproval(object):
def __init__(self, driver):
self.driver = driver
self.log = log()
self.data = dataFileName()
self.cmf = commonFun(driver)
self.acproval = Accapproval(driver)
self.comsuit = CommonSuiteData(self.driver)
self.loginElem = loginPage(self.driver)
self.authElem = AuthorizationPage(self.driver)
self.flow = Flowcontrol(self.driver)
u'''获取测试数据
Parameters:
- sheetname:sheet名称
return：表格数据
'''
def get_accapproval_data(self, sheetname):
dataFile = dataFileName()
acpPath = dataFile.get_accapproval_test_data_url()
acpData = dataFile.get_data(acpPath, sheetname)
return acpData
u'''添加访问审批'''
def add_access_approvel_001(self):
#日志开始记录
self.log.log_start("add_access_approvel")
#获取访问审批的数据
acpData = self.get_accapproval_data("add_access_approvel")
for dataRow in range(len(acpData)):
data = acpData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow != 0:
if dataRow == 1:
self.acproval.click_access_approval_button(data[2])
#设置开关状态
self.authElem.set_switch_on()
self.authElem.click_add_approval_level()
self.authElem.click_add_approval(data[3])
#添加审批人
self.authElem.set_select_user_search_button()
self.acproval.check_user(data[4])
self.authElem.set_ok_button()
#设置审批级别中的通过审批人个数
self.acproval.select_approval_num(data[3], data[5])
except Exception as e:
print ("add_access_approvell fail: ") + str(e)
self.log.log_detail(u"添加访问审批成功", True)
#点击保存
self.authElem.approval_save_button()
self.cmf.click_login_msg_button()
#点击返回
self.authElem.approval_back_button()
self.log.log_end("add_access_approvel")
u'''访问审批通过流程控制拒绝审批'''
def access_deny_approvel_002(self):
self.cmf.select_role_by_text(u"运维操作员")
#日志开始记录
self.log.log_start("access_deny_approvel")
#获取访问审批申请的数据
appData = self.get_accapproval_data("access_approvel_sso")
#获取访问审批审批的数据
acpData = self.get_accapproval_data("deny_approvel")
for dataRow in range(len(appData)):
data = appData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow != 0:
self.acproval.send_access_approval_applicant(data)
number = self.acproval.get_new_process_number()
self.loginElem.quit()
self.acproval.approval_by_approver(acpData, number)
except Exception as e:
print ("access_deny_approvel fail: ") + str(e)
self.log.log_end("access_deny_approvel")
u'''访问审批通过流程控制同意审批'''
def access_agree_approvel_003(self):
self.comsuit.use_new_user_login()
#日志开始记录
self.log.log_start("access_agree_approvel")
#获取访问审批申请的数据
appData = self.get_accapproval_data("access_approvel_sso")
#获取访问审批审批的数据
acpData = self.get_accapproval_data("agree_approvel")
for dataRow in range(len(appData)):
data = appData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow != 0:
self.acproval.send_access_approval_applicant(data)
number = self.acproval.get_new_process_number()
self.loginElem.quit()
self.acproval.approval_by_approver(acpData, number)
except Exception as e:
print ("access_agree_approvel fail: ") + str(e)
self.log.log_end("access_agree_approvel")
u'''紧急运维通过流程控制拒绝审批'''
def urgent_deny_approvel_004(self):
self.comsuit.use_new_user_login()
#日志开始记录
self.log.log_start("urgent_deny_approvel")
#获取访问审批申请的数据
appData = self.get_accapproval_data("urgent_approvel")
#获取访问审批审批的数据
acpData = self.get_accapproval_data("deny_approvel")
for dataRow in range(len(appData)):
data = appData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow != 0:
self.acproval.send_urgent_operation_applicant(data)
number = self.acproval.get_new_process_number()
self.loginElem.quit()
self.acproval.approval_by_approver(acpData, number)
except Exception as e:
print ("urgent_deny_approvel fail: ") + str(e)
self.log.log_end("urgent_deny_approvel")
u'''紧急运维通过流程控制同意审批'''
def urgent_agree_approvel_005(self):
self.comsuit.use_new_user_login()
#日志开始记录
self.log.log_start("urgent_agree_approvel")
#获取访问审批申请的数据
appData = self.get_accapproval_data("urgent_approvel")
#获取访问审批审批的数据
acpData = self.get_accapproval_data("agree_urgent")
for dataRow in range(len(appData)):
data = appData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow != 0:
self.acproval.send_urgent_operation_applicant(data)
number = self.acproval.get_new_process_number()
self.loginElem.quit()
self.acproval.approval_by_approver(acpData, number)
except Exception as e:
print ("urgent_agree_approvel fail: ") + str(e)
self.log.log_end("urgent_agree_approvel")
u'''访问审批流程任务查询'''
def access_query_process_task_006(self):
#日志开始记录
self.log.log_start("access_query_process_task")
#获取流程任务查询的数据
taskData = self.get_accapproval_data("process_task")
for dataRow in range(len(taskData)):
data = taskData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow != 0:
if dataRow == 1:
self.acproval.user_login(data[1])
self.flow.query_process_task(data)
self.log.log_detail(data[0], True)
except Exception as e:
print ("access_query_process_task fail: ") + str(e)
self.log.log_end("access_query_process_task")
u'''访问审批个人历史查询'''
def access_query_personal_history_007(self):
#日志开始记录
self.log.log_start("access_query_personal_history")
#获取个人历史查询的数据
perData = self.get_accapproval_data("personal_history")
for dataRow in range(len(perData)):
data = perData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow != 0:
self.flow.query_personal_history(data)
self.log.log_detail(data[0], True)
except Exception as e:
print ("access_query_personal_history fail: ") + str(e)
self.loginElem.quit()
self.log.log_end("access_query_personal_history")
u'''访问审批申请历史查询'''
def access_query_apply_history_008(self):
self.comsuit.use_new_user_login()
#日志开始记录
self.log.log_start("access_query_apply_history")
#获取申请历史查询的数据
applyData = self.get_accapproval_data("apply_history")
for dataRow in range(len(applyData)):
data = applyData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow != 0:
self.flow.query_apply_history(data)
self.log.log_detail(data[0], True)
except Exception as e:
print ("access_query_apply_history fail: ") + str(e)
self.log.log_end("access_query_apply_history")
u'''访问审批全部历史查询'''
def access_query_all_history_009(self):
self.comsuit.dep_switch_to_sys()
#日志开始记录
self.log.log_start("access_query_all_history")
#获取全部历史查询的数据
allData = self.get_accapproval_data("all_history")
for dataRow in range(len(allData)):
data = allData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow != 0:
self.flow.query_all_history(data)
self.log.log_detail(data[0], True)
except Exception as e:
print ("access_query_all_history fail: ") + str(e)
self.log.log_end("access_query_all_history")
u'''访问审批部门历史查询'''
def access_query_department_history_010(self):
self.comsuit.sys_switch_to_dep()
#日志开始记录
self.log.log_start("access_query_department_history")
#获取流程任务查询的数据
deprtData = self.get_accapproval_data("department_history")
for dataRow in range(len(deprtData)):
data = deprtData[dataRow]
try:
#如果不是第1行,读取数据
if dataRow != 0:
self.flow.query_department_history(data)
self.log.log_detail(data[0], True)
except Exception as e:
print ("access_query_department_history fail: ") + str(e)
self.log.log_end("access_query_department_history")