模型类的创建
from flask_sqlalchemy import SQLAlchemy
db = SQLAlchemy()
class HotModel(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True, comment="ID")
body = db.Column(db.String(1000), comment="内容")
dingyue = db.Column(db.String(64),comment="阅读")
weishi = db.Column(db.String(64),comment="卫视")
对数据库的增删改查
def get(self): #查找数据库数据
code_all = Code.query.all()
code_list = []
for item in code_all:
d1 = {
"id":item.id,
"code_name":item.code_name
}
code_list.append(d1)
print(code_list)
print(code_all)
return jsonify({
"code":200,
"msg":"获取成功",
"data":code_list
})
def post(self): #添加数据
req = reqparse.RequestParser()
req.add_argument("code_name",required=True)
args = req.parse_args()
c1 = Code(code_name=args["code_name"])
db.session.add(c1)
db.session.commit()
return jsonify({
"code":200,
"msg":"添加成功"
})
def put(self): #修改数据库数据
req = reqparse.RequestParser()
req.add_argument("id",type=int,required=True)
req.add_argument("code_name",required=True)
args = req.parse_args()
code_info = Code.query.get(args["id"])
if not code_info:
return jsonify({
"code":400,
"msg":"分类不存在"
})
code_info.code_name = args["code_name"]
db.session.commit()
return jsonify({
"code":200,
"msg":"修改成功"
})
def delete(self): #删除数据库数据
req = reqparse.RequestParser()
req.add_argument("id", type=int, required=True,help="ID必填")
args = req.parse_args()
Code.query.filter(Code.id == args["id"]).delete()
db.session.commit()
return jsonify({
"code":200,
"msg":"删除成功"
})