def test_info():
"""获取个人信息"""
# 定义测试数据
url = ConfigYaml().get_conf_url() + "/user/"
# url = "http://211.103.136.242:8064/user/"
token = "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VyX2lkIjoxLCJlbWFpbCI6Ijk1MjY3MzYzOEBxcS5jb20iLCJ1c2VybmFtZSI6InB5dGhvbiIsImV4cCI6MTYwMDUyNDI2OH0.LcQtZN02kykI8zvmxw6Y6BOksc3rmQ8EF3BNboLinC4"
headers = {"Authorization": "JWT " + token}
# 发送请求
# r = requests.get(url, headers=headers)
# 调用封装的get方法
# res = requests_get(url, headers=headers)
# 调用Requests重构的get方法
request = Request()
res = request.get(url, headers=headers)
# 输出结果
# print(r.json())
# print(r.text)
print(res)
def handle_res_body(self, info, data_type="data"):
url = info['url']
method = info['method']
data = info['data']
logger().debug(data)
if method == "GET":
res = Request().get(url, params=data)
elif method == "POST":
if data_type == "data":
res = Request().post(url, data=data)
elif data_type == "json":
headers = {"Content-Type": "application/json; charset=UTF-8"}
res = Request().post(url, json=data, headers=headers)
else:
logger().error("data_type 输入有误")
else:
logger().error("method 输入有误")
return res["body"]
def run_api(self, url, method, params=None, header=None, cookie=None):
"""
发送请求api
:return:
"""
request = Request()
if len(str(params).strip()) is not 0:
params = json.loads(params)
if str(method).lower() == "get":
# 增加Headers和cookies
res = request.get(url, json=params, headers=header, cookies=cookie)
elif str(method).lower() == "post":
res = request.post(url,
json=params,
headers=header,
cookies=cookie)
else:
log.error("错误请求method: %s" % method)
return res
def test_info():
#1、参数
url = "http://211.103.136.242:8064/user/"
token = test_Login()
headers = {'Authorization': 'JWT ' + token}
#2、get请求
# r = requests_get(url,headers = headers)
'''初始化'''
request = Request()
r = request.get(url, headers=headers)
# result = r.json()
#3、输出结果
# print(r)
print(
json.dumps(r,
sort_keys=True,
ensure_ascii=False,
indent=4,
separators=(', ', ': ')))
def run_api(self, url, method, params=None, header=None, cookie=None):
"""发送请求api"""
# 接口请求
request = Request()
# params转义json
if len(str(params).strip()) is not 0:
params = json.loads(params)
# method post、get
if str(method).lower() == "get":
# 增加了headers
res = request.get(url, json=params, headers=header, cooikes=cookie)
elif str(method).lower() == "post":
res = request.post(url,
json=params,
headers=header,
cooikes=cookie)
else:
log.error("错误的请求method %s" % method)
# print(res)
return res
def run_api(self, url, method, params=None, header=None, cookie=None):
"""
发送请求api
:return:
"""
# 2).根据url发送接口请求
request = Request()
# params 获取的是字符类型 需要转义成json
# 验证params有没有内容
if len(str(params).strip()) is not 0:
params = json.loads(params)
# method: post / get
if str(method).lower() == "get":
# 2.增加headers
res = request.get(url, json=params, headers=header, cookies=cookie) # 4.增加cookies
elif str(method).lower() == "post":
res = request.post(url, json=params, headers=header, cookies=cookie)
else:
log.error("错误请求method：%s" % method)
return res
def run_api(self, url, params, method='get', header=None, cookie=None):
"""
发送请求
"""
request = Request(ConfigYaml().get_config_url())
if not len(str(params).strip()):
return params
params = json.loads(params)
if str(method).lower() == "get":
res = request.get(url, json=params, headers=header, cookies=cookie)
log.debug('get请求')
elif str(method).lower() == "post":
res = request.post(url,
json=params,
headers=header,
cookies=cookie)
log.debug('post请求')
else:
log.error(f"错误的请求方法:{method}")
return res
def run_api(self,
url,
method,
url_params,
reference,
params=None,
header=None,
cookie=None):
"""
发送请求api
:param url:
:param method:
:param params:
:param header:
:param cookie:
:return:
"""
request = Request()
# params 转义json
if len(str(params).strip()) is not 0:
params = json.loads(params)
if str(method).lower() == "get" and str(reference).lower() == "b":
res = request.get(url, json=params, headers=header, cookies=cookie)
elif str(method).lower() == "get" and str(reference).lower() == "u":
res = request.get(url_params, headers=header, cookies=cookie)
elif str(method).lower() == "post" and str(reference).lower() == "b":
res = request.post(url,
json=params,
headers=header,
cookies=cookie)
elif str(method).lower() == "post" and str(reference).lower() == "u":
res = request.post(url_params, headers=header, cookies=cookie)
else:
log.error("错误请求method： %s" % method)
return res
def run_api(url, method, params=None, body=None, header=None, cookie=None):
request = Request()
if str(method).lower() == "get":
res = request.get(url, params=params, headers=header, cookies=cookie)
elif str(method).lower() == "post":
res = request.post(url,
params=params,
json=body,
headers=header,
cookies=cookie)
elif str(method).lower() == "put":
res = request.put(url,
json=body,
params=params,
headers=header,
cookies=cookie)
elif str(method).lower() == "delete":
res = request.delete(url,
params=params,
headers=header,
cookies=cookie)
else:
log.error("请求方法 method 错误：method写成了 %s" % method)
raise
return res
def test_run(self):
data_key = ExcelConfig.DataConfig
# run_list第一个用例，根据key获取values
url = ConfigYaml().get_conf_url() + run_list[0][data_key.url]
# print(url)
case_id = run_list[0][data_key.case_id]
case_model = run_list[0][data_key.case_model]
case_name = run_list[0][data_key.case_name]
pre_exec = run_list[0][data_key.pre_exec]
method = run_list[0][data_key.method]
params_type = run_list[0][data_key.params_type]
params = run_list[0][data_key.params]
expect_result = run_list[0][data_key.expect_result]
headers = run_list[0][data_key.headers]
cookies = run_list[0][data_key.cookies]
status_code = run_list[0][data_key.status_code]
db_verify = run_list[0][data_key.db_verify]
# 2).根据url发送接口请求
request = Request()
# params 获取的是字符类型 需要转义成json
# 验证params有没有内容
if len(str(params).strip()) is not 0:
params = json.loads(params)
# method: post / get
if str(method).lower() == "get":
# 2.增加headers
res = request.get(url, json=params)
elif str(method).lower() == "post":
res = request.post(url, json=params)
else:
log.error("错误请求method：%s" % method)
print(res)
# TestExcel().test_run()
def run_api(self, url, method, params=None, header=None, cookie=None):
"""
发送请求api
:return:
"""
# 接口请求
request = Request()
# params 转义json
#验证params 有没有内容
if len(str(params).strip()) != 0:
params = json.loads(params)
#method post/get
if str(method).lower() == "get":
#增加headers,cookies
res = request.get(url, json=params, headers=header, cookies=cookie)
elif str(method).lower() == "post":
res = request.post(url,
json=params,
headers=header,
cookies=cookie)
else:
log.error("错误请求method: %S" % method)
# print(res)
return res
# coding=utf-8
import sys
sys.path.append('../')
import pytest
import requests
from utils.RequestsUtil import Request, r_get, r_post
from common.Base import init_db
request = Request(url='http://211.103.136.242:8064')
def test_login():
"""
登录
"""
conn = init_db('db_1')
res_db = conn.fetch_one('select id from tb_user where username="******"')
print(f"数据库查询数据:{res_db}")
url = 'http://211.103.136.242:8064/authorizations/'
data = {'username': '******', 'password': '******'}
r = r_post(url, json=data)
print(r)
'''
{
'token': 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJlbWFpbCI6Ijk1MjY3MzYzOEBxcS5jb20iLCJleHAiOjE1NzM1NzE3ODAsInVzZXJuYW1lIjoicHl0aG9uIiwidXNlcl9pZCI6MX0.CDnyS9thrPFk40Z7PX4vbBTJnzQT582xlsaFZbkRnMs',
'username': '******',
'user_id': 1
}
@Time ： 2020/10/3 20:06
@Auth ： Yvon～₯㎕ζ๓
@File ：Test_Mal.py
"""
"""
登录成功：http://211.103.136.242:8064/authorizations/
post请求2
json {"username":"******","password":"******"}
"""
import pytest, json
from utils.RequestsUtil import requests_get, requests_post, Request
from config.Conf import ConfigYaml
from utils.AssertUtil import AssertUtil
from common.Base import init_db
'''初始化'''
request = Request()
#登录
# 1、导入包
import requests, json
# 2、定义登录方法
def test_Login():
# 3、定义测试数据
conf_y = ConfigYaml() #加载config.Conf文件中的ConfigYaml类
url_path = conf_y.get_conf_url() # 读取配置文件中的url
url = url_path + "/authorizations/" # 拼接url+登录参数
# url = "http://211.103.136.242:8064/authorizations/"
data = {"username": "******", "password": "******"}
# 4、发送Post请求