Hi, first of all, thanks for the project! Is it possible to incl

Hi <a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="

include related fields in response other than custom FETCH about flask_autocrud HOT 2 CLOSED

cs91chris commented on May 20, 2024

include related fields in response other than custom FETCH

from flask_autocrud.

Comments (2)

cs91chris commented on May 20, 2024

Hi,
I do not well understand what output you expect.
The models have to extend the Model class of flask_autocrud (I don't know what your BaseModel is). Your models should look like this (I have not tested):

from flask_autocrud import Model

db = SQLAlchemy()


class Company(db.Model, Model):
    __tablename__ = 'company'
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(150), nullable=False, unique=True)


class Address(db.Model, Model):
    __tablename__ = 'addresses'
    id = db.Column(db.Integer, primary_key=True)
    address_id = db.Column(db.Integer)
    company_id = db.Column(db.Integer, ForeignKey('company.id'))
    company = relationship(Company, backref="addresses")

You can see an example, where entities are artists and albums, here

flask_autocrud/tests/test_custom.py

Line 168 in 2f53dc1

def test_related(client):

Actually is not possible, with GET method, to fetch multiple related resources and applying filters on it.

Let me know

from flask_autocrud.

cs91chris commented on May 20, 2024

Hi @maikotz there is new release available. Now even multiple related resource are retrived with GET.
The following is an example that should fit your need:

curl -XGET 'http://127.0.0.1:5000/artist?_related=Album&_fields=Name&_no_links='

{
    "ArtistList": [
        {
            "AlbumList": [
                {
                    "AlbumId": 4
                },
                {
                    "AlbumId": 348
                },
                {
                    "AlbumId": 349
                }
            ],
            "ArtistId": 1,
            "Name": "AC/DC"
        },
        {
            "AlbumList": [
                {
                    "AlbumId": 3
                }
            ],
            "ArtistId": 2,
            "Name": "Accept"
        }
    ]
}