from dbtools import chaxun, commit # username = input("请输入账号:") # password = input("请输入密码:") # sql = 'select * from t_admin where username="******" and password ="******"'.format(username,password) # print(sql) # res = chaxun(sql) # if len(res) != 0: # print("管理员登陆成功!") # else: # print("管理员登陆失败!") #-------------------------------------------注册----------------------------------------- username = input("请输入账号:") password = input("请输入密码:") sql = 'INSERT into t_admin values(NULL, "{}", "{}", NULL, NULL, NULL, NULL, NULL, NULL,0, NULL, NULL, NULL)'.format( username, password) res = commit(sql) if res == True: sql = 'select * from t_admin where username="******" and password="******"'.format( username, password) res = chaxun(sql) if len(res) != 0: print("注册成功") else: print("注册失败")
""" url = "http://192.144.148.91:2333/login" # 登录接口的地址 data = { "username": "******", "password": "******" } # data传递参数键值对字典方式 res = requests.post(url=url, json=data) # url = url1,data以json方式传送 """ 2:判断结果(http状态码;返回值信息) 断言:通过就通过,失败就报错 """ assert res.status_code == 200 # 调用requests的status_code属性,获取http状态码 # res.status_code() assert res.json().get("status") == 200 # 吧返回值转换成py的字符串并断言“status”是否等于200(结果码) """ 3:查数据库 """ sql = "select * from t_user where username = '******'".format(data.get("username")) assert len(chaxun(sql)) != 0 print("ok") token = res.json().get("data").get("token") print(token) """ 用户退出接口 """ url1 = "http://192.144.148.91:2333/logout" headers = {"Content-Type": "application/json", "token": token} res1 = requests.get(url=url1, headers=headers) print(res1.text)
from dbtools import chaxun """ 获取轮播图接口 1:构造请求 """ url = "http://192.144.148.91:2333/get_title_img" # 接口地址 res = requests.get(url) # 发送get请求并把内容赋值res """ 2:判断结果(http状态码;返回值信息) 断言:通过就通过,失败就报错 """ assert res.status_code == 200 # 调用requests的status_code属性,获取http状态码 # res.status_code() assert res.json().get("status") == 200 # 吧返回值转换成py的字符串并断言“status”是否等于200(结果码) """ 3:查数据库 """ # 1)获取轮播图id for r in res.json().get("data"): lid = r.get("id") sql = "select * from t_title_img where id = {}".format(lid) print(sql) # 2)id查询数据库 res = chaxun(sql) # 查询内容赋值到res中 print(res) try: assert len(res) != 0 # 数据库中查询长度不为0证明有参数 print("id为", lid, "的轮播图存在") except: print("id为", lid, "的轮播图不存在") print("轮播图接口代码执行成功")
# 导入requests import requests from dbtools import chaxun # 构造请求 url = "http://192.144.148.91:2333/get_title_img" # 接口地址 res = requests.get(url) # http的get请求 # 判断结果(1.判断http状态码;2.判断返回值>结果码) assert res.status_code == 200 # 调用requests的status_code属性,获取http状态码 assert res.json().get("status") == 200 # 把返回值转换成python的字符串 # 查询数据库:接口返回值相关的信息 # 1.获取到每个轮播图的id for r in res.json().get("data"): # 分别获取每个轮播图的id lid = r.get("id") # 2.再用sql去数据库查这些id sql = "select * from t_title_img where id = {}".format( lid) # 去数据库中查每条轮播图的信息 res = chaxun( sql ) # res ((137, 'test555', None, '75UbhhZTcMwNLLz.jpg', 'https://images.unsplash.com/', 0, None, datetime.datetime(2020, 4, 22, 19, 10, 17), datetime.datetime(2020, 4, 22, 19, 10, 17)),) assert len(res) != 0 # 数据库查询的结果长度不为0 print("成功了!")
from dbtools import chaxun a = chaxun('show tables;') print(a)