Relationship URLs for one-to-many not returning list

[logandk]

Here's a simple API that illustrates this issue:

from flask import Flask
from flask import request
from flask.ext import restless
from flask.ext import sqlalchemy

# Initialize the app
app = Flask(__name__)
db  = sqlalchemy.SQLAlchemy(app)
api = restless.APIManager(app, flask_sqlalchemy_db=db)

# Database configuration
app.config['DEBUG'] = True
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///test.db'

# Define data models
class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String)

class Todo(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
    task = db.Column(db.String)

    user = db.relationship('User', backref=db.backref('todos', lazy='joined'))

# Seed database
db.create_all()

u = User(name='Jimi Hendrix')
t1 = Todo(task='Play guitar', user=u)
t2 = Todo(task='Burn guitar', user=u)

db.session.add(u)
db.session.commit()

# Define API
api.create_api(User, methods=['GET', 'POST', 'DELETE', 'PATCH'])

if __name__ == '__main__':
    app.run(debug=True)

Loading http://localhost:5000/api/user/1/todos returns:

{
  "task": "Play guitar", 
  "user_id": 1, 
  "id": 1, 
  "user": {
    "id": 1, 
    "name": "Jimi Hendrix"
  }
}

While http://localhost:5000/api/user/2/todos returns:

{
  "task": "Burn guitar", 
  "user_id": 1, 
  "id": 2, 
  "user": {
    "id": 1, 
    "name": "Jimi Hendrix"
  }
}

So the provided id parameter seems to be referring to the Todo instead of User.

Loading http://localhost:5000/api/user/1/todos should return something like:

{
  "total_pages": 1, 
  "objects": [
    {
      "task": "Play guitar", 
      "user_id": 1, 
      "id": 1, 
      "user": {
        "id": 1, 
        "name": "Jimi Hendrix"
      }
    }, 
    {
      "task": "Burn guitar", 
      "user_id": 1, 
      "id": 2, 
      "user": {
        "id": 1, 
        "name": "Jimi Hendrix"
      }
    }
  ], 
  "num_results": 2, 
  "page": 1
}

[jfinkels]

You are right, this is a bug. I'll look into it now.

[jfinkels]

Closing this issue, as it is fixed by c8750be.