"""ReleaseApprovalQueue model."""

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

from product.connectors import mysql


class ReleaseApprovalQueue(mysql.BaseModel):
    """ReleaseApproval Model class."""

    __tablename__ = "release_approval_queue"

    release_approval_id = Column("release_approval_id", Integer, primary_key=True)
    release_id = Column("release_id", Integer)


def delete(product_id: str, session: Session) -> bool:
    """
    Delete a ReleaseApprovalQueue record by product_id.

    Returns:
        bool: True if the record was deleted, False otherwise
    """
    result: int = (
        session.query(ReleaseApprovalQueue)
        .filter(ReleaseApprovalQueue.release_id == product_id)
        .delete()
    )
    return result == 1