"""LedgerAccountContractCurrentBalance model.

Model for managing ledger account's latest current balance entry

AFTER INSERT mysql database trigger on ledger_account_contract table
leads to INSERT/UPDATE of record into the
ledger_account_contract_current_balance table

Each new ledger entry in ledger_account_contract table
will trigger the insert query for ledger_account_contract_current_balance.table.
However, duplicate account entry in ledger_account_contract would update
an existing account entry in ledger_account_contract_current_balance.table
with the latest ledger_account_contract_id of account.
"""

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


class LedgerAccountContractCurrentBalance(BaseModel):
    """Ledger account contract Current Balance model."""

    __tablename__ = 'ledger_account_contract_current_balance'
    ledger_account_contract_current_balance_id = db.Column(db.Integer, primary_key=True)
    ledger_account_contract_id = db.Column(
        db.Integer,
        db.ForeignKey('ledger_account_contract.ledger_account_contract_id'),
        nullable=False,
    )
    account_id = db.Column(db.Integer, nullable=False)
    contract_id = db.Column(db.Integer, nullable=False)