# -- 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
