使用Flask-Restless为SQLAlchemy表创建API

Question

我使用Python, Flask, Flask- sqlalchemy和Flask- restless来创建RESTful API。数据库中包含表user。每个用户都可以关注其他用户，每个用户也可以被其他用户关注(就像在Twitter中一样)。所以我也有一个表followers来链接用户(我部分遵循了Miguel的教程)。这是我的代码:

# -*- coding: utf-8 -*-
from flask import Flask
from flask.ext.sqlalchemy import SQLAlchemy
from flask.ext.restless import APIManager
# Create the Flask application and the Flask-SQLAlchemy object.
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:////tmp/test.db'
db = SQLAlchemy(app)
followers = db.Table('followers',
    db.Column('follower_id', db.Integer, db.ForeignKey('user.id'), nullable=False),
    db.Column('followed_id', db.Integer, db.ForeignKey('user.id'), nullable=False)
)
# Model declaration
class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.Unicode, nullable=False)
    # some other properties...
    followed = db.relationship('User', 
        secondary=followers, 
        primaryjoin=(followers.c.follower_id == id), 
        secondaryjoin=(followers.c.followed_id == id), 
        backref=db.backref('followers', lazy='dynamic'), 
        lazy='dynamic')
# Create the database tables.
db.create_all()
# Create the Flask-Restless API manager.
manager = APIManager(app, flask_sqlalchemy_db=db)
# Create API endpoints, which will be available at /api/<tablename> by
# default. Allowed HTTP methods can be specified as well.
manager.create_api(User, methods=['GET', 'POST'])
if __name__ == '__main__':
    app.run(debug=True)

在数据库中添加一个新用户很容易:

from requests import post
user = {'name':'John Doe'}
post('http://localhost:5000/api/user', json=user)

但是我应该做什么样的请求在followers表中添加一些东西?

Answer 1

您需要使用PATCH。

From this docs:

PATCH /api/person/1
HTTP/1.1 Host: example.com
    { "computers":
      {
        "add": [ {"id": 1} ]
      }
    }

在你的情况下，你会这样做:

from requests import patch
follower = {'id':'37'}
cmd = {'followed': { 'add': [ follower ] } }
patch('http://localhost:5000/api/user/1', json=cmd)