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