31 lines
1.3 KiB
Python
31 lines
1.3 KiB
Python
from typing import List
|
|
from typing import Optional
|
|
from sqlalchemy import String, ForeignKey, Integer
|
|
from sqlalchemy.orm import Mapped
|
|
from sqlalchemy.orm import mapped_column
|
|
from sqlalchemy.orm import relationship
|
|
|
|
from .base import Base
|
|
|
|
class Book(Base):
|
|
__tablename__ = "book"
|
|
id: Mapped[int] = mapped_column(primary_key=True)
|
|
hash: Mapped[Optional[str]] = mapped_column(String(255))
|
|
file_name: Mapped[Optional[str]] = mapped_column(String(65656))
|
|
file_path: Mapped[Optional[str]] = mapped_column(String(65656))
|
|
name: Mapped[str] = mapped_column(String(65656))
|
|
publisher: Mapped[Optional[str]] = mapped_column(String(65656))
|
|
notes: Mapped[Optional[str]] = mapped_column(String(65656))
|
|
classification: Mapped[Optional[int]] = mapped_column(Integer)
|
|
|
|
library_id: Mapped[int] = mapped_column(ForeignKey("library.id"))
|
|
library: Mapped[int] = relationship("Library", back_populates="books")
|
|
|
|
tags: Mapped[List["BookTag"]] = relationship(
|
|
back_populates="book", cascade="all, delete-orphan"
|
|
)
|
|
|
|
def __repr__(self) -> str:
|
|
return f"Book(id={self.id!r}, name={self.name!r}, publisher={self.publisher!r}, " \
|
|
f"notes={self.notes!r}, classification={self.classification!r}), " \
|
|
f"hash={self.hash!r}, file_name={self.file_name}, file_path={self.file_path})" |