有谁能帮我设计/找到一个JSON编码器,它能在我的sqlalchemy查询中使用连接时工作,并能序列化我指定的结果吗。在
查询如下:data = db.session.query(Post).join(Users).filter(Post.area == id, Users.id == Post.user_id).all()
然后我做一个json转储,如下所示:json_object = json.dumps(data, cls=AlchemyEncoder)
传统上,我使用自己的JSON编码器,如下所示:class AlchemyEncoder(json.JSONEncoder):
def default(self, o):
if isinstance(o.__class__, DeclarativeMeta):
data = {}
fields = o.__json__() if hasattr(o, '__json__') else dir(o)
for field in [f for f in fields if not f.startswith('_') and f not in ['metadata', 'query', 'query_class']]:
value = o.__getattribute__(field)
try:
json.dumps(value)
data[field] = value
except TypeError:
data[field] = None
return data
return json.JSONEncoder.default(self, o)
它引用的函数如下所示:
^{pr2}$
但是,在我创建的JSON对象中,我将在查询中加入这些列。我的JSON编码器显然只能使用在我查询的第一个表中找到的列。在
编辑:
下面是我的两个SQLAlchemy类的外观:class Post(Base):
__tablename__ = "post"
id = db.Column('id', UUIDType(binary=False), primary_key=True)
user_id = db.Column('user_id', UUIDType(binary=False), db.ForeignKey('users.id'))
votes = db.Column('votes', db.Integer)
message = db.Column('message', db.Unicode)
media = db.Column('media', db.Unicode)
lifetime = db.Column('lifetime', db.Integer)
time_uploaded = db.Column('time_uploaded', db.DateTime, server_default=func.now())
area = db.Column('area', db.Unicode)
user = db.relationship('Users', foreign_keys=user_id)
def __json__(self):
return ['id', 'username', 'name', 'profile_picture', 'message', 'media', 'time_uploaded', 'lifetime', 'votes', 'area']
class Users(Base):
__tablename__ = "users"
id = db.Column('id', UUIDType(binary=False), primary_key=True)
username = db.Column('username', db.Unicode, unique=True)
email = db.Column('email', db.Unicode, unique=True)
password = db.Column('password', db.Unicode)
name = db.Column('name', db.Unicode)
bio = db.Column('bio', db.Unicode)
profile_picture = db.Column('profile_picture', db.Unicode)