mirror of
https://github.com/maxdorninger/MediaManager.git
synced 2026-06-11 09:06:15 -04:00
25cd4b0724
This PR refactors the movie and tv modules and adds a "common" module for shared logic. <!-- This is an auto-generated comment: release notes by coderabbit.ai --> ## Summary by CodeRabbit * **New Features** * Dedicated import and metadata services for movies and TV; completed-torrent detection and import flows. * **Refactor** * Shared media schemas, models, repository logic and base services consolidated; movie/TV services and routes now delegate to specialised import/metadata services. * **Bug Fixes** * Fixed TV episode-count method name. * **Chores** * Added .DS_Store to ignore list; added module comment. <!-- end of auto-generated comment: release notes by coderabbit.ai -->
68 lines
2.2 KiB
Python
68 lines
2.2 KiB
Python
from uuid import UUID
|
|
|
|
from sqlalchemy import ForeignKey, PrimaryKeyConstraint, UniqueConstraint
|
|
from sqlalchemy.orm import Mapped, mapped_column, relationship
|
|
|
|
from media_manager.common.models import MediaFileMixin, MediaMixin
|
|
from media_manager.database import Base
|
|
|
|
|
|
class Show(Base, MediaMixin):
|
|
__tablename__ = "show"
|
|
__table_args__ = (UniqueConstraint("external_id", "metadata_provider"),)
|
|
|
|
ended: Mapped[bool] = mapped_column(default=False)
|
|
continuous_download: Mapped[bool] = mapped_column(default=False)
|
|
|
|
seasons: Mapped[list["Season"]] = relationship(
|
|
back_populates="show", cascade="all, delete"
|
|
)
|
|
|
|
|
|
class Season(Base):
|
|
__tablename__ = "season"
|
|
__table_args__ = (UniqueConstraint("show_id", "number"),)
|
|
|
|
id: Mapped[UUID] = mapped_column(primary_key=True)
|
|
show_id: Mapped[UUID] = mapped_column(
|
|
ForeignKey(column="show.id", ondelete="CASCADE"),
|
|
)
|
|
number: Mapped[int]
|
|
external_id: Mapped[int]
|
|
name: Mapped[str]
|
|
overview: Mapped[str]
|
|
|
|
show: Mapped["Show"] = relationship(back_populates="seasons")
|
|
episodes: Mapped[list["Episode"]] = relationship(
|
|
back_populates="season", cascade="all, delete"
|
|
)
|
|
|
|
|
|
class Episode(Base):
|
|
__tablename__ = "episode"
|
|
__table_args__ = (UniqueConstraint("season_id", "number"),)
|
|
id: Mapped[UUID] = mapped_column(primary_key=True)
|
|
season_id: Mapped[UUID] = mapped_column(
|
|
ForeignKey("season.id", ondelete="CASCADE"),
|
|
)
|
|
number: Mapped[int]
|
|
external_id: Mapped[int]
|
|
title: Mapped[str]
|
|
overview: Mapped[str | None] = mapped_column(nullable=True)
|
|
|
|
season: Mapped["Season"] = relationship(back_populates="episodes")
|
|
episode_files = relationship(
|
|
"EpisodeFile", back_populates="episode", cascade="all, delete"
|
|
)
|
|
|
|
|
|
class EpisodeFile(Base, MediaFileMixin):
|
|
__tablename__ = "episode_file"
|
|
__table_args__ = (PrimaryKeyConstraint("episode_id", "file_path_suffix"),)
|
|
episode_id: Mapped[UUID] = mapped_column(
|
|
ForeignKey(column="episode.id", ondelete="CASCADE"),
|
|
)
|
|
|
|
torrent = relationship("Torrent", back_populates="episode_files", uselist=False)
|
|
episode = relationship("Episode", back_populates="episode_files", uselist=False)
|