"""Orchardadmin User model."""

from sqlalchemy import Column
from sqlalchemy import DateTime
from sqlalchemy import Enum
from sqlalchemy import Integer
from sqlalchemy import String
from sqlalchemy.sql import text

from manualadjustment.connectors import mysql


class OrchadminUser(mysql.ArtRelationsBaseModel):
    """Model for the orchadmin_users table."""

    __tablename__ = 'orchadmin_users'
    id = Column(Integer, primary_key=True)  # noqa
    login = Column(String(15), nullable=False, unique=True)
    old_password = Column(String(255))
    password = Column(String(255))
    _pass = Column(
        'pass', String(50), nullable=False, server_default=text("''"))
    f_name = Column(String(35), nullable=False)
    l_name = Column(String(35), nullable=False)
    role = Column(Integer, nullable=False, server_default=text("'0'"))
    owner = Column(String(20))
    active = Column(Enum('Y', 'N'), server_default=text("'Y'"))
    office_phone = Column(String(20))
    extension = Column(Integer)
    alt_phone = Column(String(20))
    email = Column(String(64))
    last_search = Column(String(40))
    password_date_changed = Column(DateTime)
    closer = Column(Enum('Y', 'N'), server_default=text("'N'"))
    office_location = Column(String(35))
    title = Column(String(50))
    department = Column(String(100))
    display = Column(Enum('Y', 'N'), server_default=text("'Y'"))
    password_request_key = Column(String(255))
    password_reset_datetime = Column(DateTime)