"""Manual Adjustment currency models."""

from sqlalchemy import Column
from sqlalchemy import SmallInteger
from sqlalchemy import String
from sqlalchemy.sql import text

from manualadjustment.connectors import mysql


class Currency(mysql.ArtRelationsBaseModel):
    """Model for the currencies table."""

    __tablename__ = 'currencies'
    id = Column(SmallInteger, primary_key=True)  # noqa
    ISO_4217_code = Column(String(12), unique=True)
    symbol_html_entity_code = Column(String(45))
    currency_name = Column(String(45))
    decimal_mark = Column(String(1))
    thousands_separator = Column(String(1))
    symbol_infront = Column(String(1))
    subunit_to_unit = Column(SmallInteger)
    subunit_name = Column(String(45))
    supported_payout_currency = Column(String(1), server_default=text("'N'"))