res = requests.post(url = u,json = d)
assert res.status_code == 200
assert res.json()["status"] == 200
sql = "select * from t_user where username='******'".format(d["username"])
r = query(sql)
assert len(r) != 0
print("登录接口测试通过!")
#token取出来
# print(res.text)
#取出token并且保存
token = res.json()["data"]["token"]
write_file("user_token.txt",token)
user_token = read_file("user_token.txt")
#接口2：用户修改头像
u1 = "http://192.144.148.91:2333/updateuserheadpic"
h1 = {"Content-Type":"application/json","token":user_token} #请求头:字典
d1 = {"ximg":"chen.jpg"} #参数
r1 = requests.post(url = u1,json = d1,headers = h1) #hearders：指定请求头
assert res.status_code == 200
assert res.json()["status"] == 200
#修改类型的数据如何查
sql = "select * from t_user where username = '******' and headpic = 'chen.jpg'"
assert len(query(sql)) != 0
print("用户修改头像成功!")
# 1.构造请求
u = "http://118.24.105.78:2333/login" # 接口地址
h = {"Content-Type": "application/json"} # 请求头
d = {"username": "******", "password": "******"} # 请求参数
r = requests.post(url=u, headers=h, json=d) # r 是返回值
print(r.text) # r.text：响应值
# assert 条件语句，assert是python里用来断言的
# 2.判断结果
# print( r.status_code)
assert r.status_code == 200 # 判断状态码， 获取本次响应的状态码是否等于200
# print(r.json()) # r.json()：把返回值 r 转换成字典
assert r.json()["status"] == 200 # 判断结果码
# 3.数据库查询
sql = "select * from t_user where username ='******'".format(d["username"])
assert len(query(sql)) != 0 # 如果账号存在 > sql应该是有结果的 > query(sql)长度 != 0
print("登录接口测试用例执行通过！")
# 保存 token 到 user_name.txt 文件中
token = r.json()["data"]["token"]
write_file("./user_token.txt", token) # 把 token 写入 user_token.txt 文件中
# 用户退出
nt = read_file("./user_token.txt")
u = "http://118.24.105.78:2333/logout" # 接口地址
h = {"Content-Type": "application/json", "token": nt} # 请求头
d = {"username": "******", "password": "******"} # 请求参数
r = requests.get(url=u, headers=h) # r 是返回值
print(r.text)
from dbtools import query
u = 'http://192.144.148.91:2333/login'
d = {'username':'******','password':'******'}
r = requests.post(url=u, json=d)
# print(r.text)
#判断结果
assert r.status_code == 200 #判断状态码
assert r.json()['status'] == 200 #判断结果码 r是返回值 通过r.json()转换成dict格式
#查询数据库：接口的作用来查询
# sql = 'select * from t_user where username = "******"'.format(d['username'])
# # print(query(sql))
# assert len(query(sql)) != 0
token = r.json()['data']['token']
write_file('user_token.txt', token)
user_token = read_file('user_token.txt')
# u1 = 'http://192.144.148.91:2333/updateuserheadpic'
# d1 = {"ximg" :"头像.jpg"}
# h1 = {"Content-Type":"application/json", "token":user_token }
# res = requests.post(url=u1,json=d1,headers=h1)
# assert r.status_code == 200
# assert r.json()['status'] == 200
u2 = 'http://192.144.148.91:2333/article/new'
d2 = {"title":"为什么要学测试", "content":"111", "tags":"测试1254", "brief":"介绍", "ximg":"dsfsdf.jpg" }
h2 = {"Content-Type":"application/json", "token":user_token }
res = requests.post(url=u2,json=d2,headers=h2)
# print(type(res1.text))
assert res1.status_code == 200
assert res1.json()["status"] == 200
# 数据库查询
sql = "select * from tb_user where username ='******' and password='******'".format(
dd["username"], dd["password"])
r = query(sql)
assert len(r) != 0
# len(r) != 0 > 返回值有数据> sql查到了数据 > 账号和密码在数据库 # len(r) == 0 》 账号和密码不在数据库
print("登陆成功")
#python的关联
uid = res1.json()["data"]["id"]
token = res1.json()["data"]["token"]
# print(token)
write_file('./conf/user_token.txt', res1.json()["data"]["token"])
write_file('./conf/user_id.txt', str(res1.json()["data"]["id"]))
# 文件读写的方式，写入到txt中
print("------领取任务--------")
url2 = "http://zzy.testgoup.com/api/receive/taskinfo"
data2 = {"id": "4761"}
header = {"token": token}
res = requests.post(url=url2, json=data2, headers=header)
assert res1.status_code == 200
assert res1.json()["status"] == 200
sql = "select * from tb_user_task where taskid={} and uid={}".format(
data2["id"], uid)
t = len(query(sql))
d = {"username":"******", "password":"******"}
res = requests.post(url = u,json = d)
print(res.text)
#判断结果
assert res.status_code == 200
assert res.json()["status"] == 200
#查询数据库
sql = "select * from t_user where username = '******'".format(d["username"])
print(sql)
assert len(query(sql)) != 0
print("用户登录接口成功")
#取出用户token
token = res.json()["data"]["token"]
write_file("token.txt",token)
user_token = read_file("token.txt")
# #接口2 用户写篇文章
# #构造请求
# u1 = "http://192.144.148.91:2333/article/new"
# d1 = {"title":"如何学习测试",
# "content":"每天通宵学习",
# "tags":"测试1234",
# "brief":"好好学习测试",
# "ximg":"chen.jpg"}
# h1 = {"Content-Type":"application/json","token":user_token} #请求头:字典
# res1 = requests.post(url = u1,json = d1,headers = h1)
# # print(res1.text)
# #判断结果
# assert 条件语句，assert是python里用来断言的
# 2.判断结果
# print( r.status_code)
assert r.status_code == 200 # 判断状态码， 获取本次响应的状态码是否等于200
# print(r.json()) # r.json()：把返回值 r 转换成字典
assert r.json()["status"] == 200 # 判断结果码
# 3.数据库查询
sql = "select * from t_user where username ='******'".format(d["username"])
assert len(query(sql)) != 0 # 如果账号存在 > sql应该是有结果的 > query(sql)长度 != 0
print("登录接口测试用例执行通过！")
# 保存 token 到 user_name.txt 文件中
token = r.json()["data"]["token"]
write_file("./user_token.txt", token) # 把 token 写入 user_token.txt 文件中
# 发表文章
# 1.构造请求
# nt = read_file("./user_token.txt")
u = "http://118.24.105.78:2333/article/new" # 接口地址
# h = {"Content-Type":"application/json", "token":nt} # 请求头
h = {
"Content-Type": "application/json",
"token": "{}".format(read_file("./user_token.txt"))
}
d = {
"title": "江月年年月相似",
"content": "江畔何年初见月",
"tags": "测试真的6",
"brief": "江月何年初照人",