Exemplo n.º 1
0
    def get_main(self, host, lujing=None, data=None, headers=None):
        try:
            if lujing != None:
                url = host + lujing
            else:
                url = host

            if headers != None:
                # print("ok")
                if type(headers) == dict:
                    headers = headers
                else:
                    headers = eval(
                        headers)  # 如果data 不是dict 类型 就必须先是str 然后转成dict
                res = requests.get(url=url,
                                   data=data,
                                   headers=headers,
                                   verify=False)
                # print(res)
            else:
                res = requests.get(url=url, data=data, verify=False)
            if res.status_code != 200:  # 判断响应状态码是否不为200
                print('响应状态码不等于200,实际为:{}'.format(res))
                Log().info(res)

        except Exception as e:
            Log().info('post 请求错误 错误原因为%s' % e)
        else:  # 响应状态码正确转为json
            response = res.json()  # 将返回的数据转换为json格式的 字典
            return response
Exemplo n.º 2
0
 def setUp(self):
     self.logger = Log()
     self.logger.log_info('「Login Test Start:')
     url = 'http://10.10.15.153'
     self.driver = webdriver.Chrome()
     self.driver.maximize_window()
     self.lp = LoginPage(self.driver, url)
     time.sleep(3)
Exemplo n.º 3
0
    def setUp(self):
        Current_class = os.path.basename(__file__)
        print(Current_class)
        self.log = Log(Current_class)
        #关联参数存储字典
        self.OverallData = dict()
        #关联参数生成
        self.LinkedValue = None

        self.interfacetest = InterfaceTest()
Exemplo n.º 4
0
    def post_main(self,
                  host,
                  lujing,
                  data,
                  headers=None):  #host 为基础url ,lujing为路径
        try:
            if lujing != None:
                url = host + lujing
            else:
                url = host
            # print(url)
            # print(type(data))
            if type(data) == dict:  #判断是否为dict 类型

                data = data
            else:
                # print("nooo")
                data = eval(data)  #如果data 不是dict 类型 就必须先是str 然后转成dict
            if headers != None:
                if type(headers) == dict:

                    headers = headers
                else:
                    headers = eval(
                        headers)  #如果data 不是dict 类型 就必须先是str 然后转成dict

                res = requests.post(url=url,
                                    json=data,
                                    headers=headers,
                                    verify=False)

            else:
                res = requests.post(url=url, json=data, verify=False)
            if res.status_code != 200:  #判断响应状态码是否不为200
                print('响应状态码不等于200,实际为:{}'.format(res))
                Log().info(res)

        except Exception as e:
            Log().info('post 请求错误 错误原因为%s' % e)
        else:  # 响应状态码正确转为json
            response = res.json()  # 将返回的数据转换为json格式的 字典
            return response
Exemplo n.º 5
0
class TestCase(unittest.TestCase):
    def setUp(self):
        Current_class = os.path.basename(__file__)
        print(Current_class)
        self.log = Log(Current_class)
        #关联参数存储字典
        self.OverallData = dict()
        #关联参数生成
        self.LinkedValue = None

        self.interfacetest = InterfaceTest()

    def tearDown(self):
        pass

    @data(*datalist)
    def testJDproduct(self, Data):
        #测试用用例描述
        Response, Result = None, None
        print("用例名称:{}".format(Data["CaseName"]))
        print("LinkedData" + Data["LinkedData"])
        if (Data["LinkedData"] != ''):
            self.LinkedValue = str(
                Data["LinkedData"]) + "=" + self.OverallData[str(
                    Data["LinkedData"])]
        self.log.info("Headers:%s" % (Data["Headers"]))
        if (self.LinkedValue != None):
            Result, Response = self.interfacetest.testrequest(
                Data["URL"], Data["URI"], Data["Param"] + self.LinkedValue,
                Data["RequestForm"], Data["File"], Data["CheckPoint"],
                Data["Headers"], Data["ID"], Data["CaseName"])
        else:
            Result, Response = self.interfacetest.testrequest(
                Data["URL"], Data["URI"], Data["Param"], Data["RequestForm"],
                Data["File"], Data["CheckPoint"], Data["Headers"], Data["ID"],
                Data["CaseName"])
        # print("Response:%s"%(Response))
        if (re.findall(r"<td>(.*?)</td>", Response) != None):
            self.OverallData["id"] = re.findall(r"<td>(.*?)</td>", Response[0])
        self.assertEqual("成功", Result)
Exemplo n.º 6
0
 def __init__(self, excelPath, sheet_id):
     if not os.path.exists(excelPath):
         Log().error('测试用例文件不存在!')
         sys.exit()
     self.excelPath = excelPath
     self.data = xlrd.open_workbook(excelPath)
     self.table = self.data.sheets()[sheet_id]
     # 获取第一行作为key值
     self.keys = self.table.row_values(0)
     # 获取总行数
     self.rowNum = self.table.nrows
     # 获取总列数
     self.colNum = self.table.ncols
Exemplo n.º 7
0
def send_email(file_path):
    # ----------1.跟发件相关的参数------
    # smtpserver  # 发件服务器
    smtpserver = "smtp.qq.com"
    port = 465  # 端口
    sender = "*****@*****.**"  # 账号
    shouquan = "rpybibdelqojbgfc"  # 授权码  qq邮箱
    receiver = ["*****@*****.**"]  # 接收人

    # ----------2.编辑邮件的内容------

    subject = "主题:66ifuel接口测试报告"
    msg = MIMEMultipart('alternative')
    msg['from'] = sender
    msg['to'] = ";".join(receiver)  # 发送多个接收人
    msg['subject'] = subject
    with open(file_path, 'rb') as fb:
        mail_body = fb.read()

    # # 定义邮件正文为 html 格式
    # body = MIMEText(mail_body, 'html', 'utf-8')
    # msg.attach(body)
    # # 定义邮件正文为 text 格式
    msg.attach(MIMEText('请下载html附件进行查看', 'plain', 'utf-8'))

    # 	#附件
    att = MIMEText(mail_body, 'base64', 'utf-8')
    att["Content-Type"] = "application/octet-stream"
    att["Content-Disposition"] = 'attachment; filename="test_report.html"'  # 重命名的邮件
    msg.attach(att)
    #
    #
    # 	# ----------3.发送邮件163------
    # smtp = smtplib.SMTP()
    # smtp.connect(smtpserver)  # 连服务器
    try:
        # # ----------4.发送邮件QQ------
        smtp = smtplib.SMTP_SSL(smtpserver, port)
        smtp.login(sender, shouquan)  # 登录

        smtp.sendmail(sender, receiver, msg.as_string())  # 发送
        smtp.quit()  # 关闭
    except Exception as e:
        # print(e)
        Log().warning('邮件发送失败:%s' % e)
Exemplo n.º 8
0
def mysql_execute(sql, number=None):
    '''执行 单表sql 语句'''
    # with db.cursor(cursor=pymysql.cursors.DictCursor) as cursor:#获取数据库连接的对象以字典形式
    with db.cursor() as cursor:
        try:
            if number == 'one':
                cursor.execute(sql)
                print('执行成功')
            elif number == 'more':
                cursor.executemany(sql)
            else:
                pass
        except Exception as a:
            db.rollback()  # sql 执行异常后回滚
            Log().debug("执行 SQL 语句出现异常:%s" % a)
        # print("执行 SQL 语句出现异常:%s"%a)
        else:
            cursor.close()
            cursor.commit()  # sql 无异常时提交
            db.close()
Exemplo n.º 9
0
def mysql_getrows(sql, number=None):
    ''' 返回查询结果'''
    with db.cursor() as cursor:
        try:
            if number == 'one':
                cursor.execute(sql)
                # print('执行成功')
                row = cursor.fetchone()
                return row
            elif number == 'more':
                cursor.executemany(sql)
                rows = cursor.fetchall()
                return rows
            else:
                pass
        except Exception as a:
            print("查询结果错误:%s" % a)
            Log().debug("查询结果错误:%s" % a)
        else:
            cursor.close()
            db.close()
Exemplo n.º 10
0
 def dict_data(self):
     """
     读取excel数据
     :return:
     """
     Log().info('开始读取excel数据')
     if self.rowNum <= 1:
         print("总行数小于1")
     else:
         r = []
         j = 1
         for i in list(range(self.rowNum - 1)):  #循环行
             s = {}
             # 从第二行取对应values值
             s['rowNum'] = i + 2
             values = self.table.row_values(j)
             # print(values)
             for x in list(range(self.colNum)):  # 在行的循环下进行 循环列
                 s[self.keys[x]] = values[x]
                 # # print(self.keys[x])
                 # print( values[x])
             r.append(s)
             j += 1
         return r
Exemplo n.º 11
0
    def get_xls(self):
        '''
        读取测试用例,
        xls_name为Excel表格名称
        sheet_name为sheet的名称
        '''
        # config.ini文件存放路径
        config_path = GetPath().get_conf_path()
        # 读取配置文件config.ini
        config = configparser.ConfigParser()
        config.read(config_path)
        # 获取[excel]中指定的file_name
        file_name = config.get('excel', 'file_name')
        # 获取[excel]中指定的sheet_name
        sheet_name = config.get('excel', 'sheet_name')

        # 测试用例文件路径:../TestCase
        case_path = os.path.join(GetPath().get_case_dir(), file_name)
        log = Log(__name__).getlog()
        # 判断用例文件是否存在
        if not os.path.isfile(case_path):
            # 记录到日志并退出python程序
            log.error("测试用例文件不存在!")
            os._exit(1)

        file = open_workbook(case_path)  # 打开EXCEL
        sheets = sheet_name.split('|')
        cls = []  # 用于存储用例
        for s in sheets:
            try:
                sheet = file.sheet_by_name(s)  # 打开指定sheet
            except XLRDError as e:
                log.error("config.ini文件中sheet_name编辑错误")
                raise
            nrows = sheet.nrows  # sheet的行数
            for i in range(nrows):
                if sheet.row_values(i)[0] != 'Num':  # 过滤顶栏目录
                    if sheet.row_values(i)[9] != 'no':  # 过滤未激活的用例
                        cls.append(sheet.row_values(i))
        return cls
Exemplo n.º 12
0
# @Software :PyCharm

from selenium.webdriver.support.wait import WebDriverWait
from selenium.webdriver.common.action_chains import ActionChains
from selenium.webdriver.support import expected_conditions as EC
from selenium.webdriver.common.by import By
from selenium.webdriver.common.keys import Keys
from selenium.common.exceptions import *
from Common.log import Log
from Common.dir_config import *
import time
import os
import sys

# 定义resultlog和processlog
P_log = Log(processlog_dir)
R_log = Log(resultlog_dir)


class BasePage:
    def __init__(self, driver):
        self.driver = driver
        self.driver.maximize_window()

    # 等待元素可见
    def wait_eleVisible(self, loctor, by=By.XPATH, wait_times=20):
        if by not in By.__dict__.values():
            P_log.error("定位类型[ {0} ]不在支持的定位类型范围内".format(by))
            raise InvalidSelectorException
        # 当前运行时间
        t1 = time.time()
Exemplo n.º 13
0
@file: sendMail.py
@ide: PyCharm Community Edition
@time: 2018-11-15 17:14
@blog: https://www.cnblogs.com/gotesting/

'''

import os
import smtplib
import time
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
from Common.log import Log
from Config.globalConfig import report_path

logger = Log()
# 配置收发件人
recv_address = ['*****@*****.**']
# 163的用户名和密码
send_addr_name = '*****@*****.**'
send_addr_pswd = 'jiaxy19920319'


class SendMail:
    def __init__(self, recver=None):
        """接收邮件的人:list or tuple"""
        if recver is None:
            self.sendTo = recv_address
        else:
            self.sendTo = recver
Exemplo n.º 14
0
import unittest
import HTMLTestRunner
import time

from Config.globalConfig import *
from TestSuite import  testSuite
from Common.log import Log
from Common.sendMail import SendMail

def run_test():


    runner = unittest.TextTestRunner()
    curTime = time.strftime('%Y-%m-%d_%H_%M_%S')
    report_name = report_path + '\\' + 'TestResult-' + curTime + '.html'
    with open(report_name,'wb') as f:
        runner = HTMLTestRunner.HTMLTestRunner(
            stream = f,
            title = '测试报告'
        )
        runner.run(testSuite.suite)

    time.sleep(3)
    mail = SendMail()
    mail.send()

if __name__ == '__main__':
    logger = Log()
    logger.log_info('*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*- Auto  Test  Comming -*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*')
    run_test()
    logger.log_info('*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*- Auto  Test  Done -*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*')
Exemplo n.º 15
0
    def testrequest(self, URL, URI, Param, RequestForm, File, CheckPoint,
                    Headers, num, CaseName):
        Current_class = os.path.basename(__file__)
        print(Current_class)
        log = Log(Current_class)
        # 可选
        '''
        Headers = {'Content-Type':'application/x-www-form-urlencoded;charset=UTF-8'}
        Headers = {'Content-Type':'application/json;charset=utf-8'}
        '''
        # 生成请求类的对象
        req = Interface_Request()
        # req_get = req.req_get(url,params = params,Headers = Headers)
        # 请求前缀和接口地址的拼接
        full_url = URL + URI

        # 判断请求类型
        if (RequestForm == 'GET'):
            # 调用请求类的函数,得到返回结果
            self.req_test = req.req_get(full_url, Param, Headers)

        # elif (RequestForm == 'POST' and DataForm == 'Form'):
        #     self.req_test = req.post_kv(full_url, Param, Headers)
        # elif (RequestForm == 'POST' and DataForm == 'Json'):
        #     Headers = {'Content-Type': 'application/json;charset=utf-8'}
        #     self.req_test = req.post_json(full_url, Param, Headers)
        # elif (RequestForm == 'POST' and DataForm == 'File'):
        #     Headers = {'Content-Type': 'multipart/form-data;boundary=----WebKitFormBoundaryrGKCBY7qhFd3TrwA'}
        #     self.req_test = req.post_json(full_url, Param, Headers)

        elif (RequestForm == 'POST'
              and re.search("application/x-www-form-urlencoded", Headers)):
            self.req_test = req.post_kv(full_url, Param, Headers)
        elif (RequestForm == 'POST'
              and re.search("application/json", Headers)):
            self.req_test = req.post_json(full_url, Param, Headers)
        elif (RequestForm == 'POST'
              and re.search("multipart/form-data", Headers)):
            Headers = {'Content-Type': 'multipart/form-data'}
            self.req_test = req.post_json(full_url, File, Headers)
        else:
            print("请求不通过,请检查case用例配置:{0}-{1}".format(num, CaseName))
            log.error("请求不通过,请检查case用例配置:{0}-{1}".format(num, CaseName))
            return "请求不通过,请检查case用例配置:{0}-{1}".format(num, CaseName), ''

        # 检查点与响应数据做对比
        if (re.search(CheckPoint, str(self.req_test))):
            log.info("用例编号" + str(num) + " " + CaseName + "接口执行成功")
            return "成功", str(self.req_test)
        else:
            log.error("用例编号" + str(num) + " " + CaseName + "接口执行失败")
            return "失败", str(self.req_test)


# #请求前缀
# url = "http://p.3.cn"
# #接口地址
# uri = "/prices/mgets"
# params = {"skuIds":"100004770249","type":"1"}
# Headers = {}
# #请求类型
# RequestForm = 'GET'
# #数据类型
# dataform = 'json'
# #检查点
# checkpoint = '"id":"J_100004770249"'
#
# it = InterfaceTest()
# it.testrequest(url,uri,params,RequestForm,dataform,checkpoint,Headers)
Exemplo n.º 16
0
class TestLogin(unittest.TestCase):
    def setUp(self):
        self.logger = Log()
        self.logger.log_info('「Login Test Start:')
        url = 'http://10.10.15.153'
        self.driver = webdriver.Chrome()
        self.driver.maximize_window()
        self.lp = LoginPage(self.driver, url)
        time.sleep(3)

    def tearDown(self):
        self.driver.quit()
        self.logger.log_info('_Login Test End」')

    # 登录成功
    def test_1_login_success(self):
        self.lp.login('system', '123456')
        time.sleep(3)
        try:
            msg = self.driver.find_element_by_xpath(
                '//*[@class="gd-topbar-tool-text"]').text
            self.assertEquals('system', msg)
            self.logger.log_info('Test Case "test_1_login_success" Passed !')
        except Exception as e:
            self.logger.log_error(
                'Test Case "test_4_login_fail" Failed ! \n{0}'.format(e))
            raise e

    # 无用户名登录
    def test_2_login_no_username(self):
        self.lp.login('', '123456')
        time.sleep(3)
        try:
            msg = self.driver.find_element_by_xpath(
                '//*[@class="gd-login-submit-text"]').text
            self.assertEquals('登 录', msg)
            self.logger.log_info(
                'Test Case "test_2_login_no_username" Passed !')
        except Exception as e:
            self.logger.log_error(
                'Test Case "test_4_login_fail" Failed ! \n{0}'.format(e))
            raise e

    # 无密码登录
    def test_3_login_no_passwd(self):
        self.lp.login('system', '')
        time.sleep(3)
        msg = self.driver.find_element_by_xpath(
            '//*[@class="gd-login-submit-text"]').text
        try:
            msg = self.driver.find_element_by_xpath(
                '//*[@class="gd-login-submit-text"]').text
            self.assertEquals('登 录', msg)
            self.logger.log_info('Test Case "test_3_login_no_passwd" Passed !')
        except Exception as e:
            self.logger.log_error(
                'Test Case "test_4_login_fail" Failed ! \n{0}'.format(e))
            raise e

    # 用户名/密码错误
    def test_4_login_fail(self):
        self.lp.login('system', '1234567890')
        time.sleep(3)
        try:
            msg = self.driver.find_element_by_xpath(
                '//*[@class="gd-login-msg"]').text
            self.assertEquals('用户名或密码错误', msg)
            self.logger.log_info('Test Case "test_4_login_fail" Passed !')
        except Exception as e:
            self.logger.log_error(
                'Test Case "test_4_login_fail" Failed ! \n{0}'.format(e))
            raise e
Exemplo n.º 17
0
#!/usr/bin/env python
# -*- encoding: utf-8 -*-
# @Author : Zhuzj
# @file : test_login.py
# @time : 2020/11/18 15:14
# @Software :PyCharm

import pytest
from PageObjects.login.login import login
from PageObjects.index.firstpage import First_Page
from Common.log import Log
from Common import dir_config
import TestDatas.公共数据.login_test_datas as LTD

#定义resultlog和processlog
P_log = Log(dir_config.processlog_dir)
R_log = Log(dir_config.resultlog_dir)


@pytest.mark.usefixtures("init_web")
class Test_login:
    @pytest.mark.smoke
    def test_login_success(self, init_web):
        #动态添加description中的内容
        self.test_login_success.__func__.__doc__ = LTD.success_data['dec']
        P_log.info("*******开始执行{0}测试用例******".format(LTD.success_data['name']))
        login(init_web).login_system(LTD.success_data['username'],
                                     LTD.success_data['pwd'])
        P_log.info("********{0}用例执行完成*******".format(LTD.success_data['name']))
        #name=First_Page(init_web).get_login_name()
        #P_log.info("获取到的账户名为:{0}".format(name))
Exemplo n.º 18
0
def send_requests(session,testdata):
	Log().info("开始发送请求")
	"封装requests请求"
	url = testdata["url"]
	method=testdata["method"]
	# 请求头部headers
	try:
		headers = eval(testdata["headers"])
	except:
		headers = None
	# post请求body类型
	body_type = testdata["type"]
	# 请求的datas参数 # 判断传data数据还是json
	datas=None     #定义一个datas 作为返判断返回值
	if body_type=='from':
		try:
			datas=eval(testdata["datas"]) #取出来的str 需转换为dict
		except:
			datas=None

	elif body_type=='json':
		try:
			datas =json.dumps(testdata["datas"])    #取出来的str 转变成json类型字典
		except:
			datas=None
	#执行的id
	test_nub = testdata['id']
	
	print("*******正在执行用例:-----  %s  ----**********" % test_nub)
	print("请求方式:%s, 请求url:%s" % (method, url))
	# print(type(datas))
	print("请求datas:%s" % datas)
	response = {}  # 接受返回数据  后面写入数据
	res=None        #定义一个res 作为返回值
	is_run= testdata['must']
	# print(is_run)
	if is_run=='yes':  #判断是否执行
		try:
			if method=='get':
				res=session.get(url=url,
				                headers=headers,
				                params=datas,
				                verify=False)
				response["Times"] =str(res.elapsed.total_seconds())
				print("页面返回信息:%s" % res.content.decode("utf-8"))
			elif method=='post':
				res = session.post(
				                  url=url,
				                  headers=headers,
				                  data=datas,
				                  verify=False)
				response["Times"]=str(res.elapsed.total_seconds())
				# print(response["Times"])
				print("页面返回信息:%s" % res.content.decode("utf-8"))
			else:
				print('方法有误')
				return res    # return是用来终止代码运行的  在返回结果后
			response['rowNum'] = testdata['rowNum']
			response["text"] = res.content.decode("utf-8")
			str_response=json.loads(res.text)
			# print(str_response["code"])
			if str_response["code"]!=200:           #如果状态码不为200时写入 Response
				response["Response"]=response["text"]
			else:
				response["Response"]=""   #如果=200则写入空值
			response["Msg"] = ""       #提前定义Msg 默认为空
			if testdata["CheckPoint"] in response["text"]:
				response["Result"]="pass"
			else:
				response["Result"] = "fail"

			print("用例测试结果:   %s---->%s" % (test_nub, response["Result"]))
			return response
		except Exception as msg:
			response["Msg"] = str(msg)
			# print(response)
			return response
	else:
		response=""                    #如果不执行response 赋值为空 后面调用写入方法好判断
		print("用例跳过")
		return response
Exemplo n.º 19
0
#连接数据库 port必须为int %d类型
config = {
    "host": "123.157.219.74",
    "user": "******",
    "password": "******",
    "port": 33066,
    "database": "charging",
    "charset": "utf8"
}

try:
    db = pymysql.connect(**config)
except Exception as a:
    print("数据库连接异常:%s" % a)
    Log().debug("数据库连接异常:%s" % a)


def mysql_execute(sql, number=None):
    '''执行 单表sql 语句'''
    # with db.cursor(cursor=pymysql.cursors.DictCursor) as cursor:#获取数据库连接的对象以字典形式
    with db.cursor() as cursor:
        try:
            if number == 'one':
                cursor.execute(sql)
                print('执行成功')
            elif number == 'more':
                cursor.executemany(sql)
            else:
                pass
        except Exception as a: