from app.extensions import db


class Transaction(db.Model):
    __tablename__ = "transactions"

    tran_id = db.Column(db.String(50), primary_key=True)
    cif_id = db.Column(db.String(500))
    foracid = db.Column(db.String(150))
    acid = db.Column(db.String(150))
    tran_date = db.Column(db.DateTime)
    value_date = db.Column(db.DateTime)
    pstd_date = db.Column(db.DateTime)
    tran_sub_type = db.Column(db.String(50))
    part_tran_type = db.Column(db.String(50))
    tran_crncy_code = db.Column(db.String(50))
    tran_amt = db.Column(db.Numeric(38, 0))
    tran_particular = db.Column(db.String(250))
    origination_channel = db.Column(db.String(150))
    reversal_tran_id = db.Column(db.String(50))
    isreversal = db.Column(db.String(50))


def __repr__(self):
    return f"<Transaction {self.tran_id}>" 


def to_dict(self):
    return {
        "tran_id": self.tran_id,
        "cif_id": self.cif_id,
        "foracid": self.foracid,
        "acid": self.acid,
        "tran_date": self.tran_date,
        "value_date": self.value_date,
        "pstd_date": self.pstd_date,
        "tran_sub_type": self.tran_sub_type,
        "part_tran_type": self.part_tran_type,
        "tran_crncy_code": self.tran_crncy_code,
        "tran_amt": float(self.tran_amt) if self.tran_amt is not None else None,
        "tran_particular": self.tran_particular,
        "origination_channel": self.origination_channel,
        "reversal_tran_id": self.reversal_tran_id,
        "isreversal": self.isreversal,
    }