def test03_modify_emp(self,username,success,code,message,http_code): # 调用修改员工接口 response = self.emp_api.modify_emp(username) jsonData = response.json() logging.info("修改员工接口的返回数据为:{}".format(jsonData)) # #建立连接 # conn = pymysql.connect("182.92.81.159","readuser","iHRM_user_2019","ihrm",charset = "utf8") # #获取游标 # cursor = conn.cursor() # #执行 # sql = "select username from bs_user where id={}".format(app.Emp_ID) # cursor.execute(sql) # result = cursor.fetchone()[0] # print(result) # logging.info("从数据库中查询出的员工的用户名是:{}".format(result)) # self.assertEqual(username,result) # #关闭游标 # cursor.close() # #关闭连接 # conn.close() with DBUtils() as db_utils: sql = "select username from bs_user where id={}".format(app.Emp_ID) db_utils.execute(sql) result = db_utils.fetchone()[0] logging.info("从数据库只中查询出的员工的用户名是:{}".format(result)) #断言 asser_common(self, response, http_code, success, code, message)
def test02_add_emp(self): response = self.emp_api.add_emp("小五","299999111888") jsonData = response.json() logging.info("添加员工接口返回数据为:{}".format(jsonData)) asser_common(self,response,200,True,10000,"操作成功") #获取员工ID保存全局变量 app.Emp_ID = jsonData.get("data").get("id")
def test01_login(self): response = self.login_api.login("13800000002", "123456") jsonData = response.json() logging.info("登录成功接口返回数据为:{}".format(jsonData)) asser_common(self, response, 200, True, 10000, "操作成功") token = jsonData.get("data") app.HEADERS["Authorization"] = "Bearer " + token logging.info("保存的令牌是:{}".format(app.HEADERS))
def test01_login_success(self): response = self.login_api.login("13800000002", "123456") jsonData = response.json() logging.info("登录成功接口返回数据为:{}".format(jsonData)) #断言 # self.assertEqual(200,response.status_code) # self.assertEqual(True,jsonData.get("success")) # self.assertEqual(10000,jsonData.get("code")) # self.assertIn("操作成功",jsonData.get("message")) asser_common(self, response, 200, True, 10000, "操作成功")
def test01_add_emp(self, username,mobile,success,code,message,http_code): # 调用添加员工接口 response = self.emp_api.add_emp(username, mobile) jsonData = response.json() logging.info("添加员工接口返回数据为:{}".format(jsonData)) # 获取员工ID保存全局变量 app.Emp_ID = jsonData.get("data").get("id") logging.info(app.Emp_ID) asser_common(self, response, http_code, success, code, message)
def test08_username_have_space(self): response = self.login_api.login("138000 00002", "123456") jsonData = response.json() logging.info("账号有空格时输入的数据为:{}".format(jsonData)) asser_common(self, response, 200, False, 20001, "用户名或密码错误")
def test06_password_is_empty(self): response = self.login_api.login("13800000002", " ") jsonData = response.json() logging.info("密码为空时输入的数据为:{}".format(jsonData)) asser_common(self, response, 200, False, 20001, "用户名或密码错误")
def test05_username_is_empty(self): response = self.login_api.login(" ", "error") jsonData = response.json() logging.info("账号为空时输入的数据为:{}".format(jsonData)) asser_common(self, response, 200, False, 20001, "用户名或密码错误")
def test04_username_have_special_char(self): response = self.login_api.login("@!%$&@+-", "123456") jsonData = response.json() logging.info("账号有特殊字符时输入的数据为:{}".format(jsonData)) asser_common(self, response, 200, False, 20001, "用户名或密码错误")
def test02_username_is_not_exists(self): response = self.login_api.login("13900000002", "123456") jsonData = response.json() logging.info("账号不存在时输入的数据为:{}".format(jsonData)) asser_common(self, response, 200, False, 20001, "用户名或密码错误")
def test04_delete_emp(self,success,code,message,http_code): # 调用删除员工接口 response = self.emp_api.delete_emp() jsonData = response.json() logging.info("删除员工接口的返回数据为:{}".format(jsonData)) asser_common(self, response, http_code, success, code, message)
def test02_query_emp(self,success,code,message,http_code): # 调用查询员工接口 response = self.emp_api.query_emp() jsonData = response.json() logging.info("查询员工接口的返回数据为:{}".format(jsonData)) asser_common(self, response, http_code, success, code, message)
def test_login(self, mobile, password, http_code, success, code, message): response = self.login_api.login(mobile, password) jsonData = response.json() logging.info("登录接口返回数据为:{}".format(jsonData)) asser_common(self, response, http_code, success, code, message)