"""Customer Master Master model."""

from product_configuration.connectors import mysql
from sqlalchemy import Column
from sqlalchemy import String
from sqlalchemy import Integer
from sqlalchemy import Enum
from sqlalchemy import DateTime
from sqlalchemy import SmallInteger
from sqlalchemy import null
from sqlalchemy import Text


class CustomerMasterMaster(mysql.BaseModel):
    """Customer Master Master Model."""

    __tablename__ = 'customer_master_master'

    customer_master_master_id = Column(
        SmallInteger, primary_key=True, autoincrement=True, nullable=False)
    customer_name = Column(String, nullable=False)
    sony_dms_code = Column(String, default=null)
    ci_dms_code = Column(String, default=null)
    delivery_option = Column(
        Enum('full', 'cherry_pick', 'filtered_catalog'),
        nullable=False, default='full')
    show_delivery_info = Column(Enum('Y', 'N'), nullable=False, default='Y')
    product_type_id = Column(Text)
    delivery_cap = Column(Integer, default=null)
    weekly_limit = Column(SmallInteger, default=null)
    eo_limit = Column(SmallInteger, default=null)
    encoding_order_status = Column(Enum('close', 'open'), nullable=False)
    mv_delivery_option = Column(Enum('full', 'cherry_pick'), default=null)
    ddex_party_id = Column(String, default=null)
    optin_date = Column(DateTime)
    required_genre_code = Column(Enum('Y', 'N'), default=null)
    required_subgenre_code = Column(Enum('Y', 'N'), default=null)
    required_subgenre = Column(Enum('Y', 'N'), default=null)
    instant_grat = Column(Enum('Y'), default=null)
    hd_only = Column(Enum('Y', 'N'), default=null)
    status = Column(Enum('active', 'inactive', 'terminated'), default=null)
    label_store = Column(Enum('Y', 'N'), nullable=False)