"""Genre Model.

This Genre model uses sqlalchemy.
"""

from owsresponse import response
from sqlalchemy import Column, Integer, String

from account.connectors import mysql


class Genre(mysql.BaseModel):
    """Genre DB Model."""

    __tablename__ = 'genre'

    genre_id = Column(Integer, primary_key=True)
    genre = Column(String)


def get_genres():
    """Get list of genres from genre table."""
    with mysql.session_scope(read_only=True) as session:
        result = session.query(Genre.genre_id, Genre.genre).order_by(Genre.genre).all()

        if result:
            return response.Response([r._asdict() for r in result])

    return response.create_not_found_response()