"""Subgenre queries."""

from backend.connectors import mysql
from backend.models.subgenre import Subgenre
from backend.utils import api as api_utils

class SubgenreQuery(object):
    """Handles Subgenre queries."""

    @classmethod
    @mysql.db_session_wrap
    def get_genre_subgenres(cls, genre_id, session):
        """Get all subgenres for a genre from DB.

        Args:
            genre_id (int): genre id
            session (object): SQLAlchemy database session (optional)

        Returns:
            List of all subgenres for the genre
        """
        subgenres = session.query(Subgenre) \
            .filter(Subgenre.genre_id == genre_id) \
            .order_by(Subgenre.orchard_id).all()

        return api_utils.create_get_list_response(
            [sg.to_dict() for sg in subgenres])