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)