def __init__(self, driver):
self.driver = driver
self.dataFile = dataFileName()
self.cmf = commonFun(self.driver)
self.initDriver = initDriver()
self.loginElem = loginPage(self.driver)
self.roleElem = Role(self.driver)
self.userElem = UserPage(self.driver)
self.frameElem = frameElement(self.driver)
self.authElem = AuthMethodPage(self.driver)
self.dptment = Department(self.driver)
self.resource = Resource(self.driver)
self.account = Accountmgr(self.driver)
self.windowsElem = WindowsResource(self.driver)
self.databaseElem = DatabaseResource(self.driver)
self.usergroup = Usergroup(self.driver)
self.regroup = Regroup(self.driver)
self.appElem = AppPage(self.driver)
self.authorizationElem = AuthorizationPage(self.driver)
self.testAutho = testAuthorization(self.driver)
self.clientElem = ClientPage(self.driver)
self.command = CommandRule(self.driver)
self.ntp = NtpService(self.driver)
self.mail = MailPage(self.driver)
self.syslog = Syslog(driver)
self.ssoElem = SsoPage(self.driver)
self.alarm = AlarmPage(self.driver)
self.PwdStr = PwdStrategy(self.driver)
self.passwdenvelope = EnvelopePage(self.driver)
def __init__(self, driver):
self.driver = driver
self.log = log()
self.cmf = commonFun(driver)
self.frameElem = frameElement(driver)
self.command = CommandRule(driver)
self.sso = testSso(driver)
self.comsuit = CommonSuiteData(driver)
def __init__(self, driver):
self.driver = driver
self.getElem = getElement(driver)
self.selectElem = selectElement(driver)
self.frameElem = frameElement(driver)
self.cnEn = cnEncode()
self.acproval = Accapproval(driver)
self.command = CommandRule(driver)
self.log = log()
def __init__(self, driver):
self.driver = driver
self.log = log()
self.cmf = commonFun(driver)
self.frameElem = frameElement(driver)
self.command = CommandRule(driver)
self.comsuit = CommonSuiteData(driver)
self.timerule = TimeRule(driver)
self.getElem = getElement(driver)
self.loginElem = loginPage(self.driver)
def __init__(self, driver):
self.driver = driver
self.log = log()
self.cmf = commonFun(driver)
self.frameElem = frameElement(driver)
self.testrole = testRole(driver)
self.command = CommandRule(driver)
self.comsuit = CommonSuiteData(driver)
self.timerule = TimeRule(driver)
self.retime = RetimeRule(driver)
def __init__(self, driver): self.driver = driver self.getElem = getElement(driver) self.selectElem = selectElement(driver) self.frameElem = frameElement(driver) self.cmf = commonFun(driver) self.cnEn = cnEncode() self.comsuit = CommonSuiteData(self.driver) self.command = CommandRule(self.driver) self.tableElem = tableElement(driver) self.log = log() self.userElem = UserPage(self.driver)
def __init__(self, driver): self.driver = driver self.getElem = getElement(driver) self.selectElem = selectElement(driver) self.frameElem = frameElement(driver) self.cnEn = cnEncode() self.acproval = Accapproval(driver) self.command = CommandRule(driver) self.log = log()
def __init__(self,driver): self.driver = driver self.log = log() self.cmf = commonFun(driver) self.frameElem = frameElement(driver) self.testrole = testRole(driver) self.command = CommandRule(driver) self.sso = testSso(driver) self.comsuit = CommonSuiteData(driver)
def __init__(self,driver): self.driver = driver self.log = log() self.cmf = commonFun(driver) self.frameElem = frameElement(driver) self.testrole = testRole(driver) self.command = CommandRule(driver) self.comsuit = CommonSuiteData(driver) self.timerule = TimeRule(driver) self.getElem = getElement(driver) self.loginElem = loginPage(self.driver)
def __init__(self, driver): self.driver = driver self.getElem = getElement(driver) self.selectElem = selectElement(driver) self.frameElem = frameElement(driver) self.cmf = commonFun(driver) self.cnEn = cnEncode() self.comsuit = CommonSuiteData(self.driver) self.command = CommandRule(self.driver) self.tableElem = tableElement(driver) self.log = log() self.userElem = UserPage(self.driver) self.role = Role(driver)
class testRetime(object):
def __init__(self, driver):
self.driver = driver
self.log = log()
self.cmf = commonFun(driver)
self.frameElem = frameElement(driver)
self.testrole = testRole(driver)
self.command = CommandRule(driver)
self.comsuit = CommonSuiteData(driver)
self.timerule = TimeRule(driver)
self.retime = RetimeRule(driver)
u'''获取测试数据
Parameters:
- sheetname:sheet名称
return：表格数据
'''
def get_table_data(self, sheetname):
dataFile = dataFileName()
retrulePath = dataFile.get_retime_test_data_url()
retruleData = dataFile.get_data(retrulePath, sheetname)
return retruleData
u'''添加资源时间规则'''
def add_retime_rule_001(self):
#日志开始记录
self.log.log_start("add_retime_rule")
#获取添加资源时间规则测试数据
retruleData = self.get_table_data("add_retime_rule")
#保存成功的弹出框
comrulMsg = self.testrole.popup()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(retruleData)):
data = retruleData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
self.command.click_add_button()
if dataRow == 3:
self.retime.click_running_state()
self.timerule.start_date(data[2])
self.timerule.date_of_termination(data[4], data[5])
self.retime.set_month_start_time(data[6])
self.retime.set_month_end_time(data[7])
self.retime.set_week_start_time(data[8])
self.retime.set_week_end_time(data[9])
self.retime.set_day_start_time(data[10])
self.retime.set_day_end_time(data[11])
self.retime.select_action(data[12])
self.command.click_add_users_button()
self.command.check_all_user()
self.command.click_add_resource_button()
self.retime.check_resource(data[13])
self.retime.click_save_retime()
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data,
flag)
self.command.click_back_command()
except Exception as e:
print("add_retime_rule fail:" + str(e))
self.log.log_end("add_retime_rule")
u'''编辑资源时间规则'''
def mod_retime_rule_002(self):
#日志开始记录
self.log.log_start("mod_retime_rule")
#获取编辑资源时间规则测试数据
retruleData = self.get_table_data("mod_retime_rule")
#保存成功的弹出框
comrulMsg = self.testrole.popup()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(retruleData)):
data = retruleData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
self.retime.click_option_method(data[2], data[3])
self.retime.select_action(data[4])
self.retime.click_save_retime()
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data,
flag)
self.command.click_back_command()
except Exception as e:
print("mod_retime_rule fail:" + str(e))
self.log.log_end("mod_retime_rule")
u'''资源时间规则结果'''
def add_retime_rule_result_003(self):
self.frameElem.from_frame_to_otherFrame("topFrame")
self.cmf.select_role_by_text(u"运维操作员")
#日志开始记录
self.log.log_start("add_retime_rule_result")
#获取资源时间审批测试数据
retruleData = self.get_table_data("add_retime_rule_result")
for dataRow in range(len(retruleData)):
data = retruleData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
self.retime.check_resource_time_rule(data)
except Exception as e:
print("add_retime_rule_result fail:" + str(e))
self.log.log_end("add_retime_rule_result")
u'''操作资源时间规则'''
def option_retime_rule_004(self):
self.comsuit.sys_switch_to_dep()
self.comsuit.switch_to_moudle(u"运维管理", u"规则定义")
self.command.click_left_rule(3)
#日志开始记录
self.log.log_start("option_retime_rule")
#获取操作资源时间规则测试数据
retruleData = self.get_table_data("option_retime_rule")
#保存成功的弹出框
comrulMsg = self.testrole.popup()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(retruleData)):
data = retruleData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
if dataRow == 1:
self.retime.click_bulkdel_retime()
elif dataRow == 2 or dataRow == 3:
self.retime.click_option_method(data[2], data[3])
elif dataRow == 4 or dataRow == 5:
time.sleep(5)
self.retime.click_option_method(data[2], data[3])
self.command.set_row_command(data[4])
self.command.check_sure_button()
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data,
flag)
time.sleep(3)
self.command.click_cancel_button()
continue
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data,
flag)
except Exception as e:
print("option_retime_rule fail:" + str(e))
self.log.log_end("option_retime_rule")
u'''校验资源时间规则'''
def check_retime_rule_005(self):
#日志开始记录
self.log.log_start("check_retime_rule")
#获取校验资源时间规则测试数据
retruleData = self.get_table_data("check_retime_rule")
#保存成功的弹出框
comrulMsg = self.testrole.popup()
self.command.click_add_button()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(retruleData)):
data = retruleData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
if 2 <= dataRow <= 4:
if dataRow != 4:
self.timerule.start_date(data[2], data[3])
else:
self.timerule.start_date(data[2])
if dataRow != 2:
self.timerule.date_of_termination(data[4], data[5])
elif 5 <= dataRow <= 11:
if dataRow == 5:
self.timerule.date_of_termination(data[4], data[5])
self.retime.set_month_start_time(data[6])
self.retime.set_month_end_time(data[7])
if dataRow == 11:
self.retime.set_day_start_time(data[8])
elif 12 <= dataRow <= 17:
self.retime.set_day_start_time(data[8])
self.retime.set_day_end_time(data[9])
elif dataRow == 18:
self.command.click_add_users_button()
self.command.check_all_user()
self.retime.click_save_retime()
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data,
flag)
except Exception as e:
print("check_retime_rule fail:" + str(e))
self.command.click_back_command()
self.log.log_end("check_retime_rule")
u'''删除资源时间规则'''
def del_retime_rule_006(self):
#日志开始记录
self.log.log_start("del_retime_rule")
#获取删除资源时间规则测试数据
retruleData = self.get_table_data("del_retime_rule")
#保存成功的弹出框
comrulMsg = self.testrole.popup()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(retruleData)):
data = retruleData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
self.retime.click_option_method(data[2], data[3])
self.retime.click_bulkdel_retime()
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data,
flag)
self.cmf.click_login_msg_button()
except Exception as e:
print("del_retime_rule fail:" + str(e))
self.log.log_end("del_retime_rule")
class Backuprestore(object):
def __init__(self, driver):
self.driver = driver
self.getElem = getElement(driver)
self.selectElem = selectElement(driver)
self.frameElem = frameElement(driver)
self.cmf = commonFun(driver)
self.cnEn = cnEncode()
self.comsuit = CommonSuiteData(self.driver)
self.command = CommandRule(self.driver)
self.tableElem = tableElement(driver)
self.log = log()
self.userElem = UserPage(self.driver)
u'''点击自动备份开关'''
def auto_backup_switch(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_click_EC("id", "btn_qh")
u'''勾选系统配置'''
def check_sys_config(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
values = self.check_common()
if values[0] == None:
self.getElem.find_element_wait_and_click_EC("id", "configBackUp")
if values[1] != None:
self.getElem.find_element_wait_and_click_EC("id", "databaseBackUp")
u'''勾选实体配置'''
def check_entity_config(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
values = self.check_common()
if values[0] != None:
self.getElem.find_element_wait_and_click_EC("id", "configBackUp")
if values[1] == None:
self.getElem.find_element_wait_and_click_EC("id", "databaseBackUp")
u'''勾选实体配置和系统配置'''
def check_all_config(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
values = self.check_common()
if values[0] == None:
self.getElem.find_element_wait_and_click_EC("id", "configBackUp")
if values[1] == None:
self.getElem.find_element_wait_and_click_EC("id", "databaseBackUp")
u'''勾选实体或者系统配置公共方法'''
def check_common(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
selem = self.getElem.find_element_with_wait_EC("id", "configBackUp")
value = selem.get_attribute('checked')
selemdb = self.getElem.find_element_with_wait_EC("id", "databaseBackUp")
valuedb = selemdb.get_attribute('checked')
list = [value, valuedb]
return list
u'''勾选实体或者系统配置
parameter:
- stauts:勾选配置信息1代表系统配置2代表实体配置，3代表系统配置和实体配置
'''
def check_config(self, stauts):
staut = self.cnEn.is_float(stauts)
if staut == '1':
self.check_sys_config()
elif staut == '2':
self.check_entity_config()
else:
self.check_all_config()
u'''选择备份方式
parameter:
- stauts:value属性值，1代表一次性执行，2代表周期性执行
'''
def select_backup_mode(self, stauts):
staut = self.cnEn.is_float(stauts)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
selem = self.getElem.find_element_with_wait_EC("id", "backUpType")
self.selectElem.select_element_by_value(selem, staut)
u'''选择执行小时
parameter:
- stauts:value属性值
'''
def select_hour(self, stauts):
staut = self.cnEn.is_float(stauts)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
selem = self.getElem.find_element_with_wait_EC("id", "startHour")
self.selectElem.select_element_by_value(selem, staut)
u'''填写分钟
parameter:
- minute:分钟
'''
def set_minute(self, minute):
minu = self.cnEn.is_float(minute)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_clear_EC("id", "startMinute")
self.getElem.find_element_wait_and_sendkeys("id", "startMinute", minu)
u'''选择执行方式
parameter:
- staut:0代表按天，1代表按周，2代表按月，3代表按年
'''
def select_execu_mode(self, staut):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
if staut == 0:
self.getElem.find_element_wait_and_click_EC("id", "dayradio")
elif staut == 1:
self.getElem.find_element_wait_and_click_EC("id", "weekradio")
elif staut == 2:
self.getElem.find_element_wait_and_click_EC("id", "monthRadio")
else:
self.getElem.find_element_wait_and_click_EC("id", "yearRadio")
u'''选择存储位置
parameter:
- stauts:value属性值1代表本地备份2代表ftp备份
'''
def select_storage_location(self, stauts):
staut = self.cnEn.is_float(stauts)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
selem = self.getElem.find_element_with_wait_EC("id", "backUpLocation")
self.selectElem.select_element_by_value(selem, staut)
u'''填写远程路径
parameter:
- path:远程路径
'''
def set_remote_path(self, path):
pat = self.cnEn.is_float(path)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_clear_EC("id", "path")
self.getElem.find_element_wait_and_sendkeys("id", "path", pat)
u'''填写服务器IP
parameter:
- ip:服务器IP
'''
def set_ftpip(self, ip):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_clear_EC("id", "ip")
self.getElem.find_element_wait_and_sendkeys("id", "ip", ip)
u'''填写连接用户名
parameter:
- minute:连接用户名
'''
def set_name(self, name):
nam = self.cnEn.is_float(name)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_clear_EC("id", "username")
self.getElem.find_element_wait_and_sendkeys("id", "username", nam)
u'''填写连接口令
parameter:
- password:连接口令
'''
def set_password(self, password):
pwd = self.cnEn.is_float(password)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_clear_EC("id", "password")
self.getElem.find_element_wait_and_sendkeys("id", "password", pwd)
u'''填写确认口令
parameter:
- minute:分钟
'''
def set_password_again(self, password):
pwd = self.cnEn.is_float(password)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_clear_EC("id", "passwordAgain")
self.getElem.find_element_wait_and_sendkeys("id", "passwordAgain", pwd)
u'''点击立刻备份'''
def click_backup_immediately(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_click_EC("id", "back_up_now")
u'''点击保存'''
def click_save(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_click_EC("id", "back_up_save")
u'''选择系统备份还原或者查看备份文件
parameter:
- staut:0代表系统备份还原，1代表查看备份文件
'''
def select_backup_menu(self, staut):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
if staut == 0:
self.getElem.find_element_wait_and_click_EC("id", "tit1")
elif staut == 1:
self.getElem.find_element_wait_and_click_EC("id", "tit2")
u'''点击操作列操作
Parameters:
- filename:文件名称
- value:1代表下载，2代表删除，3代表还原
'''
def click_operat_file(self,filename, value):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
row = 1
selems = self.driver.find_elements_by_name("file")
for selem in selems:
idvalue = selem.get_attribute('id')
row = row +1
if idvalue == filename:
xpath = ".//*[@id='content_rt02']/div/table/tbody/tr[" + str(row) + "]/td[7]/input[" + str(value) + "]"
self.getElem.find_element_wait_and_click_EC("xpath", xpath)
time.sleep(1)
u'''下载上传完成后点击操作列操作
Parameters:
- filename:文件名称
- value:1代表下载，2代表删除，3代表还原
'''
def upload_click_operat_file(self,filename, value):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
row = 1
filenames = ""+filename[:-6] + ""+filename+""
selems = self.driver.find_elements_by_name("file")
for selem in selems:
idvalue = selem.get_attribute('id')
row = row +1
if idvalue == filename or idvalue == filenames:
xpath = ".//*[@id='content_rt02']/div/table/tbody/tr[" + str(row) + "]/td[7]/input[" + str(value) + "]"
self.getElem.find_element_wait_and_click_EC("xpath", xpath)
time.sleep(1)
u'''点击还原系统配置'''
def click_restore_sys_config(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_click_EC("id", "deleConfig1")
u'''点击清空数据库'''
def click_reset_database(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_click_EC("id", "resetDataBase1")
u'''点击清空数据库'''
def click_reset_audit(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_click_EC("id", "delAuditFile1")
u'''填写syslogip
parameter:
- syslogip:syslogip
'''
def set_syslogip(self, syslogip):
ip = self.cnEn.is_float(syslogip)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_clear_EC("id", "host")
self.getElem.find_element_wait_and_sendkeys("id", "host", ip)
u'''填写syslog端口
parameter:
- port:syslog端口
'''
def set_port(self, port):
sysport = self.cnEn.is_float(port)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_clear_EC("id", "port")
self.getElem.find_element_wait_and_sendkeys("id", "port", sysport)
u'''点击syslog保存'''
def click_syslog_save(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_click_EC("id", "save_syslog")
u'''获取syslogip值'''
def get_syslog_port(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
selem = self.getElem.find_element_with_wait_EC("id", "port")
value = selem.get_attribute("value")
return value
u'''获取文件名称'''
def get_file_name(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
selem = self.getElem.find_element_with_wait_EC("xpath", ".//*[@id='content_rt02']/div/table/tbody/tr[2]")
value = selem.get_attribute('id')
return value
u'''编辑syslog
parameter:
- ip:syslogip
- port:端口
'''
def set_syslog(self, port, ip='no'):
time.sleep(3)
self.comsuit.switch_to_moudle(u'系统配置', u'关联服务')
self.command.click_left_rule(1)
if ip != 'no':
self.set_syslogip(ip)
self.set_port(port)
self.click_syslog_save()
self.frameElem.switch_to_content()
self.cmf.click_msg_button(1)
u'''检验syslog端口是否为备份之前信息
parameter:
- port:端口
- checklog:检验信息
'''
def check_syslog_content(self, port, checklog):
self.comsuit.switch_to_moudle(u'系统配置', u'关联服务')
self.command.click_left_rule(1)
elemText = self.get_syslog_port()
strdata3 = self.cnEn.is_float(port)
if elemText == strdata3:
self.log.log_detail(checklog, True)
else:
self.log.log_detail(checklog, False)
u'''校验用户或者角色信息
Parameters:
- namevalue:传入的要被查询名称
- name:表格列的name属性
- checklog:日志信息
return：定位该名称位于第几行
'''
def check_content(self,namevalue, name, checklog):
row = self.cmf.find_row_by_name(namevalue, name)
if row != 0:
self.log.log_detail(checklog, True)
else:
self.log.log_detail(checklog, False)
u'''填写用户信息
parameters:
account : 用户账号
name : 用户名称
pwd : 用户密码
agpwd : 确认密码
'''
def set_user_info(self, account, name, pwd, agpwd):
self.comsuit.switch_to_moudle(u"运维管理", u"用户")
self.frameElem.from_frame_to_otherFrame("mainFrame")
self.userElem.add_button()
self.userElem.set_user_account(account)
self.userElem.set_user_name(name)
self.userElem.set_user_pwd(pwd)
self.userElem.set_user_enquire_pwd(agpwd)
self.userElem.save_button()
self.frameElem.switch_to_content()
self.cmf.click_login_msg_button()
u'''点击用户操作列对应的删除按钮
parameters:
- account : 用户账号
'''
def del_user_info(self, account):
self.comsuit.switch_to_moudle(u"运维管理", u"用户")
self.frameElem.from_frame_to_otherFrame("mainFrame")
self.userElem.operate_delete(account)
self.frameElem.switch_to_content()
self.cmf.click_msg_button(1)
self.frameElem.switch_to_content()
self.cmf.click_msg_button(1)
u'''点击备份还原配置文件的删除
parameters:
- filename : 文件名称
- loginfo : 日志信息
'''
def del_backup_file(self, filename, loginfo):
self.click_operat_file(filename, 2)
self.frameElem.switch_to_content()
self.cmf.click_msg_button(1)
self.frameElem.switch_to_content()
self.cmf.click_msg_button(1)
time.sleep(1)
self.log.log_detail(loginfo, True)
u'''执行还原操作
parameters:
- filename :执行还原的文件名称
- loginfo :日志信息
- stauts :状态1代表执行操作列按钮2代表进行上传后操作列按钮
'''
def execute_restore(self, filename, loginfo, stauts=1):
self.comsuit.switch_to_moudle(u'系统配置', u'备份还原')
self.command.click_left_rule(0)
self.select_backup_menu(1)
if stauts == 1:
self.click_operat_file(filename, 3)
elif stauts == 2:
self.upload_click_operat_file(filename, 3)
time.sleep(8)
self.frameElem.switch_to_content()
self.getElem.find_element_with_wait_EC("classname", "aui_state_highlight")
time.sleep(5)
self.cmf.click_msg_button(1)
self.log.log_detail(loginfo, True)
u'''配置备份信息
parameters:
- data :数据文件集
- backMsg :保存成功的弹出框信息
- flag :无检查点的测试项标识，如果为True说明通过
'''
def config_backup(self, data, backMsg, flag):
self.comsuit.switch_to_moudle(u'系统配置', u'备份还原')
self.command.click_left_rule(0)
self.check_config(data[12])
self.select_backup_mode(data[4])
self.backup_time(data[5], data[6])
self.select_storage_location(data[7])
self.click_save()
time.sleep(3)
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", backMsg, data, flag)
self.click_backup_immediately()
time.sleep(2)
self.frameElem.switch_to_content()
self.cmf.click_msg_button(1)
self.log.log_detail(data[9], True)
self.select_backup_menu(1)
u'''执行日期
Parameters:
- type :t代表今天，c代表clear，q代表确定，默认选择今天
- backuptime :执行日期设定的日期，格式为2016-9-7 11:42:42
'''
def backup_time(self, types, backuptime):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
# 时间控件的fram的xpath
fxpath = "//iframe[@hidefocus='true']"
# 日期控件table的xpath路径
txpath = "/html/body/div/div[3]/table"
status = self.cnEn.is_float('1')
type = self.cnEn.is_float(types)
# 转成datetime对象
date = datetime(*xldate_as_tuple(backuptime, 0))
end = date.strftime('%Y-%m-%d %H:%M:%S')
self.option_time("backUpTime", fxpath, status, type, txpath, end)
u'''操作时间控件
Parameters:
- wdateId：日期控件input控件的ID值
- fxpath：日期控件frame的xpath路径
- status: 日期控件是否有时分秒
- txpath：日期控件table的xpath路径
- time：设定的日期，格式为2016-9-7 11:42:42
- type：t代表今天，c代表clear，q代表确定，默认选择今天
'''
def option_time(self,wdateId,fxpath,status='0',type='t',txpath = None,dtime = None):
self.getElem.find_element_wait_and_click("id",wdateId)
frame = self.driver.find_element_by_xpath(fxpath)
self.driver.switch_to_frame(frame)
if type == 't':
self.getElem.find_element_wait_and_click("id","dpTodayInput")
elif type == 'c':
self.getElem.find_element_wait_and_click("id","dpClearInput")
elif type == 'q':
if dtime is not None:
list = dtime.split()
ymdList = list[0].split("-")
hmsList = list[1].split(":")
#年
tYear = ymdList[0]
#月
tMon = ymdList[1]
#日
tDay = ymdList[2]
#时
tHour = hmsList[0]
#分
tMin = hmsList[1]
#秒
tSen = hmsList[2]
dTitle = self.getElem.find_element_with_wait("id","dpTitle").find_elements_by_tag_name("input")
#设定月
dTitle[0].clear()
dTitle[0].send_keys(tMon)
#设定年
dTitle[1].clear()
dTitle[1].send_keys(tYear)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_click_EC("id", "backUpTime")
self.driver.switch_to_frame(frame)
if txpath is not None:
iStatus = False
for itr in range(7):
if itr != 0:
for itd in range(7):
ct = self.tableElem.get_table_cell_text(txpath,itr,itd)[0]
#排除第一行大于7的
if itr == 1 and int(ct) > 7:
continue
#排除倒数第二行小于15的
if itr == 5 and int(ct) < 15:
continue
#排除最后一行小于15的
if itr == 6 and int(ct) < 15:
continue
#如果跟给定的日期一致，点击日期
if int(ct) == int(tDay):
self.tableElem.get_table_cell_text(txpath,itr,itd)[1].click()
iStatus = True
break
#找到日期后跳出循环
if iStatus:
break
#日期控件是否有时分秒
if status == '1':
dTime = self.getElem.find_element_with_wait("id","dpTime").find_elements_by_tag_name("input")
#设定小时
dTime[0].clear()
dTime[0].send_keys(tHour)
#设定分钟
dTime[2].clear()
dTime[2].send_keys(tMin)
#设定秒
dTime[4].clear()
dTime[4].send_keys(tSen)
self.getElem.find_element_wait_and_click("id","dpOkInput")
u'''上传操作
parameters:
- filename :执行还原的文件名称
- loginfo :日志信息
'''
def backup_file_upload(self, filename, loginfo):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
value = "C:\Users\Administrator\Downloads\\" + filename+""
self.getElem.find_element_wait_and_sendkeys("id", "backUpFile", value)
time.sleep(2)
self.getElem.find_element_wait_and_click_EC("id", "up_file")
self.frameElem.switch_to_content()
self.cmf.click_msg_button(1)
time.sleep(1)
self.log.log_detail(loginfo, True)
class testCommand(object):
def __init__(self, driver):
self.driver = driver
self.log = log()
self.cmf = commonFun(driver)
self.frameElem = frameElement(driver)
self.testrole = testRole(driver)
self.command = CommandRule(driver)
self.sso = testSso(driver)
self.comsuit = CommonSuiteData(driver)
u'''获取测试数据
Parameters:
- sheetname:sheet名称
return：表格数据
'''
def get_table_data(self, sheetname):
dataFile = dataFileName()
comrulPath = dataFile.get_command_test_data_url()
comrulData = dataFile.get_data(comrulPath, sheetname)
return comrulData
u'''添加命令规则'''
def add_command_rule_001(self):
#日志开始记录
self.log.log_start("add_command_rule")
#获取添加命令规则测试数据
comrulData = self.get_table_data("add_command_rule")
#保存成功的弹出框
comrulMsg = self.testrole.popup()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(comrulData)):
data = comrulData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
self.command.click_add_button()
self.command.select_command_type((data[2]))
self.command.set_command(data[3])
self.command.click_add_command_button()
self.command.set_test_command(data[4])
self.command.click_test_command_button()
self.cmf.click_login_msg_button()
if int(data[2]) == 2:
self.command.click_approver_command()
self.command.check_all_user()
self.command.click_add_users_button()
self.command.check_all_user()
self.command.click_add_resource_button()
self.command.check_all_resource()
self.command.click_save_command()
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data,
flag)
self.command.click_back_command()
except Exception as e:
print("add_command_rule fail:" + str(e))
self.log.log_end("add_command_rule")
u'''编辑命令规则'''
def mod_command_rule_002(self):
#日志开始记录
self.log.log_start("mod_command_rule")
#获取编辑命令规则测试数据
comrulData = self.get_table_data("mod_command_rule")
#保存成功的弹出框
comrulMsg = self.testrole.popup()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(comrulData)):
data = comrulData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
self.command.click_action_public_command(data[2], data[3])
self.command.set_command(data[4])
self.command.click_add_command_button()
self.command.click_save_command()
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data,
flag)
self.command.click_back_command()
except Exception as e:
print("mod_command_rule fail:" + str(e))
self.log.log_end("mod_command_rule")
u'''操作命令规则'''
def option_command_rule_003(self):
#日志开始记录
self.log.log_start("option_command_rule")
#获取操作命令规则测试数据
comrulData = self.get_table_data("option_command_rule")
#保存成功的弹出框
comrulMsg = self.testrole.popup()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(comrulData)):
data = comrulData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
if dataRow == 1:
self.command.click_del_command()
elif dataRow == 2:
self.command.click_deploy_command()
elif dataRow == 3 or dataRow == 4:
self.command.click_action_public_command(
data[2], data[3])
elif dataRow == 5 or dataRow == 6:
time.sleep(5)
self.command.click_action_public_command(
data[2], data[3])
self.command.set_row_command(data[4])
self.command.check_sure_button()
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data,
flag)
time.sleep(3)
self.command.click_cancel_button()
continue
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data,
flag)
except Exception as e:
print("option_command_rule fail:" + str(e))
self.log.log_end("option_command_rule")
u'''校验命令规则'''
def check_command_rule_004(self):
#日志开始记录
self.log.log_start("check_command_rule")
#获取校验命令规则测试数据
comrulData = self.get_table_data("check_command_rule")
#保存成功的弹出框
comrulMsg = self.testrole.popup()
self.command.click_add_button()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(comrulData)):
data = comrulData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
if data[2] != "no":
self.command.select_command_type((data[2]))
if data[3] != "no":
self.command.set_command(data[3])
self.command.click_add_command_button()
if data[4] != "no":
self.command.set_test_command(data[4])
self.command.click_test_command_button()
if dataRow == 4:
self.command.click_save_command()
elif dataRow == 5:
self.command.click_add_users_button()
self.command.check_all_user()
self.command.click_save_command()
elif dataRow == 6:
self.command.click_add_resource_button()
self.command.check_all_resource()
self.command.click_save_command()
elif dataRow == 7:
self.command.click_approver_command()
self.command.check_all_user()
self.command.clear_command()
self.command.click_save_command()
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data,
flag)
except Exception as e:
print("check_command_rule fail:" + str(e))
self.command.click_back_command()
self.log.log_end("check_command_rule")
u'''命令审批'''
def command_approval_005(self):
self.frameElem.from_frame_to_otherFrame("topFrame")
self.cmf.select_role_by_text(u"运维操作员")
#日志开始记录
self.log.log_start("command_approval")
#获取命令审批测试数据
comrulData = self.get_table_data("command_approval")
for dataRow in range(len(comrulData)):
data = comrulData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
self.command.sso_command(data)
handles = self.driver.window_handles
if dataRow == 2:
self.command.command_by_message_approval(
data[6], data[7], data[8])
self.cmf.click_login_msg_button()
self.driver.switch_to.window(handles[1])
self.driver.close()
self.driver.switch_to.window(handles[0])
#关闭浏览器
self.log.log_detail(data[0], True)
except Exception as e:
print("command_approval fail:" + str(e))
self.log.log_end("command_approval")
u'''删除命令规则'''
def del_command_rule_006(self):
# self.comsuit.sys_switch_to_dep()
# self.comsuit.switch_to_moudle(u"运维管理", u"规则定义")
#日志开始记录
self.log.log_start("del_command_rule")
#获取删除命令规则测试数据
comrulData = self.get_table_data("del_command_rule")
#保存成功的弹出框
comrulMsg = self.testrole.popup()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(comrulData)):
data = comrulData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
self.command.click_action_public_command(data[2], data[3])
self.command.click_del_command()
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data,
flag)
self.cmf.click_login_msg_button()
except Exception as e:
print("del_command_rule fail:" + str(e))
self.log.log_end("del_command_rule")
class testAddress(object):
def __init__(self, driver):
self.driver = driver
self.log = log()
self.cmf = commonFun(driver)
self.frameElem = frameElement(driver)
self.testrole = testRole(driver)
self.command = CommandRule(driver)
self.comsuit = CommonSuiteData(driver)
self.timerule = TimeRule(driver)
self.getElem = getElement(driver)
self.loginElem = loginPage(driver)
self.adrerule = AddressRule(driver)
u'''获取测试数据
Parameters:
- sheetname:sheet名称
return：表格数据
'''
def get_table_data(self, sheetname):
dataFile = dataFileName()
adrerulePath = dataFile.get_adrerule_test_data_url()
adreruleData = dataFile.get_data(adrerulePath, sheetname)
return adreruleData
u'''添加地址规则'''
def add_address_rule_001(self):
#日志开始记录
self.log.log_start("add_address_rule")
#获取添加地址规则测试数据
adreruleData = self.get_table_data("add_address_rule")
#保存成功的弹出框
comrulMsg = self.testrole.popup()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(adreruleData)):
data = adreruleData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
self.command.click_add_button()
self.adrerule.set_rulename((data[2]))
self.timerule.select_depart(data[3])
self.timerule.set_status_type(data[4])
self.adrerule.checkbox_ip_rule(data[5])
self.adrerule.set_ip(data[6])
self.adrerule.set_ip_mask(data[7])
if dataRow != 1 and dataRow != 5:
if dataRow == 3 or dataRow == 7:
self.adrerule.click_add_ip_segment()
self.adrerule.set_ip_start(data[9])
self.adrerule.set_ip_end(data[10])
else:
self.adrerule.set_ip_test(data[8])
self.adrerule.click_test()
self.cmf.click_msg_button(1)
self.adrerule.set_description(data[11])
self.adrerule.click_save()
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data,
flag)
self.command.click_back_command()
self.comsuit.switch_to_moudle(u'运维管理', u'用户')
self.adrerule.edit_user_address_rule(data[12], data[13])
self.comsuit.switch_to_moudle(u'运维管理', u'规则定义')
self.command.click_left_rule(2)
except Exception as e:
print("add_address_rule fail:" + str(e))
self.comsuit.user_quit()
self.log.log_end("add_address_rule")
u'''添加地址规则结果'''
def add_address_rule_result_002(self):
#日志开始记录
self.log.log_start("add_address_rule_result")
#获取添加地址规则测试数据
adreruleData = self.get_table_data("add_address_rule")
#保存成功的弹出框
comrulMsg = self.testrole.popup()
for dataRow in range(len(adreruleData)):
data = adreruleData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
list = [data[14], data[15], data[16], data[17], data[18]]
self.loginElem.login(list)
self.frameElem.from_frame_to_otherFrame("topFrame")
if self.getElem.is_element_exsit('id', "logout"):
self.comsuit.user_quit()
flag = True
self.cmf.test_win_check_point("xpath", comrulMsg, list,
flag)
except Exception as e:
print("add_address_rule_result fail:" + str(e))
self.comsuit.login_and_switch_to_dep()
self.comsuit.switch_to_moudle(u'运维管理', u'规则定义')
self.command.click_left_rule(2)
self.log.log_end("add_address_rule_result")
u'''编辑地址规则'''
def mod_address_rule_003(self):
#日志开始记录
self.log.log_start("mod_address_rule")
#获取编辑地址规则测试数据
adreruleData = self.get_table_data("mod_address_rule")
#保存成功的弹出框
comrulMsg = self.testrole.popup()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(adreruleData)):
data = adreruleData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
self.adrerule.click_edit_address(data[2])
self.adrerule.set_rulename((data[3]))
self.timerule.set_status_type(data[4])
self.adrerule.checkbox_ip_rule(data[5])
self.adrerule.set_ip(data[6])
self.adrerule.set_ip_mask(data[7])
self.adrerule.set_ip_start(data[8])
self.adrerule.set_ip_end(data[9])
self.adrerule.set_description(data[10])
self.adrerule.click_save()
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data,
flag)
self.command.click_back_command()
except Exception as e:
print("mod_address_rule fail:" + str(e))
self.log.log_end("mod_address_rule")
u'''校验地址规则'''
def check_address_rule_004(self):
#日志开始记录
self.log.log_start("check_address_rule")
#获取校验地址规则测试数据
adreruleData = self.get_table_data("check_address_rule")
#保存成功的弹出框
comrulMsg = self.testrole.popup()
self.command.click_add_button()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(adreruleData)):
data = adreruleData[dataRow]
try:
if dataRow != 0:
#如果不是第一行标题，则读取数据
if dataRow == 2:
self.adrerule.checkbox_ip_rule(data[3])
elif dataRow == 3 or dataRow == 4:
self.adrerule.set_ip(data[4])
elif dataRow == 5:
self.adrerule.set_ip_mask(data[5])
elif dataRow != 1:
self.adrerule.set_rulename(data[2])
self.adrerule.click_save()
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data,
flag)
except Exception as e:
print("check_address_rule fail:" + str(e))
self.command.click_back_command()
self.log.log_end("check_address_rule")
u'''检索地址规则'''
def query_address_rule_005(self):
#日志开始记录
self.log.log_start("query_address_rule")
#获取检索地址规则测试数据
adreruleData = self.get_table_data("query_address_rule")
for dataRow in range(len(adreruleData)):
data = adreruleData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
self.timerule.click_reset_time()
if dataRow != 4:
self.adrerule.set_search_addressname((data[1]))
self.adrerule.click_search_address()
self.log.log_detail(data[0], True)
except Exception as e:
print("query_address_rule fail:" + str(e))
self.log.log_end("query_address_rule")
u'''删除地址规则'''
def del_address_rule_006(self):
#日志开始记录
self.log.log_start("del_address_rule")
#获取删除地址规则测试数据
adrerulData = self.get_table_data("del_address_rule")
#保存成功的弹出框
comrulMsg = self.testrole.popup()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(adrerulData)):
data = adrerulData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
if dataRow == 1:
self.adrerule.click_bulkdel_address()
else:
self.adrerule.click_del_address(data[2])
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data,
flag)
if dataRow != 1:
self.cmf.click_login_msg_button()
except Exception as e:
print("del_address_rule fail:" + str(e))
self.log.log_end("del_address_rule")
class testCommand(object):
def __init__(self,driver):
self.driver = driver
self.log = log()
self.cmf = commonFun(driver)
self.frameElem = frameElement(driver)
self.testrole = testRole(driver)
self.command = CommandRule(driver)
self.sso = testSso(driver)
self.comsuit = CommonSuiteData(driver)
u'''获取测试数据
Parameters:
- sheetname:sheet名称
return：表格数据
'''
def get_table_data(self, sheetname):
dataFile = dataFileName()
comrulPath = dataFile.get_command_test_data_url()
comrulData = dataFile.get_data(comrulPath, sheetname)
return comrulData
u'''添加命令规则'''
def add_command_rule_001(self):
#日志开始记录
self.log.log_start("add_command_rule")
#获取添加命令规则测试数据
comrulData = self.get_table_data("add_command_rule")
#保存成功的弹出框
comrulMsg = self.testrole.popup()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(comrulData)):
data = comrulData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
self.command.click_add_button()
self.command.select_command_type((data[2]))
self.command.set_command(data[3])
self.command.click_add_command_button()
self.command.set_test_command(data[4])
self.command.click_test_command_button()
self.cmf.click_login_msg_button()
if int(data[2]) == 2:
self.command.click_approver_command()
self.command.check_all_user()
self.command.click_add_users_button()
self.command.check_all_user()
self.command.click_add_resource_button()
self.command.check_all_resource()
self.command.click_save_command()
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data, flag)
self.command.click_back_command()
except Exception as e:
print ("add_command_rule fail:" + str(e))
self.log.log_end("add_command_rule")
u'''编辑命令规则'''
def mod_command_rule_002(self):
#日志开始记录
self.log.log_start("mod_command_rule")
#获取编辑命令规则测试数据
comrulData = self.get_table_data("mod_command_rule")
#保存成功的弹出框
comrulMsg = self.testrole.popup()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(comrulData)):
data = comrulData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
self.command.click_action_public_command(data[2], data[3])
self.command.set_command(data[4])
self.command.click_add_command_button()
self.command.click_save_command()
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data, flag)
self.command.click_back_command()
except Exception as e:
print ("mod_command_rule fail:" + str(e))
self.log.log_end("mod_command_rule")
u'''操作命令规则'''
def option_command_rule_003(self):
#日志开始记录
self.log.log_start("option_command_rule")
#获取操作命令规则测试数据
comrulData = self.get_table_data("option_command_rule")
#保存成功的弹出框
comrulMsg = self.testrole.popup()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(comrulData)):
data = comrulData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
if dataRow == 1:
self.command.click_del_command()
elif dataRow == 2:
self.command.click_deploy_command()
elif dataRow == 3 or dataRow == 4:
self.command.click_action_public_command(data[2], data[3])
elif dataRow == 5 or dataRow == 6:
time.sleep(5)
self.command.click_action_public_command(data[2], data[3])
self.command.set_row_command(data[4])
self.command.check_sure_button()
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data, flag)
time.sleep(3)
self.command.click_cancel_button()
continue
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data, flag)
except Exception as e:
print ("option_command_rule fail:" + str(e))
self.log.log_end("option_command_rule")
u'''校验命令规则'''
def check_command_rule_004(self):
#日志开始记录
self.log.log_start("check_command_rule")
#获取校验命令规则测试数据
comrulData = self.get_table_data("check_command_rule")
#保存成功的弹出框
comrulMsg = self.testrole.popup()
self.command.click_add_button()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(comrulData)):
data = comrulData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
if data[2] != "no":
self.command.select_command_type((data[2]))
if data[3] != "no":
self.command.set_command(data[3])
self.command.click_add_command_button()
if data[4] != "no":
self.command.set_test_command(data[4])
self.command.click_test_command_button()
if dataRow == 4:
self.command.click_save_command()
elif dataRow == 5:
self.command.click_add_users_button()
self.command.check_all_user()
self.command.click_save_command()
elif dataRow == 6:
self.command.click_add_resource_button()
self.command.check_all_resource()
self.command.click_save_command()
elif dataRow == 7:
self.command.click_approver_command()
self.command.check_all_user()
self.command.clear_command()
self.command.click_save_command()
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data, flag)
except Exception as e:
print ("check_command_rule fail:" + str(e))
self.command.click_back_command()
self.log.log_end("check_command_rule")
u'''命令审批'''
def command_approval_005(self):
self.frameElem.from_frame_to_otherFrame("topFrame")
self.cmf.select_role_by_text(u"运维操作员")
#日志开始记录
self.log.log_start("command_approval")
#获取命令审批测试数据
comrulData = self.get_table_data("command_approval")
for dataRow in range(len(comrulData)):
data = comrulData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
self.command.sso_command(data)
handles = self.driver.window_handles
if dataRow == 2:
self.command.command_by_message_approval(data[6], data[7], data[8])
self.cmf.click_login_msg_button()
self.driver.switch_to.window(handles[1])
self.driver.close()
self.driver.switch_to.window(handles[0])
#关闭浏览器
self.log.log_detail(data[0], True)
except Exception as e:
print ("command_approval fail:" + str(e))
self.log.log_end("command_approval")
u'''删除命令规则'''
def del_command_rule_006(self):
# self.comsuit.sys_switch_to_dep()
# self.comsuit.switch_to_moudle(u"运维管理", u"规则定义")
#日志开始记录
self.log.log_start("del_command_rule")
#获取删除命令规则测试数据
comrulData = self.get_table_data("del_command_rule")
#保存成功的弹出框
comrulMsg = self.testrole.popup()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(comrulData)):
data = comrulData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
self.command.click_action_public_command(data[2], data[3])
self.command.click_del_command()
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data, flag)
self.cmf.click_login_msg_button()
except Exception as e:
print ("del_command_rule fail:" + str(e))
self.log.log_end("del_command_rule")
class CommonSuiteData():
def __init__(self, driver):
self.driver = driver
self.dataFile = dataFileName()
self.cmf = commonFun(self.driver)
self.initDriver = initDriver()
self.loginElem = loginPage(self.driver)
self.roleElem = Role(self.driver)
self.userElem = UserPage(self.driver)
self.frameElem = frameElement(self.driver)
self.authElem = AuthMethodPage(self.driver)
self.dptment = Department(self.driver)
self.resource = Resource(self.driver)
self.account = Accountmgr(self.driver)
self.windowsElem = WindowsResource(self.driver)
self.databaseElem = DatabaseResource(self.driver)
self.usergroup = Usergroup(self.driver)
self.regroup = Regroup(self.driver)
self.appElem = AppPage(self.driver)
self.authorizationElem = AuthorizationPage(self.driver)
self.testAutho = testAuthorization(self.driver)
self.clientElem = ClientPage(self.driver)
self.command = CommandRule(self.driver)
self.ntp = NtpService(self.driver)
self.mail = MailPage(self.driver)
self.syslog = Syslog(driver)
self.ssoElem = SsoPage(self.driver)
self.alarm = AlarmPage(self.driver)
self.PwdStr = PwdStrategy(self.driver)
self.passwdenvelope = EnvelopePage(self.driver)
u'''切换模块
parameter:
levelText1 : 一级模块名称
levelText2 : 二级模块名称
'''
def switch_to_moudle(self, levelText1, levelText2):
time.sleep(2)
self.frameElem.from_frame_to_otherFrame("topFrame")
self.cmf.select_menu(levelText1)
self.cmf.select_menu(levelText1, levelText2)
#----------------------------------------用户相关------------------------------
u'''填写用户信息
parameters:
data[1] : 用户名称
data[3] : 用户账号
data[4] : 用户密码
data[5] : 确认密码
data[6] : 开始时间
data[7] : 访问方式
data[8] : AD域账号
roleText : 用户角色
'''
def set_user_basic_info(self, data, roleText, status='no'):
self.frameElem.from_frame_to_otherFrame("mainFrame")
if status != 'no':
self.userElem.add_role_button()
else:
self.userElem.add_button()
self.userElem.set_user_account(data[3])
self.userElem.set_user_name(data[1])
self.userElem.set_user_pwd(data[4])
self.userElem.set_user_enquire_pwd(data[5])
self.userElem.set_start_time(data[6])
if data[12] != "":
self.userElem.set_user_email(data[12])
if data[10] != "":
self.userElem.set_dep(data[10])
if data[7] != "":
#设置访问方式
self.userElem.click_advanced_option()
self.userElem.set_auth_method_rule(data[7])
#访问方式不是默认方式
if int(data[7]) != 2:
self.userElem.set_ad_name(data[8])
if data[9] != "":
self.userElem.set_user_role(roleText)
self.userElem.click_role_add_button()
self.userElem.save_button()
self.cmf.click_login_msg_button()
u'''删除用户'''
def del_user(self):
self.switch_to_moudle(u"运维管理", u"用户")
self.frameElem.from_frame_to_otherFrame("mainFrame")
self.userElem.select_all_button()
self.userElem.del_button()
self.frameElem.switch_to_content()
self.cmf.click_login_msg_button()
self.cmf.click_login_msg_button()
u'''用户退出'''
def user_quit(self):
self.loginElem.quit()
#-----------------------------部门--------------------------------------------
u'''填写部门名称
parameters :
data[0] : 部门名称
data[1] : 操作类型(添加：0)
data[2] : 添加的部门名称
'''
def set_dep(self, data):
self.switch_to_moudle(u"运维管理", u"组织定义")
self.dptment.click_left_department()
#点击展开按钮
self.dptment.click_dept_switch()
self.dptment.click_basic_operation(data[0], int(data[1]))
self.dptment.popup_sendkey(data[2])
self.dptment.click_ok_button()
self.cmf.click_login_msg_button()
def set_del_dep(self, data):
self.switch_to_moudle(u"运维管理", u"组织定义")
self.dptment.click_left_department()
self.dptment.click_dept_switch()
self.dptment.click_basic_operation(data[0], int(data[1]))
self.cmf.click_login_msg_button()
self.cmf.click_login_msg_button()
#-----------------------------用户组------------------------------------------
u'''添加用户到用户组'''
def set_user_to_group(self, data):
# self.usergroup.click_left_usergroup()
# self.usergroup.click_usergroup_switch()
self.usergroup.click_usergroup_add_user(data[3], data[4])
self.regroup.check_depart(data[5])
self.usergroup.click_usergroup_add_user_query()
self.regroup.check_all_resource()
self.regroup.click_resource_okbutton()
self.cmf.click_login_msg_button()
u'''填写用户组信息
parameters:
data[0] : 操作类型(添加：0)
data[1] : 部门名称
data[2] : 编辑的用户组名称
data[3] : 添加的用户组名称
'''
def set_add_user_group(self, data):
self.switch_to_moudle(u"运维管理", u"组织定义")
self.usergroup.click_left_usergroup()
self.usergroup.click_usergroup_switch()
self.usergroup.usergroup_click_basic_operation(int(data[0]), data[1],
data[2])
self.dptment.popup_sendkey(data[3])
self.dptment.click_ok_button()
self.cmf.click_login_msg_button()
if data[4] != "":
self.set_user_to_group(data)
u'''删除用户组
parameters :
data[0] : 操作类型(删除:4)
data[1] : 部门名称
data[2] : 删除的用户组名称
'''
def set_del_user_group(self, data):
self.switch_to_moudle(u"运维管理", u"组织定义")
self.usergroup.click_left_usergroup()
self.usergroup.click_usergroup_switch()
self.usergroup.usergroup_click_basic_operation(int(data[0]), data[1],
data[2])
self.cmf.click_login_msg_button()
self.cmf.click_login_msg_button()
#-----------------------------资源组------------------------------------------
u'''添加资源到资源组'''
def set_res_to_group(self, data):
self.regroup.click_regroup_add_resouce(data[3], data[4])
self.regroup.check_depart(data[5])
self.regroup.click_regroup_add_resouce_query()
self.regroup.check_all_resource()
self.regroup.click_resource_okbutton()
time.sleep(1)
self.cmf.click_login_msg_button()
u'''填写资源组信息
parameters:
data[0] : 操作类型(添加：0)
data[1] : 部门名称
data[2] : 编辑的资源组名称
data[3] : 添加的资源组名称
'''
def set_add_res_group(self, data):
self.switch_to_moudle(u"运维管理", u"组织定义")
self.regroup.click_left_regroup()
self.regroup.click_regroup_switch()
self.regroup.regroup_click_basic_operation(int(data[0]), data[1],
data[2])
self.dptment.popup_sendkey(data[3])
self.dptment.click_ok_button()
self.cmf.click_login_msg_button()
if data[4] != "":
self.set_res_to_group(data)
u'''删除资源组
parameters :
data[0] : 操作类型(删除:4)
data[1] : 部门名称
data[2] : 删除的资源组名称
'''
def set_del_res_group(self, data):
self.switch_to_moudle(u"运维管理", u"组织定义")
self.regroup.click_left_regroup()
self.regroup.click_regroup_switch()
self.regroup.regroup_click_basic_operation(int(data[0]), data[1],
data[2])
self.cmf.click_login_msg_button()
self.cmf.click_login_msg_button()
#-----------------------------资源--------------------------------------------
u'''填写资源基本信息
parameters :
data[0]:资源类型
data[1]:资源名称
data[2]:资源IP
data[3]:部门
'''
def set_resource_info(self, data):
self.switch_to_moudle(u"运维管理", u"资源")
self.frameElem.from_frame_to_otherFrame("mainFrame")
self.resource.click_add_edit_button()
self.resource.select_resource_type(data[0])
self.resource.set_resource_name(data[1])
self.resource.set_resource_ip(data[2])
if data[3] != 'no':
time.sleep(5)
self.resource.set_depart(data[3])
#选择协议
if data[4] != "":
self.resource.select_agreement(data[4])
if data[5] != "":
self.resource.click_account_sync()
self.resource.set_admin_account(data[5])
self.resource.set_admin_pwd(data[6])
self.resource.set_confirm_pwd(data[7])
#提权口令
if data[8] != "":
self.resource.click_up_super()
self.resource.set_super_pwd(data[8])
self.resource.set_super_confirm_pwd(data[9])
#填写域名
if data[10] != "":
self.databaseElem.set_domain_name(data[10])
#账号分类
if data[11] != "":
self.resource.click_account_sync()
self.windowsElem.select_account_type(data[11])
#归属域控主机
if data[12] != "":
self.windowsElem.select_attach_domian(data[12])
#主机名
if data[13] != "":
self.databaseElem.set_host_name(data[13])
self.resource.click_save_button()
self.cmf.click_login_msg_button()
time.sleep(3)
# self.driver.implicitly_wait(3)
self.cmf.back()
u'''填写数据库基本信息'''
def set_database_res_info(self, data):
self.switch_to_moudle(u"运维管理", u"资源")
self.frameElem.from_frame_to_otherFrame("mainFrame")
self.resource.click_add_edit_button()
self.resource.select_resource_type(data[2])
self.databaseElem.add_edit_database_resource(data)
self.cmf.click_login_msg_button()
time.sleep(3)
self.cmf.back()
u'''填写资源账号基本信息
parameters:
data[1]:资源名称
data[4] : 账号编辑方式
data[5] : 账号名称
data[6] : 口令
data[7] : 确认口令
'''
def set_res_account(self, data):
self.switch_to_moudle(u"运维管理", u"资源")
self.account.click_account_manage_button(data[0])
time.sleep(1)
self.account.click_account_add_edit_button(data[2])
self.account.select_edit_way(data[1])
if data[2] != "no":
self.account.set_account_name(data[2])
self.account.set_account_pwd(data[3])
self.account.set_account_confirm_pwd(data[4])
self.account.set_authorize()
self.account.click_save_account()
self.cmf.click_login_msg_button()
#-----------------------------授权----------------------------------------
u'''填写授权基本信息
parameters:
data[1]:授权名称
data[2]:部门名称
data[3]:状态
'''
def set_authorization(self, data):
self.switch_to_moudle(u'运维管理', u'授权')
self.authorizationElem.add_button()
self.authorizationElem.set_auth_name(data[1])
self.authorizationElem.set_dep(data[2], data[3])
self.authorizationElem.click_add_user()
self.authorizationElem.set_select_user_search_button()
self.authorizationElem.set_user_check_all_button()
self.authorizationElem.set_ok_button()
#添加资源
self.authorizationElem.click_add_res()
self.authorizationElem.set_select_res_search_button()
self.authorizationElem.set_res_check_all_button()
self.authorizationElem.set_ok_button()
self.authorizationElem.save_button()
self.cmf.click_login_msg_button()
self.cmf.back()
#---------------------------------填写应用发布信息----------------------------
u'''填写应用发布信息'''
def set_application_info(self, data):
self.switch_to_moudle(u"系统配置", u"关联服务")
self.appElem.app_module_button()
self.appElem.click_add_button()
self.appElem.set_name(data[0])
self.appElem.set_ip(data[1])
self.appElem.set_app_account(data[3])
self.appElem.set_pwd(data[4])
self.appElem.set_repwd(data[5])
self.appElem.ip_is_succ()
self.appElem.click_save_button()
self.cmf.click_login_msg_button()
u'''删除应用发布'''
def del_application(self, rowList):
self.switch_to_moudle(u"系统配置", u"关联服务")
self.appElem.app_module_button()
self.frameElem.from_frame_to_otherFrame("rigthFrame")
app_data = self.get_table_data("add_application")
for dataRow in rowList:
data = app_data[dataRow]
if dataRow != 0:
self.appElem.operate_del(data[0])
self.cmf.click_login_msg_button()
self.cmf.click_login_msg_button()
#-------------------------------------客户端-----------------------------------
u'''填写客户端基本信息'''
def set_client_info(self, data):
#self.switch_to_moudle(u"系统配置",u"客户端配置")
self.frameElem.from_frame_to_otherFrame("mainFrame")
self.clientElem.add_button()
self.clientElem.set_client_name(data[2])
self.clientElem.set_action_stream(data[3])
self.clientElem.set_database_res_type(data[0], data[1])
self.clientElem.save_button()
u'''删除客户端'''
def set_delete_client_info(self, data):
#self.switch_to_moudle(u"系统配置",u"客户端配置")
self.frameElem.from_frame_to_otherFrame("mainFrame")
self.clientElem.select_query_res_type(data[0], data[1])
self.clientElem.click_query_button()
self.clientElem.del_operation(data[2])
self.cmf.click_login_msg_button()
#------------------------------资源账号授权------------------------------------
u'''添加用户和资源账号类型的授权'''
def set_authorization_info(self, data):
self.switch_to_moudle(u"运维管理", u"授权")
self.testAutho.common_part(data)
self.testAutho.add_user(data)
self.authorizationElem.click_add_res_account()
self.authorizationElem.set_select_res_ip(data[6])
self.authorizationElem.set_select_res_account(data[8])
self.authorizationElem.set_select_res_search_button()
self.authorizationElem.set_res_check_all_button()
self.authorizationElem.set_ok_button()
self.authorizationElem.res_account_status()
self.authorizationElem.save_button()
self.cmf.click_login_msg_button()
u'''删除授权'''
def del_authorization(self):
self.switch_to_moudle(u"运维管理", u"授权")
self.frameElem.from_frame_to_otherFrame("mainFrame")
self.authorizationElem.check_all()
self.authorizationElem.del_button()
self.cmf.click_login_msg_button()
self.cmf.click_login_msg_button()
#-----------------------------数据----------------------------------------
u'''获取数据
Parameters:
- sheetname:sheet名称
return：表格数据
'''
def get_table_data(self, sheetname):
filePath = self.dataFile.get_common_suite_test_data_url()
fileData = self.dataFile.get_data(filePath, sheetname)
return fileData
u'''添加应用发布'''
def add_application(self, rowList):
app_data = self.get_table_data('add_application')
for dataRow in rowList:
data = app_data[dataRow]
if dataRow != 0:
self.set_application_info(data)
u'''初始化用户登录'''
def isomper_login(self):
login_data = self.get_table_data('add_user')
logindata = login_data[4]
self.loginElem.login(logindata)
u'''添加用户数据模板'''
def add_user_data_module(self, rowList):
self.switch_to_moudle(u"运维管理", u"用户")
user_data = self.get_table_data("add_user")
for dataRow in rowList:
data = user_data[dataRow]
if dataRow != 0:
self.set_user_basic_info(data, data[9], data[13])
self.userElem.click_back_button()
u'''添加系统管理员和部门管理员的用户'''
def add_user_with_role(self):
rowList = [1]
self.add_user_data_module(rowList)
u'''登录并切换至角色公用方法
parameters:
login_status ：'no'(登录状态：没有登录)
'''
def login_and_switch_to_common(self, login_status='no'):
login_data = self.get_table_data("add_user")
logindata = login_data[1]
if login_status == 'no':
self.loginElem.login(logindata)
#获取角色
roleList = logindata[9].split(',')
return roleList
u'''使用系统管理员登录系统'''
def login_sysadmin(self):
login_data = self.get_table_data('add_user')
logindata = login_data[1]
self.loginElem.login(logindata)
u'''使用安全保密管理员登录系统'''
def login_secadmin(self):
login_data = self.get_table_data('add_user')
logindata = login_data[2]
self.loginElem.login(logindata)
u'''使用安全审计员登录系统'''
def login_sysaudit(self):
login_data = self.get_table_data('add_user')
logindata = login_data[3]
self.loginElem.login(logindata)
u'''用户登录系统'''
def login_user(self, row):
login_data = self.get_table_data('add_user')
logindata = login_data[int(row)]
self.loginElem.login(logindata)
u'''切换至运维操作员'''
def switch_to_operation(self):
self.cmf.select_role_by_text(u"运维操作员")
#使用新添加的用户登录
def use_new_user_login(self):
login_data = self.get_table_data("add_user")
logindata = login_data[1]
time.sleep(2)
self.loginElem.login(logindata)
u'''运维管理员登录'''
def sso_user_login(self, rowList):
login_data = self.get_table_data("add_user")
logindata = login_data[rowList]
time.sleep(1)
self.loginElem.login(logindata)
u'''运维管理员AD域方式登录'''
def sso_user_ad_login(self, rowList):
login_data = self.get_table_data("add_user")
logindata = login_data[rowList]
self.frameElem.switch_to_content()
self.loginElem.set_login_method(logindata[2])
self.loginElem.set_ad_login_username(logindata[3])
self.loginElem.set_ad_login_pwd(logindata[11])
time.sleep(1)
self.loginElem.click_login_button()
u'''添加认证配置'''
def add_meth_method(self):
meth_data = self.get_table_data("meth_method")
methData = meth_data[1]
self.switch_to_moudle(u"策略配置", u"认证强度")
self.authElem.select_all_auth(methData)
u'''会话配置,设置最大登录数'''
def set_login_max_num(self):
self.loginElem.set_max_login_count()
u'''添加登录测试数据'''
def add_login_data(self):
rowList = [2, 3, 4, 5, 6, 7]
self.add_user_data_module(rowList)
u'''添加授权用户'''
def add_authorization_user(self):
rowList = [8, 9, 10, 11, 12]
self.add_user_data_module(rowList)
u'''添加应用发布用户'''
def add_app_user(self):
rowList = [3]
self.add_user_data_module(rowList)
u'''添加单点登录用户'''
def add_sso_user(self):
rowList = [6, 8, 9, 10, 11, 13]
self.add_user_data_module(rowList)
u'''添加部门'''
def add_dep(self, rowList):
dep_data = self.get_table_data("add_dep")
for dataRow in rowList:
data = dep_data[dataRow]
if dataRow != 0:
self.set_dep(data)
u'''删除部门'''
def del_dep(self, rowList):
dep_data = self.get_table_data("del_dep")
for dataRow in rowList:
data = dep_data[dataRow]
if dataRow != 0:
self.set_del_dep(data)
u'''增加资源数据模板'''
def add_resource_modele(self, rowList):
res_data = self.get_table_data("add_res")
for dataRow in rowList:
data = res_data[dataRow]
if dataRow != 0:
self.set_resource_info(data)
u'''添加授权资源'''
def add_resource(self):
rowList = [1, 2]
self.add_resource_modele(rowList)
u'''添加sso资源'''
def add_sso_resource(self):
#rowList = [1,2,3,4,5,7,8]
rowList = [1, 3, 4, 5]
self.add_resource_modele(rowList)
u'''添加依附操作系统'''
def add_database_resource(self):
rowList = [2]
self.add_resource_modele(rowList)
u'''添加资源账号数据模板'''
def add_res_account_module(self, rowList):
account_data = self.get_table_data("res_account")
for dataRow in rowList:
data = account_data[dataRow]
if dataRow != 0:
self.set_res_account(data)
u'''添加授权资源账号'''
def add_res_account(self):
rowList = [1, 3]
self.add_res_account_module(rowList)
u'''添加sso资源账号'''
def add_sso_res_account(self):
rowList = [1, 2, 4, 5, 6, 7]
#rowList = [1,2,3,4,5,6,7,9,10]
self.add_res_account_module(rowList)
u'''添加用户组'''
def add_user_group(self, rowList):
user_group_data = self.get_table_data("add_user_group")
for dataRow in rowList:
data = user_group_data[dataRow]
if dataRow != 0:
self.set_add_user_group(data)
u'''删除用户组'''
def del_user_group(self, rowList):
user_group_data = self.get_table_data("del_user_group")
for dataRow in rowList:
data = user_group_data[dataRow]
if dataRow != 0:
self.set_del_user_group(data)
u'''添加资源组'''
def add_res_group(self, rowList):
res_group_data = self.get_table_data("add_res_group")
for dataRow in rowList:
data = res_group_data[dataRow]
if dataRow != 0:
self.set_add_res_group(data)
u'''删除资源组'''
def del_res_group(self, rowList):
res_group_data = self.get_table_data("del_res_group")
for dataRow in rowList:
data = res_group_data[dataRow]
if dataRow != 0:
self.set_del_res_group(data)
u'''添加授权'''
def add_authrization(self, rowList):
auth_data = self.get_table_data("add_authorization")
for dataRow in rowList:
data = auth_data[dataRow]
if dataRow != 0:
self.set_authorization(data)
u'''添加授权数据模板'''
def add_authorization_module(self, rowList):
autho_data = self.get_table_data("add_account_auth")
for dataRow in rowList:
data = autho_data[dataRow]
if dataRow != 0:
self.set_authorization_info(data)
self.authorizationElem.back_button()
u'''添加单点登录授权'''
def add_sso_authorization(self):
rowList = [1]
#rowList = [1,2,3,4,5,6,7]
self.add_authorization_module(rowList)
u'''单点登录模板'''
def sso_module(self, rowList):
sso_data = self.get_table_data("sso")
for dataRow in rowList:
data = sso_data[dataRow]
if dataRow != 0:
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.ssoElem.select_account(data[0], data[1])
self.ssoElem.select_sso_icon(data[0], data[2])
if data[3] != "":
self.ssoElem.select_protocol(data[3])
#self.ssoElem.execute_chrome_key()
self.ssoElem.choice_browser(data[2], data[4], data[5], data[6])
u'''添加客户端数据模板'''
def add_client_module(self, rowList):
client_data = self.get_table_data("add_client")
self.switch_to_moudle(u"系统配置", u"客户端配置")
for dataRow in rowList:
data = client_data[dataRow]
if dataRow != 0:
self.set_client_info(data)
u'''删除客户端数据模板'''
def del_client_module(self, rowList):
client_data = self.get_table_data("del_client")
self.switch_to_moudle(u"系统配置", u"客户端配置")
for dataRow in rowList:
data = client_data[dataRow]
if dataRow != 0:
self.set_delete_client_info(data)
u'''添加数据库资源模板'''
def add_database_res_module(self, rowList):
database_data = self.get_table_data("add_database")
for dataRow in rowList:
data = database_data[dataRow]
if dataRow != 0:
self.set_database_res_info(data)
u'''删除用户数据模板'''
def del_user_data_module(self, rowList):
self.switch_to_moudle(u"运维管理", u"用户")
self.frameElem.from_frame_to_otherFrame("mainFrame")
user_data = self.get_table_data("add_user")
for dataRow in rowList:
data = user_data[dataRow]
if dataRow != 0:
self.switch_to_moudle(u"运维管理", u"用户")
self.userElem.operate_delete(data[1])
self.frameElem.switch_to_content()
self.cmf.click_login_msg_button()
self.cmf.click_login_msg_button()
u'''添加密码策略数据模板'''
def add_strategy_data_module(self, rowList):
self.switch_to_moudle(u"策略配置", u"密码策略")
self.frameElem.from_frame_to_otherFrame("mainFrame")
pwd_data = self.get_table_data("add_strategy")
for dataRow in rowList:
data = pwd_data[dataRow]
if dataRow != 0:
self.PwdStr.add_pwd_button()
self.PwdStr.set_pwd_name(data[1])
self.PwdStr.term_of_validity(data[2])
self.PwdStr.password_length_min(data[3])
self.PwdStr.password_length_max(data[4])
self.PwdStr.set_lower_case(data[5])
self.PwdStr.set_capital(data[6])
self.PwdStr.set_minimum_digital(data[7])
self.PwdStr.set_Minimum_symbol(data[8])
self.PwdStr.save_button()
self.frameElem.switch_to_content()
self.cmf.click_msg_button(1)
self.PwdStr.return_button()
u'''删除密码策略数据模板'''
def del_strategy_data_module(self, rowList):
self.switch_to_moudle(u"策略配置", u"密码策略")
self.frameElem.from_frame_to_otherFrame("mainFrame")
pwd_data = self.get_table_data("add_strategy")
for dataRow in rowList:
data = pwd_data[dataRow]
if dataRow != 0:
self.PwdStr.del_sing_strategy(data[1])
self.frameElem.switch_to_content()
self.cmf.click_login_msg_button()
self.cmf.click_login_msg_button()
u'''删除资源数据模板'''
def del_resource_modele(self, rowList):
self.switch_to_moudle(u"运维管理", u"资源")
self.frameElem.from_frame_to_otherFrame("mainFrame")
res_data = self.get_table_data("add_res")
for dataRow in rowList:
data = res_data[dataRow]
if dataRow != 0:
self.resource.click_del_button(data[1])
self.frameElem.switch_to_content()
self.cmf.click_login_msg_button()
self.cmf.click_login_msg_button()
u'''删除授权数据模板'''
def del_authorization_module(self, rowList):
self.switch_to_moudle(u'运维管理', u'授权')
self.frameElem.from_frame_to_otherFrame("mainFrame")
autho_data = self.get_table_data("add_account_auth")
for dataRow in rowList:
data = autho_data[dataRow]
if dataRow != 0:
self.authorizationElem.click_auth_checkbox(data[2])
self.authorizationElem.del_button()
self.frameElem.switch_to_content()
self.cmf.click_login_msg_button()
self.cmf.click_login_msg_button()
#-------------------------------添加涉密版用户前置条件---------------------------------------
u'''前置条件通用'''
def secret_user_prefix_condition(self):
self.isomper_login()
self.switch_to_moudle(u'角色管理', u'角色定义')
#------------------------------部门前置条件-----------------------------------
def depart_module_prefix_condition(self):
#使用系统管理员登录
self.login_sysadmin()
#切换到组织定义
self.switch_to_moudle(u"运维管理", u"组织定义")
#------------------------------资源组前置条件-----------------------------------
def regroup_module_prefix_condition(self):
#使用安全保密管理员登录
self.login_secadmin()
#添加资源
self.add_resource_modele([9, 6])
self.user_quit()
#使用系统管理员登录
self.login_sysadmin()
#切换到组织定义
self.switch_to_moudle(u"运维管理", u"组织定义")
def regroup_module_post_condition(self):
self.user_quit()
#使用安全保密管理员登录
self.login_secadmin()
#删除资源
self.del_resource_modele([9, 6])
self.user_quit()
#------------------------------用户组前置条件-----------------------------------
def usergroup_module_prefix_condition(self):
#使用系统管理员登录
self.login_sysadmin()
#添加用户
self.add_user_data_module([5, 6, 7, 8])
#切换到组织定义
self.switch_to_moudle(u"运维管理", u"组织定义")
def usergroup_module_post_condition(self):
self.del_user_data_module([5, 6, 7, 8])
self.user_quit()
#------------------------------NTP服务前置条件---------------------------------
def ntp_module_prefix_condition(self):
#使用系统管理员登录
self.login_sysadmin()
#切换到NTP服务
self.switch_to_moudle(u'系统配置', u'关联服务')
self.ntp.click_left_moudle(0)
#-------------------------------SYSLOG前置条件---------------------------------
def syslog_module_prefix_condition(self):
#使用系统管理员登录
self.login_sysadmin()
#切换到NTP服务
self.switch_to_moudle(u'系统配置', u'关联服务')
self.ntp.click_left_moudle(1)
#------------------------------邮件前置条件---------------------------------
def mail_module_prefix_condition(self):
#使用系统管理员登录
self.login_sysadmin()
#切换到邮件服务
self.switch_to_moudle(u'系统配置', u'关联服务')
self.mail.click_left_moudle_test()
#------------------------------密码信封前置条件---------------------------------
def passwd_envelope_module_prefix_condition(self):
#使用系统管理员登录
self.login_sysadmin()
#切换到邮件服务
self.switch_to_moudle(u'系统配置', u'关联服务')
self.passwdenvelope.click_left_moudle_envelope()
#-------------------------------应用发布后置条件-------------------------------
def application_module_prefix_condition(self):
#使用系统管理员登录
self.login_sysadmin()
self.add_user_data_module([9, 10])
self.switch_to_moudle(u"系统配置", u"关联服务")
def application_module_post_condition(self):
self.del_user_data_module([9, 10])
self.user_quit()
#-------------------------------网卡配置前置条件-------------------------------
def network_card_module_prefix_condition(self):
#使用系统管理员登录
self.login_sysadmin()
#切换到网卡配置
self.switch_to_moudle(u'系统配置', u'网络配置')
#-------------------------------路由配置前置条件-------------------------------
def routing_module_prefix_condition(self):
#使用系统管理员登录
self.login_sysadmin()
#切换到路由配置
self.cmf.select_menu(u'系统配置', u'网络配置', u'路由配置')
#------------------------------备份还原前置条件-----------------------------------
def backup_restore_module_prefix_condition(self):
#使用系统管理员登录
self.login_sysadmin()
#-----------------------------客户端配置前置条件------------------------------
def client_module_prefix_condition(self):
#使用系统管理员登录
self.login_sysadmin()
self.switch_to_moudle(u"系统配置", u"客户端配置")
#-----------------------------AD域抽取前置条件------------------------------
def ad_module_prefix_condition(self):
#使用系统管理员登录
self.login_sysadmin()
self.add_user_data_module([18])
self.switch_to_moudle(u"系统配置", u"AD定时抽取")
u'''AD域抽取后置条件'''
def ad_module_post_condition(self):
self.del_user_data_module([18])
self.user_quit()
#------------------------------使用授权前置条件---------------------------------
def use_auth_module_prefix_condition(self):
#使用系统管理员登录
self.login_sysadmin()
self.switch_to_moudle(u'系统配置', u'使用授权')
#------------------------------用户模块前置条件--------------------------------
u'''用户模块前置条件'''
def user_module_prefix_condition(self):
#使用系统管理员登录
self.login_sysadmin()
self.switch_to_moudle(u'运维管理', u'用户')
#--------------------------认证方式前置条件------------------------------------
u'''认证方式前置条件'''
def auth_method_prefix_condition(self):
#使用安全保密管理员登录
self.login_secadmin()
self.add_user_data_module([11])
self.switch_to_moudle(u"策略配置", u"认证强度")
self.frameElem.from_frame_to_otherFrame("mainFrame")
u'''认证方式后置条件'''
def auth_method_post_condition(self):
self.del_user_data_module([11])
self.user_quit()
#---------------------------------登录模块前置条件-----------------------------
u'''登录模块前置条件'''
def login_module_prefix_condition(self):
#使用安全保密管理员登录
self.login_secadmin()
#配置认证方式
self.add_meth_method()
#配置最大登录数
self.set_login_max_num()
#添加登录用户数据
self.add_user_data_module([12, 13, 14, 15, 16, 17])
#改变a的状态为关
self.userElem.change_user_status_off("gyrlogin2")
#系统管理员退出
self.user_quit()
u'''登录模块后置条件'''
def login_module_post_condition(self):
#使用安全保密管理员登录
self.login_secadmin()
#删除认证方式
self.authElem.del_auth_method()
self.del_user_data_module([12, 13, 14, 15, 16, 17])
self.user_quit()
#------------------------------告警策略前置条件---------------------------------
def alarm_strategy_module_prefix_condition(self):
#使用安全保密管理员登录
self.login_secadmin()
def alarm_strategy_module_post_condition(self):
self.alarm.del_command_config()
self.alarm.del_default_config()
self.alarm.del_auth_config()
self.user_quit()
#------------------------------会话配置前置条件--------------------------------
def session_module_prefix_condition(self):
#使用安全保密管理员登录
self.login_secadmin()
self.switch_to_moudle(u"策略配置", u"会话配置")
#------------------------------密码策略前置条件--------------------------------
def pwdstr_module_prefix_condition(self):
#使用安全保密管理员登录
self.login_secadmin()
#添加资源
self.add_resource_modele([14])
self.add_user_data_module([19])
self.switch_to_moudle(u"策略配置", u"密码策略")
def pwdstr_module_post_condition(self):
self.del_resource_modele([14])
self.del_user_data_module([19])
self.user_quit()
#------------------------------linux资源前置条件-----------------------------------
def linuxre_module_prefix_condition(self):
#使用安全保密管理员登录
self.login_secadmin()
#添加密码策略
self.add_strategy_data_module([1])
#切换到资源
self.switch_to_moudle(u"运维管理", u"资源")
def linuxre_module_post_condition(self):
#删除密码策略
self.del_strategy_data_module([1])
self.user_quit()
#------------------------------network资源前置条件-----------------------------------
def networkre_module_prefix_condition(self):
#使用安全保密管理员登录
self.login_secadmin()
#切换到资源
self.switch_to_moudle(u"运维管理", u"资源")
#------------------------------windows资源前置条件-----------------------------------
def windowre_module_prefix_condition(self):
#使用安全保密管理员登录
self.login_secadmin()
#添加密码策略
self.add_strategy_data_module([2])
#切换到资源
self.switch_to_moudle(u"运维管理", u"资源")
def windowre_module_post_condition(self):
#删除密码策略
self.del_strategy_data_module([2])
self.user_quit()
#-----------------------------数据库前置条件----------------------------------
def database_resource_prefix_condition(self):
self.login_sysadmin()
#添加应用发布
self.add_application([1])
self.user_quit()
#使用安全保密管理员登录
self.login_secadmin()
self.add_resource_modele([17])
self.switch_to_moudle(u"运维管理", u"资源")
def database_resource_post_condition(self):
self.del_resource_modele([17])
self.user_quit()
self.login_sysadmin()
self.del_application([1])
self.user_quit()
#------------------------------授权前置条件-----------------------------------
def authori_module_prefix_condition(self):
#使用安全保密管理员登录
self.login_secadmin()
self.add_resource_modele([15, 16])
self.add_res_account_module([18, 19])
self.user_quit()
self.login_sysadmin()
#添加授权用户
self.add_user_data_module([20, 21, 22, 23, 24])
self.add_res_group([1])
self.add_user_group([1])
self.user_quit()
self.login_secadmin()
self.switch_to_moudle(u'运维管理', u'授权')
def authori_module_post_condition(self):
self.del_resource_modele([15, 16])
self.user_quit()
self.login_sysadmin()
self.del_res_group([1])
self.del_user_group([1])
self.del_user_data_module([20, 21, 22, 23, 24])
self.user_quit()
#------------------------------命令规则前置条件-----------------------------------
def commandrule_module_prefix_condition(self):
self.login_sysadmin()
#添加用户
self.add_user_data_module([25])
self.user_quit()
self.login_secadmin()
#添加资源
self.add_resource_modele([3])
#添加资源账号
self.add_res_account_module([4])
#添加授权
self.add_authorization_module([2])
#切换到规则定义
self.switch_to_moudle(u'运维管理', u'规则定义')
self.command.click_left_rule(0)
def commandrule_module_post_condition(self):
#删除授权
self.del_authorization_module([2])
#删除资源
self.del_resource_modele([3])
self.user_quit()
self.login_sysadmin()
#删除用户
self.del_user_data_module([25])
self.user_quit()
#------------------------------时间规则前置条件-----------------------------------
def timerule_module_prefix_condition(self):
self.login_secadmin()
#添加用户
self.add_user_data_module([26, 27, 28, 29, 30])
#切换到规则定义
self.switch_to_moudle(u'运维管理', u'规则定义')
self.command.click_left_rule(1)
def timerule_module_post_condition(self):
#删除用户
self.del_user_data_module([26, 27, 28, 29, 30])
self.user_quit()
#------------------------------地址规则前置条件-----------------------------------
def addressrule_module_prefix_condition(self):
self.login_secadmin()
#添加用户
self.add_user_data_module([31, 32, 33, 34, 35, 36, 37, 38])
#切换到规则定义
self.switch_to_moudle(u'运维管理', u'规则定义')
self.command.click_left_rule(2)
def addressrule_module_post_condition(self):
self.del_user_data_module([31, 32, 33, 34, 35, 36, 37, 38])
self.user_quit()
#------------------------------资源时间规则前置条件-----------------------------------
def retimerule_module_prefix_condition(self):
self.login_sysadmin()
#添加用户
self.add_user_data_module([39])
self.user_quit()
self.login_secadmin()
#添加资源
self.add_resource_modele([4, 5, 10])
#添加资源账号
self.add_res_account_module([5, 6, 14])
self.add_authorization_module([6])
#切换到规则定义
self.switch_to_moudle(u'运维管理', u'规则定义')
self.command.click_left_rule(3)
def retimerule_module_post_condition(self):
self.user_quit()
self.login_sysadmin()
#删除用户
self.del_user_data_module([39])
self.user_quit()
self.login_secadmin()
#删除资源
self.del_resource_modele([4, 5, 10])
#删除授权
self.del_authorization_module([6])
self.user_quit()
#------------------------------流程前置条件-----------------------------------
def process_module_prefix_condition(self):
self.login_sysadmin()
#添加用户
self.add_user_data_module([40, 41, 42, 43, 44])
self.user_quit()
self.login_secadmin()
#添加资源
self.add_resource_modele([11, 12])
#添加资源账号
self.add_res_account_module([15, 16])
self.add_authrization([1])
def process_module_post_condition(self):
#删除授权
self.del_authorization_module([7])
#删除资源
self.del_resource_modele([11, 12])
self.user_quit()
self.login_sysadmin()
#删除用户
self.del_user_data_module([40, 41, 42, 43, 44])
self.user_quit()
#------------------------------双人授权前置条件-----------------------------------
def dualmandate_module_prefix_condition(self):
self.login_sysadmin()
#添加用户
self.add_user_data_module([45, 46])
self.user_quit()
self.login_secadmin()
#添加资源
self.add_resource_modele([13])
#添加资源账号
self.add_res_account_module([17])
#添加授权
self.add_authrization([4])
def dualmandate_module_post_condition(self):
#删除授权
self.del_authorization_module([8])
#删除资源
self.del_resource_modele([13])
self.user_quit()
self.login_sysadmin()
#删除用户
self.del_user_data_module([45, 46])
self.user_quit()
#-----------------------------行为报表前置条件---------------------------------
def opt_report_module_prefix_condition(self):
self.login_secadmin()
self.add_resource_modele([18])
self.user_quit()
self.login_sysadmin()
self.add_user_data_module([47])
self.add_res_group([2])
self.add_user_group([2])
self.user_quit()
self.login_sysaudit()
self.switch_to_moudle(u"报表管理", u"审计报表")
def opt_report_module_post_condition(self):
self.user_quit()
self.login_secadmin()
self.del_resource_modele([18])
self.user_quit()
self.login_sysadmin()
self.del_user_data_module([47])
self.del_res_group([2])
self.del_user_group([2])
self.user_quit()
#-----------------------------配置报表前置条件---------------------------------
def conf_report_module_prefix_condition(self):
self.login_sysadmin()
self.add_user_data_module([48])
self.add_user_group([3])
self.user_quit()
self.login_sysaudit()
self.switch_to_moudle(u"报表管理", u"审计报表")
def conf_report_module_post_condition(self):
self.user_quit()
self.login_sysadmin()
self.del_user_data_module([48])
self.del_user_group([3])
self.user_quit()
#-----------------------------配置审计前置条件------------------------------
def system_log_prefix_condition(self):
self.login_sysadmin()
self.add_user_data_module([49])
self.switch_to_moudle(u"系统配置", u"关联服务")
self.ntp.click_left_moudle(1)
#填写syslog信息
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.syslog.set_ip("172.16.10.11")
self.syslog.set_ident("aa")
self.syslog.save_button()
self.cmf.click_login_msg_button()
self.user_quit()
self.login_sysaudit()
self.switch_to_moudle(u"审计管理", u"配置审计")
def system_log_post_condition(self):
self.user_quit()
self.login_sysadmin()
self.del_user_data_module([49])
self.user_quit()
#-----------------------------运维审计前置条件------------------------------
def audit_log_prefix_condition(self):
self.login_and_switch_to_dep()
self.add_user_data_module([43])
self.add_resource_modele([22])
self.add_res_account_module([20])
self.add_authorization_module([9])
self.switch_to_operation()
self.sso_module([1])
self.user_quit()
#新添加的运维管理员登录
self.sso_user_login(43)
self.sso_module([1])
#新添加的运维管理员退出
self.user_quit()
self.login_and_switch_to_sys()
self.switch_to_moudle(u"审计管理", u"运维审计")
def audit_log_post_condition(self):
self.sys_switch_to_dep()
self.del_authorization_module([9])
self.del_resource_modele([22])
self.del_user_data_module([43])
self.user_quit()
#------------------------------命令单点登录前置条件----------------------------
u'''单点登录前置条件'''
def sso_prefix_condition(self):
self.login_and_switch_to_dep()
self.add_resource_modele([1, 3, 4, 5])
self.add_res_account_module([1, 2, 4, 5, 6, 7])
self.add_authorization_module([1])
self.switch_to_operation()
#self.user_quit()
#self.login_and_switch_to_common()
u'''单点登录后置条件'''
def sso_post_condition(self):
self.user_quit()
self.login_and_switch_to_dep()
self.del_resource_modele([1, 3, 4, 5])
self.del_authorization_module([1])
self.user_quit()
#------------------------------windows单点登录前置条件-------------------------
u'''windows单点登录前置条件'''
def windows_sso_prefix_condition(self):
self.login_and_switch_to_sys()
#配置认证方式
self.add_meth_method()
self.add_user_data_module([42])
self.sys_switch_to_dep()
#self.login_and_switch_to_dep()
self.add_resource_modele([2, 7, 8])
self.add_res_account_module([3, 9, 10])
self.add_authorization_module([3, 4])
self.switch_to_operation()
#self.user_quit()
#self.login_and_switch_to_common()
u'''单点登录后置条件'''
def windows_sso_post_condition(self):
self.user_quit()
self.login_and_switch_to_dep()
self.del_authorization_module([3, 4])
self.del_user_data_module([42])
self.del_resource_modele([8, 7, 2])
self.user_quit()
#------------------------------数据库单点登录前置条件-------------------------
u'''数据库单点登录前置条件'''
def database_sso_prefix_condition(self):
#使用公共用户登录系统
self.login_and_switch_to_sys()
#添加应用发布
self.add_application([2])
#添加客户端
self.add_client_module([1, 2])
self.sys_switch_to_dep()
self.add_database_res_module([1, 2, 3])
self.add_res_account_module([11, 12, 13])
self.add_authorization_module([5])
self.switch_to_operation()
u'''数据库单点登录后置条件'''
def database_sso_post_condition(self):
self.user_quit()
self.login_and_switch_to_dep()
self.del_authorization_module([5])
self.del_resource_modele([19, 20, 21])
self.dep_switch_to_sys()
self.del_application([2])
self.del_client_module([1, 2])
self.user_quit()
class RetimeRule(object):
def __init__(self, driver):
self.driver = driver
self.getElem = getElement(driver)
self.selectElem = selectElement(driver)
self.frameElem = frameElement(driver)
self.cnEn = cnEncode()
self.acproval = Accapproval(driver)
self.command = CommandRule(driver)
self.log = log()
u'''点击删除'''
def click_bulkdel_retime(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_click_EC(
"id", "delete_rule_time_resource")
u'''选择默认动作
Parameters:
- staut:0代表禁止登录，1代表允许登录
'''
def select_default_type(self, state):
try:
valu = self.cnEn.is_float(state)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
selem = self.getElem.find_element_with_wait_EC("id", "defaultType")
self.selectElem.select_element_by_value(selem, valu)
except Exception:
print("Select default action failure")
u'''点击运行状态'''
def click_running_state(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_click_EC("id", "ruleState")
u'''填写每月开始日期
Parameters:
- starttime:每月的开始时间
'''
def set_month_start_time(self, starttime):
valu = self.cnEn.is_float(starttime)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_clear_EC("id", "fortMonthStartTime")
self.getElem.find_element_wait_and_sendkeys("id", "fortMonthStartTime",
valu)
u'''填写每月结束日期
Parameters:
- endtime:每月的结束时间
'''
def set_month_end_time(self, endtime):
valu = self.cnEn.is_float(endtime)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_clear_EC("id", "fortMonthEndTime")
self.getElem.find_element_wait_and_sendkeys("id", "fortMonthEndTime",
valu)
u'''选择每周开始日期
Parameters:
- starttime:每周的开始时间
'''
def set_week_start_time(self, starttime):
valu = self.cnEn.is_float(starttime)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
selem = self.getElem.find_element_with_wait_EC("id",
"fortWeekStartTime")
self.selectElem.select_element_by_value(selem, valu)
u'''选择每周结束日期
Parameters:
- endtime:每周的结束时间
'''
def set_week_end_time(self, endtime):
valu = self.cnEn.is_float(endtime)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
selem = self.getElem.find_element_with_wait_EC("id", "fortWeekEndTime")
self.selectElem.select_element_by_value(selem, valu)
u'''填写每天开始时间
Parameters:
- starttime:每天的开始时间
'''
def set_day_start_time(self, starttime):
valu = self.cnEn.is_float(starttime)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_clear_EC("id", "fortDayStartTime")
self.getElem.find_element_wait_and_sendkeys("id", "fortDayStartTime",
valu)
u'''填写每天结束时间
Parameters:
- endtime:每天的结束时间
'''
def set_day_end_time(self, endtime):
valu = self.cnEn.is_float(endtime)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_clear_EC("id", "fortDayEndTime")
self.getElem.find_element_wait_and_sendkeys("id", "fortDayEndTime",
valu)
u'''选择动作
Parameters:
- staut:0代表禁止登录，1代表允许登录
'''
def select_action(self, state):
valu = self.cnEn.is_float(state)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
if valu == '1':
self.getElem.find_element_wait_and_click_EC("id", "ruleTypePass")
elif valu == '0':
self.getElem.find_element_wait_and_click_EC("id", "ruleTypeDeny")
u'''点击保存'''
def click_save_retime(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_click_EC("id", "save_rule_time")
u'''填写检索的资源名称
Parameters:
- rename:资源名称
'''
def set_query_rename(self, rename):
resname = self.cnEn.is_float(rename)
self.frameElem.from_frame_to_otherFrame("artIframe")
self.getElem.find_element_wait_and_clear_EC("id", "fortResourceName")
self.getElem.find_element_wait_and_sendkeys("id", "fortResourceName",
resname)
u'''勾选某个资源
Parameters:
- rename:资源名称
'''
def check_resource(self, rename):
self.frameElem.from_frame_to_otherFrame("artIframe")
self.set_query_rename(rename)
self.command.click_check_resource()
self.getElem.find_element_wait_and_click_EC("id", "resource_check_all")
self.command.check_sure_button()
u'''点击操作的公共方法
parameter:
- value:序号
- statu:代表点击的操作，1代表勾选复选框；2代表上移；3代表下移；4代表插入；5代表编辑
'''
def click_option_method(self, value, status):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
valu = self.cnEn.is_float(value)
statu = self.cnEn.is_float(status)
# 获取table对象
tableelem = self.getElem.find_element_with_wait_EC(
"id", "content_table")
# 获取table对象下的所有tr
trelems = tableelem.find_elements_by_tag_name("tr")
# 位于第几行
line = 0
# 循环所有tr
for trelem in trelems:
line += 1
# 找到tr下所有td对象
tds = trelem.find_elements_by_tag_name("td")
# 获取td[2]的文本
tdtext = tds[1].text
if tdtext == valu:
#勾选复选框
if statu == '1':
xpath = ".//*[@id='content_table']/tbody/tr[" + str(
line) + "]/td[1]/input[1]"
#上移
elif statu == '2':
xpath = ".//*[@id='content_table']/tbody/tr[" + str(
line) + "]/td[8]/a[1]"
#下移
elif statu == '3':
xpath = ".//*[@id='content_table']/tbody/tr[" + str(
line) + "]/td[8]/a[2]"
#插入
elif statu == '4':
xpath = ".//*[@id='content_table']/tbody/tr[" + str(
line) + "]/td[8]/a[3]"
#编辑
elif statu == '5':
xpath = ".//*[@id='content_table']/tbody/tr[" + str(
line) + "]/td[8]/a[4]"
self.getElem.find_element_wait_and_click_EC("xpath", xpath)
break
u'''校验资源时间规则结果
parameter:
- data:数据集
'''
def check_resource_time_rule(self, data):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
row = self.acproval.select_resoure_sso(data[1])
xpath = "//*[@id='content_table']/tbody/tr[" + str(
row * 2) + "]/td/div/table/tbody/tr/td[2]/a[1]/img"
isExsit = self.getElem.is_element_exsit("xpath", xpath)
if isExsit == True:
self.log.log_detail(data[0], True)
else:
self.log.log_detail(data[0], True)
class RetimeRule(object):
def __init__(self, driver):
self.driver = driver
self.getElem = getElement(driver)
self.selectElem = selectElement(driver)
self.frameElem = frameElement(driver)
self.cnEn = cnEncode()
self.acproval = Accapproval(driver)
self.command = CommandRule(driver)
self.log = log()
u'''点击删除'''
def click_bulkdel_retime(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_click_EC("id", "delete_rule_time_resource")
u'''选择默认动作
Parameters:
- staut:0代表禁止登录，1代表允许登录
'''
def select_default_type(self, state):
try:
valu = self.cnEn.is_float(state)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
selem = self.getElem.find_element_with_wait_EC("id", "defaultType")
self.selectElem.select_element_by_value(selem, valu)
except Exception:
print("Select default action failure")
u'''点击运行状态'''
def click_running_state(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_click_EC("id", "ruleState")
u'''填写每月开始日期
Parameters:
- starttime:每月的开始时间
'''
def set_month_start_time(self, starttime):
valu = self.cnEn.is_float(starttime)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_clear_EC("id", "fortMonthStartTime")
self.getElem.find_element_wait_and_sendkeys("id", "fortMonthStartTime", valu)
u'''填写每月结束日期
Parameters:
- endtime:每月的结束时间
'''
def set_month_end_time(self, endtime):
valu = self.cnEn.is_float(endtime)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_clear_EC("id", "fortMonthEndTime")
self.getElem.find_element_wait_and_sendkeys("id", "fortMonthEndTime", valu)
u'''选择每周开始日期
Parameters:
- starttime:每周的开始时间
'''
def set_week_start_time(self, starttime):
valu = self.cnEn.is_float(starttime)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
selem = self.getElem.find_element_with_wait_EC("id", "fortWeekStartTime")
self.selectElem.select_element_by_value(selem, valu)
u'''选择每周结束日期
Parameters:
- endtime:每周的结束时间
'''
def set_week_end_time(self, endtime):
valu = self.cnEn.is_float(endtime)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
selem = self.getElem.find_element_with_wait_EC("id", "fortWeekEndTime")
self.selectElem.select_element_by_value(selem, valu)
u'''填写每天开始时间
Parameters:
- starttime:每天的开始时间
'''
def set_day_start_time(self, starttime):
valu = self.cnEn.is_float(starttime)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_clear_EC("id", "fortDayStartTime")
self.getElem.find_element_wait_and_sendkeys("id", "fortDayStartTime", valu)
u'''填写每天结束时间
Parameters:
- endtime:每天的结束时间
'''
def set_day_end_time(self, endtime):
valu = self.cnEn.is_float(endtime)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_clear_EC("id", "fortDayEndTime")
self.getElem.find_element_wait_and_sendkeys("id", "fortDayEndTime", valu)
u'''选择动作
Parameters:
- staut:0代表禁止登录，1代表允许登录
'''
def select_action(self, state):
valu = self.cnEn.is_float(state)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
if valu == '1':
self.getElem.find_element_wait_and_click_EC("id", "ruleTypePass")
elif valu == '0':
self.getElem.find_element_wait_and_click_EC("id", "ruleTypeDeny")
u'''点击保存'''
def click_save_retime(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_click_EC("id", "save_rule_time")
u'''填写检索的资源名称
Parameters:
- rename:资源名称
'''
def set_query_rename(self, rename):
resname = self.cnEn.is_float(rename)
self.frameElem.from_frame_to_otherFrame("artIframe")
self.getElem.find_element_wait_and_clear_EC("id", "fortResourceName")
self.getElem.find_element_wait_and_sendkeys("id", "fortResourceName", resname)
u'''勾选某个资源
Parameters:
- rename:资源名称
'''
def check_resource(self, rename):
self.frameElem.from_frame_to_otherFrame("artIframe")
self.set_query_rename(rename)
self.command.click_check_resource()
self.getElem.find_element_wait_and_click_EC("id", "resource_check_all")
self.command.check_sure_button()
u'''点击操作的公共方法
parameter:
- value:序号
- statu:代表点击的操作，1代表勾选复选框；2代表上移；3代表下移；4代表插入；5代表编辑
'''
def click_option_method(self, value, status):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
valu = self.cnEn.is_float(value)
statu = self.cnEn.is_float(status)
# 获取table对象
tableelem = self.getElem.find_element_with_wait_EC("id", "content_table")
# 获取table对象下的所有tr
trelems = tableelem.find_elements_by_tag_name("tr")
# 位于第几行
line = 0
# 循环所有tr
for trelem in trelems:
line += 1
# 找到tr下所有td对象
tds = trelem.find_elements_by_tag_name("td")
# 获取td[2]的文本
tdtext = tds[1].text
if tdtext == valu:
#勾选复选框
if statu == '1':
xpath = ".//*[@id='content_table']/tbody/tr[" + str(line) + "]/td[1]/input[1]"
#上移
elif statu == '2':
xpath = ".//*[@id='content_table']/tbody/tr[" + str(line) + "]/td[8]/a[1]"
#下移
elif statu == '3':
xpath = ".//*[@id='content_table']/tbody/tr[" + str(line) + "]/td[8]/a[2]"
#插入
elif statu == '4':
xpath = ".//*[@id='content_table']/tbody/tr[" + str(line) + "]/td[8]/a[3]"
#编辑
elif statu == '5':
xpath = ".//*[@id='content_table']/tbody/tr[" + str(line) + "]/td[8]/a[4]"
self.getElem.find_element_wait_and_click_EC("xpath", xpath)
break
u'''校验资源时间规则结果
parameter:
- data:数据集
'''
def check_resource_time_rule(self, data):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
row = self.acproval.select_resoure_sso(data[1])
xpath = "//*[@id='content_table']/tbody/tr[" + str(row*2) + "]/td/div/table/tbody/tr/td[2]/a[1]/img"
isExsit = self.getElem.is_element_exsit("xpath", xpath)
if isExsit == True:
self.log.log_detail(data[0], True)
else:
self.log.log_detail(data[0], True)
class testTime(object):
def __init__(self, driver):
self.driver = driver
self.log = log()
self.cmf = commonFun(driver)
self.frameElem = frameElement(driver)
self.command = CommandRule(driver)
self.comsuit = CommonSuiteData(driver)
self.timerule = TimeRule(driver)
self.getElem = getElement(driver)
self.loginElem = loginPage(self.driver)
u'''提示内容框元素路径'''
def div_msg(self):
div_msg = "html/body/div[1]/div/table/tbody/tr[2]/td[2]/div/table/tbody/tr[2]/td[2]/div"
return div_msg
u'''获取测试数据
Parameters:
- sheetname:sheet名称
return：表格数据
'''
def get_table_data(self, sheetname):
dataFile = dataFileName()
timerulPath = dataFile.get_timerule_test_data_url()
timerulData = dataFile.get_data(timerulPath, sheetname)
return timerulData
u'''添加时间规则'''
def add_time_rule_001(self):
#日志开始记录
self.log.log_start("add_time_rule")
#获取添加时间规则测试数据
timerulData = self.get_table_data("add_time_rule")
#保存成功的弹出框
comrulMsg = self.div_msg()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(timerulData)):
data = timerulData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
self.command.click_add_button()
self.timerule.set_rulename((data[2]))
self.timerule.select_depart(data[3])
self.timerule.start_date(data[4])
self.timerule.date_of_termination(data[6], data[7])
self.timerule.set_status_type(data[8])
self.timerule.set_time(data[9], data[10], data[11])
self.timerule.set_descrip(data[12])
self.timerule.click_save_time()
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data,
flag)
self.command.click_back_command()
self.comsuit.switch_to_moudle(u'运维管理', u'用户')
self.timerule.edit_user_time_rule(data[13], data[14])
if dataRow != 5:
self.comsuit.switch_to_moudle(u'运维管理', u'规则定义')
self.command.click_left_rule(1)
except Exception as e:
print("add_time_rule fail:" + str(e))
self.comsuit.user_quit()
self.log.log_end("add_time_rule")
u'''添加时间规则结果'''
def add_time_rule_result_002(self):
#日志开始记录
self.log.log_start("add_time_rule_result")
#获取添加时间规则测试数据
timerulData = self.get_table_data("add_time_rule")
#保存成功的弹出框
comrulMsg = self.div_msg()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(timerulData)):
data = timerulData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
list = [data[15], data[16], data[17], data[18], data[19]]
self.loginElem.login(list)
self.frameElem.from_frame_to_otherFrame("topFrame")
if self.getElem.is_element_exsit('id', "logout"):
self.comsuit.user_quit()
else:
self.cmf.click_login_msg_button()
flag = True
self.cmf.test_win_check_point("xpath", comrulMsg, list,
flag)
except Exception as e:
print("add_time_rule_result fail:" + str(e))
self.comsuit.login_secadmin()
self.comsuit.switch_to_moudle(u'运维管理', u'规则定义')
self.command.click_left_rule(1)
self.log.log_end("add_time_rule_result")
u'''编辑时间规则'''
def mod_time_rule_003(self):
#日志开始记录
self.log.log_start("mod_time_rule")
#获取编辑时间规则测试数据
timerulData = self.get_table_data("mod_time_rule")
#保存成功的弹出框
comrulMsg = self.div_msg()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(timerulData)):
data = timerulData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
self.timerule.click_edit_time(data[2])
self.timerule.set_rulename((data[3]))
self.timerule.start_date(data[4])
self.timerule.date_of_termination(data[5], data[6])
self.timerule.set_status_type(data[7])
self.timerule.deselect_time(data[8], data[9], data[10])
self.timerule.set_time(data[11], data[12], data[13])
self.timerule.set_descrip(data[14])
self.timerule.click_save_time()
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data,
flag)
self.command.click_back_command()
except Exception as e:
print("mod_time_rule fail:" + str(e))
self.log.log_end("mod_time_rule")
u'''校验时间规则'''
def check_time_rule_004(self):
#日志开始记录
self.log.log_start("check_time_rule")
#获取校验时间规则测试数据
timerulData = self.get_table_data("check_time_rule")
#保存成功的弹出框
comrulMsg = self.div_msg()
self.command.click_add_button()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(timerulData)):
data = timerulData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow == 2 or dataRow == 3:
self.timerule.set_rulename((data[2]))
elif dataRow == 4:
self.timerule.select_depart(data[3])
elif dataRow == 5:
self.timerule.start_date(data[4], data[5])
elif dataRow == 6:
self.timerule.date_of_termination(data[6], data[7])
elif dataRow == 7:
self.timerule.start_date(data[4])
elif dataRow == 8 or dataRow == 9:
self.timerule.set_time(data[8], data[9], data[10])
if dataRow != 0:
self.timerule.click_save_time()
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data,
flag)
except Exception as e:
print("check_time_rule fail:" + str(e))
self.command.click_back_command()
self.log.log_end("check_time_rule")
u'''检索时间规则'''
def query_time_rule_005(self):
#日志开始记录
self.log.log_start("query_time_rule")
#获取检索时间规则测试数据
timerulData = self.get_table_data("query_time_rule")
for dataRow in range(len(timerulData)):
data = timerulData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
self.timerule.click_reset_time()
if dataRow != 4:
self.timerule.set_search_timename((data[1]))
self.timerule.click_search_time()
self.log.log_detail(data[0], True)
except Exception as e:
print("query_time_rule fail:" + str(e))
self.log.log_end("query_time_rule")
u'''删除时间规则'''
def del_time_rule_006(self):
#日志开始记录
self.log.log_start("del_time_rule")
#获取删除时间规则测试数据
timerulData = self.get_table_data("del_time_rule")
#保存成功的弹出框
comrulMsg = self.div_msg()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(timerulData)):
data = timerulData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
if dataRow == 1:
self.timerule.click_bulkdel_time()
self.cmf.click_login_msg_button()
self.log.log_detail(data[0], True)
else:
self.timerule.click_del_time(data[2])
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data,
flag)
self.cmf.click_login_msg_button()
except Exception as e:
print("del_time_rule fail:" + str(e))
self.log.log_end("del_time_rule")
class testTime(object):
def __init__(self,driver):
self.driver = driver
self.log = log()
self.cmf = commonFun(driver)
self.frameElem = frameElement(driver)
self.testrole = testRole(driver)
self.command = CommandRule(driver)
self.comsuit = CommonSuiteData(driver)
self.timerule = TimeRule(driver)
self.getElem = getElement(driver)
self.loginElem = loginPage(self.driver)
u'''获取测试数据
Parameters:
- sheetname:sheet名称
return：表格数据
'''
def get_table_data(self, sheetname):
dataFile = dataFileName()
timerulPath = dataFile.get_timerule_test_data_url()
timerulData = dataFile.get_data(timerulPath, sheetname)
return timerulData
u'''添加时间规则'''
def add_time_rule_001(self):
#日志开始记录
self.log.log_start("add_time_rule")
#获取添加时间规则测试数据
timerulData = self.get_table_data("add_time_rule")
#保存成功的弹出框
comrulMsg = self.testrole.popup()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(timerulData)):
data = timerulData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
self.command.click_add_button()
self.timerule.set_rulename((data[2]))
self.timerule.select_depart(data[3])
self.timerule.start_date(data[4])
self.timerule.date_of_termination(data[6], data[7])
self.timerule.set_status_type(data[8])
self.timerule.set_time(data[9], data[10], data[11])
self.timerule.set_descrip(data[12])
self.timerule.click_save_time()
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data, flag)
self.command.click_back_command()
self.comsuit.switch_to_moudle(u'运维管理', u'用户')
self.timerule.edit_user_time_rule(data[13], data[14])
if dataRow != 5:
self.comsuit.switch_to_moudle(u'运维管理', u'规则定义')
self.command.click_left_rule(1)
except Exception as e:
print ("add_time_rule fail:" + str(e))
self.comsuit.user_quit()
self.log.log_end("add_time_rule")
u'''添加时间规则结果'''
def add_time_rule_result_002(self):
#日志开始记录
self.log.log_start("add_time_rule_result")
#获取添加时间规则测试数据
timerulData = self.get_table_data("add_time_rule")
#保存成功的弹出框
comrulMsg = self.testrole.popup()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(timerulData)):
data = timerulData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
list = [data[15], data[16], data[17], data[18], data[19]]
self.loginElem.login(list)
self.frameElem.from_frame_to_otherFrame("topFrame")
if self.getElem.is_element_exsit('id', "logout"):
self.comsuit.user_quit()
else:
self.cmf.click_login_msg_button()
flag = True
self.cmf.test_win_check_point("xpath", comrulMsg, list, flag)
except Exception as e:
print ("add_time_rule_result fail:" + str(e))
self.comsuit.login_and_switch_to_dep()
self.comsuit.switch_to_moudle(u'运维管理', u'规则定义')
self.command.click_left_rule(1)
self.log.log_end("add_time_rule_result")
u'''编辑时间规则'''
def mod_time_rule_003(self):
#日志开始记录
self.log.log_start("mod_time_rule")
#获取编辑时间规则测试数据
timerulData = self.get_table_data("mod_time_rule")
#保存成功的弹出框
comrulMsg = self.testrole.popup()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(timerulData)):
data = timerulData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
self.timerule.click_edit_time(data[2])
self.timerule.set_rulename((data[3]))
self.timerule.start_date(data[4])
self.timerule.date_of_termination(data[5], data[6])
self.timerule.set_status_type(data[7])
self.timerule.deselect_time(data[8], data[9], data[10])
self.timerule.set_time(data[11], data[12], data[13])
self.timerule.set_descrip(data[14])
self.timerule.click_save_time()
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data, flag)
self.command.click_back_command()
except Exception as e:
print ("mod_time_rule fail:" + str(e))
self.log.log_end("mod_time_rule")
u'''校验时间规则'''
def check_time_rule_004(self):
#日志开始记录
self.log.log_start("check_time_rule")
#获取校验时间规则测试数据
timerulData = self.get_table_data("check_time_rule")
#保存成功的弹出框
comrulMsg = self.testrole.popup()
self.command.click_add_button()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(timerulData)):
data = timerulData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow == 2 or dataRow == 3:
self.timerule.set_rulename((data[2]))
elif dataRow == 4:
self.timerule.select_depart(data[3])
elif dataRow == 5:
self.timerule.start_date(data[4], data[5])
elif dataRow == 6:
self.timerule.date_of_termination(data[6], data[7])
elif dataRow == 7:
self.timerule.start_date(data[4])
elif dataRow == 8 or dataRow == 9:
self.timerule.set_time(data[8], data[9], data[10])
if dataRow != 0:
self.timerule.click_save_time()
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data, flag)
except Exception as e:
print ("check_time_rule fail:" + str(e))
self.command.click_back_command()
self.log.log_end("check_time_rule")
u'''检索时间规则'''
def query_time_rule_005(self):
#日志开始记录
self.log.log_start("query_time_rule")
#获取检索时间规则测试数据
timerulData = self.get_table_data("query_time_rule")
for dataRow in range(len(timerulData)):
data = timerulData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
self.timerule.click_reset_time()
if dataRow != 4:
self.timerule.set_search_timename((data[1]))
self.timerule.click_search_time()
self.log.log_detail(data[0], True)
except Exception as e:
print ("query_time_rule fail:" + str(e))
self.log.log_end("query_time_rule")
u'''删除时间规则'''
def del_time_rule_006(self):
#日志开始记录
self.log.log_start("del_time_rule")
#获取删除时间规则测试数据
timerulData = self.get_table_data("del_time_rule")
#保存成功的弹出框
comrulMsg = self.testrole.popup()
#无检查点的测试项标识，如果为True说明通过
flag = False
for dataRow in range(len(timerulData)):
data = timerulData[dataRow]
try:
#如果不是第一行标题，则读取数据
if dataRow != 0:
if dataRow == 1:
self.timerule.click_bulkdel_time()
self.cmf.click_login_msg_button()
self.log.log_detail(data[0],True)
else:
self.timerule.click_del_time(data[2])
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", comrulMsg, data, flag)
self.cmf.click_login_msg_button()
except Exception as e:
print ("del_time_rule fail:" + str(e))
self.log.log_end("del_time_rule")
class Backuprestore(object):
def __init__(self, driver):
self.driver = driver
self.getElem = getElement(driver)
self.selectElem = selectElement(driver)
self.frameElem = frameElement(driver)
self.cmf = commonFun(driver)
self.cnEn = cnEncode()
self.comsuit = CommonSuiteData(self.driver)
self.command = CommandRule(self.driver)
self.tableElem = tableElement(driver)
self.log = log()
self.userElem = UserPage(self.driver)
self.role = Role(driver)
u'''点击自动备份开关'''
def auto_backup_switch(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_click_EC("id", "btn_qh")
u'''勾选系统配置'''
def check_sys_config(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
values = self.check_common()
if values[0] == None:
self.getElem.find_element_wait_and_click_EC("id", "configBackUp")
if values[1] != None:
self.getElem.find_element_wait_and_click_EC("id", "databaseBackUp")
u'''勾选实体配置'''
def check_entity_config(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
values = self.check_common()
if values[0] != None:
self.getElem.find_element_wait_and_click_EC("id", "configBackUp")
if values[1] == None:
self.getElem.find_element_wait_and_click_EC("id", "databaseBackUp")
u'''勾选实体配置和系统配置'''
def check_all_config(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
values = self.check_common()
if values[0] == None:
self.getElem.find_element_wait_and_click_EC("id", "configBackUp")
if values[1] == None:
self.getElem.find_element_wait_and_click_EC("id", "databaseBackUp")
u'''勾选实体或者系统配置公共方法'''
def check_common(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
selem = self.getElem.find_element_with_wait_EC("id", "configBackUp")
value = selem.get_attribute('checked')
selemdb = self.getElem.find_element_with_wait_EC("id", "databaseBackUp")
valuedb = selemdb.get_attribute('checked')
list = [value, valuedb]
return list
u'''勾选实体或者系统配置
parameter:
- stauts:勾选配置信息1代表系统配置2代表实体配置，3代表系统配置和实体配置
'''
def check_config(self, stauts):
staut = self.cnEn.is_float(stauts)
if staut == '1':
self.check_sys_config()
elif staut == '2':
self.check_entity_config()
else:
self.check_all_config()
u'''选择备份方式
parameter:
- stauts:value属性值，1代表一次性执行，2代表周期性执行
'''
def select_backup_mode(self, stauts):
staut = self.cnEn.is_float(stauts)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
selem = self.getElem.find_element_with_wait_EC("id", "backUpType")
self.selectElem.select_element_by_value(selem, staut)
u'''选择执行小时
parameter:
- stauts:value属性值
'''
def select_hour(self, stauts):
staut = self.cnEn.is_float(stauts)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
selem = self.getElem.find_element_with_wait_EC("id", "startHour")
self.selectElem.select_element_by_value(selem, staut)
u'''填写分钟
parameter:
- minute:分钟
'''
def set_minute(self, minute):
minu = self.cnEn.is_float(minute)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_clear_EC("id", "startMinute")
self.getElem.find_element_wait_and_sendkeys("id", "startMinute", minu)
u'''选择执行方式
parameter:
- staut:0代表按天，1代表按周，2代表按月，3代表按年
'''
def select_execu_mode(self, staut):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
if staut == 0:
self.getElem.find_element_wait_and_click_EC("id", "dayradio")
elif staut == 1:
self.getElem.find_element_wait_and_click_EC("id", "weekradio")
elif staut == 2:
self.getElem.find_element_wait_and_click_EC("id", "monthRadio")
else:
self.getElem.find_element_wait_and_click_EC("id", "yearRadio")
u'''选择存储位置
parameter:
- stauts:value属性值1代表本地备份2代表ftp备份
'''
def select_storage_location(self, stauts):
staut = self.cnEn.is_float(stauts)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
selem = self.getElem.find_element_with_wait_EC("id", "backUpLocation")
self.selectElem.select_element_by_value(selem, staut)
u'''填写远程路径
parameter:
- path:远程路径
'''
def set_remote_path(self, path):
pat = self.cnEn.is_float(path)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_clear_EC("id", "path")
self.getElem.find_element_wait_and_sendkeys("id", "path", pat)
u'''填写服务器IP
parameter:
- ip:服务器IP
'''
def set_ftpip(self, ip):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_clear_EC("id", "ip")
self.getElem.find_element_wait_and_sendkeys("id", "ip", ip)
u'''填写连接用户名
parameter:
- minute:连接用户名
'''
def set_name(self, name):
nam = self.cnEn.is_float(name)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_clear_EC("id", "username")
self.getElem.find_element_wait_and_sendkeys("id", "username", nam)
u'''填写连接口令
parameter:
- password:连接口令
'''
def set_password(self, password):
pwd = self.cnEn.is_float(password)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_clear_EC("id", "password")
self.getElem.find_element_wait_and_sendkeys("id", "password", pwd)
u'''填写确认口令
parameter:
- minute:分钟
'''
def set_password_again(self, password):
pwd = self.cnEn.is_float(password)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_clear_EC("id", "passwordAgain")
self.getElem.find_element_wait_and_sendkeys("id", "passwordAgain", pwd)
u'''点击立刻备份'''
def click_backup_immediately(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_click_EC("id", "back_up_now")
u'''点击保存'''
def click_save(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_click_EC("id", "back_up_save")
u'''选择系统备份还原或者查看备份文件
parameter:
- staut:0代表系统备份还原，1代表查看备份文件
'''
def select_backup_menu(self, staut):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
if staut == 0:
self.getElem.find_element_wait_and_click_EC("id", "tit1")
elif staut == 1:
self.getElem.find_element_wait_and_click_EC("id", "tit2")
u'''点击操作列操作
Parameters:
- filename:文件名称
- value:1代表下载，2代表删除，3代表还原
'''
def click_operat_file(self,filename, value):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
row = 1
selems = self.driver.find_elements_by_name("file")
for selem in selems:
idvalue = selem.get_attribute('id')
row = row +1
if idvalue == filename:
xpath = ".//*[@id='content_rt02']/div/table/tbody/tr[" + str(row) + "]/td[7]/input[" + str(value) + "]"
self.getElem.find_element_wait_and_click_EC("xpath", xpath)
time.sleep(1)
u'''下载上传完成后点击操作列操作
Parameters:
- filename:文件名称
- value:1代表下载，2代表删除，3代表还原
'''
def upload_click_operat_file(self,filename, value):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
row = 1
filenames = ""+filename[:-6] + ""+filename+""
selems = self.driver.find_elements_by_name("file")
for selem in selems:
idvalue = selem.get_attribute('id')
row = row +1
if idvalue == filename or idvalue == filenames:
xpath = ".//*[@id='content_rt02']/div/table/tbody/tr[" + str(row) + "]/td[7]/input[" + str(value) + "]"
self.getElem.find_element_wait_and_click_EC("xpath", xpath)
time.sleep(1)
u'''点击还原系统配置'''
def click_restore_sys_config(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_click_EC("id", "deleConfig1")
u'''点击清空数据库'''
def click_reset_database(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_click_EC("id", "resetDataBase1")
u'''点击清空数据库'''
def click_reset_audit(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_click_EC("id", "delAuditFile1")
u'''填写syslogip
parameter:
- syslogip:syslogip
'''
def set_syslogip(self, syslogip):
ip = self.cnEn.is_float(syslogip)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_clear_EC("id", "host")
self.getElem.find_element_wait_and_sendkeys("id", "host", ip)
u'''填写syslog端口
parameter:
- port:syslog端口
'''
def set_port(self, port):
sysport = self.cnEn.is_float(port)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_clear_EC("id", "port")
self.getElem.find_element_wait_and_sendkeys("id", "port", sysport)
u'''点击syslog保存'''
def click_syslog_save(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_click_EC("id", "save_syslog")
u'''获取syslogip值'''
def get_syslog_port(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
selem = self.getElem.find_element_with_wait_EC("id", "port")
value = selem.get_attribute("value")
return value
u'''获取文件名称'''
def get_file_name(self):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
selem = self.getElem.find_element_with_wait_EC("xpath", ".//*[@id='content_rt02']/div/table/tbody/tr[2]")
value = selem.get_attribute('id')
return value
u'''编辑syslog
parameter:
- ip:syslogip
- port:端口
'''
def set_syslog(self, port, ip='no'):
self.comsuit.switch_to_moudle(u'系统配置', u'关联服务')
self.command.click_left_rule(1)
if ip != 'no':
self.set_syslogip(ip)
self.set_port(port)
self.click_syslog_save()
self.frameElem.switch_to_content()
self.cmf.click_msg_button(1)
u'''检验syslog端口是否为备份之前信息
parameter:
- port:端口
- checklog:检验信息
'''
def check_syslog_content(self, port, checklog):
self.comsuit.switch_to_moudle(u'系统配置', u'关联服务')
self.command.click_left_rule(1)
elemText = self.get_syslog_port()
strdata3 = self.cnEn.is_float(port)
if elemText == strdata3:
self.log.log_detail(checklog, True)
else:
self.log.log_detail(checklog, False)
u'''校验用户或者角色信息
Parameters:
- namevalue:传入的要被查询名称
- name:表格列的name属性
- checklog:日志信息
return：定位该名称位于第几行
'''
def check_content(self,namevalue, name, checklog):
row = self.cmf.find_row_by_name(namevalue, name)
if row != 0:
self.log.log_detail(checklog, True)
else:
self.log.log_detail(checklog, False)
u'''填写用户信息
parameters:
account : 用户账号
name : 用户名称
pwd : 用户密码
agpwd : 确认密码
'''
def set_user_info(self, account, name, pwd, agpwd):
self.comsuit.switch_to_moudle(u"运维管理", u"用户")
self.frameElem.from_frame_to_otherFrame("mainFrame")
self.userElem.add_button()
self.userElem.set_user_account(account)
self.userElem.set_user_name(name)
self.userElem.set_user_pwd(pwd)
self.userElem.set_user_enquire_pwd(agpwd)
self.userElem.save_button()
self.frameElem.switch_to_content()
self.cmf.click_login_msg_button()
u'''点击用户操作列对应的删除按钮
parameters:
- account : 用户账号
'''
def del_user_info(self, account):
self.comsuit.switch_to_moudle(u"运维管理", u"用户")
self.frameElem.from_frame_to_otherFrame("mainFrame")
self.userElem.operate_delete(account)
self.frameElem.switch_to_content()
self.cmf.click_msg_button(1)
self.frameElem.switch_to_content()
self.cmf.click_msg_button(1)
u'''点击备份还原配置文件的删除
parameters:
- filename : 文件名称
- loginfo : 日志信息
'''
def del_backup_file(self, filename, loginfo):
self.click_operat_file(filename, 2)
self.frameElem.switch_to_content()
self.cmf.click_msg_button(1)
self.frameElem.switch_to_content()
self.cmf.click_msg_button(1)
time.sleep(1)
self.log.log_detail(loginfo, True)
u'''点击角色操作列对应的删除按钮
parameters:
- rolename : 角色名称
'''
def del_role_info(self, rolename):
self.comsuit.switch_to_moudle(u"角色管理", u"角色定义")
self.frameElem.from_frame_to_otherFrame("mainFrame")
self.role.delete(rolename)
self.frameElem.switch_to_content()
self.cmf.click_msg_button(1)
u'''执行还原操作
parameters:
- filename :执行还原的文件名称
- loginfo :日志信息
- stauts :状态1代表执行操作列按钮2代表进行上传后操作列按钮
'''
def execute_restore(self, filename, loginfo, stauts=1):
self.comsuit.switch_to_moudle(u'系统配置', u'备份还原')
self.command.click_left_rule(0)
self.select_backup_menu(1)
if stauts == 1:
self.click_operat_file(filename, 3)
elif stauts == 2:
self.upload_click_operat_file(filename, 3)
time.sleep(5)
self.frameElem.switch_to_content()
self.getElem.find_element_with_wait_EC("classname", "aui_state_highlight")
time.sleep(3)
self.cmf.click_msg_button(1)
self.log.log_detail(loginfo, True)
u'''配置备份信息
parameters:
- data :数据文件集
- backMsg :保存成功的弹出框信息
- flag :无检查点的测试项标识，如果为True说明通过
'''
def config_backup(self, data, backMsg, flag):
self.comsuit.switch_to_moudle(u'系统配置', u'备份还原')
self.command.click_left_rule(0)
self.check_config(data[12])
self.select_backup_mode(data[4])
self.backup_time(data[5], data[6])
self.select_storage_location(data[7])
self.click_save()
time.sleep(3)
self.frameElem.switch_to_content()
self.cmf.test_win_check_point("xpath", backMsg, data, flag)
self.click_backup_immediately()
time.sleep(2)
self.frameElem.switch_to_content()
self.cmf.click_msg_button(1)
self.log.log_detail(data[9], True)
self.select_backup_menu(1)
u'''填写角色信息
Parameters:
- rolename :角色名称
- shortname :名称简写
'''
def set_role_info(self, rolename, shortname):
self.comsuit.switch_to_moudle(u"角色管理", u"角色定义")
self.frameElem.from_frame_to_otherFrame("mainFrame")
self.role.add()
self.role.edit_rolename(rolename)
self.role.edit_shortname(shortname)
self.role.select_sysrole()
self.role.save_button()
self.frameElem.switch_to_content()
self.cmf.click_msg_button(1)
u'''执行日期
Parameters:
- type :t代表今天，c代表clear，q代表确定，默认选择今天
- backuptime :执行日期设定的日期，格式为2016-9-7 11:42:42
'''
def backup_time(self, types, backuptime):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
# 时间控件的fram的xpath
fxpath = "//iframe[@hidefocus='true']"
# 日期控件table的xpath路径
txpath = "/html/body/div/div[3]/table"
status = self.cnEn.is_float('1')
type = self.cnEn.is_float(types)
# 转成datetime对象
date = datetime(*xldate_as_tuple(backuptime, 0))
end = date.strftime('%Y-%m-%d %H:%M:%S')
self.option_time("backUpTime", fxpath, status, type, txpath, end)
u'''操作时间控件
Parameters:
- wdateId：日期控件input控件的ID值
- fxpath：日期控件frame的xpath路径
- status: 日期控件是否有时分秒
- txpath：日期控件table的xpath路径
- time：设定的日期，格式为2016-9-7 11:42:42
- type：t代表今天，c代表clear，q代表确定，默认选择今天
'''
def option_time(self,wdateId,fxpath,status='0',type='t',txpath = None,dtime = None):
self.getElem.find_element_wait_and_click("id",wdateId)
frame = self.driver.find_element_by_xpath(fxpath)
self.driver.switch_to_frame(frame)
if type == 't':
self.getElem.find_element_wait_and_click("id","dpTodayInput")
elif type == 'c':
self.getElem.find_element_wait_and_click("id","dpClearInput")
elif type == 'q':
if dtime is not None:
list = dtime.split()
ymdList = list[0].split("-")
hmsList = list[1].split(":")
#年
tYear = ymdList[0]
#月
tMon = ymdList[1]
#日
tDay = ymdList[2]
#时
tHour = hmsList[0]
#分
tMin = hmsList[1]
#秒
tSen = hmsList[2]
dTitle = self.getElem.find_element_with_wait("id","dpTitle").find_elements_by_tag_name("input")
#设定月
dTitle[0].clear()
dTitle[0].send_keys(tMon)
#设定年
dTitle[1].clear()
dTitle[1].send_keys(tYear)
self.frameElem.from_frame_to_otherFrame("rigthFrame")
self.getElem.find_element_wait_and_click_EC("id", "backUpTime")
self.driver.switch_to_frame(frame)
if txpath is not None:
iStatus = False
for itr in range(7):
if itr != 0:
for itd in range(7):
ct = self.tableElem.get_table_cell_text(txpath,itr,itd)[0]
#排除第一行大于7的
if itr == 1 and int(ct) > 7:
continue
#排除倒数第二行小于15的
if itr == 5 and int(ct) < 15:
continue
#排除最后一行小于15的
if itr == 6 and int(ct) < 15:
continue
#如果跟给定的日期一致，点击日期
if int(ct) == int(tDay):
self.tableElem.get_table_cell_text(txpath,itr,itd)[1].click()
iStatus = True
break
#找到日期后跳出循环
if iStatus:
break
#日期控件是否有时分秒
if status == '1':
dTime = self.getElem.find_element_with_wait("id","dpTime").find_elements_by_tag_name("input")
#设定小时
dTime[0].clear()
dTime[0].send_keys(tHour)
#设定分钟
dTime[2].clear()
dTime[2].send_keys(tMin)
#设定秒
dTime[4].clear()
dTime[4].send_keys(tSen)
self.getElem.find_element_wait_and_click("id","dpOkInput")
u'''上传操作
parameters:
- filename :执行还原的文件名称
- loginfo :日志信息
'''
def backup_file_upload(self, filename, loginfo):
self.frameElem.from_frame_to_otherFrame("rigthFrame")
value = "C:\Users\Administrator\Downloads\\" + filename+""
self.getElem.find_element_wait_and_sendkeys("id", "backUpFile", value)
time.sleep(2)
self.getElem.find_element_wait_and_click_EC("id", "up_file")
self.frameElem.switch_to_content()
self.cmf.click_msg_button(1)
time.sleep(1)
self.log.log_detail(loginfo, True)