python - Python Flask-SQLAlchemy ORM 问题 ?

Question

Python 的这个插件好难懂：

from sqlalchemy import Column, Integer, String
from lib.database import Base

class User(Base):
    __tablename__ = '表名'
    ID = Column(Integer, primary_key=True)
    app_key = Column(String(50), unique=True)
    secret = Column(String(120), unique=True)

    def __init__(self, app_key=None, secret=None):
        self.app_key = app_key
        self.secret = secret

    def __repr__(self):
        return f'<User {self.app_key!r}>'

>>> from model.user import User
>>> User.query.all()
[User(ID=3, app_key='TEST_1a2a0ad5579b7b45fc675181c7aeba8b', secret='TEST_c8593ffbfdbfc86445ff91430c5cb3aafc65'), User(ID=4, app_key='aaaaaa', secret='aaaaaa')]>>> 

为什么通过框架返回的时候就是：Unexpect System Error - Object of type User is not JSON serializable 有什么好的学习资料么，真的好难懂

Answer 1

你的 Base 是这样的吗？

from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base()
class User(Base):
    __tablename__ = '表名'
    ID = Column(Integer, primary_key=True)
    app_key = Column(String(50), unique=True)
    secret = Column(String(120), unique=True)

    def __init__(self, app_key=None, secret=None):
        self.app_key = app_key
        self.secret = secret

    def __repr__(self):