python flask-sqlalchemy flask-marshmallow基本使用

article/2025/10/31 4:59:16

首先安装
pip install marshmallow-sqlalchemy
pip install flask-sqlalchemy
pip install flask-marshmallow
参考
sqlalchemy query 官网
app.py文件内容

from flask import Flask,jsonify
import config
from flask_sqlalchemy import SQLAlchemy
from flask_marshmallow import Marshmallow
from flask_restful import Api,request
app=Flask(__name__)
app.config.from_object(config)
api=Api(app)
db=SQLAlchemy(app)
ma=Marshmallow(app)
class test(db.Model):id = db.Column(db.Integer,primary_key=True)name = db.Column(db.String(24))age=db.Column(db.Integer)money=db.relationship('moneys',uselist=False)  #class moneys(db.Model):id = db.Column(db.Integer,db.ForeignKey('test.id'))money = db.Column(db.String(),primary_key=True)class UserSchema(ma.ModelSchema):class Meta:model = testclass MoneySchema(ma.ModelSchema):class Meta:model = moneys@app.route('/')
def index():one_user = test.query.all()user_schema = UserSchema(many=True) #用已继承ma.ModelSchema类的自定制类生成序列化类print(one_user)output = user_schema.dumps(one_user) #生成可序列化对象return output@app.route("/test", methods=["POST"])
def add_user():user_schema = UserSchema(many=False)ss=user_schema.load(request.get_json(force=True))print (ss)db.session.add(ss)db.session.commit()return user_schema.dump(test.query.filter(test.id==request.json['id']).first())if __name__ == '__main__':app.run(debug=True)

config.py 文件内容

DIALECT = 'postgresql'
DRIVER = 'psycopg2'
USERNAME = 'chenxu'
PASSWORD = 'postgres'
HOST = '127.0.0.1'
PORT = '5432'
DATABASE = 'chenxu'SQLALCHEMY_DATABASE_URI = "{}://{}:{}@{}:{}/{}".format(DIALECT,USERNAME, PASSWORD, HOST, PORT,DATABASE)