"""ProductReviewStatusHistory."""
from sqlalchemy import Column
from sqlalchemy import DateTime
from sqlalchemy import ForeignKey
from sqlalchemy import Integer

from content_review.connectors import mysql


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

    __tablename__ = 'product_review_status_history'

    product_review_status_history_id = Column(
        'id', Integer, primary_key=True, key='id')
    product_id = Column('product_id', Integer, index=True)
    review_type_id = Column(
        'review_type_id', Integer,
        ForeignKey('review_type.id'), index=True)
    review_status_type_id = Column(
        'review_status_type_id', Integer,
        ForeignKey('review_status_type.id'), index=True)
    created_timestamp = Column('created_timestamp', DateTime)
    review_timestamp = Column('review_timestamp', DateTime)


DEFAULT_FIELDS = {
    ProductReviewStatusHistory.product_review_status_history_id,
    ProductReviewStatusHistory.product_id,
    ProductReviewStatusHistory.review_type_id,
    ProductReviewStatusHistory.review_status_type_id,
    ProductReviewStatusHistory.created_timestamp,
    ProductReviewStatusHistory.review_timestamp
}


def create_history_object(
        product_id, review_type_id, review_status_type_id,
        created_timestamp, review_timestamp):
    """Insert a new history item.

    Args:
        product_id (int): The product id.
        review_type_id (int): References the review_type.
        review_status_type_id (int): References the review_status_type
        created_timestamp (object): DateTime UTC
        review_timestamp (object): DateTime of the created_timestamp in
                                   product_review_history

    Returns:
       object: ProductReviewStatusHistory()
    """
    return ProductReviewStatusHistory(
        product_id=product_id,
        review_type_id=review_type_id,
        review_status_type_id=review_status_type_id,
        created_timestamp=created_timestamp,
        review_timestamp=review_timestamp
    )