"""reference_mechanical_rate Model."""

from abacus_common_logic.connectors.database import db
from abacus_common_logic.models import BaseModel, NormalizedDateTime


class ReferenceMechanicalRate(BaseModel):
    """reference_mechanical_rate Model."""

    __tablename__ = 'reference_mechanical_rate'
    reference_mechanical_rate_id = db.Column(db.Integer, primary_key=True)
    country_code = db.Column(db.String(3), nullable=False)
    base_rate = db.Column(db.Numeric(10, 4), nullable=False)
    minute_rate = db.Column(db.Numeric(10, 4), nullable=False)
    ringtone_rate = db.Column(db.Numeric(10, 4), nullable=False)
    effective_start_date = db.Column(NormalizedDateTime(), nullable=False)

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