class AddressRule(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.acproval = Accapproval(driver) self.user = UserPage(driver) u'''点击批量删除''' def click_bulkdel_address(self): self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_click_EC("id", "delete_rule_address") u'''点击编辑按钮 Parameters: - addressname:地址规则名称 ''' def click_edit_address(self, addressname): try: self.frameElem.from_frame_to_otherFrame("rigthFrame") row = self.acproval.find_name_by_row(addressname, "fortRuleAddressName") update_xpath = ".//*[@id='content_table']/tbody/tr[" + str(row) + "]/td[5]/input[1]" time.sleep(3) self.getElem.find_element_wait_and_click("xpath", update_xpath) except Exception: print("Click the Edit button to fail") u'''点击删除按钮 Parameters: - addressname:时间规则名称 ''' def click_del_address(self, addressname): try: self.frameElem.from_frame_to_otherFrame("rigthFrame") row = self.acproval.find_name_by_row(addressname, "fortRuleAddressName") del_xpath = ".//*[@id='content_table']/tbody/tr[" + str(row) + "]/td[5]/input[2]" self.getElem.find_element_wait_and_click("xpath", del_xpath) except Exception: print("Click the Del button to fail") u'''填写检索名称 Parameters: - addressname:名称 ''' def set_search_addressname(self, addressname): self.frameElem.from_frame_to_otherFrame("rigthFrame") name = self.cnEn.is_float(addressname) self.getElem.find_element_wait_and_clear("id", "rule_address_id") self.getElem.find_element_wait_and_sendkeys("id", "rule_address_id", name) u'''点击检索按钮''' def click_search_address(self): self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_click_EC("id", "rule_address") u'''填写地址规则名称 Parameters: - rulename:规则名称 ''' def set_rulename(self, rulename): name = self.cnEn.is_float(rulename) self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_clear("id", "fortRuleAddressName") self.getElem.find_element_wait_and_sendkeys("id", "fortRuleAddressName", name) u'''选择IP规则 Parameters: - stauts:1代表勾选IP掩码,2代表勾选IP区间,3代表IP掩码和IP区间 ''' def checkbox_ip_rule(self, stauts): staut = self.cnEn.is_float(stauts) self.frameElem.from_frame_to_otherFrame("rigthFrame") if staut == '1': self.getElem.find_element_wait_and_click_EC("id", "one_ip") elif staut == '2': self.getElem.find_element_wait_and_click_EC("id", "duo_ip") else: self.getElem.find_element_wait_and_click_EC("id", "one_ip") self.getElem.find_element_wait_and_click_EC("id", "duo_ip") u'''点击增加多个IP''' def click_add_more_ip(self): self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_click_EC("id", "add_ip_mask") u'''填写ip地址 Parameters: - iplist:所填写的IP列表集合 ''' def set_ip(self, iplist): self.frameElem.from_frame_to_otherFrame("rigthFrame") #获取所有页面IP地址集合 fortips = self.driver.find_elements_by_name("fortIp") ipaddress = iplist.split() self.ip_mask_common(fortips, ipaddress) u'''填写ip地址掩码 Parameters: - masklist:所填写的IP掩码value值列表集合 ''' def set_ip_mask(self, masklist): self.frameElem.from_frame_to_otherFrame("rigthFrame") #获取所有页面IP掩码集合 fortMasks = self.driver.find_elements_by_name("fortMask") masklists = masklist.split() self.ip_mask_common(fortMasks, masklists) u'''填写IP地址和掩码公共方法 Parameters: - ipsets:页面IP段集合 - dataipsets:列表数据集合 ''' def ip_mask_common(self, ipsets, dataipsets): #获取页面集合长度 ipsetth = len(ipsets) fortth = 0 #循环ip掩码进行填写操作 for ipset in ipsets: if fortth < ipsetth and dataipsets[fortth] != 'no': fortips = self.driver.find_elements_by_name("fortIp") if ipsets == fortips: ipset.clear() ipset.send_keys(dataipsets[fortth]) fortth = fortth + 1 u'''点击增加多个IP段''' def click_add_ip_segment(self): self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_click_EC("id", "add_ip_range") u'''填写起始段IP Parameters: - ipstartlist:所填写的起始段IP列表集合 ''' def set_ip_start(self, ipstartlist): self.frameElem.from_frame_to_otherFrame("rigthFrame") ipstarts = ipstartlist.split() self.ip_segment_common("fortIpStart", ipstarts) u'''填写结束段IP Parameters: - ipendlist:所填写的结束段IP列表集合 ''' def set_ip_end(self, ipendlist): self.frameElem.from_frame_to_otherFrame("rigthFrame") ipends = ipendlist.split() self.ip_segment_common("fortIpEnd", ipends) u'''填写区间段IP公共方法 Parameters: - ipsetname:页面IP段name属性 - dataipsets:列表数据集合 ''' def ip_segment_common(self, ipsetname, dataipsets): #获取所有页面IP段集合 ipsets = self.driver.find_elements_by_name(ipsetname) #获取IP段集合长度 ipsetsth = len(ipsets) fortth = 0 #循环进行段ip填写操作 for ipset in ipsets: if fortth < ipsetsth: ipset.clear() ipset.send_keys(dataipsets[fortth]) fortth = fortth + 1 u'''点击测试''' def click_test(self): self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_click_EC("id", "test_ip") u'''填写测试ip地址 Parameters: - testip:ip地址 ''' def set_ip_test(self, testip): ip = self.cnEn.is_float(testip) self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_clear("id", "testIp") self.getElem.find_element_wait_and_sendkeys("id", "testIp", ip) u'''填写描述信息 Parameters: - description:描述信息 ''' def set_description(self, description): descript = self.cnEn.is_float(description) self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_clear("id", "fortDescription") self.getElem.find_element_wait_and_sendkeys("id", "fortDescription", descript) u'''点击保存''' def click_save(self): self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_click_EC("id", "save_rule_address") u'''点击返回''' def click_back(self): self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_click_EC("id", "history_skip") u'''给用户添加地址规则 Parameters: - username:要编辑的用户名称 - adrerule:地址规则名称 ''' def edit_user_address_rule(self, username, adrerule): self.frameElem.from_frame_to_otherFrame("mainFrame") name = self.cnEn.is_float(username) self.user.operate_edit(name) self.user.click_advanced_option() self.select_adress_rule(adrerule) self.user.save_button() self.cmf.click_login_msg_button() self.user.click_back_button() u'''选择地址规则 Parameters: - adrerule:地址规则名称 ''' def select_adress_rule(self, adrerule): self.frameElem.from_frame_to_otherFrame("mainFrame") addressrule = self.cnEn.is_float(adrerule) select_elem = self.getElem.find_element_with_wait_EC('id',"fortRuleAddressId") self.selectElem.select_element_by_visible_text(select_elem, addressrule)
class AddressRule(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.acproval = Accapproval(driver) self.user = UserPage(driver) u'''点击批量删除''' def click_bulkdel_address(self): self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_click_EC("id", "delete_rule_address") u'''点击编辑按钮 Parameters: - addressname:地址规则名称 ''' def click_edit_address(self, addressname): try: self.frameElem.from_frame_to_otherFrame("rigthFrame") row = self.acproval.find_name_by_row(addressname, "fortRuleAddressName") update_xpath = ".//*[@id='content_table']/tbody/tr[" + str(row) + "]/td[5]/input[1]" time.sleep(3) self.getElem.find_element_wait_and_click("xpath", update_xpath) except Exception: print("Click the Edit button to fail") u'''点击删除按钮 Parameters: - addressname:时间规则名称 ''' def click_del_address(self, addressname): try: self.frameElem.from_frame_to_otherFrame("rigthFrame") row = self.acproval.find_name_by_row(addressname, "fortRuleAddressName") del_xpath = ".//*[@id='content_table']/tbody/tr[" + str(row) + "]/td[5]/input[2]" self.getElem.find_element_wait_and_click("xpath", del_xpath) except Exception: print("Click the Del button to fail") u'''填写检索名称 Parameters: - addressname:名称 ''' def set_search_addressname(self, addressname): self.frameElem.from_frame_to_otherFrame("rigthFrame") name = self.cnEn.is_float(addressname) self.getElem.find_element_wait_and_clear("id", "rule_address_id") self.getElem.find_element_wait_and_sendkeys("id", "rule_address_id", name) u'''点击检索按钮''' def click_search_address(self): self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_click_EC("id", "rule_address") u'''填写地址规则名称 Parameters: - rulename:规则名称 ''' def set_rulename(self, rulename): name = self.cnEn.is_float(rulename) self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_clear("id", "fortRuleAddressName") self.getElem.find_element_wait_and_sendkeys("id", "fortRuleAddressName", name) u'''选择IP规则 Parameters: - stauts:1代表勾选IP掩码,2代表勾选IP区间,3代表IP掩码和IP区间 ''' def checkbox_ip_rule(self, stauts): staut = self.cnEn.is_float(stauts) self.frameElem.from_frame_to_otherFrame("rigthFrame") if staut == '1': self.getElem.find_element_wait_and_click_EC("id", "one_ip") elif staut == '2': self.getElem.find_element_wait_and_click_EC("id", "duo_ip") else: self.getElem.find_element_wait_and_click_EC("id", "one_ip") self.getElem.find_element_wait_and_click_EC("id", "duo_ip") u'''点击增加多个IP''' def click_add_more_ip(self): self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_click_EC("id", "add_ip_mask") u'''填写ip地址 Parameters: - iplist:所填写的IP列表集合 ''' def set_ip(self, iplist): self.frameElem.from_frame_to_otherFrame("rigthFrame") #获取所有页面IP地址集合 fortips = self.driver.find_elements_by_name("fortIp") ipaddress = iplist.split() self.ip_mask_common(fortips, ipaddress) u'''填写ip地址掩码 Parameters: - masklist:所填写的IP掩码value值列表集合 ''' def set_ip_mask(self, masklist): self.frameElem.from_frame_to_otherFrame("rigthFrame") #获取所有页面IP掩码集合 fortMasks = self.driver.find_elements_by_name("fortMask") masklists = masklist.split() self.ip_mask_common(fortMasks, masklists) u'''填写IP地址和掩码公共方法 Parameters: - ipsets:页面IP段集合 - dataipsets:列表数据集合 ''' def ip_mask_common(self, ipsets, dataipsets): #获取页面集合长度 ipsetth = len(ipsets) fortth = 0 #循环ip掩码进行填写操作 for ipset in ipsets: if fortth < ipsetth and dataipsets[fortth] != 'no': fortips = self.driver.find_elements_by_name("fortIp") if ipsets == fortips: ipset.clear() ipset.send_keys(dataipsets[fortth]) fortth = fortth + 1 u'''点击增加多个IP段''' def click_add_ip_segment(self): self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_click_EC("id", "add_ip_range") u'''填写起始段IP Parameters: - ipstartlist:所填写的起始段IP列表集合 ''' def set_ip_start(self, ipstartlist): self.frameElem.from_frame_to_otherFrame("rigthFrame") ipstarts = ipstartlist.split() self.ip_segment_common("fortIpStart", ipstarts) u'''填写结束段IP Parameters: - ipendlist:所填写的结束段IP列表集合 ''' def set_ip_end(self, ipendlist): self.frameElem.from_frame_to_otherFrame("rigthFrame") ipends = ipendlist.split() self.ip_segment_common("fortIpEnd", ipends) u'''填写区间段IP公共方法 Parameters: - ipsetname:页面IP段name属性 - dataipsets:列表数据集合 ''' def ip_segment_common(self, ipsetname, dataipsets): #获取所有页面IP段集合 ipsets = self.driver.find_elements_by_name(ipsetname) #获取IP段集合长度 ipsetsth = len(ipsets) fortth = 0 #循环进行段ip填写操作 for ipset in ipsets: if fortth < ipsetsth: ipset.clear() ipset.send_keys(dataipsets[fortth]) fortth = fortth + 1 u'''点击测试''' def click_test(self): self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_click_EC("id", "test_ip") u'''填写测试ip地址 Parameters: - testip:ip地址 ''' def set_ip_test(self, testip): ip = self.cnEn.is_float(testip) self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_clear("id", "testIp") self.getElem.find_element_wait_and_sendkeys("id", "testIp", ip) u'''填写描述信息 Parameters: - description:描述信息 ''' def set_description(self, description): descript = self.cnEn.is_float(description) self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_clear("id", "fortDescription") self.getElem.find_element_wait_and_sendkeys("id", "fortDescription", descript) u'''点击保存''' def click_save(self): self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_click_EC("id", "save_rule_address") u'''点击返回''' def click_back(self): self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_click_EC("id", "history_skip") u'''给用户添加地址规则 Parameters: - username:要编辑的用户名称 - adrerule:地址规则名称 ''' def edit_user_address_rule(self, username, adrerule): self.frameElem.from_frame_to_otherFrame("mainFrame") name = self.cnEn.is_float(username) self.user.operate_edit(name) self.user.click_advanced_option() self.select_adress_rule(adrerule) self.user.save_button() self.cmf.click_login_msg_button() self.user.click_back_button() u'''选择地址规则 Parameters: - adrerule:地址规则名称 ''' def select_adress_rule(self, adrerule): self.frameElem.from_frame_to_otherFrame("mainFrame") addressrule = self.cnEn.is_float(adrerule) select_elem = self.getElem.find_element_with_wait_EC('id',"fortRuleAddressId") self.selectElem.select_element_by_visible_text(select_elem, addressrule)
class TimeRule(object): def __init__(self, driver): self.driver = driver self.getElem = getElement(driver) self.selectElem = selectElement(driver) self.frameElem = frameElement(driver) self.tableElem = tableElement(driver) self.cmf = commonFun(driver) self.cnEn = cnEncode() self.acproval = Accapproval(driver) self.user = UserPage(driver) u'''点击批量删除''' def click_bulkdel_time(self): self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_click_EC("id", "delete_rule_time") u'''填写时间规则名称 Parameters: - rulename:时间规则名称 ''' def set_rulename(self, rulename): name = self.cnEn.is_float(rulename) self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_clear("id", "fortRuleTimeName") self.getElem.find_element_wait_and_sendkeys("id", "fortRuleTimeName", name) u'''选择部门 Parameters: - deptname:部门名称 ''' def select_depart(self, deptname): name = self.cnEn.is_float(deptname) self.select_depart_right_common("department_name", "tree_1_switch", name) time.sleep(2) u'''启动日期 Parameters: - type:t代表今天,c代表clear,q代表确定,默认选择今天 - starttime:启动日期 ''' def start_date(self, types, starttime=None): self.frameElem.from_frame_to_otherFrame("rigthFrame") # 时间控件的fram的xpath # fxpath = "//iframe[@hidefocus='true']" fxpath = "/html/body/div/iframe" # 日期控件table的xpath路径 txpath = "/html/body/div/div[3]/table" status = self.cnEn.is_float('0') type = self.cnEn.is_float(types) if starttime != None: # 转成datetime对象 date = datetime(*xldate_as_tuple(starttime, 0)) start = date.strftime('%Y-%m-%d %H:%M:%S') self.option_time_rule("fortStartTime", fxpath, status, type, txpath, start) else: self.option_time_rule("fortStartTime", fxpath, status, type, txpath) u'''结束日期 Parameters: - type:t代表今天,c代表clear,q代表确定,默认选择今天 - endtime:结束日期设定的日期,格式为2016-9-7 11:42:42 ''' def date_of_termination(self, types, endtime): 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('0') type = self.cnEn.is_float(types) # 转成datetime对象 date = datetime(*xldate_as_tuple(endtime, 0)) end = date.strftime('%Y-%m-%d %H:%M:%S') self.option_time_rule("fortEndTime", fxpath, status, type, txpath, end) u'''设置状态类型 Parameters: - status: 状态类型0代表禁止使用,1代表允许使用 ''' def set_status_type(self, status): self.frameElem.from_frame_to_otherFrame("rigthFrame") statu = self.cnEn.is_float(status) selem = self.getElem.find_element_with_wait_EC("id", "fortAccessType") self.selectElem.select_element_by_value(selem, statu) u'''设置时间 Parameters: - method: 设置方式 option的value值 - weeks: 星期(可多选)option的value值 - hours: 小时(可多选) ''' def set_time(self, methods, weeks, hours='no'): self.frameElem.from_frame_to_otherFrame("rigthFrame") #设置时间方式 method = self.cnEn.is_float(methods) selem = self.getElem.find_element_with_wait_EC("id", "method") self.selectElem.select_element_by_value(selem, method) #设置日期 week = weeks.split() if methods == "weeks": for data in week: welem = self.getElem.find_element_with_wait_EC("id", "fortWeeks") self.selectElem.select_element_by_value(welem, data) elif methods == "days": for data in week: welem = self.getElem.find_element_with_wait_EC("id", "fortDays") self.selectElem.select_element_by_value(welem, data) if hours != 'no': #设置小时 hour = hours.split() for hr in hour: helem = self.getElem.find_element_with_wait_EC("id", "fortHours") self.selectElem.select_element_by_value(helem, hr) u'''取消时间 Parameters: - method: 设置方式 option的value值 - weeks: 星期(可多选)option的value值 - hours: 小时(可多选) ''' def deselect_time(self, methods, weeks, hours='no'): self.frameElem.from_frame_to_otherFrame("rigthFrame") #设置日期 week = weeks.split() if methods == "weeks": for data in week: welem = self.getElem.find_element_with_wait_EC("id", "fortWeeks") self.selectElem.deselect_element_by_value(welem, data) elif methods == "days": for data in week: welem = self.getElem.find_element_with_wait_EC("id", "fortDays") self.selectElem.deselect_element_by_value(welem, data) if hours != 'no': #设置小时 hour = hours.split() for hr in hour: helem = self.getElem.find_element_with_wait_EC("id", "fortHours") self.selectElem.deselect_element_by_value(helem, hr) u'''填写描述信息 Parameters: - descrip:描述信息 ''' def set_descrip(self, descrip): self.frameElem.from_frame_to_otherFrame("rigthFrame") description = self.cnEn.is_float(descrip) self.getElem.find_element_wait_and_clear("id", "fortDescription") self.getElem.find_element_wait_and_sendkeys("id", "fortDescription", description) u'''点击保存按钮''' def click_save_time(self): self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_click_EC("id", "save_rule_time") u'''填写检索名称 Parameters: - timename:名称 ''' def set_search_timename(self, timename): self.frameElem.from_frame_to_otherFrame("rigthFrame") name = self.cnEn.is_float(timename) self.getElem.find_element_wait_and_clear("id", "fortRuleTimeName") self.getElem.find_element_wait_and_sendkeys("id", "fortRuleTimeName", name) u'''点击检索按钮''' def click_search_time(self): self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_click_EC("id", "retFortRuleTimeName") u'''点击重置''' def click_reset_time(self): self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_click_EC("id", "resetting") u'''点击编辑按钮 Parameters: - timename:时间规则名称 ''' def click_edit_time(self, timename): try: self.frameElem.from_frame_to_otherFrame("rigthFrame") row = self.acproval.find_name_by_row(timename, "fortRuleTimeName") update_xpath = "/html/body/div/div[6]/div[2]/div/table/tbody/tr[" + str(row) + "]/td[6]/input[1]" self.getElem.find_element_wait_and_click("xpath", update_xpath) except Exception: print("Click the Edit button to fail") u'''点击删除按钮 Parameters: - timename:时间规则名称 ''' def click_del_time(self, timename): try: self.frameElem.from_frame_to_otherFrame("rigthFrame") row = self.acproval.find_name_by_row(timename, "fortRuleTimeName") del_xpath = "/html/body/div/div[6]/div[2]/div/table/tbody/tr[" + str(row) + "]/td[6]/input[2]" self.getElem.find_element_wait_and_click("xpath", del_xpath) except Exception: print("Click the Del button to fail") u'''选择部门公共方法 parameter: - idname:填写框id - swithid:部门展开按钮id - deptname:部门名称 ''' def select_depart_right_common(self, idname, swithid, deptname): try: self.frameElem.from_frame_to_otherFrame("rigthFrame") self.driver.implicitly_wait(10) self.getElem.find_element_wait_and_click_EC('id', idname) self.driver.implicitly_wait(10) self.getElem.find_element_wait_and_click_EC('id', swithid) self.driver.implicitly_wait(10) #获取所有a标签的对象 elems = self.driver.find_elements_by_tag_name("a") for elem in elems: elemtext = elem.get_attribute("title") elemid = elem.get_attribute("id") if deptname == elemtext: self.getElem.find_element_wait_and_click("id", elemid) break except Exception as e: print "Department select error:" + str(e) 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_rule(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") if wdateId == "fortStartTime": self.getElem.find_element_wait_and_click_EC("id", "fortStartTime") elif wdateId == "fortEndTime": self.getElem.find_element_wait_and_click_EC("id", "fortEndTime") 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: - username:要编辑的用户名称 - timerule:时间规则test值 ''' def edit_user_time_rule(self, username, timerule): self.frameElem.from_frame_to_otherFrame("mainFrame") name = self.cnEn.is_float(username) self.user.operate_edit(name) self.user.click_advanced_option() self.select_time_rule(timerule) self.user.save_button() self.cmf.click_login_msg_button() self.user.click_back_button() u'''选择时间规则 Parameters: - timerule:时间规则test值 ''' def select_time_rule(self, timerule): self.frameElem.from_frame_to_otherFrame("mainFrame") timer = self.cnEn.is_float(timerule) select_elem = self.getElem.find_element_with_wait_EC('id',"fortRuleTimeId") self.selectElem.select_element_by_visible_text(select_elem, timer)
class User(): def __init__(self,driver): self.driver = driver self.log = log() self.user = UserPage(driver) self.cmf = commonFun(driver) self.getElem = getElement(driver) self.cnEnde = cnEncode() self.selectElem = selectElement(driver) self.dataFile = dataFileName() self.frameElem = frameElement(self.driver) self.tableEle = tableElement(self.driver) u'''提示框元素路径''' def user_msg(self): user_msg = "html/body/div[1]/div/table/tbody/tr[2]/td[2]/div/table/tbody/tr[2]/td[2]/div" return user_msg u'''获取测试数据 Parameters: - sheetname:sheet名称 return:表格数据 ''' def get_table_data(self,sheetname): dataFile = dataFileName() filePath = dataFile.get_person_test_data_url() authFileData = dataFile.get_data(filePath,sheetname) return authFileData u'''校验有弹出框类型用例是否通过 parameters: data : 检查点 flag : 通过标识(True or False) ''' def check_with_pop_up(self,data,flag): #点击保存按钮弹出框 user_msg = self.user_msg() self.frameElem.switch_to_content() self.cmf.test_win_check_point("xpath",user_msg,data,flag) u'''校验没有弹出框类型用例是否通过 parameters: data : 检查点 flag : 通过标识(True lse) status : 0,代表判断条件为相等 ''' def check_without_pop_up(self,var1,var2,data): #点击保存按钮弹出框 user_msg = self.user_msg() if var1 == var2: self.cmf.test_win_check_point("","",data,True) else: self.cmf.test_win_check_point("","",data,False) u'''重置''' def reset(self): self.user.click_reset_button() self.user.click_search_button() u'''切换至用户模块''' def switch_to_user_module(self): self.frameElem.switch_to_content() self.frameElem.switch_to_top() self.cmf.select_menu(u"运维管理") self.cmf.select_menu(u"运维管理",u"用户") u'''添加用户''' def add_user_001(self): #日志开始记录 self.log.log_start("addUser") #获取添加用户的数据 user_data = self.get_table_data("add_user") #无检查点的测试项标识,如果为True说明通过 flag = False for dataRow in range(len(user_data)): data = user_data[dataRow] try: #如果不是第一行标题,则读取数据 if dataRow != 0: self.frameElem.from_frame_to_otherFrame("mainFrame") self.user.add_button() self.user.set_user_account(data[2]) self.user.set_user_name(data[3]) if data[6] != "": self.user.set_dep(data[6]) self.user.set_user_pwd(data[7]) self.user.set_user_enquire_pwd(data[8]) self.user.set_user_role(data[15]) self.user.click_role_add_button() self.user.save_button() #判断测试项是否通过 self.check_with_pop_up(data,flag) #清空标识状态 flag = False # self.switch_to_user_module() # self.cmf.back() self.user.click_back_button() if self.cmf.is_namevalue_exsit(data[2],"fortUserAccount"): print ("add user success") except Exception as e: print ("user add fail: ") + str(e) self.log.log_end("addUser") u'''编辑用户''' def edit_user_002(self): #日志开始记录 self.log.log_start("editUser") #获取编辑用户的数据 user_data = self.get_table_data("mod_user") #无检查点的测试项标识,如果为True说明通过 flag = False for dataRow in range(len(user_data)): data = user_data[dataRow] try: #如果不是第一行标题,则读取数据 if dataRow != 0: self.frameElem.from_frame_to_otherFrame("mainFrame") self.user.operate_edit(data[2]) self.user.set_user_account(data[3]) self.user.set_user_name(data[4]) self.user.set_user_status(data[8]) self.user.set_user_pwd(data[9]) self.user.set_user_enquire_pwd(data[10]) self.user.save_button() #判断测试项是否通过 self.check_with_pop_up(data,flag) #清空标识状态 flag = False self.switch_to_user_module() # self.cmf.back() # self.user.click_back_button() if self.cmf.is_namevalue_exsit(data[2],"fortUserAccount"): print ("edit user success") except Exception as e: print ("edit user fail: ") + str(e) self.log.log_end("editUser") u'''生成证书''' def create_user_cert_003(self): #日志开始记录 self.log.log_start("CreateUserCert") #获取生成证书用户的数据 user_data = self.get_table_data("create_cert") #无检查点的测试项标识,如果为True说明通过 flag = False for dataRow in range(len(user_data)): data = user_data[dataRow] try: #如果不是第一行标题,则读取数据 if dataRow != 0: self.frameElem.from_frame_to_otherFrame("mainFrame") self.user.operate_cert(data[3]) self.user.create_cert() cert_name = self.user.get_cert() #判断生成的证书名字和指定的名字是否相等 self.check_without_pop_up(cert_name,data[2],data) #清空标识状态 flag = False self.switch_to_user_module() # self.cmf.back() except Exception as e: print ("Create user cert fail: ") + str(e) self.log.log_end("CreateUserCert") u'''重新生成证书''' def create_user_cert_again_003(self): #点击保存按钮弹出框 user_msg = self.user_msg() #日志开始记录 self.log.log_start("ReCreateUserCert") #获取重新生成证书的数据 user_data = self.get_table_data("reCreate_cert") #无检查点的测试项标识,如果为True说明通过 flag = False for dataRow in range(len(user_data)): data = user_data[dataRow] try: #如果不是第一行标题,则读取数据 if dataRow != 0: self.frameElem.from_frame_to_otherFrame("mainFrame") self.user.operate_cert(data[2]) cert_num_old = self.user.get_cert_serial_num() self.user.create_cert() self.cmf.click_login_msg_button() self.frameElem.from_frame_to_otherFrame("mainFrame") cert_num_new = self.user.get_cert_serial_num() if cert_num_old != cert_num_new: self.cmf.test_win_check_point("","",data,True) else: self.cmf.test_win_check_point("","",data,False) #清空标识状态 flag = False self.switch_to_user_module() # self.cmf.back() except Exception as e: print ("ReCreate user cert fail: ") + str(e) self.log.log_end("ReCreateUserCert") u'''删除证书''' def delete_user_cert_004(self): #日志开始记录 self.log.log_start("DeleteUserCert") #获取删除证书的数据 user_data = self.get_table_data("delete_cert") #无检查点的测试项标识,如果为True说明通过 flag = False for dataRow in range(len(user_data)): data = user_data[dataRow] try: #如果不是第一行标题,则读取数据 if dataRow != 0: self.frameElem.from_frame_to_otherFrame("mainFrame") self.user.operate_cert(data[3]) self.user.delete_cert() #判断测试项是否通过 self.check_with_pop_up(data,flag) self.frameElem.from_frame_to_otherFrame("mainFrame") if self.user.get_init_cert_name() == data[2]: print ("Delete cert success!") #清空标识状态 flag = False self.frameElem.from_frame_to_otherFrame("mainFrame") # self.switch_to_user_module() self.cmf.back() except Exception as e: print ("Delete user cert fail: ") + str(e) self.log.log_end("DeleteUserCert") u'''校验用户''' def checkout_user_005(self): #保存成功的弹出框 user_msg = self.user_msg() #日志开始记录 self.log.log_start("checkoutUser") #获取用户校验的数据 user_data = self.get_table_data("user_check")#user_check #无检查点的测试项标识,如果为True说明通过 self.frameElem.from_frame_to_otherFrame("mainFrame") self.user.add_button() flag = False for dataRow in range(len(user_data)): data = user_data[dataRow] try: #如果不是第一行标题,则读取数据 if dataRow != 0: self.frameElem.from_frame_to_otherFrame("mainFrame") self.user.set_user_account(data[2]) self.user.set_user_name(data[3]) if dataRow == range(len(user_data))[-1]: self.user.clear_dep() self.user.set_user_pwd(data[7]) self.user.set_user_enquire_pwd(data[8]) self.user.set_user_mobile(data[9]) self.user.set_user_phone(data[10]) self.user.set_user_email(data[11]) self.user.save_button() #判断测试项是否通过 self.check_with_pop_up(data,flag) #清空标识状态 flag = False except Exception as e: print ("checkoutUser fail: ") + str(e) self.switch_to_user_module() self.log.log_end("checkoutUser") u'''检索条件:用户状态''' def search_user_by_status_006(self): #日志开始记录 self.log.log_start("Search user by status") #获取按照用户状态检索的数据 user_data = self.get_table_data("search_by_status")#user_check #无检查点的测试项标识,如果为True说明通过 flag = False for dataRow in range(len(user_data)): data = user_data[dataRow] try: #如果不是第一行标题,则读取数据 if dataRow != 0: self.frameElem.from_frame_to_otherFrame("mainFrame") row = self.user.search_by_status(data[3]) self.user.search_by_user_status(data[2]) self.user.click_search_button() search_row = self.user.get_rows() #判断测试项是否通过 self.check_without_pop_up(row,search_row,data) self.reset() #清空标识状态 flag = False except Exception as e: print ("search user by status fail: ") + str(e) self.log.log_end("Search user by status") u'''检索条件:账号或者名称''' def search_user_by_username_006(self): #日志开始记录 self.log.log_start("Search user by username") #获取按照账号或名称检索的数据 user_data = self.get_table_data("search_by_name")#user_check #无检查点的测试项标识,如果为True说明通过 flag = False for dataRow in range(len(user_data)): data = user_data[dataRow] try: #如果不是第一行标题,则读取数据 if dataRow != 0: self.frameElem.from_frame_to_otherFrame("mainFrame") row = self.user.search_direct_by_account_or_name(data[3]) self.user.search_accountorname(data[3]) self.user.click_search_button() search_row = self.user.get_rows() #判断测试项是否通过 self.check_without_pop_up(row,search_row,data) self.reset() #清空标识状态 flag = False except Exception as e: print ("search user by username fail: ") + str(e) self.log.log_end("Search user by username") u'''检索条件:部门''' def search_user_by_dep_006(self): #日志开始记录 self.log.log_start("Search user by department") #获取按部门检索的数据 user_data = self.get_table_data("search_by_dep")#user_check #无检查点的测试项标识,如果为True说明通过 flag = False for dataRow in range(len(user_data)): data = user_data[dataRow] try: #如果不是第一行标题,则读取数据 if dataRow != 0: self.frameElem.from_frame_to_otherFrame("mainFrame") if dataRow == 1: row = self.user.search_direct_by_dep(data[3]) self.user.set_dep(data[3]) elif dataRow == 2: row = self.user.get_rows() self.user.click_child_node() self.user.set_dep(data[3]) self.user.click_search_button() search_row = self.user.get_rows() #判断测试项是否通过 self.check_without_pop_up(row,search_row,data) self.reset() #清空标识状态 flag = False except Exception as e: print ("search user by department fail: ") + str(e) self.log.log_end("Search user by department") u'''检索条件:角色''' def search_user_by_role_006(self): #日志开始记录 self.log.log_start("SearchUserByRole") #获取按角色检索的数据 user_data = self.get_table_data("search_by_role")#user_check #无检查点的测试项标识,如果为True说明通过 flag = False for dataRow in range(len(user_data)): data = user_data[dataRow] try: #如果不是第一行标题,则读取数据 if dataRow != 0: self.frameElem.from_frame_to_otherFrame("mainFrame") row = self.user.search_direct_by_role(data[3]) self.user.search_user_role(data[3]) self.user.click_search_button() search_row = self.user.get_rows() #判断测试项是否通过 self.check_without_pop_up(row,search_row,data) self.reset() #清空标识状态 flag = False except Exception as e: print ("search user by role fail: ") + str(e) self.log.log_end("SearchUserByRole") u'''删除单个用户''' def del_user_007(self): #日志开始记录 self.log.log_start("DelOneUser") #获取删除用户(单个)的数据 user_data = self.get_table_data("del_user")#user_check #无检查点的测试项标识,如果为True说明通过 flag = False for dataRow in range(len(user_data)): data = user_data[dataRow] try: #如果不是第一行标题,则读取数据 if dataRow != 0: self.frameElem.from_frame_to_otherFrame("mainFrame") self.user.operate_delete(data[2]) self.cmf.click_login_msg_button() #判断测试项是否通过 self.check_with_pop_up(data,flag) #清空标识状态 flag = False #判断删除的账号是否存在 if not self.cmf.is_namevalue_exsit(data[2],"fortUserAccount"): print ("del user success") except Exception as e: print ("DelOneUser fail: ") + str(e) self.log.log_end("DelOneUser") u'''删除全部用户''' def del_all_user_008(self): #日志开始记录 self.log.log_start("DelAllUser") #获取用户删除的数据 user_data = self.get_table_data("del_all_user")#user_check #无检查点的测试项标识,如果为True说明通过 flag = False for dataRow in range(len(user_data)): data = user_data[dataRow] try: #如果不是第一行标题,则读取数据 if dataRow != 0: # self.frameElem.from_frame_to_otherFrame("mainFrame") # self.user.page_select_all() self.frameElem.from_frame_to_otherFrame("mainFrame") self.user.del_specified_user(data[2]) #self.user.select_all_button() self.user.del_button() self.cmf.click_login_msg_button() #判断测试项是否通过 self.check_with_pop_up(data,flag) #清空标识状态 flag = False except Exception as e: print ("del all fail: ") + str(e) self.log.log_end("DelAllUser") #if __name__ == "__main__":#internet explorer # browser = setDriver().set_local_driver() # commonSuite = CommonSuiteData(browser) # userCase = User(browser) # commonSuite.isomper_login() # cmf = commonFun(browser) # # #添加角色 # commonSuite.add_sys_role() ## commonSuite.add_dep_role() # cmf.select_menu(u'运维管理') # cmf.select_menu(u'运维管理','用户') # userCase.add_user_001() # userCase.edit_user_002() # userCase.create_user_cert_003() # userCase.create_user_cert_again_003() # userCase.delete_user_cert_004() # # userCase.checkout_user_005() # userCase.search_user_by_username_006() # userCase.search_user_by_status_006() # userCase.search_user_by_dep_006() # userCase.search_user_by_role_006() # userCase.del_user_007() # userCase.del_all_user_008()
class User(): def __init__(self, driver): self.driver = driver self.log = log() self.user = UserPage(driver) self.cmf = commonFun(driver) self.getElem = getElement(driver) self.cnEnde = cnEncode() self.selectElem = selectElement(driver) self.dataFile = dataFileName() self.frameElem = frameElement(self.driver) self.tableEle = tableElement(self.driver) u'''提示框元素路径''' def user_msg(self): user_msg = "html/body/div[1]/div/table/tbody/tr[2]/td[2]/div/table/tbody/tr[2]/td[2]/div" return user_msg u'''获取测试数据 Parameters: - sheetname:sheet名称 return:表格数据 ''' def get_table_data(self, sheetname): dataFile = dataFileName() filePath = dataFile.get_person_test_data_url() authFileData = dataFile.get_data(filePath, sheetname) return authFileData u'''校验有弹出框类型用例是否通过 parameters: data : 检查点 flag : 通过标识(True or False) ''' def check_with_pop_up(self, data, flag): #点击保存按钮弹出框 user_msg = self.user_msg() self.frameElem.switch_to_content() self.cmf.test_win_check_point("xpath", user_msg, data, flag) u'''校验没有弹出框类型用例是否通过 parameters: data : 检查点 flag : 通过标识(True lse) status : 0,代表判断条件为相等 ''' def check_without_pop_up(self, var1, var2, data): #点击保存按钮弹出框 user_msg = self.user_msg() if var1 == var2: self.cmf.test_win_check_point("", "", data, True) else: self.cmf.test_win_check_point("", "", data, False) u'''重置''' def reset(self): self.user.click_reset_button() self.user.click_search_button() u'''切换至用户模块''' def switch_to_user_module(self): self.frameElem.switch_to_content() self.frameElem.switch_to_top() self.cmf.select_menu(u"运维管理") self.cmf.select_menu(u"运维管理", u"用户") u'''添加用户''' def add_user_001(self): #日志开始记录 self.log.log_start("addUser") #获取添加用户的数据 user_data = self.get_table_data("add_user") #无检查点的测试项标识,如果为True说明通过 flag = False for dataRow in range(len(user_data)): data = user_data[dataRow] try: #如果不是第一行标题,则读取数据 if dataRow != 0: self.frameElem.from_frame_to_otherFrame("mainFrame") self.user.add_button() self.user.set_user_account(data[2]) self.user.set_user_name(data[3]) if data[6] != "": self.user.set_dep(data[6]) self.user.set_user_pwd(data[7]) self.user.set_user_enquire_pwd(data[8]) self.user.set_user_role(data[15]) self.user.click_role_add_button() self.user.save_button() #判断测试项是否通过 self.check_with_pop_up(data, flag) #清空标识状态 flag = False # self.switch_to_user_module() # self.cmf.back() self.user.click_back_button() if self.cmf.is_namevalue_exsit(data[2], "fortUserAccount"): print("add user success") except Exception as e: print("user add fail: ") + str(e) self.log.log_end("addUser") u'''编辑用户''' def edit_user_002(self): #日志开始记录 self.log.log_start("editUser") #获取编辑用户的数据 user_data = self.get_table_data("mod_user") #无检查点的测试项标识,如果为True说明通过 flag = False for dataRow in range(len(user_data)): data = user_data[dataRow] try: #如果不是第一行标题,则读取数据 if dataRow != 0: self.frameElem.from_frame_to_otherFrame("mainFrame") self.user.operate_edit(data[2]) self.user.set_user_account(data[3]) self.user.set_user_name(data[4]) self.user.set_user_status(data[8]) self.user.set_user_pwd(data[9]) self.user.set_user_enquire_pwd(data[10]) self.user.save_button() #判断测试项是否通过 self.check_with_pop_up(data, flag) #清空标识状态 flag = False self.switch_to_user_module() # self.cmf.back() # self.user.click_back_button() if self.cmf.is_namevalue_exsit(data[2], "fortUserAccount"): print("edit user success") except Exception as e: print("edit user fail: ") + str(e) self.log.log_end("editUser") u'''生成证书''' def create_user_cert_003(self): #日志开始记录 self.log.log_start("CreateUserCert") #获取生成证书用户的数据 user_data = self.get_table_data("create_cert") #无检查点的测试项标识,如果为True说明通过 flag = False for dataRow in range(len(user_data)): data = user_data[dataRow] try: #如果不是第一行标题,则读取数据 if dataRow != 0: self.frameElem.from_frame_to_otherFrame("mainFrame") self.user.operate_cert(data[3]) self.user.create_cert() cert_name = self.user.get_cert() #判断生成的证书名字和指定的名字是否相等 self.check_without_pop_up(cert_name, data[2], data) #清空标识状态 flag = False self.switch_to_user_module() # self.cmf.back() except Exception as e: print("Create user cert fail: ") + str(e) self.log.log_end("CreateUserCert") u'''重新生成证书''' def create_user_cert_again_003(self): #点击保存按钮弹出框 user_msg = self.user_msg() #日志开始记录 self.log.log_start("ReCreateUserCert") #获取重新生成证书的数据 user_data = self.get_table_data("reCreate_cert") #无检查点的测试项标识,如果为True说明通过 flag = False for dataRow in range(len(user_data)): data = user_data[dataRow] try: #如果不是第一行标题,则读取数据 if dataRow != 0: self.frameElem.from_frame_to_otherFrame("mainFrame") self.user.operate_cert(data[2]) cert_num_old = self.user.get_cert_serial_num() self.user.create_cert() self.cmf.click_login_msg_button() self.frameElem.from_frame_to_otherFrame("mainFrame") cert_num_new = self.user.get_cert_serial_num() if cert_num_old != cert_num_new: self.cmf.test_win_check_point("", "", data, True) else: self.cmf.test_win_check_point("", "", data, False) #清空标识状态 flag = False self.switch_to_user_module() # self.cmf.back() except Exception as e: print("ReCreate user cert fail: ") + str(e) self.log.log_end("ReCreateUserCert") u'''删除证书''' def delete_user_cert_004(self): #日志开始记录 self.log.log_start("DeleteUserCert") #获取删除证书的数据 user_data = self.get_table_data("delete_cert") #无检查点的测试项标识,如果为True说明通过 flag = False for dataRow in range(len(user_data)): data = user_data[dataRow] try: #如果不是第一行标题,则读取数据 if dataRow != 0: self.frameElem.from_frame_to_otherFrame("mainFrame") self.user.operate_cert(data[3]) self.user.delete_cert() #判断测试项是否通过 self.check_with_pop_up(data, flag) self.frameElem.from_frame_to_otherFrame("mainFrame") if self.user.get_init_cert_name() == data[2]: print("Delete cert success!") #清空标识状态 flag = False self.frameElem.from_frame_to_otherFrame("mainFrame") # self.switch_to_user_module() self.cmf.back() except Exception as e: print("Delete user cert fail: ") + str(e) self.log.log_end("DeleteUserCert") u'''校验用户''' def checkout_user_005(self): #保存成功的弹出框 user_msg = self.user_msg() #日志开始记录 self.log.log_start("checkoutUser") #获取用户校验的数据 user_data = self.get_table_data("user_check") #user_check #无检查点的测试项标识,如果为True说明通过 self.frameElem.from_frame_to_otherFrame("mainFrame") self.user.add_button() flag = False for dataRow in range(len(user_data)): data = user_data[dataRow] try: #如果不是第一行标题,则读取数据 if dataRow != 0: self.frameElem.from_frame_to_otherFrame("mainFrame") self.user.set_user_account(data[2]) self.user.set_user_name(data[3]) if dataRow == range(len(user_data))[-1]: self.user.clear_dep() self.user.set_user_pwd(data[7]) self.user.set_user_enquire_pwd(data[8]) self.user.set_user_mobile(data[9]) self.user.set_user_phone(data[10]) self.user.set_user_email(data[11]) self.user.save_button() #判断测试项是否通过 self.check_with_pop_up(data, flag) #清空标识状态 flag = False except Exception as e: print("checkoutUser fail: ") + str(e) self.switch_to_user_module() self.log.log_end("checkoutUser") u'''检索条件:用户状态''' def search_user_by_status_006(self): #日志开始记录 self.log.log_start("Search user by status") #获取按照用户状态检索的数据 user_data = self.get_table_data("search_by_status") #user_check #无检查点的测试项标识,如果为True说明通过 flag = False for dataRow in range(len(user_data)): data = user_data[dataRow] try: #如果不是第一行标题,则读取数据 if dataRow != 0: self.frameElem.from_frame_to_otherFrame("mainFrame") row = self.user.search_by_status(data[3]) self.user.search_by_user_status(data[2]) self.user.click_search_button() search_row = self.user.get_rows() #判断测试项是否通过 self.check_without_pop_up(row, search_row, data) self.reset() #清空标识状态 flag = False except Exception as e: print("search user by status fail: ") + str(e) self.log.log_end("Search user by status") u'''检索条件:账号或者名称''' def search_user_by_username_006(self): #日志开始记录 self.log.log_start("Search user by username") #获取按照账号或名称检索的数据 user_data = self.get_table_data("search_by_name") #user_check #无检查点的测试项标识,如果为True说明通过 flag = False for dataRow in range(len(user_data)): data = user_data[dataRow] try: #如果不是第一行标题,则读取数据 if dataRow != 0: self.frameElem.from_frame_to_otherFrame("mainFrame") row = self.user.search_direct_by_account_or_name(data[3]) self.user.search_accountorname(data[3]) self.user.click_search_button() search_row = self.user.get_rows() #判断测试项是否通过 self.check_without_pop_up(row, search_row, data) self.reset() #清空标识状态 flag = False except Exception as e: print("search user by username fail: ") + str(e) self.log.log_end("Search user by username") u'''检索条件:部门''' def search_user_by_dep_006(self): #日志开始记录 self.log.log_start("Search user by department") #获取按部门检索的数据 user_data = self.get_table_data("search_by_dep") #user_check #无检查点的测试项标识,如果为True说明通过 flag = False for dataRow in range(len(user_data)): data = user_data[dataRow] try: #如果不是第一行标题,则读取数据 if dataRow != 0: self.frameElem.from_frame_to_otherFrame("mainFrame") if dataRow == 1: row = self.user.search_direct_by_dep(data[3]) self.user.set_dep(data[3]) elif dataRow == 2: row = self.user.get_rows() self.user.click_child_node() self.user.set_dep(data[3]) self.user.click_search_button() search_row = self.user.get_rows() #判断测试项是否通过 self.check_without_pop_up(row, search_row, data) self.reset() #清空标识状态 flag = False except Exception as e: print("search user by department fail: ") + str(e) self.log.log_end("Search user by department") u'''检索条件:角色''' def search_user_by_role_006(self): #日志开始记录 self.log.log_start("SearchUserByRole") #获取按角色检索的数据 user_data = self.get_table_data("search_by_role") #user_check #无检查点的测试项标识,如果为True说明通过 flag = False for dataRow in range(len(user_data)): data = user_data[dataRow] try: #如果不是第一行标题,则读取数据 if dataRow != 0: self.frameElem.from_frame_to_otherFrame("mainFrame") row = self.user.search_direct_by_role(data[3]) self.user.search_user_role(data[3]) self.user.click_search_button() search_row = self.user.get_rows() #判断测试项是否通过 self.check_without_pop_up(row, search_row, data) self.reset() #清空标识状态 flag = False except Exception as e: print("search user by role fail: ") + str(e) self.log.log_end("SearchUserByRole") u'''删除单个用户''' def del_user_007(self): #日志开始记录 self.log.log_start("DelOneUser") #获取删除用户(单个)的数据 user_data = self.get_table_data("del_user") #user_check #无检查点的测试项标识,如果为True说明通过 flag = False for dataRow in range(len(user_data)): data = user_data[dataRow] try: #如果不是第一行标题,则读取数据 if dataRow != 0: self.frameElem.from_frame_to_otherFrame("mainFrame") self.user.operate_delete(data[2]) self.cmf.click_login_msg_button() #判断测试项是否通过 self.check_with_pop_up(data, flag) #清空标识状态 flag = False except Exception as e: print("DelOneUser fail: ") + str(e) self.log.log_end("DelOneUser") u'''删除全部用户''' def del_all_user_008(self): #日志开始记录 self.log.log_start("DelAllUser") #获取用户删除的数据 user_data = self.get_table_data("del_all_user") #user_check #无检查点的测试项标识,如果为True说明通过 flag = False for dataRow in range(len(user_data)): data = user_data[dataRow] try: #如果不是第一行标题,则读取数据 if dataRow != 0: # self.frameElem.from_frame_to_otherFrame("mainFrame") # self.user.page_select_all() self.frameElem.from_frame_to_otherFrame("mainFrame") self.user.del_specified_user(data[2]) #self.user.select_all_button() self.user.del_button() self.cmf.click_login_msg_button() #判断测试项是否通过 self.check_with_pop_up(data, flag) #清空标识状态 flag = False except Exception as e: print("del all fail: ") + str(e) self.log.log_end("DelAllUser") #if __name__ == "__main__":#internet explorer # browser = setDriver().set_local_driver() # commonSuite = CommonSuiteData(browser) # userCase = User(browser) # commonSuite.isomper_login() # cmf = commonFun(browser) # # #添加角色 # commonSuite.add_sys_role() ## commonSuite.add_dep_role() # cmf.select_menu(u'运维管理') # cmf.select_menu(u'运维管理','用户') # userCase.add_user_001() # userCase.edit_user_002() # userCase.create_user_cert_003() # userCase.create_user_cert_again_003() # userCase.delete_user_cert_004() # # userCase.checkout_user_005() # userCase.search_user_by_username_006() # userCase.search_user_by_status_006() # userCase.search_user_by_dep_006() # userCase.search_user_by_role_006() # userCase.del_user_007() # userCase.del_all_user_008()
class TimeRule(object): def __init__(self, driver): self.driver = driver self.getElem = getElement(driver) self.selectElem = selectElement(driver) self.frameElem = frameElement(driver) self.tableElem = tableElement(driver) self.cmf = commonFun(driver) self.cnEn = cnEncode() self.acproval = Accapproval(driver) self.user = UserPage(driver) u'''点击批量删除''' def click_bulkdel_time(self): self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_click_EC("id", "delete_rule_time") u'''填写时间规则名称 Parameters: - rulename:时间规则名称 ''' def set_rulename(self, rulename): name = self.cnEn.is_float(rulename) self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_clear("id", "fortRuleTimeName") self.getElem.find_element_wait_and_sendkeys("id", "fortRuleTimeName", name) u'''选择部门 Parameters: - deptname:部门名称 ''' def select_depart(self, deptname): name = self.cnEn.is_float(deptname) self.select_depart_right_common("department_name", "tree_1_switch", name) time.sleep(2) u'''启动日期 Parameters: - type:t代表今天,c代表clear,q代表确定,默认选择今天 - starttime:启动日期 ''' def start_date(self, types, starttime=None): time.sleep(2) self.frameElem.from_frame_to_otherFrame("rigthFrame") # 时间控件的fram的xpath # fxpath = "//iframe[@hidefocus='true']" fxpath = "/html/body/div/iframe" # 日期控件table的xpath路径 txpath = "/html/body/div/div[3]/table" status = self.cnEn.is_float('0') type = self.cnEn.is_float(types) if starttime != None: # 转成datetime对象 date = datetime(*xldate_as_tuple(starttime, 0)) start = date.strftime('%Y-%m-%d %H:%M:%S') self.option_time_rule("fortStartTime", fxpath, status, type, txpath, start) else: self.option_time_rule("fortStartTime", fxpath, status, type, txpath) u'''结束日期 Parameters: - type:t代表今天,c代表clear,q代表确定,默认选择今天 - endtime:结束日期设定的日期,格式为2016-9-7 11:42:42 ''' def date_of_termination(self, types, endtime): 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('0') type = self.cnEn.is_float(types) # 转成datetime对象 date = datetime(*xldate_as_tuple(endtime, 0)) end = date.strftime('%Y-%m-%d %H:%M:%S') self.option_time_rule("fortEndTime", fxpath, status, type, txpath, end) u'''设置状态类型 Parameters: - status: 状态类型0代表禁止使用,1代表允许使用 ''' def set_status_type(self, status): self.frameElem.from_frame_to_otherFrame("rigthFrame") statu = self.cnEn.is_float(status) selem = self.getElem.find_element_with_wait_EC("id", "fortAccessType") self.selectElem.select_element_by_value(selem, statu) u'''设置时间 Parameters: - method: 设置方式 option的value值 - weeks: 星期(可多选)option的value值 - hours: 小时(可多选) ''' def set_time(self, methods, weeks, hours='no'): self.frameElem.from_frame_to_otherFrame("rigthFrame") #设置时间方式 method = self.cnEn.is_float(methods) selem = self.getElem.find_element_with_wait_EC("id", "method") self.selectElem.select_element_by_value(selem, method) #设置日期 week = weeks.split() if methods == "weeks": for data in week: welem = self.getElem.find_element_with_wait_EC("id", "fortWeeks") self.selectElem.select_element_by_value(welem, data) elif methods == "days": for data in week: welem = self.getElem.find_element_with_wait_EC("id", "fortDays") self.selectElem.select_element_by_value(welem, data) if hours != 'no': #设置小时 hour = hours.split() for hr in hour: helem = self.getElem.find_element_with_wait_EC("id", "fortHours") self.selectElem.select_element_by_value(helem, hr) u'''取消时间 Parameters: - method: 设置方式 option的value值 - weeks: 星期(可多选)option的value值 - hours: 小时(可多选) ''' def deselect_time(self, methods, weeks, hours='no'): self.frameElem.from_frame_to_otherFrame("rigthFrame") #设置日期 week = weeks.split() if methods == "weeks": for data in week: welem = self.getElem.find_element_with_wait_EC("id", "fortWeeks") self.selectElem.deselect_element_by_value(welem, data) elif methods == "days": for data in week: welem = self.getElem.find_element_with_wait_EC("id", "fortDays") self.selectElem.deselect_element_by_value(welem, data) if hours != 'no': #设置小时 hour = hours.split() for hr in hour: helem = self.getElem.find_element_with_wait_EC("id", "fortHours") self.selectElem.deselect_element_by_value(helem, hr) u'''填写描述信息 Parameters: - descrip:描述信息 ''' def set_descrip(self, descrip): self.frameElem.from_frame_to_otherFrame("rigthFrame") description = self.cnEn.is_float(descrip) self.getElem.find_element_wait_and_clear("id", "fortDescription") self.getElem.find_element_wait_and_sendkeys("id", "fortDescription", description) u'''点击保存按钮''' def click_save_time(self): self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_click_EC("id", "save_rule_time") u'''填写检索名称 Parameters: - timename:名称 ''' def set_search_timename(self, timename): self.frameElem.from_frame_to_otherFrame("rigthFrame") name = self.cnEn.is_float(timename) self.getElem.find_element_wait_and_clear("id", "fortRuleTimeName") self.getElem.find_element_wait_and_sendkeys("id", "fortRuleTimeName", name) u'''点击检索按钮''' def click_search_time(self): self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_click_EC("id", "retFortRuleTimeName") u'''点击重置''' def click_reset_time(self): self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_click_EC("id", "resetting") u'''点击编辑按钮 Parameters: - timename:时间规则名称 ''' def click_edit_time(self, timename): try: self.frameElem.from_frame_to_otherFrame("rigthFrame") row = self.acproval.find_name_by_row(timename, "fortRuleTimeName") update_xpath = "/html/body/div/div[6]/div[2]/div/table/tbody/tr[" + str(row) + "]/td[6]/input[1]" self.getElem.find_element_wait_and_click("xpath", update_xpath) except Exception: print("Click the Edit button to fail") u'''点击删除按钮 Parameters: - timename:时间规则名称 ''' def click_del_time(self, timename): try: self.frameElem.from_frame_to_otherFrame("rigthFrame") row = self.acproval.find_name_by_row(timename, "fortRuleTimeName") del_xpath = "/html/body/div/div[6]/div[2]/div/table/tbody/tr[" + str(row) + "]/td[6]/input[2]" self.getElem.find_element_wait_and_click("xpath", del_xpath) except Exception: print("Click the Del button to fail") u'''选择部门公共方法 parameter: - idname:填写框id - swithid:部门展开按钮id - deptname:部门名称 ''' def select_depart_right_common(self, idname, swithid, deptname): try: time.sleep(2) self.frameElem.from_frame_to_otherFrame("rigthFrame") self.getElem.find_element_wait_and_click_EC('id', idname) time.sleep(2) self.getElem.find_element_wait_and_click_EC('id', swithid) #获取所有a标签的对象 elems = self.driver.find_elements_by_tag_name("a") for elem in elems: elemtext = elem.get_attribute("title") elemid = elem.get_attribute("id") if deptname == elemtext: self.getElem.find_element_wait_and_click("id", elemid) break except Exception as e: print "Department select error:" + str(e) 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_rule(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) time.sleep(2) self.frameElem.from_frame_to_otherFrame("rigthFrame") if wdateId == "fortStartTime": self.getElem.find_element_wait_and_click_EC("id", "fortStartTime") elif wdateId == "fortEndTime": self.getElem.find_element_wait_and_click_EC("id", "fortEndTime") 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: - username:要编辑的用户名称 - timerule:时间规则test值 ''' def edit_user_time_rule(self, username, timerule): self.frameElem.from_frame_to_otherFrame("mainFrame") name = self.cnEn.is_float(username) self.user.operate_edit(name) self.user.click_advanced_option() self.select_time_rule(timerule) self.user.save_button() self.cmf.click_login_msg_button() self.user.click_back_button() u'''选择时间规则 Parameters: - timerule:时间规则test值 ''' def select_time_rule(self, timerule): self.frameElem.from_frame_to_otherFrame("mainFrame") timer = self.cnEn.is_float(timerule) select_elem = self.getElem.find_element_with_wait_EC('id',"fortRuleTimeId") self.selectElem.select_element_by_visible_text(select_elem, timer)