"""Reference Flowthrough Calculation Model."""

from abacus_common_logic.connectors.database import db
from abacus_common_logic.models.base import CRUDMixin


class ReferenceFlowthroughCalculation(db.Model, CRUDMixin):
    """Reference Flowthrough Calculation Model."""

    __tablename__ = 'reference_flowthrough_calculation'
    reference_flowthrough_calculation_id = db.Column(db.Integer, primary_key=True)
    flowthrough_calculation_name = db.Column(db.String(180), nullable=False)
    flowthrough_calculation = db.Column(db.String(180), nullable=False)
    flowthrough_calculation_example = db.Column(db.String(180), nullable=False)
    flowthrough_calculation_example_summary = db.Column(db.String(180), nullable=False)

    contract_flowthroughs = db.relationship(
        'ContractFlowthrough',
        backref='reference_flowthrough_calculation',
        cascade='all, delete-orphan',
        uselist=True
    )

    @classmethod
    def default_order(cls):
        """Override to customize default ordering."""
        return cls.reference_flowthrough_calculation_id.asc()