"""TrackWriter Model."""

from sqlalchemy import Column
from sqlalchemy import Integer
from sqlalchemy import String
from sqlalchemy.orm import Session

from product.connectors import mysql


class TrackWriter(mysql.BaseModel):
    """TrackWriter Model class."""

    __tablename__ = "track_writer"

    track_writer_id = Column("track_writer_id", Integer, primary_key=True, autoincrement=True)
    upc = Column("upc", String)


def delete(upc: str, session: Session) -> bool:
    """Delete TrackWriter by upc.

    Returns:
    bool: True if the records were deleted, False otherwise
    """
    result: int = session.query(TrackWriter).filter(TrackWriter.upc == upc).delete()
    return result != 0