首先安装
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 = test
class 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)
表结构如下
moneys
test