VivianDee
45 lines
1.5 KiB
Python
45 lines
1.5 KiB
Python
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,
|
|
} |