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()
