python接口测试

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()