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