def test_reg_normal(self):
# 环境检查及数据准备
conn = get_conn()
result = query_db(
conn, "select id from user where name='{}'".format(NEW_USER))
print(result)
if result:
change_db(conn,
"delete from user where name='{}'".format(NEW_USER))
# 组装和发送请求
url = "http://115.28.108.130:5000/api/user/reg/"
data = {"name": NEW_USER, "password": "******"}
res = requests.post(url=url, json=data)
print(res.json())
res_dict = res.json()
# 断言
self.assertEqual("100000", res_dict["code"])
self.assertEqual("成功", res_dict["msg"])
self.assertEqual(NEW_USER, res_dict["data"]["name"])
# 数据库断言
result2 = query_db(
conn, "select * from user where name='{}'".format(NEW_USER))
name = result2[0][1]
self.assertEqual(NEW_USER, name)
# 环境清理
change_db(conn, "delete from user where name='{}'".format(NEW_USER))
conn.close()
def providers():
sql = """
select count(ClaimID) cc, o.Provider, F.PotentialFraud
from Outpatient o
left join Fraud F on o.Provider = F.Provider
group by o.Provider
order by cc
DESC LIMIT 100 offset 1500;
"""
res = query_db(sql)
return json.dumps(res)
def test_reg_normal(self):
# 环境检查及数据准备
conn = get_conn()
result = query_db(
conn, "select id from user where name ='{}'".format(NEW_USER))
if result:
change_db(conn,
"delete from `user` where name = '{}'".format(NEW_USER))
# 组装和发送请求
url = "http://115.28.108.130:5000/api/user/reg/"
data = {"name": NEW_USER, "password": "******"}
res = requests.post(url=url, json=data)
res_dict = res.json()
print(res.json())
# 断言,传两个参数，assert代表期望结果，Equal代表实际结果
self.assertEqual("100000", res_dict["code"])
self.assertEqual("成功", res_dict["msg"])
self.assertEqual("SHM9", res_dict["data"]["name"])
def get_user_data(conn, name):
result = query_db(conn, "select * from user where name='{}'".format(name))
return result
def provider_fraud(providerId):
res = query_db(
'select * from Fraud where Provider= ?', (providerId,))
return json.dumps(res)
def provider(providerId):
res = query_db(
'select * from Outpatient i left join Beneficiary B on i.BeneID = B.BeneID where Provider= ?', (providerId,))
return json.dumps(res)