class SendValidataCode(unittest.TestCase):
def setUp(self):
self.filename = Request().dirname(
) + "/Document/Wechat_Applet/sendValidataCode.json"
self.filecontent = FileContent(self.filename)
self.apiname = self.filecontent.get_apiname() # 获取apiname用于获得url
self.api = self.filecontent.get_api() # 获取api用于校验
self.caselist = self.filecontent.get_caselist(
) # 获取caselist列表，包括"reqParams"和"expectResult"
# self.casenumber = self.filecontent.get_casenumber() # 获取case数量
self.verify = Verify()
self.verificationErrors = []
def get_response(self, serial):
"""
:param serial:
:return: 获取接口返回
"""
print(self.apiname)
url = Request().get_url(serial=serial,
filename=self.filename,
apiname=self.apiname)
# session = requests.session()
response = requests.post(url)
if response.status_code == 200:
return response
else:
raise ConnectionRefusedError()
def verify_received_mysql(self, serial):
"""
校验数据库收到了验证码，只判断了最近的一条记录是发送的号码(号码从case获取)
:param serial
:return:
"""
sql = "SELECT * FROM auto.sms WHERE phone='{}' AND smstype='brokerUserLoginCode'"\
.format(self.filecontent.get_reqparams(serial)['phone'])
self.assertIsNotNone(SqlOperation().select_data(sql))
def test_send_success(self):
"""
成功发送验证码
校验点：1、message:返回验证码已发送
2、数据库收到了验证码
:return:
"""
time.sleep(60)
# casenum = {serial: instruction}, 如果与json文档不一致的话就会报错
casenum = {1: "验证码已发送，成功发送验证码"}
for key, value in casenum.items():
print(value, self.filecontent.get_instruction(serial=key - 1))
if operator.eq(value,
self.filecontent.get_instruction(serial=key - 1)):
print("TestCase {}: {}".format(
key, self.filecontent.get_instruction(serial=key - 1)))
else:
raise ValueError(
"TestCase {}'s instruction is not Equal to CaseNum.".
format(key - 1))
delete_sql = """
DELETE FROM auto.sms WHERE phone='{}'
""".format(
self.filecontent.get_reqparams(serial=key - 1)['phone'])
SqlOperation().delete_data(sql=delete_sql)
response = self.get_response(serial=key - 1)
json_result = response.json()
print("response content: ", json_result)
expectresult = self.filecontent.get_expectresult(serial=key - 1)
print("code verify is beginning...")
self.verify.verify_code(expectresult=expectresult,
result=json_result)
print("code verify is success.")
print("message verify is beginning...")
self.verify.verify_message(expectresult=expectresult,
result=json_result)
print("message verify is success.")
self.verify_received_mysql(serial=key - 1)
print("ALL END!!")
def test_repeat_fail(self):
"""
60s内仅能获取一次验证码
校验点：1、message:60s内仅能获取一次验证码，请稍后再试
2、code:返回值为20000
:return:
"""
time.sleep(60)
for num in range(len(self.caselist)):
print("TestCase {}: {}".format(
(num + 1), self.filecontent.get_instruction(serial=num)))
try:
operator.eq(self.caselist[num]['serial'], num + 1)
except IOError:
print("TestCase Number: {} Document is ERROR!".format(num + 1))
finally:
self.filecontent.get_instruction(serial=num)
response = self.get_response(serial=num)
json_result = response.json()
print("response content: ", json_result)
expectresult = self.filecontent.get_expectresult(serial=num)
print("api verify is beginning...")
self.verify.verify_api(expectresult=expectresult,
result=json_result)
print("api verify is success.")
print("code verify is beginning...")
self.verify.verify_code(expectresult=expectresult,
result=json_result)
print("code verify is success.")
print("message verify is beginning...")
self.verify.verify_message(expectresult=expectresult,
result=json_result)
print("message verify is success.")
print("ALL END!!")
def tearDown(self):
SqlOperation().close()
class QueryBrokerOrderPageList(unittest.TestCase):
def setUp(self):
self.filename = Request().dirname() + "/Document/Wechat_Applet/queryBrokerOrderPageList.json"
self.filecontent = FileContent(self.filename)
self.apiname = self.filecontent.get_apiname() # 获取apiname用于获得url
self.api = self.filecontent.get_api() # 获取api用于校验
self.caselist = self.filecontent.get_caselist() # 获取caselist列表，包括"reqParams"和"expectResult"
# self.casenumber = self.filecontent.get_casenumber() # 获取case数量
self.verify = Verify()
self.verificationErrors = []
def get_response(self, serial):
"""
:param serial:
:return: 获取接口返回
"""
url = Request().get_url(serial=serial, filename=self.filename, apiname=self.apiname)
session = requests.session()
response = session.post(url)
if response.status_code == 200:
return response
else:
raise ConnectionRefusedError()
def verify_datalist_number(self, serial, result):
"""
校验dataList列表长度，小于等于pagesize，即每次请求最多为pagesize规定的数值，默认为15
:return:
"""
pagesize_parama = self.filecontent.get_reqparams(serial)['queryRequest']['pagesize']
datalist = result['data']['dataList']
len_datalist = len(datalist)
self.assertTrue(len_datalist <= pagesize_parama,
msg="len_datalist: {}, pagesize: {}".format(len_datalist, pagesize_parama))
def verify_status(self, serial, result):
"""
校验status为当前查询列表的status
:param serial:
:param result:
:return:
"""
expect_status = self.filecontent.get_datalist(serial)[0]['status']
result_datalist = result['data']['dataList']
for i in range(len(result_datalist)):
self.assertEqual(expect_status, result_datalist[i]['status'])
def test_to_pay(self):
"""
待车商支付订单列表
校验点：1、校验datalist列表长度<=pagesize的值
2、校验datalist所有订单的status=0
:return:
"""
# casenum = {serial: instruction}, 如果与json文档不一致的话就会报错
casenum = {1: "待车商支付订单列表"}
for key, value in casenum.items():
print(value, self.filecontent.get_instruction(serial=key-1))
if operator.eq(value, self.filecontent.get_instruction(serial=key-1)):
print("TestCase {}: {}".format(key, self.filecontent.get_instruction(serial=key-1)))
else:
raise ValueError("TestCase {}'s instruction is not Equal to CaseNum.".format(key-1))
sql_data = self.filecontent.get_sqldata(serial=key-1)
if SqlOperation().select_data(sql_data['select']) != 0:
SqlOperation().delete_data(sql_data['delete'])
SqlOperation().insert_data(sql_data['insert'])
response = self.get_response(serial=key-1)
json_result = response.json()
print("response content: ", json_result)
expectresult = self.filecontent.get_expectresult(serial=key-1)
print("code verify is beginning...")
self.verify.verify_code(expectresult=expectresult, result=json_result)
print("code verify is success.")
print("message verify is beginning...")
self.verify.verify_message(expectresult=expectresult, result=json_result)
print("message verify is success.")
self.verify_datalist_number(serial=key - 1, result=json_result)
self.verify_status(serial=key-1, result=json_result)
print("ALL END!!")
def test_broker_to_confirm(self):
"""
待经纪人确认订单列表
校验点：1、校验datalist列表长度<=pagesize的值
2、校验datalist所有订单的status=1
:return:
"""
# casenum = {serial: instruction}, 如果与json文档不一致的话就会报错
casenum = {2: "待经纪人确认订单列表"}
for key, value in casenum.items():
print(value, self.filecontent.get_instruction(serial=key - 1))
if operator.eq(value, self.filecontent.get_instruction(serial=key - 1)):
print("TestCase {}: {}".format(key, self.filecontent.get_instruction(serial=key - 1)))
else:
raise ValueError("TestCase {}'s instruction is not Equal to CaseNum.".format(key - 1))
sql_data = self.filecontent.get_sqldata(serial=key - 1)
if SqlOperation().select_data(sql_data['select']) != 0:
SqlOperation().delete_data(sql_data['delete'])
SqlOperation().insert_data(sql_data['insert'])
response = self.get_response(serial=key - 1)
json_result = response.json()
print("response content: ", json_result)
expectresult = self.filecontent.get_expectresult(serial=key - 1)
print("code verify is beginning...")
self.verify.verify_code(expectresult=expectresult, result=json_result)
print("code verify is success.")
print("message verify is beginning...")
self.verify.verify_message(expectresult=expectresult, result=json_result)
print("message verify is success.")
self.verify_datalist_number(serial=key - 1, result=json_result)
self.verify_status(serial=key - 1, result=json_result)
print("ALL END!!")
def test_customer_to_confirm(self):
"""
待车商确认订单列表
校验点：1、校验datalist列表长度<=pagesize的值
2、校验datalist所有订单的status=2
:return:
"""
# casenum = {serial: instruction}, 如果与json文档不一致的话就会报错
casenum = {3: "待车商确认订单列表"}
for key, value in casenum.items():
print(value, self.filecontent.get_instruction(serial=key - 1))
if operator.eq(value, self.filecontent.get_instruction(serial=key - 1)):
print("TestCase {}: {}".format(key, self.filecontent.get_instruction(serial=key - 1)))
else:
raise ValueError("TestCase {}'s instruction is not Equal to CaseNum.".format(key - 1))
sql_data = self.filecontent.get_sqldata(serial=key - 1)
if SqlOperation().select_data(sql_data['select']) is not None:
SqlOperation().delete_data(sql_data['delete'])
SqlOperation().insert_data(sql_data['insert'])
response = self.get_response(serial=key - 1)
json_result = response.json()
print("response content: ", json_result)
expectresult = self.filecontent.get_expectresult(serial=key - 1)
print("code verify is beginning...")
self.verify.verify_code(expectresult=expectresult, result=json_result)
print("code verify is success.")
print("message verify is beginning...")
self.verify.verify_message(expectresult=expectresult, result=json_result)
print("message verify is success.")
self.verify_datalist_number(serial=key - 1, result=json_result)
self.verify_status(serial=key - 1, result=json_result)
print("ALL END!!")
def test_paid_success(self):
"""
交易成功订单列表
校验点：1、校验datalist列表长度<=pagesize的值；
2、校验datalist所有订单的status=3
:return:
"""
# casenum = {serial: instruction}, 如果与json文档不一致的话就会报错
casenum = {4: "交易成功订单列表"}
for key, value in casenum.items():
print(value, self.filecontent.get_instruction(serial=key-1))
if operator.eq(value, self.filecontent.get_instruction(serial=key-1)):
print("TestCase {}: {}".format(key, self.filecontent.get_instruction(serial=key-1)))
else:
raise ValueError("TestCase {}'s instruction is not Equal to CaseNum.".format(key-1))
response = self.get_response(serial=key-1)
json_result = response.json()
print("response content: ", json_result)
expectresult = self.filecontent.get_expectresult(serial=key-1)
print("code verify is beginning...")
self.verify.verify_code(expectresult=expectresult, result=json_result)
print("code verify is success.")
print("message verify is beginning...")
self.verify.verify_message(expectresult=expectresult, result=json_result)
print("message verify is success.")
self.verify_datalist_number(serial=key - 1, result=json_result)
self.verify_status(serial=key-1, result=json_result)
print("ALL END!!")
def test_paid_fail(self):
"""
交易失败订单列表
校验点：1、校验datalist列表长度<=pagesize的值
2、校验datalist所有订单的status=3
:return:
"""
# casenum = {serial: instruction}, 如果与json文档不一致的话就会报错
casenum = {5: "交易失败订单列表"}
for key, value in casenum.items():
print(value, self.filecontent.get_instruction(serial=key - 1))
if operator.eq(value, self.filecontent.get_instruction(serial=key - 1)):
print("TestCase {}: {}".format(key, self.filecontent.get_instruction(serial=key - 1)))
else:
raise ValueError("TestCase {}'s instruction is not Equal to CaseNum.".format(key - 1))
response = self.get_response(serial=key - 1)
json_result = response.json()
print("response content: ", json_result)
expectresult = self.filecontent.get_expectresult(serial=key - 1)
print("code verify is beginning...")
self.verify.verify_code(expectresult=expectresult, result=json_result)
print("code verify is success.")
print("message verify is beginning...")
self.verify.verify_message(expectresult=expectresult, result=json_result)
print("message verify is success.")
self.verify_datalist_number(serial=key - 1, result=json_result)
self.verify_status(serial=key - 1, result=json_result)
print("ALL END!!")
def test_all_list(self):
"""
全部订单列表
校验点：1、校验datalist列表长度<=pagesize的值
2、datalist不为空
:return:
"""
# casenum = {serial: instruction}, 如果与json文档不一致的话就会报错
casenum = {6: "全部订单列表"}
for key, value in casenum.items():
print(value, self.filecontent.get_instruction(serial=key - 1))
if operator.eq(value, self.filecontent.get_instruction(serial=key - 1)):
print("TestCase {}: {}".format(key, self.filecontent.get_instruction(serial=key - 1)))
else:
raise ValueError("TestCase {}'s instruction is not Equal to CaseNum.".format(key - 1))
response = self.get_response(serial=key - 1)
json_result = response.json()
print("response content: ", json_result)
expectresult = self.filecontent.get_expectresult(serial=key - 1)
print("code verify is beginning...")
self.verify.verify_code(expectresult=expectresult, result=json_result)
print("code verify is success.")
print("message verify is beginning...")
self.verify.verify_message(expectresult=expectresult, result=json_result)
print("message verify is success.")
self.verify_datalist_number(serial=key-1, result=json_result)
self.verify.verify_data_isNotNull(result=json_result)
print("ALL END!!")
def tearDown(self):
SqlOperation().close()
class BrokerVerifyCodeLogin(unittest.TestCase):
def setUp(self):
self.filename = Request().dirname() + "/Document/Wechat_Applet/brokerVerifyCodeLogin.json"
# self.filename = os.path.abspath("../Document/Wechat_Applet/brokerVerifyCodeLogin")
self.filecontent = FileContent(self.filename)
self.apiname = self.filecontent.get_apiname()
self.api = self.filecontent.get_api()
self.caselist = self.filecontent.get_caselist()
self.verify = Verify()
self.phone = "18867520068"
def get_url(self, requestparam):
"""
创建会话，获取response
:param requestparam:
:return:
"""
dic = dict()
dic['requestParam'] = requestparam
dic['source'] = int(Request().get_source())
signature = MD5().encodingpassword(MapUtil().get_signbase(dic, Request.separator()) +
MD5().encodingpassword(Request.get_app_secret()))
dic["signature"] = signature
url = Request().get_host() + self.apiname + "?" + MapUtil().get_signbase(dic, Request.separator())
print("url: ", url)
return url
def get_success_response(self):
"""
serial为0时，获取验证码登陆
:param serial:
:return:
"""
requestParam = {
"cellphone": self.phone,
"verifyCode": self.get_verify_code(),
"code": ""
}
response = requests.post(self.get_url(requestParam))
return response
def get_response(self, serial):
"""
从json文件中读取请求参数
:param serial:
:return:
"""
url = Request().get_url(serial=serial, apiname=self.apiname, filename=self.filename)
response = requests.post(url)
if response.status_code == 200:
return response
else:
raise ConnectionRefusedError()
@staticmethod
def sendvaliddatacode():
"""
sendValiddataCode
:return:
"""
reqparams = "http://10.10.13.75:8080/dealer/sendvalidatecode.json?" \
"invokeType=20&phone=18867520068&signature=589f9e341eca8079f33e80adb3b7b3b3&source=123456"
# sendvalidatacode_url = Request().get_host() + self.apiname + "?" + reqparams
r = requests.post(url=reqparams)
if r.json()['message'] == "验证码已发送":
print("验证码已发送")
else:
print("sendValidataCode response is ", r.json())
raise ConnectionError("The api sendValidataCode response is error. %s" % r.json())
def get_verify_code(self):
time.sleep(60)
self.sendvaliddatacode()
sql = """
SELECT code FROM auto.sms WHERE phone='18867520068' AND smstype='brokerUserLoginCode'
ORDER BY sendtime DESC LIMIT 1
"""
code = SqlOperation().select_data(sql=sql)[0]
if len(code) == 6:
print("get verify code is ", code)
return code
else:
raise ValueError("The verify code is Error. Please check the sendvalidatacode api is OK.", code)
def test_login_success(self):
print("TestCase 1:")
json_result = self.get_success_response().json()
expectresult = self.filecontent.get_expectresult(serial=0)
print("result: ", json_result)
self.assertEqual(expectresult['code'], json_result['code'], msg="Code is Error, result = %s."
% json_result)
self.assertEqual(expectresult['message'], json_result['message'], msg="Message is Error, result = %s."
% json_result['message'])
self.assertEqual(expectresult['data'], json_result['data'],
msg="Data is Error, result = {}." .format(json_result))
print("Test Login Success is OK.")
def test_login_fail(self):
"""
登陆失败，验证码过期
:return:
"""
# casenum = {serial: instruction}, 如果与json文档不一致的话就会报错
casenum = {2: "登陆失败，验证码过期/错误"}
for key, value in casenum.items():
print(value, self.filecontent.get_instruction(serial=key-1))
if operator.eq(value, self.filecontent.get_instruction(serial=key-1)):
print("TestCase {}: {}".format(key, self.filecontent.get_instruction(serial=key-1)))
else:
raise ValueError("用例匹配失败：TestCase {}'s instruction is not Equal to CaseNum.".format(key))
delete_sql = """
DELETE FROM auto.sms WHERE phone='{}'
""".format(self.filecontent.get_reqparams(serial=key - 1)['phone'])
SqlOperation().delete_data(sql=delete_sql)
response = self.get_response(serial=key-1)
self.verify.verify_code_200(response=response)
print(response.content)
json_result = response.json()
print("response content: ", json_result)
expectresult = self.filecontent.get_expectresult(serial=key-1)
print("api verify is beginning...")
self.verify.verify_api(expectresult=expectresult, result=json_result)
print("api verify is success.")
print("code verify is beginning...")
self.verify.verify_code(expectresult=expectresult, result=json_result)
print("code verify is success.")
print("message verify is beginning...")
self.verify.verify_message(expectresult=expectresult, result=json_result)
print("message verify is success.")
print("ALL END!!")
def tearDown(self):
SqlOperation().close()
class SaveBrokerUserFormId(unittest.TestCase):
def setUp(self):
self.filename = Request().dirname() + "/Document/Wechat_Applet/saveBrokerUserFormId.json"
self.filecontent = FileContent(self.filename)
self.apiname = self.filecontent.get_apiname() # 获取apiname用于获得url
self.api = self.filecontent.get_api() # 获取api用于校验
self.caselist = self.filecontent.get_caselist() # 获取caselist列表，包括"reqParams"和"expectResult"
self.verify = Verify()
# self.result = GlobalVar().global_dic
self.verificationErrors = []
def get_response(self, serial):
"""
:param serial:
:return: 获取接口返回
"""
url = Request().get_url(serial=serial, filename=self.filename, apiname=self.apiname)
session = requests.session()
response = session.post(url, timeout=1)
if response.status_code == 200:
return response
else:
raise ConnectionRefusedError("request is refused.")
def verify_formid_sql(self, serial):
"""
校验请求后数据库是否有生成对应的formId记录
:return:
"""
select_sql = self.filecontent.get_sqldata(serial)['select']
self.assertEqual(SqlOperation().select_data(select_sql)[0], self.filecontent.get_reqparams(serial)['formId'],
msg="check sql db is Error.")
def test_get_success(self):
"""
小程序表单提交--保存form_id
校验点：1、message:返回值 success
2、请求后与数据库生成的记录做对比，form_id与请求参数的form_id保持一致
:return:
"""
# casenum = {serial: instruction}, 如果与json文档不一致的话就会报错
casenum = {1: "form_id保存成功"}
for key, value in casenum.items():
print(value, self.filecontent.get_instruction(serial=key - 1))
if operator.eq(value, self.filecontent.get_instruction(serial=key - 1)):
print("TestCase {}: {}".format(key, self.filecontent.get_instruction(serial=key - 1)))
else:
raise ValueError("用例匹配失败：TestCase {}'s instruction is not Equal to CaseNum.".format(key))
sql_data = self.filecontent.get_sqldata(serial=key - 1)
if SqlOperation().select_data(sql_data['select']) is not None:
SqlOperation().delete_data(sql_data['delete'])
response = self.get_response(serial=key - 1)
json_result = response.json()
print("response content: ", json_result)
expectresult = self.filecontent.get_expectresult(serial=key - 1)
print("code verify is beginning...")
self.verify.verify_code(expectresult=expectresult, result=json_result)
print("code verify is success.")
print("message verify is beginning...")
self.verify.verify_message(expectresult=expectresult, result=json_result)
print("message verify is success.")
self.verify_formid_sql(serial=key - 1)
print("ALL END!!")
def tearDown(self):
pass
class GetCarSourceAllByEs(unittest.TestCase):
def setUp(self):
self.filename = Request().dirname(
) + "/Document/Wechat_Applet/getCarSourceAllByEs.json"
self.filecontent = FileContent(self.filename)
self.apiname = self.filecontent.get_apiname() # 获取apiname用于获得url
self.api = self.filecontent.get_api() # 获取api用于校验
self.caselist = self.filecontent.get_caselist(
) # 获取caselist列表，包括"reqParams"和"expectResult"
self.verify = Verify()
# self.result = GlobalVar().global_dic
self.verificationErrors = []
def get_response(self, serial):
"""
:param serial:
:return: 获取接口返回
"""
url = Request().get_url(serial=serial,
filename=self.filename,
apiname=self.apiname)
session = requests.session()
response = session.post(url, timeout=1)
if response.status_code == 200:
return response
else:
raise ConnectionRefusedError("request is refused.")
def verify_data_number(self, serial, result):
"""
校验data列表长度，小于等于pagesize，即每次请求最多为pagesize规定的数值，默认为15
:return:
"""
pagesize_parama = self.filecontent.get_reqparams(serial)['pageSize']
data = result['data']
len_data = len(data)
self.assertTrue(len_data <= pagesize_parama,
msg="len_datalist: {}, pagesize: {}".format(
len_data, pagesize_parama))
def test_get_success(self):
"""
查询车源列表成功
校验点：1、message:返回值 查询车源列表成功
2、data列表不为空
3、data长度<=pageSize，pageSize为请求参数传入的值
:return:
"""
# casenum = {serial: instruction}, 如果与json文档不一致的话就会报错
casenum = {1: "查询车源列表成功"}
for key, value in casenum.items():
print(value, self.filecontent.get_instruction(serial=key - 1))
if operator.eq(value,
self.filecontent.get_instruction(serial=key - 1)):
print("TestCase {}: {}".format(
key, self.filecontent.get_instruction(serial=key - 1)))
else:
raise ValueError(
"用例匹配失败：TestCase {}'s instruction is not Equal to CaseNum."
.format(key))
response = self.get_response(serial=key - 1)
json_result = response.json()
print("response content: ", json_result)
expectresult = self.filecontent.get_expectresult(serial=key - 1)
print("code verify is beginning...")
self.verify.verify_code(expectresult=expectresult,
result=json_result)
print("code verify is success.")
print("message verify is beginning...")
self.verify.verify_message(expectresult=expectresult,
result=json_result)
print("message verify is success.")
print("data verify is beginning...")
self.verify.verify_data_isNotNull(result=json_result)
print("data verify is success.")
self.verify_data_number(serial=key - 1, result=json_result)
print("ALL END!!")
def tearDown(self):
pass
