"""Release Manual Adjustment and related models."""

from sqlalchemy import Column
from sqlalchemy import DateTime
from sqlalchemy import Float
from sqlalchemy import ForeignKey
from sqlalchemy import func
from sqlalchemy import Integer
from sqlalchemy import Text
from sqlalchemy import TIMESTAMP
from sqlalchemy.orm import relationship

from manualadjustment.connectors import mysql


class ReleaseManualAdjustment(mysql.ArtRelationsBaseModel):
    """Model for the manual_adjustment table."""

    __tablename__ = 'release_manual_adjustment'

    _id = Column(
        'id', Integer, primary_key=True, autoincrement=True, nullable=False)
    date_created = Column(DateTime, default=func.now())
    created_by = Column(Integer)
    category_id = Column(
        Integer, ForeignKey('manual_adjustment_category.category_id'))
    amount = Column(Float(precision=18, decimal_return_scale=6))
    currencies_id = Column(Integer)
    description = Column(Text)
    last_updated = Column(
        TIMESTAMP, server_default=func.now(),
        onupdate=func.current_timestamp())
    vendor_manual_adjustment_id = Column(
        Integer, ForeignKey('manual_adjustment.id'))
    release_id = Column(Integer)

    # relationships
    category = relationship(
        'ManualAdjustmentCategory', foreign_keys=[category_id], lazy='joined')
    manual_adjustment = relationship(
        'ManualAdjustment', back_populates='release_manual_adjustments')