import requests
 unittest
 json
 pyMysqL

conn = pyMysqL.connect(host='10.10.100.224',port=3840,user=kexin_adminkexin@admin!iot')
cursor = conn.cursor()
sql = "SELECT device_num FROM emergency  WHERE device_name = 'test2'"
cursor.execute(sql)
num = cursor.fetchone()#从数据库拿到想要的参数
print(num)

class Test_run(unittest.TestCase):
    def test_run_status(self):
        url = http://10.10.100.224:10001/api/emergencyService/doorlock/getBatterStatus
        payload = {deviceNum:num}

        re = requests.post(url,data=payload)
        da = json.loads(re.text)
        code = da[code]
        self.assertEqual(code,1)
        (da)

if __name__ == __main__:
    unittest.main()