import unittest
import time
import requests
import pymysql
import pandas as pd
class login_shopxo(unittest.TestCase):
def setUp(self):
mydb = pymysql.connect(host="192.168.141.77", port=3306, user="root", password="Abc_031005", database="shopxo")
print(mydb)
# 执行sql语句后,取出返回结果的一个接口。
mycursor = mydb.cursor()
print(mycursor)
mycursor.execute("delete from sxo_cart where user_id=406")
mydb.commit()
pass
def tearDown(self):
pass
def test_login_shopxo(self):
login_url="http://192.168.141.77/shopxo/"+"api.php?s=user/login&"+"application=app&application_client_type=weixin"
print(login_url)
data={
"accounts": "admin",
"pwd": "shopxo",
"type": "username"
}
res=requests.post(url=login_url,json=data).json()
print(res)
#断言是否登录成功
result_login=res['msg']
print(result_login)
self.assertEqual(result_login,"登录成功")
#获取token值
token_price=res['data']['token']
print(token_price)
cart="http://192.168.141.77/shopxo/"+"api.php?s=cart/save&"+"application=app&application_client_type=weixin"+"&token="+token_price
data={
"goods_id": "12",
"spec": [
{
"type": "颜色",
"value": "粉色"
},
{
"type": "尺码",
"value": "S+S"
}
],
"stock": 1
}
res=requests.post(url=cart,json=data).json()
print(res)
self.assertEqual(res['msg'], '加入成功')
# 通过数据库进行进一步断言
db = pymysql.connect(host="192.168.141.77", port=3306, user="root", password="Abc_031005", database="shopxo")
print(db)
read_mysql_result = pd.read_sql("select goods_id from sxo_cart", db)
print(read_mysql_result)
print(type(read_mysql_result))
# 把dataframe格式转换为列表形式。
result_fin = read_mysql_result.values.flatten().tolist()
print(result_fin)
self.assertIn(11,result_fin)
if __name__ == '__main__':
unittest.main()