zip函数
将多个可迭代对象中的每个元素,一一对应的组装/打包成一个元组
a = [1,2,3]
b = [4,5,6]
c = zip(a,b)
c的结果是
(1, 4) (2, 5) (3, 6)
解压与遍历
print(*c) 解包时,只能解包1次
for i, j in c:
for i, j in zip(a,b):
i代表的是()中左边的数据
j代表的是()中右边的数据
使用zip函数打包数据
"""
使用zip函数打包数据
"""
a = [1,2,3]
b = [4,5,6]
c = zip(a,b)
# print(*c)# 解包,只能解一次
# for i,j in c:
# # print(i)
# # print(j)
# print(i,'\t',j)
"""处理测试用例数据和预期结果"""
data = [
{'username':'test01','password':'123456'},
{'username':'test02','password':'123456'},
{'username':'test03','password':'123'}
]
expects =[
'登录成功','登录成功','登录失败'
]
case = zip(data,expects)#打包
for i,j in case:#解包
print(i,j)
测试登录接口
"""
测试登录接口，发送请求，检查响应结果正确性，如果测试失败，输出实际响应内容
登陆接口 login
返回文本类型 html文本格式
用例: test01登陆
1.初始化数据库:写test01
2.列表存用例(发送请求),存预期
3.发送请求
4.比对响应结果
"""
import requests, pymysql
try:
# 数据库初始化
sqls = ["delete from user where username = 'test01'",
"insert into user(id,username,password) values(2,'test01','123456')"
]
conn = pymysql.connect(host='192.168.139.137', user='root', password='123456', db='exam')
cursor = conn.cursor()
for sql in sqls: # 遍历列表
cursor.execute(sql)
conn.commit()
conn.close()
# 执行用例 (发送请求)
case_data = [
{'username': 'test01', 'password': '123456'},
{'username': 'test01', 'password': ''},
{'username': '', 'password': '123456'},
{'username': '', 'password': ''},
{'username': 'test001', 'password': '123456'},
{'username': 'test01', 'password': '123'},
{'username': 'test001', 'password': '1236'},
]
expects = ['登录验证成功', '用户名或密码为空', '用户名或密码为空', '用户名或密码为空', '用户名或密码错误', '用户名或密码错误', '用户名或密码错误']
cases = zip(case_data, expects) # 打包：用例数据 预期结果
# [(用例数据1,预期1),(用例数据2,预期2)]
address = 'http://192.168.139.137/exam/login/'
for arg, expect in cases: # arg表示某一个参数,expect表示某一个预期
res = requests.post(address, arg) # 响应对象
actual = res.text # 实际结果
if expect in actual:
print("测试通过")
else:
print("测试失败\n\t预期结果:", expect, '\n\t实际结果:', actual)
except Exception as e:
print(e)
测试注册接口
"""
测试注册接口，发送请求，检查响应结果正确性，如果测试失败，输出实际响应内容
注册测试用例
接口地址 : http://192.168.175.128/exam/signup/
用户名 密码 确认密码 预期
test02 123456 123456 {'Status': 1000, 'Result': 'Success', 'Message': '注册成功'},
test03 123456 123456 {'Status': 1003, 'Result': 'Username test03 is taken', 'Message': '用户名已被占用'}
test04 1234 123456 {'Status': 1002, 'Result': 'Password Not Compare', 'Message': '两次输入密码的不一致'}
'' 123456 123456 {'Status': 1001, 'Result': 'Input Incomplete', 'Message': '输入信息不完整'}
test05 '' 123456 {'Status': 1001, 'Result': 'Input Incomplete', 'Message': '输入信息不完整'}
test06 123456 '' {'Status': 1001, 'Result': 'Input Incomplete', 'Message': '输入信息不完整'}
'' '' '' {'Status': 1001, 'Result': 'Input Incomplete', 'Message': '输入信息不完整'}
思路：
1.数据库初始化(删除test02，添加test03)
2.用例存列表，预期存入列表
3.循环发送请求,获得响应结果,比对结果
"""
import requests, pymysql
try:
# 数据库初始化
sqls = ["delete from user where username = 'test02'",
"delete from user where username = 'test03'",
"insert into user(id,username,password) values(3,'test03','123456')"]
conn = pymysql.connect(host='192.168.139.137', user='root', password='123456', db='exam')
cursor = conn.cursor()
for sql in sqls: # 遍历列表
cursor.execute(sql)
conn.commit()
conn.close()
# 执行用例 (发送参数给接口)
cases_data = [
{'username': 'test02', 'password': '123456', 'confirm': '123456','name':'测试01'},
{'username': 'test03', 'password': '123456', 'confirm': '123456','name':'测试03'},
{'username': 'test04', 'password': '1234', 'confirm': '123456','name':'测试04'},
{'username': '', 'password': '123456', 'confirm': '123456','name':'测试10'},
{'username': 'test05', 'password': '', 'confirm': '123456','name':'测试05'},
{'username': 'test06', 'password': '123456', 'confirm': '','name':'测试06'},
{'username': '', 'password': '', 'confirm': '','name':''}
]
expects = [
{'Status': 1000, 'Result': 'Success', 'Message': '注册成功'},
{'Status': 1003, 'Result': 'Username test03 is taken', 'Message': '用户名已被占用'},
{'Status': 1002, 'Result': 'Password Not Compare', 'Message': '密码错误'},
{'Status': 1001, 'Result': 'Input Incomplete', 'Message': '输入信息不完整'},
{'Status': 1001, 'Result': 'Input Incomplete', 'Message': '输入信息不完整'},
{'Status': 1003, 'Result': 'Username test06 is taken', 'Message': '用户名已被占用'},
{'Status': 1001, 'Result': 'Input Incomplete', 'Message': '输入信息不完整'}
]
cases = zip(cases_data,expects)
url = 'http://192.168.139.137/exam/signup/'
i = 0 # 表示第i个预期结果
for case,expect in cases:#遍历测试用例 获取参数
res = requests.post(url,case)
actual = res.json()
if expect == actual:
print('测试通过')
else:
print('测试失败\n\t预期结果:',str(expect),'\n\t实际结果:',str(actual))
i = i + 1
except Exception as e:
print(e)
注册接口完成落库检查
"""
测试注册接口，发送请求，检查响应结果和落库结果正确性
sqls=[
"select count(*) from exam.user where username='test02'",
"select count(*) from exam.user where username='test03'",
"select count(*) from exam.user where username='test04'",
"select count(*) from exam.user where username=''",
"select count(*) from exam.user where username='test05'",
"select count(*) from exam.user where username='test06'",
"select count(*) from exam.user where username=''"
]
dbexpect=[1,1,0,0,0,0,0]
思路:
1.数据库初始化
sqls=[很多sql语句]
循环执行sql语句
2.自动化执行多条测试用例
case_data=[很多用例数据(格式都是字典)]
expects=[很多接口返回预期结果(格式是文本或字典)]
expect_sqls=[落库检查的sql语句]
expect_db_rows=[很多预期的数据库中的行数]
循环发送数据,同时比对接口返回,同时比对落库
"""
try:
#数据库初始化
sqls=["delete from user where username = 'test02'",
"delete from user where username = 'test03'",
"insert into user(id,username,password) values(3,'test03','123456')"
]
# 测试数据
case_data=[
{'username': 'test02', 'password': '123456', 'confirm': '123456','name':'测试02'},
{'username': 'test03', 'password': '123456', 'confirm': '123456','name':'测试03'},
{'username': 'test04', 'password': '1234', 'confirm': '123456','name':'测试04'},
{'username': '', 'password': '123456', 'confirm': '123456','name':'测试10'},
{'username': 'test05', 'password': '', 'confirm': '123456','name':'测试05'},
{'username': 'test06', 'password': '123456', 'confirm': '','name':'测试06'},
{'username': '', 'password': '', 'confirm': '','name':''}
]
# 预期结果
expects=[
{'Status': 1000, 'Result': 'Success', 'Message': '注册成功'},
{'Status': 1003, 'Result': 'Username test03 is taken', 'Message': '用户名已被占用'},
{'Status': 1002, 'Result': 'Password Not Compare', 'Message': '两次输入密码的不一致'},
{'Status': 1001, 'Result': 'Input Incomplete', 'Message': '输入信息不完整'},
{'Status': 1001, 'Result': 'Input Incomplete', 'Message': '输入信息不完整'},
{'Status': 1001, 'Result': 'Input Incomplete', 'Message': '输入信息不完整'},
{'Status': 1001, 'Result': 'Input Incomplete', 'Message': '输入信息不完整'}
]
expect_sqls=[
"select count(*) from user where username='test02'",
"select count(*) from user where username='test03'",
"select count(*) from user where username='test04'",
"select count(*) from user where username=''",
"select count(*) from user where username='test05'",
"select count(*) from user where username='test06'",
"select count(*) from user where username=''",
]
expect_db_rows = [1,1,0,0,0,0,0]
# 数据库初始化
import requests,pymysql
conn = pymysql.connect(host='192.168.139.137', user='root', password='123456', db='exam')
cursor = conn.cursor()
for sql in sqls: # 遍历列表 初始化sql语句列表
cursor.execute(sql)
conn.commit()
conn.close()
#执行用例(发送请求,比对接口返回,落库检查)
cases = zip(case_data,expects,expect_sqls,expect_db_rows)
url = 'http://192.168.139.137/exam/signup/'
for arg,expect,sql,expect_rows in cases:
res = requests.post(url,arg)
actual = res.json()
# 判断接口返回正确性
if expect==actual:
print('接口返回正确')
else:
print('接口返回错误\n\t预期结果:',str(expect),'\n\t实际结果:',str(actual))
#落库检查
conn = pymysql.connect(host='192.168.139.137', user='root', password='123456', db='exam')
cursor = conn.cursor()
cursor.execute(sql)
rows = cursor.fetchone()
actual_rows = rows[0]
if actual_rows == expect_rows:
print("落库正确")
else:
print("落库失败\n\t预期结果:",str(expect_rows),'实际结果:',str(actual_rows))
conn.close()
except Exception as e:
print(e)
作者：暄总-tester
