mirror of
https://github.com/tcsenpai/swingmusic.git
synced 2025-06-06 19:25:34 +00:00
102 lines
3.0 KiB
Python
102 lines
3.0 KiB
Python
from app.models import FavType
|
|
from .utils import SQLiteManager
|
|
|
|
|
|
class SQLiteFavoriteMethods:
|
|
"""THis class contains methods for interacting with the favorites table."""
|
|
|
|
@classmethod
|
|
def check_is_favorite(cls, itemhash: str, fav_type: str):
|
|
"""
|
|
Checks if an item is favorited.
|
|
"""
|
|
sql = """SELECT * FROM favorites WHERE hash = ? AND type = ?"""
|
|
with SQLiteManager(userdata_db=True) as cur:
|
|
cur.execute(sql, (itemhash, fav_type))
|
|
items = cur.fetchall()
|
|
cur.close()
|
|
return len(items) > 0
|
|
|
|
@classmethod
|
|
def insert_one_favorite(cls, fav_type: str, fav_hash: str):
|
|
"""
|
|
Inserts a single favorite into the database.
|
|
"""
|
|
# try to find the favorite in the database, if it exists, don't insert it
|
|
if cls.check_is_favorite(fav_hash, fav_type):
|
|
return
|
|
|
|
sql = """INSERT INTO favorites(type, hash) VALUES(?,?)"""
|
|
with SQLiteManager(userdata_db=True) as cur:
|
|
cur.execute(sql, (fav_type, fav_hash))
|
|
cur.close()
|
|
|
|
@classmethod
|
|
def get_all(cls) -> list[tuple]:
|
|
"""
|
|
Returns a list of all favorites.
|
|
"""
|
|
sql = """SELECT * FROM favorites"""
|
|
with SQLiteManager(userdata_db=True) as cur:
|
|
cur.execute(sql)
|
|
favs = cur.fetchall()
|
|
cur.close()
|
|
return [fav for fav in favs if fav[1] != ""]
|
|
|
|
@classmethod
|
|
def get_favorites(cls, fav_type: str) -> list[tuple]:
|
|
"""
|
|
Returns a list of favorite tracks.
|
|
"""
|
|
sql = """SELECT * FROM favorites WHERE type = ?"""
|
|
with SQLiteManager(userdata_db=True) as cur:
|
|
cur.execute(sql, (fav_type,))
|
|
all_favs = cur.fetchall()
|
|
cur.close()
|
|
return all_favs
|
|
|
|
@classmethod
|
|
def get_fav_tracks(cls) -> list[tuple]:
|
|
"""
|
|
Returns a list of favorite tracks.
|
|
"""
|
|
return cls.get_favorites(FavType.track)
|
|
|
|
@classmethod
|
|
def get_fav_albums(cls) -> list[tuple]:
|
|
"""
|
|
Returns a list of favorite albums.
|
|
"""
|
|
return cls.get_favorites(FavType.album)
|
|
|
|
@classmethod
|
|
def get_fav_artists(cls) -> list[tuple]:
|
|
"""
|
|
Returns a list of favorite artists.
|
|
"""
|
|
return cls.get_favorites(FavType.artist)
|
|
|
|
@classmethod
|
|
def delete_favorite(cls, fav_type: str, fav_hash: str):
|
|
"""
|
|
Deletes a favorite from the database.
|
|
"""
|
|
sql = """DELETE FROM favorites WHERE hash = ? AND type = ?"""
|
|
|
|
with SQLiteManager(userdata_db=True) as cur:
|
|
cur.execute(sql, (fav_hash, fav_type))
|
|
cur.close()
|
|
|
|
@classmethod
|
|
def get_track_count(cls) -> int:
|
|
"""
|
|
Returns the number of favorite tracks.
|
|
"""
|
|
sql = """SELECT COUNT(*) FROM favorites WHERE type = ?"""
|
|
|
|
with SQLiteManager(userdata_db=True) as cur:
|
|
cur.execute(sql, (FavType.track,))
|
|
count = cur.fetchone()[0]
|
|
cur.close()
|
|
return count
|