def screen_step(self,stepName): u"""浏览器页面截图""" nowtime = time.strftime("%Y%m%d%H%M%S") self.driver.get_screenshot_as_file(ReadConfig.get_image_path() + "%s.png" % nowtime) png = ReadConfig.get_image_path() + "%s.png" % nowtime self.doc.add_paragraph(stepName) self.doc.add_picture(png, width=Inches(6.0), height=Inches(3.0))
def __init__(self): # logger = LogManager('test').get_logger_and_add_handlers(1,is_add_stream_handler=True, log_path=ReadConfig.log_path, log_filename=time.strftime("%Y-%m-%d")+'.log' ) self.resultPath = ReadConfig.get_reportPath() self.scheme = rc.get_ngboss("SCHEME") self.ip = rc.get_ngboss("IP") self.port = rc.get_ngboss("PORT") self.timeout = rc.get_ngboss("timeout") self.headers = {} self.data = {} self.cookie = {} self.url = None self.session = requests.session() self.files = {} self.state = 0
logger = LogManager('ChgUserPwd').get_logger_and_add_handlers( 1, log_path=ReadConfig.log_path, log_filename=time.strftime("%Y-%m-%d") + '.log') ora = MyOracle() #取10个测试号码修改密码为108109: sql = "select rownum No ,'' flowid , '' result_info ,t.access_num , \ t.password Old_pwd,uop_file4.f_csb_encrypt('108109',t.subscriber_ins_id) new_pwd ,t.subscriber_ins_id \ from uop_file4.um_subscriber t \ where t.access_num like '1880872%' and t.mgmt_district = '0872' \ and t.remove_tag = '0' and rownum <=100" paras = ora.select(sql) logger.info('测试准备数据:{}'.format(paras)) now = time.strftime("%Y%m%d%H%M%S") file = ReadConfig.get_data_path() + 'ApiTest_ChgUserPwd_%s.xlsx' % now #生成xls表,方便后续写入测试结果 write_dict_xls(inputData=paras, sheetName='用户密码修改', outPutFile=file) logger.info('写入测试数据到xls.....') rc = ReadConfig.ReadConfig("ngboss_config.ini") h = { 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.162 Safari/537.36', "Connection": "keep - alive", "Referer": rc.get_ngboss('url') } lo_param = { "LOGIN_MODE": "BOSS", "STAFF_ID": "TESTKM13",
from selenium import webdriver from selenium.webdriver.common.by import By from Base import ReadConfig from Base.Mylog import LogManager from PageObj.ngboss.login_page import LoginPage from PageObj.ngboss.mainpage import MainPage from PageObj.cust.CustomerBase import CustBasePage from Check.PageCheck import PageAssert # logger = LogManager('test').get_logger_and_add_handlers(1,is_add_stream_handler=True, log_path=ReadConfig.log_path, log_filename=time.strftime("%Y-%m-%d")+'.log' ) logger = LogManager('GroupMebAdd').get_logger_and_add_handlers( 1, is_add_stream_handler=True, log_path=ReadConfig.log_path, log_filename=time.strftime("%Y-%m-%d") + '.log') rc = ReadConfig.ReadConfig("ngboss_config.ini") class GroupMebAdd(CustBasePage): def open_base(self): self.driver.get(rc.get_ngboss('url')) self.driver.maximize_window() def Open_GroupMebAddFrame(self): self.driver.switch_to.default_content() loc_frame = self.find(( By.XPATH, "//iframe[contains(@src,'/customercentre/customercentre?service=page/customer.cs.entmembermgr.addmember.AddEnterpriseMember')]" )) self.driver.switch_to.frame(loc_frame) logger.info("GrpMebAdd:" + str(loc_frame))
logger = LogManager('test').get_logger_and_add_handlers(1, log_path=ReadConfig.log_path, log_filename=time.strftime("%Y-%m-%d")+'.log' ) ora = MyOracle() #取20个未实名制的测试号码客户信息: sql = "SELECT rownum No ,t.access_num ,to_char(t.subscriber_ins_id) subscriber_ins_id , \ to_char(a.iden_id) iden_id,'' NEW_IDENID ,a.iden_type_id,a.iden_nr,b.party_name,\ to_char(t.cust_id) cust_id ,'' flowid , '' result_info ,'' NEWCUSTNAME \ FROM uop_file4.um_subscriber T ,uop_cp.cb_identification a,uop_cp.cb_party b \ where t.remove_tag = '0' and t.access_num LIKE '1880872%' and t.mgmt_district = '0872'\ and a.party_id = t.cust_id \ and a.party_id = b.party_id \ and rownum <=100" paras = ora.select(sql) logger.info('测试准备数据:{}'.format(paras)) now = time.strftime("%Y%m%d%H%M%S") file = ReadConfig.get_data_path() + 'ApiTest_ModfiyRealChkInfo_%s.xls' % now #生成xls表,方便后续写入测试结果 write_dict_xls(inputData=paras, sheetName='实名制登记', outPutFile=file) logger.info('写入测试数据到xls.....') rc = ReadConfig.ReadConfig("ngboss_config.ini") h = { 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.162 Safari/537.36', "Connection": "keep - alive", "Referer": rc.get_ngboss('url') } lo_param = {"LOGIN_MODE": "BOSS", "STAFF_ID": "TESTKM13", "IS_XACTIVE": "false", "BROWSER_VERSION": "IE-11", "PASSWORD": "******", "LOGIN_FLAG": "1"} @ddt.ddt
import unittest,os import time,ddt from Base import HTMLTestRunnerCNNew from PageObj.order.person.FamilyNetPage import FamilyNetPage from selenium import webdriver from selenium.webdriver.common.by import By from Base import ReadConfig from Base.OperExcel import get_exceldata,write_xlsBycolName_append from Base.Mylog import LogManager from Check.PageCheck import PageAssert from TestCases.suite import mySuitePrefixAdd from Common.TestDataMgnt import get_testDataFile,get_FuncRow,get_TestData os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.UTF8' rc = ReadConfig.ReadConfig("ngboss_config.ini") logger = LogManager('FamilyNetTest').get_logger_and_add_handlers(1, log_path=ReadConfig.log_path, log_filename=time.strftime("%Y-%m-%d")+'.log' ) # file = ReadConfig.data_path + 'UITest_ShareActive.xls' # paras = get_exceldata(file,0) # logger.info('测试案例执行数据准备:{}'.format(paras)) file = get_testDataFile() paras = get_TestData('FamilyNetTest')['params'] row = get_FuncRow('FamilyNetTest') @ddt.ddt class FamilyNetTest(unittest.TestCase): """家庭网(省内版)办理""" def setUp(self): self.driver = webdriver.Chrome() self.driver.get(rc.get_ngboss('url')) #这里可以切换环境,去ngboss_config.ini配置 self.driver.maximize_window()
import json from Base import HTMLTestRunnerCNNew from Base import ReadConfig from Base.Mylog import LogManager from Common.function import dict_get from Base.OracleOper import MyOracle from Base.OperExcel import write_dict_xls, write_xlsBycolName_append from TestCases.suite import mySuitePrefixAdd logger = LogManager('test').get_logger_and_add_handlers( 1, is_add_stream_handler=True, log_path=ReadConfig.log_path, log_filename=time.strftime("%Y-%m-%d") + '.log') rc = ReadConfig.ReadConfig("ngboss_config.ini") h = { 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.162 Safari/537.36', "Connection": "keep - alive", "Referer": rc.get_ngboss('url') } lo_param = { "LOGIN_MODE": "BOSS", "STAFF_ID": "TESTKM06", "IS_XACTIVE": "false", "BROWSER_VERSION": "IE-11", "PASSWORD": "******", "LOGIN_FLAG": "1" }
def save_docreport(self, title): nowtime = time.strftime("%Y%m%d%H%M%S") title = title + '_' + nowtime self.doc.save(ReadConfig.get_reportDoc_path() + '%s.docx' % title)
def screen(self): u"""浏览器页面截图""" nowtime = time.strftime("%Y_%m_%d_%H_%M_%S") self.driver.get_screenshot_as_file(ReadConfig.get_image_path() + "%s.png" % nowtime)
title = title + '_' + nowtime self.doc.save(ReadConfig.get_reportDoc_path() + '%s.docx' % title) def add_dochead(self, title): return self.doc.add_heading(title, level=1) def screenshot_SaveAsDoc(self, stepName): self.screen_step(stepName) self.save_docreport(stepName) """================处理Docx测试记录===============""" def uploadFile(self, locator, filename): '''上传组件-上传完整文件 :param locator: 上传按钮元素 :param filename: 要上传的完整路径文件 ''' self.find_element_click(locator) time.sleep(2) args = r"E:\ProgramData\PycharmProjects\webtest\Common\upload.exe --chrome %s" % filename logger.info('要上传的文件路径:{}'.format(filename)) print('执行上传的参数:{}'.format(args)) os.system(args) time.sleep(3) if __name__ == '__main__': print("用例开始执行时间:" + time.strftime("%Y%m%d%H%M%S")) print(ReadConfig.get_image_path()) print(ReadConfig.get_reportDoc_path())
from selenium.webdriver.common.by import By from Base import HTMLTestRunnerCNNew from Base import ReadConfig from Base.Mylog import LogManager from Common.TestDataMgnt import MainPageData from Common.TestDataMgnt import create_testDataFile from TestCases.suite import mySuitePrefixAdd from Base.OperExcel import write_xlsBycolName_append logger = LogManager('test').get_logger_and_add_handlers( 1, is_add_stream_handler=True, log_path=ReadConfig.log_path, log_filename=time.strftime("%Y-%m-%d") + '.log') os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.UTF8' rc = ReadConfig.ReadConfig("ngboss_config.ini") person_menu_paras = MainPageData().get_personMenu() #获取个人菜单测试数据 file_personMenu = ReadConfig.get_data_path( ) + 'UITest_PersonMenuSmokeTest_%s.xls' % time.strftime("%Y%m%d%H%M%S") create_testDataFile(paras=person_menu_paras, filename=file_personMenu) group_menu_paras = MainPageData().get_groupMenu() #获取个人菜单测试数据 file_GroupMenu = ReadConfig.get_data_path( ) + 'UITest_GroupMenuSmokeTest_%s.xls' % time.strftime("%Y%m%d%H%M%S") create_testDataFile(paras=group_menu_paras, filename=file_GroupMenu) base_url = rc.get_ngboss("url") username = rc.get_ngboss("username") password = rc.get_ngboss("password")