From b14580f9a2b8e9597e3e2b52da17553a90e12470 Mon Sep 17 00:00:00 2001 From: Jeremy Hansen Date: Sun, 10 Mar 2024 03:50:51 -0700 Subject: multimedia/sickchill: Support newer SQLAlchemy Signed-off-by: Willy Sudiarto Raharjo --- multimedia/sickchill/sickchill.SlackBuild | 6 +- multimedia/sickchill/use-older-SQLAlchemy.patch | 167 ------------------------ 2 files changed, 1 insertion(+), 172 deletions(-) delete mode 100644 multimedia/sickchill/use-older-SQLAlchemy.patch (limited to 'multimedia') diff --git a/multimedia/sickchill/sickchill.SlackBuild b/multimedia/sickchill/sickchill.SlackBuild index 094cd49c98..efec98d47e 100644 --- a/multimedia/sickchill/sickchill.SlackBuild +++ b/multimedia/sickchill/sickchill.SlackBuild @@ -25,7 +25,7 @@ cd $(dirname $0) ; CWD=$(pwd) PRGNAM=sickchill VERSION=${VERSION:-2024.3.1} -BUILD=${BUILD:-1} +BUILD=${BUILD:-2} TAG=${TAG:-_SBo} PKGTYPE=${PKGTYPE:-tgz} @@ -97,10 +97,6 @@ find -L . \ \( -perm 666 -o -perm 664 -o -perm 640 -o -perm 600 -o -perm 444 \ -o -perm 440 -o -perm 400 \) -exec chmod 644 {} \; -# Revert changes that require SQLAlchmey > 2.0 until SBo catches up -patch -p1 < $CWD/use-older-SQLAlchemy.patch -sed -i 's|>=2.0.0,<3.0.0|<2.0.0|' pyproject.toml - # Correct python module names and remove version requirements sed -i 's|kodipydent-alt.*|kodipydent = "\*"|' pyproject.toml sed -i 's|new-rtorrent-python.*|rtorrent-python = "\*"|' pyproject.toml diff --git a/multimedia/sickchill/use-older-SQLAlchemy.patch b/multimedia/sickchill/use-older-SQLAlchemy.patch deleted file mode 100644 index 4ab716afa2..0000000000 --- a/multimedia/sickchill/use-older-SQLAlchemy.patch +++ /dev/null @@ -1,167 +0,0 @@ -diff --git a/sickchill/oldbeard/databases/movie.py b/sickchill/oldbeard/databases/movie.py -index 3598dcc..52000a3 100644 ---- a/sickchill/oldbeard/databases/movie.py -+++ b/sickchill/oldbeard/databases/movie.py -@@ -4,45 +4,43 @@ from typing import List - - import guessit - from slugify import slugify --from sqlalchemy import ForeignKey, JSON -+from sqlalchemy import Boolean, Column, Date, DateTime, ForeignKey, Integer, Interval, JSON, SmallInteger, String - from sqlalchemy.event import listen - from sqlalchemy.ext.declarative import declarative_base --from sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column, relationship, sessionmaker -+from sqlalchemy.orm import relationship, sessionmaker - - logger = logging.getLogger("sickchill.movie") - -- --class Base(DeclarativeBase): -- """Declarative Base Class""" -- -+Base = declarative_base() - - Session = sessionmaker() - - - class Movie(Base): - __tablename__ = "movie" -- pk: Mapped[int] = mapped_column(primary_key=True) -- name: Mapped[str] -- date: Mapped[datetime.date] -- year: Mapped[int] -- status: Mapped[int] -- paused: Mapped[bool] = mapped_column(default=False) -- location: Mapped[str] -- start: Mapped[datetime.timedelta] = mapped_column(default=datetime.timedelta(days=-7)) -- interval: Mapped[datetime.timedelta] = mapped_column(default=datetime.timedelta(days=1)) -- added: Mapped[datetime.datetime] = mapped_column(default=datetime.datetime.now) -- updated: Mapped[datetime.datetime] = mapped_column(onupdate=datetime.datetime.now) -- completed: Mapped[datetime.datetime] -- searched: Mapped[datetime.datetime] -- slug: Mapped[str] -- -- language: Mapped[str] -- -- result_pk: Mapped[int] = mapped_column(ForeignKey("result.pk")) -- results: Mapped[List["Result"]] = relationship(backref="movie") -- -- images: Mapped[List["Images"]] = relationship(backref="movie") -- indexer_data: Mapped[List["IndexerData"]] = relationship(backref="movie") -+ -+ pk = Column(Integer, primary_key=True) -+ name = Column(String) -+ date = Column(Date) -+ year = Column(SmallInteger) -+ status = Column(Integer) -+ paused = Column(Boolean, default=False) -+ location = Column(String) -+ start = Column(Interval, default=datetime.timedelta(days=-7)) -+ interval = Column(Interval, default=datetime.timedelta(days=1)) -+ added = Column(DateTime, default=datetime.datetime.now) -+ updated = Column(DateTime, onupdate=datetime.datetime.now) -+ completed = Column(DateTime) -+ searched = Column(DateTime) -+ slug = Column(String) -+ -+ language = Column(String) -+ -+ result_pk = Column(Integer, ForeignKey("result.pk")) -+ results: list = relationship("Result", backref="movie") -+ -+ images: list = relationship("Images", backref="movie") -+ indexer_data: list = relationship("IndexerData", backref="movie") - - def __init__(self, name: str, year: int): - self.name = name -@@ -134,21 +132,21 @@ listen(Movie.name, "set", Movie.slugify, retval=False) - - class Result(Base): - __tablename__ = "result" -- pk: Mapped[int] = mapped_column(primary_key=True) -- name: Mapped[str] -- title: Mapped[str] -- url: Mapped[str] -- size: Mapped[int] -- year: Mapped[int] -- provider: Mapped[str] -- seeders: Mapped[int] -- leechers: Mapped[int] -- info_hash: Mapped[str] -- group: Mapped[str] -- kind: Mapped[str] -- guess = mapped_column(JSON) -- found: Mapped[datetime.datetime] = mapped_column(default=datetime.datetime.now) -- updated: Mapped[datetime.datetime] = mapped_column(onupdate=datetime.datetime.now) -+ pk = Column(Integer, primary_key=True) -+ name = Column(String) -+ title = Column(String) -+ url = Column(String) -+ size = Column(Integer) -+ year = Column(SmallInteger) -+ provider = Column(String) -+ seeders = Column(Integer) -+ leechers = Column(Integer) -+ info_hash = Column(String) -+ group = Column(String) -+ type = Column(String) -+ guess = Column(JSON) -+ found = Column(DateTime, default=datetime.datetime.now) -+ updated = Column(DateTime, onupdate=datetime.datetime.now) - - session = Session() - -@@ -172,7 +170,7 @@ class Result(Base): - self.leechers = result["leechers"] - self.size = result["size"] - self.year = guess["year"] or movie.year -- self.kind = provider.provider_type -+ self.type = provider.provider_type - - self.provider = provider.get_id() - -@@ -187,12 +185,12 @@ class Result(Base): - class Images(Base): - __tablename__ = "images" - -- url: Mapped[str] = mapped_column(primary_key=True) -- path: Mapped[str] -- site: Mapped[str] -- style: Mapped[int] -+ url = Column(String, primary_key=True) -+ path = Column(String) -+ site = Column(String) -+ style = Column(Integer) - -- movie_pk: Mapped[int] = mapped_column(ForeignKey("movie.pk")) -+ movie_pk = Column(Integer, ForeignKey("movie.pk")) - - def __init__(self, site: str, movie_pk: int, url: str, path: str, style: int): - self.url = url -@@ -204,13 +202,13 @@ class Images(Base): - - class IndexerData(Base): - __tablename__ = "indexer_data" -- pk: Mapped[str] = mapped_column(primary_key=True) -- site: Mapped[str] -- data = mapped_column(JSON) -+ pk = Column(String, primary_key=True) -+ site = Column(String) -+ data = Column(JSON) - -- movie_pk: Mapped[int] = mapped_column(ForeignKey("movie.pk")) -+ movie_pk = Column(Integer, ForeignKey("movie.pk")) - -- genres: Mapped[List["Genres"]] = relationship(backref="indexer_data") -+ genres: list = relationship("Genres", backref="indexer_data") - - def __repr__(self): - return f"[{self.__tablename__.replace('_', ' ').title()}] {self.site}: {self.pk} - {self.movie.name}" -@@ -218,5 +216,5 @@ class IndexerData(Base): - - class Genres(Base): - __tablename__ = "genres" -- pk: Mapped[str] = mapped_column(primary_key=True) -- indexer_data_pk: Mapped[int] = mapped_column(ForeignKey("indexer_data.pk")) -+ pk = Column(String, primary_key=True) -+ indexer_data_pk = Column(Integer, ForeignKey("indexer_data.pk")) -- cgit v1.2.3