def test_ClientOne(self):
readconfig = ReadConfig.ReadConfig()
readdb = ReadDB.Pymssql()
url = readconfig.get_url('url') + api
session = readconfig.get_member('session')
origin = readconfig.get_url('origin')
headers = {
'Content-Type': "application/json",
'Authorization': session,
"Origin": origin
}
r = requests.get(url=url, headers=headers)
if r.status_code == 200:
clientinfo = readdb.GetClientinfo(
readconfig.get_client('clientid1'))
self.assertEqual(r.json()[0]['display'], clientinfo['display'],
case_describe)
self.assertEqual(r.json()[0]['level'], clientinfo['level'],
case_describe)
self.assertEqual(r.json()[0]['status'], clientinfo['status'],
case_describe)
else:
self.assertEqual(r.status_code, 200, case_describe)
def test_Blog(self):
readconfig = ReadConfig.ReadConfig()
readdb = ReadDB.Pymssql()
url = readconfig.get_url('url') + api
session = readconfig.get_member('session')
origin = readconfig.get_url('origin')
headers = {
'Content-Type': "application/json",
'Authorization': session,
"Origin": origin
}
r = requests.get(url=url, headers=headers)
if r.status_code == 200:
self.assertIn('id', r.json(), case_describe)
customerinfo = readdb.GetBlog(readconfig.get_member('phone'))
self.assertEqual(r.json()['id'], customerinfo['blogid'],
case_describe)
self.assertEqual(r.json()['phone'], customerinfo['phone'],
case_describe)
self.assertEqual(r.json()['companyName'],
customerinfo['companyName'], case_describe)
self.assertEqual(r.json()['nickname'], customerinfo['nickname'],
case_describe)
readconfig.set_member('blogid', customerinfo['blogid'])
else:
self.assertEqual(200, r.status_code, case_describe)
def test_ClientAdd(self, data):
excel = ReadExcl.Xlrd()
readconfig = ReadConfig.ReadConfig()
readdb = ReadDB.Pymssql()
#填写求求参数
url = readconfig.get_url('url') + api
session = readconfig.get_member('session')
origin = readconfig.get_url('origin')
headers = {
'Content-Type': "application/json",
'Authorization': session,
"Origin": origin
}
payload = {
"display": str(data["display"]),
"phone": str(data["phone"]),
"level": str(data["level"])
}
r = requests.post(url=url, headers=headers, data=json.dumps(payload))
#处理请求数据到excl用例文件
excel.set_cell(sheet_name, int(data["case_id"]),
excel.get_sheet_colname(sheet_name)["result_code"],
r.status_code, excel.set_color(r.status_code))
excel.set_cell(sheet_name, int(data["case_id"]),
excel.get_sheet_colname(sheet_name)["result_msg"],
r.text, excel.set_color())
excel.save()
if r.status_code == 200 or r.status_code == 204:
self.assertIn('id', r.json(), data["case_describe"])
clientinfo = readdb.GetClientinfo(r.json()['id'])
self.assertEqual(clientinfo['display'], str(data["display"]),
data["case_describe"])
self.assertEqual(clientinfo['level'], data['level'],
data["case_describe"])
self.assertEqual(clientinfo['phone'], str(data["phone"]),
data["case_describe"])
self.assertEqual(clientinfo['companyId'],
readconfig.get_member('companyId'),
data["case_describe"])
self.assertEqual(clientinfo['customerId'],
readconfig.get_member('customerId'),
data["case_describe"])
readconfig.set_client('clientid' + str(data['level']),
r.json()['id'])
self.assertEqual(r.status_code, data['expected_code'],
data["case_describe"])
def test_ClientMaintain(self, data):
readdb = ReadDB.Pymssql()
excel = ReadExcl.Xlrd()
readconfig = ReadConfig.ReadConfig()
#填写求求参数
url = readconfig.get_url('url') + api
session = readconfig.get_member('session')
origin = readconfig.get_url('origin')
headers = {
'Content-Type': "application/json",
'Authorization': session,
"Origin": origin
}
readdb.SetCustomerMoney(str(data["money"]),
readconfig.get_member('userid'))
if data['isone']:
payload = [{
"id": readconfig.get_client('clientid2'),
"display": "qqq"
}]
else:
payload = [{
"id": readconfig.get_client('clientid3'),
"display": "qqq"
}, {
"id": readconfig.get_client('clientid4'),
"display": "qqq"
}]
r = requests.post(url=url, headers=headers, data=json.dumps(payload))
#处理请求数据到excl用例文件
excel.set_cell(sheet_name, int(data["case_id"]),
excel.get_sheet_colname(sheet_name)["result_code"],
r.status_code, excel.set_color(r.status_code))
excel.set_cell(sheet_name, int(data["case_id"]),
excel.get_sheet_colname(sheet_name)["result_msg"],
r.text, excel.set_color())
excel.save()
if r.status_code == 200 or r.status_code == 204:
orderprice = readdb.GetClientMaintainOrder(r.json()['orderId'])
usermoney = readdb.GetUserMoney(readconfig.get_member('userid'))
self.assertEqual(orderprice, usermoney, data["case_describe"])
self.assertEqual(r.status_code, data['expected_code'],
data["case_describe"])
def test_ClientMaintainNumber(self):
readconfig = ReadConfig.ReadConfig()
readdb = ReadDB.Pymssql()
url = readconfig.get_url('url') + api
session = readconfig.get_member('session')
origin = readconfig.get_url('origin')
headers = {
'Content-Type': "application/json",
'Authorization': session,
"Origin": origin
}
r = requests.get(url=url, headers=headers)
if r.status_code == 200 or r.status_code == 204:
maintainnumber = readdb.GetClientMaintainNumber(
readconfig.get_member('customerid'))
self.assertEqual(r.json()['maintainNumber'], maintainnumber,
case_describe)
else:
self.assertEqual(r.status_code, 200, case_describe)
def test_ClientRemarks(self, data):
excel = ReadExcl.Xlrd()
readconfig=ReadConfig.ReadConfig()
readdb = ReadDB.Pymssql()
#填写求求参数
url = readconfig.get_url('url')+api.format(readconfig.get_client('clientid1'))
session = readconfig.get_member('session')
origin = readconfig.get_url('origin')
headers = {'Content-Type': "application/json",'Authorization':session,"Origin":origin}
payload = {"remarks": str(data["remarks"])}
r = requests.post(url=url, headers = headers,data = json.dumps(payload))
#处理请求数据到excl用例文件
excel.set_cell(sheet_name,int(data["case_id"]),excel.get_sheet_colname(sheet_name)["result_code"],r.status_code,excel.set_color(r.status_code))
excel.set_cell(sheet_name,int(data["case_id"]),excel.get_sheet_colname(sheet_name)["result_msg"],r.text,excel.set_color())
excel.save()
if r.status_code==200 or r.status_code==204:
clientinfo = readdb.GetClientinfo(readconfig.get_client('clientid1'))
self.assertEqual(clientinfo['remarks'],str(data['remarks']),data["case_describe"])
self.assertEqual(r.status_code,data['expected_code'],data["case_describe"])
def test_ClientAll(self):
readconfig = ReadConfig.ReadConfig()
readdb = ReadDB.Pymssql()
url = readconfig.get_url('url') + api
session = readconfig.get_member('session')
origin = readconfig.get_url('origin')
headers = {
'Content-Type': "application/json",
'Authorization': session,
"Origin": origin
}
r = requests.get(url=url, headers=headers)
if r.status_code == 200:
clientallid = readdb.GetClientAllinfo(
readconfig.get_member('customerid'))
responeclientallid = []
for i in range(len(r.json())):
responeclientallid.append(r.json()[i]['id'])
self.assertIn(r.json()[i]['id'], clientallid, case_describe)
self.assertEqual(len(responeclientallid), len(clientallid),
case_describe)
else:
self.assertEqual(r.status_code, 200, case_describe)
