从Sqlalchemy基类生成JSON，其中包括关系中的子簇

Question

我正在尝试生成我的sqlalchemy类的json，我遵循了这个示例：https://blogs.gnome.org/danni/2013/03/07/generating-json-from-sqlalchemy-objects/

它运行良好，但是现在我想包括Sqlachemy关系产生的子类的所有数据。我已经尝试过几件事，最后一个试图在子插槽上迭代，但我不知道为什么该方法子类不返回任何内容。这是修改的函数：

def tojson(self):
    res=self.columnitems
    for cls in self.__class__.__subclasses__():
        res[cls.__name__]=cls.tojson()
    return res

您知道有什么方法吗？

预先感谢

Answer 1

我尚无法评论，但是根据我假设您正在尝试从(相关(SQLalchemy类生成JSON的信息。您可以将棉花糖(https://marshmallow.readthedocs.io/en/latest/(用于此。

下面的(快速(示例显示了如何使用两个相关表的棉花糖生成JSON。

from sqlalchemy import Column, Integer, String, Boolean
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import create_engine, ForeignKey
from sqlalchemy.orm import sessionmaker, relationship
Base = declarative_base()

# Creating dummy classes...
class Owner(Base):
    __tablename__ = 'owner'
    id = Column('id', Integer, primary_key=True)
    name = Column('name', String(250))
    interested_in_cars = Column('interest', Boolean)
    car = relationship('Car', uselist=False, back_populates="owner")
    def __init__(self, name, interested_in_cars, id):
        self.id = id
        self.name = name
        self.interested_in_cars = interested_in_cars
    def __repr__(self):
        return '< (id={id}) Owner: {name} - interested: {interested_in_cars} >'.format(id=self.id,
                                                                                       name=self.name,
                                                                                       interested_in_cars=self.interested_in_cars)

class Car(Base):
    __tablename__ = 'car'
    id = Column('id', Integer, primary_key=True)
    brand = Column(String(250))
    owner_id = Column(Integer, ForeignKey('owner.id'))
    owner = relationship('Owner', back_populates='car')
    def __init__(self, owner_id, brand):
        self.owner_id = owner_id
        self.brand = brand
    def __repr__(self):
        return '< Owner: {owner_id} - Car: {brand} >'.format(owner_id=self.owner_id, brand=self.brand)

engine = create_engine('sqlite:///')
session = sessionmaker()
session.configure(bind=engine)
ex_ses = session()
Base.metadata.create_all(engine)
owner_1 = Owner(interested_in_cars=True, name='Owner a', id=1)
owner_2 = Owner(interested_in_cars=False, name='Owner b', id=2)
ex_ses.add(owner_1)
ex_ses.add(owner_2)
# ID's - quick example
car_1 = Car(owner_id=1, brand='Car a')
car_2 = Car(owner_id=2, brand='Car b')
ex_ses.add(car_1)
ex_ses.add(car_2)
ex_ses.commit()
# Using marshmallow to generate the json
from marshmallow import Schema, fields, pprint

class OwnerShema(Schema):
    id = fields.Int()
    name = fields.String()
    interested_in_cars = fields.Boolean()
    car = fields.Nested('CarShema')

class CarShema(Schema):
    id = fields.Int()
    brand = fields.String()

# Example Owners and cars
owners_cars = ex_ses.query(Owner).all()
print('Owners and cars: ', owners_cars)
owners_cars_shema = OwnerShema()
pprint(owners_cars_shema.dump(owners_cars, many=True).data)

有关更多信息，请参见棉花糖文档(上面提供的链接(。