"""Placeholder UPC Model."""

from oto import response
from sentry_sdk import capture_exception
from sqlalchemy.exc import SQLAlchemyError

from product.connectors import mysql


def generate_upc():
    """Generate a new placeholder UPC value.

    Returns:
        response.Response: containing dict with placeholder upc or error
    """
    with mysql.db_session() as session:
        try:
            generate_upc_query = "INSERT INTO placeholder_upc VALUES (null);"
            generated_upc = session.execute(generate_upc_query).lastrowid
            placeholder_upc = {"placeholder_upc": generated_upc}

            return response.Response(message=placeholder_upc)
        except SQLAlchemyError as exception:
            capture_exception(exception)
            return response.create_fatal_response()