python在sql筛选_如何使用SQLAlchemy筛选器子查询？

我用SQLAlchemy的时间不长。

我有这样的结构：class Category(db.Model):

id = db.Column(db.Integer, primary_key=True)

name = db.Column(db.String(140))

parent_id = db.Column(db.Integer, db.ForeignKey('category.id'))

parent = db.relationship("Category", remote_side=id, backref="sub_categories")

def __repr__(self):

return ''.format(self)

class Object(db.Model):

id = db.Column(db.Integer, primary_key=True)

name = db.Column(db.String(140))

category_id = db.Column(db.Integer, db.ForeignKey('category.id'), nullable=False)

category = db.relationship('Category', backref="objects")

values = db.relationship("Value", secondary="object_value", backref="objects")

def __repr__(self):

return ''.format(self)

class Property(db.Model):

id = db.Column(db.Integer, primary_key=True)

name = db.Column(db.String(140))

categories = db.relationship("Category", secondary="category_property", backref="properties")

def __repr__(self):

return ''.format(self)

class Value(db.Model):

id = db.Column(db.Integer, primary_key=True)

value = db.Column(db.String(140))

property_id = db.Column(db.Integer, db.ForeignKey("property.id"))

prop = db.relationship('Property', backref="values")

def __repr__(self):

return ''.format(self)

db.Table(

'category_property', db.Model.metadata,

db.Column('category_id', db.Integer, db.ForeignKey('category.id')),

db.Column('property_id', db.Integer, db.ForeignKey('property.id'))

)

db.Table(

'object_value', db.Model.metadata,

db.Column('object_id', db.Integer, db.ForeignKey('object.id')),

db.Column('value_id', db.Integer, db.ForeignKey('value.id'))

)

使用这个我试图得到所有的对象的类别，但在对象我只想得到在类别中使用的属性。我是说像这样的人：

^{pr2}$

some_join_subquery中必须包含什么？在