Class Audio

pstext/models.py:9–24

from .database import Base

class Audio(Base):
    __tablename__ = 'audio'  # 数据表的表名

    id = Column(Integer, primary_key=True, index=True, autoincrement=True)
    title = Column(String(100), unique=True, nullable=False, comment='音频名称')
    size = Column(String(100), comment='文件大小')
    extension = Column(String(100), comment='文件类型')
    progress = Column(Float, default=False, comment='进度')
    data = relationship('Data', back_populates='audio')  # 'Data'是关联的类名；back_populates来指定反向访问的属性名称
    created_at = Column(DateTime, server_default=func.now(), comment='创建时间')

    # __mapper_args__ = {"order_by": created_at}  # 默认是正序，倒序加上.desc()方法

    #读取数据后，显示出来的方式
    def __repr__(self):
        return f'{self.title}_{self.size}'


class Data(Base):