def __init__(self): """ 初始化需要的参数 :return: """ global log, resultPath # log初始化 log = 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.log_path print("log ****" + self.resultPath) # 取得config\caselist.txt文件路径 self.caseListFile = os.path.join(ReadConfig.conf_path, "caselist.txt") # 取得test_case文件路径 self.caseFile = os.path.join(ReadConfig.proDir, "TestCases") # 定义一个空列表,用于保存类名 self.caseList = []
import unittest, ddt import time import requests import json from Base import HTMLTestRunnerCNNew from Base import ReadConfig from Base.Mylog import LogManager from Base.OperExcel import get_exceldata, write_xlsBycolName_append, write_dict_xls from Base.OracleOper import MyOracle from Common.function import dict_get from TestCases.suite import mySuitePrefixAdd 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.....')
import time 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)
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 unittest, ddt import time import requests 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": "******",
import unittest,os import time,ddt from Base import HTMLTestRunnerCNNew from PageObj.order.person.offerOpers import OfferOperPage from selenium import webdriver from selenium.webdriver.common.by import By from Base import ReadConfig from Base.OperExcel import write_xlsBycolName_append from Base.Mylog import LogManager from Check.PageCheck import PageAssert from TestCases.suite import mySuitePrefixAdd from Common.TestDataMgnt import get_TestData,get_testDataFile os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.UTF8' rc = ReadConfig.ReadConfig("ngboss_config.ini") logger = LogManager('OfferOperTest').get_logger_and_add_handlers(1, log_path=ReadConfig.log_path, log_filename=time.strftime("%Y-%m-%d")+'.log' ) # file = ReadConfig.data_path + 'UITest_OfferChg.xls' # offers = get_exceldata(file,0) file = get_TestData('OfferOperTest')['filename'] offers = get_TestData('OfferOperTest')['params'] row = get_TestData('OfferOperTest')['FuncRow'] logger.info('测试案例执行数据准备:{}'.format(offers)) @ddt.ddt class OfferOperTest(unittest.TestCase): """个人业务-商品订购测试""" def setUp(self): self.driver = webdriver.Chrome() self.driver.get(rc.get_ngboss('url')) #这里可以切换环境,去ngboss_config.ini配置 self.driver.maximize_window()
from Base import ReadConfig from Base.SysPara import SysPara as sp from PageObj.ngboss.mainpage import MainPage from PageObj.ngboss.login_page import LoginPage from Base.Mylog import LogManager from Check.PageCheck import PageAssert from Common.TestAsserts import Assertion as Assert from PageObj.order.BizCommon.ElementPartBase import MainPlanSelectPart from PageObj.order.BizCommon.ElementPartBase import DealUserCommon from PageObj.order.BizCommon.ElementPartBase import SelectElements from PageObj.order.BizCommon.ElementPartBase import PageCommonPart from Check.RuleCheck import RuleCheckBefore # 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('ProdChangePage').get_logger_and_add_handlers( 1, log_path=ReadConfig.log_path, log_filename=time.strftime("%Y-%m-%d") + '.log') rc = ReadConfig.ReadConfig("ngboss_config.ini") class ProdChangePage(Base): def open_base(self): self.driver.get(rc.get_ngboss('url')) self.driver.maximize_window() def openProductChange(self): LoginPage(self.driver).login() # 登录 MainPage(self.driver).open_CataMenu( 'crm9000', 'crm9200',
import time from Base.base import Base from selenium.webdriver.common.by import By from Base import ReadConfig from selenium import webdriver from PageObj.ngboss.login_page import LoginPage from PageObj.ngboss.mainpage import MainPage from PageObj.order.BizCommon.PersonOrder.ElementPartBase import DealUserCommon from PageObj.order.BizCommon.PersonOrder.ElementPartBase import SelectElements from Check.PageCheck import PageAssert from Base.Mylog import LogManager rc = ReadConfig.ReadConfig("ngboss_config.ini") logger = LogManager('PlatServiceOrder').get_logger_and_add_handlers(1,is_add_stream_handler=True, log_path=ReadConfig.log_path, log_filename=time.strftime("%Y-%m-%d")+'.log' ) class PlatServiceOrder(Base): '''平台业务受理''' def open_base(self): self.driver.get(rc.get_ngboss('url')) self.driver.maximize_window() #self.driver.implicitly_wait(30) def openPlatServiceOrder(self): LoginPage(self.driver).login(rc.get_ngboss('username'), rc.get_ngboss('password')) # 登录 MainPage(self.driver).open_CataMenu('crm9000', 'IBS1000', 'IBS9271',menuPath='page/order.page.pc.person.plat.PlatOrder') # 进入产品变更页面 logger.info('进入平台业务办理页面') def searchPlatSvcByOfferCode(self,OfferCode): ''' 通过OfferCode查询平台服务 :param OfferCode:平台服务编码OfferCode
from PageObj.order.person.ChangeProdStatus import ChangeProdStatus from selenium.webdriver.common.by import By from selenium import webdriver from Base import ReadConfig # from Common.function import join_dictlists # from Base.OperExcel import write_dict_xls,write_xlsBycolName_append from Base.Mylog import LogManager from Base.OracleOper import MyOracle from TestCases.suite import mySuitePrefixAdd from Check.PageCheck import PageAssert from Common.TestDataMgnt import get_TestData os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.UTF8' rc = ReadConfig.ReadConfig("ngboss_config.ini") logger = LogManager('ChangeProdStatusTest').get_logger_and_add_handlers( 1, log_path=ReadConfig.log_path, log_filename=time.strftime("%Y-%m-%d") + '.log') # ora = MyOracle() #取停开机业务受理号码 ''' :param busiCode: 传入停开机业务受理类型 126 局方开机,136 局方停机 132 挂失 131 报停,133 报开 138 特殊停机 496 担保开机 497 紧急开机 ''' params = [] file = get_TestData('SubscriberStop')['filename'] # 报停
import time from Base.base import Base from selenium.webdriver.common.by import By from Base import ReadConfig from Base.Mylog import LogManager from Check.RuleCheck import RuleCheckBefore from Check.PageCheck import PageAssert from Common.TestAsserts import Assertion rc = ReadConfig.ReadConfig("ngboss_config.ini") logger = LogManager('MainPlanSelectPart').get_logger_and_add_handlers(1,is_add_stream_handler=True, log_path=ReadConfig.log_path, log_filename=time.strftime("%Y-%m-%d")+'.log' ) #================处理页面元素公共类,包含主套餐、服务、优惠、平台服务等======================# class MainPlanSelectPart(Base): '''选择主套餐组件''' def searchMainPlan(self,productId): ''' 查询主套套餐 :param productId: 主套餐编码 :return: ''' text_productSearch = (By.ID,'productSelectPRODUCT_SEARCH_TEXT') self.element_sendkey_enter(text_productSearch,productId) #输入产品编码按回车查询 # time.sleep(2) PageAssert(self.driver).pageLoading() SubproductStr = "//button[contains(@productid,'%s') and contains(@ontap,'productSelect.selectProduct')]" %productId btn_Subproduct = (By.XPATH,SubproductStr) #订购按钮 self.isElementDisplay(btn_Subproduct,'click') #点击主套餐订购 PageAssert(self.driver).pageLoading()
import ddt,time from Base import HTMLTestRunnerCNNew from selenium.webdriver.common.by import By from selenium import webdriver from Base import ReadConfig from Base.OperExcel import write_dict_xls,write_xlsBycolName_append from PageObj.order.person.ChangePayRela import ChangePayRelaNor from Base.Mylog import LogManager from Base.OracleOper import MyOracle from TestCases.suite import mySuitePrefixAdd from Check.PageCheck import PageAssert from Common.TestDataMgnt import get_TestData,get_testDataFile os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.UTF8' rc = ReadConfig.ReadConfig("ngboss_config.ini") logger = LogManager('ChangeProdStatusTest').get_logger_and_add_handlers(1, log_path=ReadConfig.log_path, log_filename=time.strftime("%Y-%m-%d")+'.log' ) # ora = MyOracle() # ''' # operCode == '1' 分账 # operCode == '2' 合账 # ''' # #分账 # sql_sep = "select rownum No ,'' result_info ,'' flowid,T.ACCESS_NUM ,'1' Oper_code from uop_file4.um_subscriber t ,uop_file4.um_prod_sta a \ # where t.remove_tag = '0' and a.IS_MAIN ='1' and a.PROD_STATUS='0' and a.EXPIRE_DATE> sysdate \ # and a.PARTITION_ID = t.partition_id and a.SUBSCRIBER_INS_ID = t.subscriber_ins_id \ # and t.access_num LIKE '187%' and t.mgmt_district ='0872' \ # and rownum <=3 " # # # 合帐 # sql_merg = "select rownum No ,'' result_info ,'' flowid,T.ACCESS_NUM ,'2' Oper_code from uop_file4.um_subscriber t ,uop_file4.um_prod_sta a \
from selenium.webdriver.common.by import By from selenium import webdriver from Base import ReadConfig from Base.OperExcel import write_dict_xls,write_xlsBycolName_append from PageObj.order.group.BusiAccept.GroupOfferAccept import GroupOfferAccept from Base.Mylog import LogManager from TestCases.suite import mySuitePrefixAdd # from Check.PageCheck import PageAssert from Check.DataCheck import DataCheck # from Data.DataMgnt.TestDataMgnt import TestDataExcel from Data.DataMgnt.DataOper import DataOper from Data.DataMgnt.TestResult import TestResultOper os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.UTF8' rc = ReadConfig.ReadConfig("ngboss_config.ini") logger = LogManager('CrtUsVpmnTest').get_logger_and_add_handlers(1, log_path=ReadConfig.log_path, log_filename=time.strftime("%Y-%m-%d")+'.log' ) # params = TestDataExcel().get_TestData('CrtUsVPMN')['params'] # file = TestDataExcel().get_TestData('CrtUsVPMN')['filename'] params = DataOper().getCasePara('CrtUsVPMN') logger.info('=========================') logger.info(params) @ddt.ddt class CrtUsVpmnTest(unittest.TestCase): '''集团VPMN商品订购''' # @classmethod def setUp(self): self.driver = webdriver.Chrome() self.driver.get(rc.get_ngboss('url')) #这里可以切换环境,去ngboss_config.ini配置 self.driver.maximize_window()