From b0ea7ab93564f1b2f004f7ea74783508f12f4ff6 Mon Sep 17 00:00:00 2001 From: Parker Date: Tue, 21 Jan 2025 20:38:33 -0600 Subject: Fixes + Use SQLAlchemy --- code/utils/models.py | 31 +++++++++++++++++++++++++++++++ 1 file changed, 31 insertions(+) create mode 100644 code/utils/models.py (limited to 'code/utils/models.py') diff --git a/code/utils/models.py b/code/utils/models.py new file mode 100644 index 0000000..3dbd6be --- /dev/null +++ b/code/utils/models.py @@ -0,0 +1,31 @@ +from sqlalchemy import ( + Column, + Integer, + String, + DateTime, + BigInteger, +) + + +from utils.database import Base + + +class Requests(Base): + __tablename__ = "requests" + + id = Column(Integer, primary_key=True, index=True) + title = Column(String) + release_year = Column(Integer) + local_id = Column(Integer) + tmdbid = Column(Integer) + tvdbid = Column(Integer) + user_id = Column(BigInteger) + + +class JellyfinAccounts(Base): + __tablename__ = "jellyfin_accounts" + + id = Column(Integer, primary_key=True, index=True) + user_id = Column(BigInteger) + jellyfin_user_id = Column(String) + deletion_time = Column(DateTime) -- cgit v1.2.3-70-g09d2