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)
