# -- coding: utf-8 -- from config import Conf from common.my_log import Log import logging import time text_log = Log(__name__, file=logging.INFO, cmd=logging.INFO) class Text_action(object): def __init__(self, file_path): self.name = file_path def read_file(self): """ :return: """ with open(self.name, 'r', encoding='utf-8') as fp: for line in fp.readlines(): print(line) def write_file(self, value): """ :return: """ now = time.strftime('%Y-%m-%d %H:%M:%S') with open(self.name, 'a', encoding='utf-8') as ft:
# -- coding: utf-8 -- import xlrd import logging from config.Conf import * from common.my_log import Log readexcel_log = Log(__name__, file=logging.INFO, cmd=logging.WARN) class ReadExcel(object): def __init__(self, filepath, sheetname): """ :param filepath:数据地址 :param sheetname: sheet页名称 """ self.filepath = filepath self.workbook = xlrd.open_workbook(filepath) self.worksheet_name = self.workbook.sheet_by_name(sheetname) def get_excel(self, rows, cloxs): """ :return: """ try: value = self.worksheet_name.cell_value(rows, cloxs) except Exception:
from common.my_log import Log import logging from Page.base_page import BasePage from common.readexcel import ReadExcel from config.Conf import * from common.readini import Readini csplogin_log = Log(__name__, file=logging.INFO, cmd=logging.INFO) csplogin_excel = ReadExcel(filepath=test_data + r'\test_login_data.xlsx', sheetname="login") class LoginPage_CSP(BasePage): username = [ (csplogin_excel.get_excel(1, 3), csplogin_excel.get_excel(1, 4), csplogin_excel.get_excel(1, 5)), csplogin_excel.get_excel(2, 5), #错误的账号 (csplogin_excel.get_excel(3, 3), csplogin_excel.get_excel(3, 4), csplogin_excel.get_excel(3, 5)), csplogin_excel.get_excel(4, 3), #输入错误的密码 (csplogin_excel.get_excel(5, 3), csplogin_excel.get_excel(5, 4)) ] #登录按钮 photo = (csplogin_excel.get_excel(6, 3), csplogin_excel.get_excel(6, 4)) msg = (csplogin_excel.get_excel(7, 3), csplogin_excel.get_excel(7, 4)) url = Readini().get_value(os.path.join(current_path, 'config.ini'), 'test_url', 'url3') def loginbutton(self):
from common.my_log import Log from common.myunit import MYunit import logging import unittest from Page.csp_page.customer_page import CustmoerPage from common import screenshoot from common.writeexcel import Write_Excel import time from config import Conf test_cspcustmoer_log = Log(__name__, file=logging.INFO, cmd=logging.WARN) writedata = Write_Excel(filepath=Conf.test_data + r'\test_customer_data.xlsx', number=4) class Test_csp_custmoer(MYunit): def testcase06(self): """ 测试新增客户且审核通过 :return: """ self.login.csp_login() self.login.wait(0.5) self.custmoer = CustmoerPage(self.driver) value = self.custmoer.assert_text(self.custmoer.add_value[0]) self.custmoer.add_customer() # 新建客户 self.custmoer.finding_check(way_number=True) # 需身份验证查询待审核的数据 value2 = self.custmoer.getpagecode() if value in value2: self.custmoer.click_check() # 客户信息新建审核通过 self.custmoer.find_name() # 查询数据
import unittest import logging from common.my_log import Log from common.myunit import MYunit from Page.csp_page.chatbot_page import ChatbotPage from common import screenshoot import time from common.writeexcel import Write_Excel from config import Conf test_cspchatbot_log = Log(__name__, file=logging.INFO, cmd=logging.WARN) writedata = Write_Excel(filepath=Conf.test_data + r'\test_chatbot_data.xlsx', number=4) class Test_csp_chatbot(MYunit): #@unittest.skip('pass') def testcase12(self): """ 测试新建一个chatbot且审核通过 :return: """ self.login.csp_login() self.login.wait(0.5) self.chatbot = ChatbotPage(self.driver) value = self.chatbot.assert_chatbotname() self.chatbot.add_chatbot() #新增一个chatbot self.chatbot.intocheck(way=True) #进入chatbot审核内置表单 self.chatbot.find_check() #查询出待审核的chatbot数据 value2 = self.chatbot.getpagecode() if value in value2:
from common.my_log import Log from selenium.webdriver.support.ui import WebDriverWait from selenium.webdriver.support import expected_conditions as EC import logging from selenium.webdriver.common.by import By from selenium.webdriver.support.ui import Select import time import win32api import win32con import win32com.client from config.Conf import * import os import random base_log = Log(__name__, logging.INFO, cmd=logging.INFO) read_config = Readini() class BasePage(object): def __init__(self, driver, url=read_config.get_value( os.path.join(current_path, 'config.ini'), 'test_url', 'url1')): """ :param driver: :param url: """ self.base_driver = driver self.base_url = url
# -- coding: utf-8 -- from common.my_log import Log from config import Conf import logging import time screenshoot_log = Log(__name__, file=logging.INFO, cmd=logging.INFO) def screen_shoot(driver, dir, name): """ 截图 :param driver: 浏览器驱动 :param dir: 截图存放地址 :param name: 截图名称 :return: """ now = time.strftime('%Y-%m-%d-%H-%M-%S') file = Conf.test_screenshoot + dir + r'\photo' + now + name + '.png' screenshoot_log.csp_log.info(f'screenshoot {name} save in {file} success') return driver.get_screenshot_as_file(file)
# -- coding: utf-8 -- import logging from selenium import webdriver from common.my_log import Log driver_log = Log(__name__, file=logging.INFO, cmd=logging.INFO) class Driver(object): def chormedriver(self): """ 连接chorme驱动 :return: """ try: self.driver = webdriver.Chrome() except Exception: driver_log.csp_log.exception( f'connection {self.driver} FAIL,sorry please install Chorme driver ' ) raise else: return self.driver def Firefoxdriver(self): """ 连接firefox驱动 :return: """
from common.my_log import Log import logging from Page.base_page import BasePage from common.readexcel import ReadExcel from config.Conf import * from Page.login_page import LoginPage_CSP from common.readini import Readini import os from selenium import webdriver update_pws_log = Log(__name__, file=logging.INFO, cmd=logging.INFO) update_pws_date = ReadExcel(filepath=test_data + r'\test_update_password.xlsx', sheetname="update_pws") class UpdatepwsPage(BasePage): updatedate = [ (update_pws_date.get_excel(1, 3), update_pws_date.get_excel(1, 4)), #0点击忘记密码按钮 (update_pws_date.get_excel(2, 3), update_pws_date.get_excel(2, 4), update_pws_date.get_excel(2, 5)), #1找回密码-输入手机号 (update_pws_date.get_excel(3, 3), update_pws_date.get_excel(3, 4)), #2找回密码-点击获取验证码 (update_pws_date.get_excel(4, 3), update_pws_date.get_excel(4, 4), update_pws_date.get_excel(4, 5)), #3找回密码-输入新密码 (update_pws_date.get_excel(5, 3), update_pws_date.get_excel(5, 4)), #4找回密码-再次输入新密码 (update_pws_date.get_excel(6, 3), update_pws_date.get_excel(6,
from common.my_log import Log import logging from Page.base_page import BasePage from common.readexcel import ReadExcel from config.Conf import * system_log = Log(__name__,file=logging.INFO,cmd=logging.INFO) account_date=ReadExcel(filepath=test_data+r'\test_system_management.xlsx',sheetname="账号管理") role_date =ReadExcel(filepath=test_data+r'\test_system_management.xlsx',sheetname="角色管理") sensitive_date = ReadExcel(filepath=test_data+r'\test_system_management.xlsx',sheetname="敏感词库管理") class SyStem_Management_Page(BasePage): accountdate=[(account_date.get_excel(1,3),account_date.get_excel(1,4)), #0点击系统管理 (account_date.get_excel(2,3),account_date.get_excel(2,4)), #1点击账号管理 (account_date.get_excel(3,3),account_date.get_excel(3,4)), #2输入用户名 (account_date.get_excel(4,3),account_date.get_excel(4,4)), #3输入用户姓名 (account_date.get_excel(5,3),account_date.get_excel(5,4)), #4输入手机号 (account_date.get_excel(6,3),account_date.get_excel(6,4)), #5选择所属角色 (account_date.get_excel(7,3),account_date.get_excel(7,4)), #6选择角色状态 (account_date.get_excel(8,3),account_date.get_excel(8,4)), #7点击查询按钮 (account_date.get_excel(9,3),account_date.get_excel(9,4)), #8点击编辑按钮 (account_date.get_excel(10,3),account_date.get_excel(10,4),account_date.get_excel(10,5)), #9变更用户名 (account_date.get_excel(11,3),account_date.get_excel(11,4),account_date.get_excel(11,5)), #10点击确认变更按钮 (account_date.get_excel(12,3),account_date.get_excel(12,4)), #11点击删除按钮 (account_date.get_excel(13,3),account_date.get_excel(13,4)), #12点击停用按钮 (account_date.get_excel(14,3),account_date.get_excel(14,4)), #13点击新增账号按钮 (account_date.get_excel(15,3),account_date.get_excel(15,4),account_date.get_excel(15,5)), #14输入新增的用户名
# -- coding: utf-8 -- import os from config import Conf from common.my_log import Log import logging delete_log = Log(__name__, file=logging.INFO, cmd=logging.INFO) import time import locale def delete_file(filepath): """ 删除文件 :param filepath: :return: """ file = os.listdir(filepath) for i in file: deletefile = os.path.join(filepath, i) if os.path.isdir(deletefile): delete_file(deletefile) delete_log.csp_log.info(f'THE file of {filepath} 已清空') else: os.remove(deletefile) delete_log.csp_log.info(f'删除{deletefile}成功') def create_dir(filepath): """
from common.myunit import MYunit from common.my_log import Log import logging import unittest from Page.csp_page.csp_page import CspPage from common import screenshoot from common.writeexcel import Write_Excel import time from config import Conf import pytest csp_testlog = Log(__name__, file=logging.INFO, cmd=logging.WARN) writedata = Write_Excel(filepath=Conf.test_data + r'\test_csp_data.xlsx', number=5) class Test_csp_manage(MYunit): #@unittest.skip('pass') def testcase20(self): """ 测试新建csp且审核不通过 :return: """ self.login.csp_login() self.login.wait(0.5) self.csp = CspPage(self.driver) newname = self.csp.random_number() value = self.csp.get_assert_text(text=newname) self.csp.new_csp(name=newname) # 新增一个csp self.csp.intocheck(way=True) # 进入csp审核节点 self.csp.find_check_csp(cspname=newname) # 查询待审核的csp数据
# -- coding: utf-8 -- import configparser import logging from common.my_log import Log import os from config import Conf readini_log = Log(__name__, file=logging.INFO, cmd=logging.WARN) class Readini(object): def __init__(self): self.config = configparser.ConfigParser() def get_value(self, filepath, sectionname, optionname): """ 读取配置文件数据 :param filepath:配置文件 :param sectionname: :param optionname: :return: """ try: self.config.read(filepath, encoding='utf-8') value = self.config.get(sectionname, optionname) except Exception: readini_log.csp_log.exception( f'from {filepath} get value:[{value}]----- failed') raise