"""LedgerAccountCurrentBalance model.

Model for managing ledger account's latest current balance entry

Insertion trigger on ledger_account table leads to insertion/updation of record into the
ledger_account_current_balance table

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

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


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

    __tablename__ = 'ledger_account_current_balance'
    ledger_account_current_balance_id = db.Column(db.Integer, primary_key=True)
    ledger_account_id = db.Column(
        db.Integer, db.ForeignKey('ledger_account.ledger_account_id'), nullable=False
    )
    account_id = db.Column(db.Integer, nullable=False)