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.....') 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 = {
#取10个测试号码停机操作:busicode =131表示停机操作 '''busiCode: 传入停开机业务受理类型 126 局方开机,136 局方停机 132 挂失 131 报停,133 报开 138 特殊停机 496 担保开机 497 紧急开机 ''' sql = "select rownum No ,'' flowid , '' result_info ,t.access_num , '133' busicode \ from uop_file4.um_subscriber t \ where t.access_num in ('18887253716','18887269718','18887269711','18887267264') and t.remove_tag = '0' and rownum <=10" paras = ora.select(sql) #生成xls表,方便后续写入测试结果 write_dict_xls(inputData=paras, sheetName='停开机业务受理', outPutFile=file) logger.info('写入测试数据到xls.....') ##数据驱动paramunittest: # interfaceList_xls = get_exceldata(ReadConfig.data_path+ 'testdata.xls',0) # print(interfaceList_xls) # @paramunittest.parametrized(*interfaceList_xls) @ddt.ddt class TestIntf(unittest.TestCase): def setUp(self): self.file = file self.headers = h self.session = requests.session() logger.info("构建登录请求.....") logger.info("登录地址:" + rc.get_interface_url("url_login"))
self.assertNotIn('校验失败',ruleMsg) # 校验通过才继续执行 logger.info('开始设置主号家庭短号服务') test.screen_step('进入亲情网办理菜单') test.set_mainCard(AccessNum) logger.info('新增家庭成员并设置家庭短号服务') test.set_mutiCard(mutiAccessNumList) time.sleep(2) test.find_element_click(Btn_commit) time.sleep(15) submitMsg = PageAssert(self.driver).assert_submitAfter(file=file,row=row) logger.info('业务受理信息:{}'.format(submitMsg)) test.screen_step('点击提交,受理信息:{}'.format(submitMsg)) test.save_docreport(title) time.sleep(3) self.assertIn('业务受理成功',submitMsg) def tearDown(self): print('测试结束,关闭浏览器器!') self.driver.close() if __name__ == '__main__': report_title = u'亲情网业务办理自动化测试报告' desc = u'亲情网业务办理测试详情:' nowtime = time.strftime("%Y%m%d%H%M%S") logger.info("开始执行testSuite......") print("开始执行testSuite......") with open(ReadConfig.get_reportPath() + report_title + nowtime + ".html", 'wb') as fp: runner = HTMLTestRunnerCNNew.HTMLTestRunner(stream=fp, title=report_title, description=desc,verbosity=2) runner.run(mySuitePrefixAdd(FamilyNetTest,"test_acceptMultiOffer"))
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() self.driver.implicitly_wait(20) #暂时设置40s,隐式等待 @ddt.data(*offers) def test_chgMainOffer(self,dic): """商品主套餐变更""" logger.info("开始参数化......") accessNum = str(dic.get('ACCESS_NUM'))
# ora = MyOracle() #取停开机业务受理号码 ''' :param busiCode: 传入停开机业务受理类型 126 局方开机,136 局方停机 132 挂失 131 报停,133 报开 138 特殊停机 496 担保开机 497 紧急开机 ''' params = [] file = get_TestData('SubscriberStop')['filename'] # 报停 paras_stop = get_TestData(FuncCode='SubscriberStop')['params'] logger.info('停开机业务受理-报停测试准备数据:{}'.format(paras_stop)) params.extend(paras_stop) # 合帐 paras_open = get_TestData(FuncCode='SubscriberOpen')['params'] logger.info('停开机业务受理-报停测试准备数据:{}'.format(paras_open)) params.extend(paras_open) print('======合并后=====', params) # sql_StopMobile = "select rownum No ,'' result_info ,'' flowid,T.ACCESS_NUM,'131' BUSI_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_OpenMobile = "select rownum No ,'' result_info ,'' flowid,T.ACCESS_NUM,'133' BUSI_CODE,a.PROD_STATUS 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 = '1' and a.EXPIRE_DATE> sysdate \
# 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 \ # 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 " # paras_sep= ora.select(sql_sep) # 分账 # paras_merg= ora.select(sql_merg) # 分账 # # paras = paras_sep # # paras = paras_merg file = get_testDataFile() params = [] # 分账 paras_sep = get_TestData(FuncCode='ChgPayRelaSeprate')['params'] logger.info('普通付费关系变更-分账测试准备数据:{}'.format(paras_sep)) params.extend(paras_sep) # 合帐 paras_merge = get_TestData(FuncCode='ChgPayRelaMerge')['params'] logger.info('普通付费关系变更-合帐测试准备数据:{}'.format(paras_merge)) params.extend(paras_merge) params = params print('======合并后=====', params) # now = time.strftime("%Y%m%d%H%M%S") # file = ReadConfig.get_data_path() + 'UITest_ChgPayRelaTest_%s.xls' % now # #生成xls表,方便后续写入测试结果 # write_dict_xls(inputData=paras, sheetName='普通付费关系变更', outPutFile=file) # logger.info('写入测试数据到xls.....') @ddt.ddt class ChgPayRelaTest(unittest.TestCase):
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() @ddt.data(*params) def testCrtUsVpmn(self,dic): '''集团VPMN商品订购''' logger.info("开始参数化......")
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('ChgOfferTest').get_logger_and_add_handlers( 1, log_path=ReadConfig.log_path, log_filename=time.strftime("%Y-%m-%d") + '.log') file = ReadConfig.data_path + 'UITest_ChgOffer.xls' offers = get_exceldata(file, 0) svc = get_exceldata(file, 1) active = get_exceldata(file, 2) logger.info('主套餐变更测试案例执行数据准备:{}'.format(offers)) logger.info('服务变更案例执行数据准备:{}'.format(svc)) logger.info('营销活动受理案例执行数据准备:{}'.format(svc)) @ddt.ddt class ChgOfferTest(unittest.TestCase): """个人业务-商品订购测试""" @classmethod def setUp(self): self.driver = webdriver.Chrome() self.driver.get(rc.get_ngboss('url')) #这里可以切换环境,去ngboss_config.ini配置 self.driver.maximize_window() @ddt.data(*offers) def test_chgMainOffer(self, dic):