diff options
Diffstat (limited to 'python/Dawn/models.py')
| -rw-r--r-- | python/Dawn/models.py | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/python/Dawn/models.py b/python/Dawn/models.py index b9b6323c..dc8ff7d4 100644 --- a/python/Dawn/models.py +++ b/python/Dawn/models.py @@ -40,6 +40,7 @@ BOND_STRAT = ENUM('M_STR_MAV', 'M_STR_SMEZZ', 'CSO_TRANCH', 'M_MTG_GOOD', 'M_MTG_B4PR', 'M_MTG_RW', name='bond_strat') ASSET_CLASS = ENUM('CSO', 'Subprime', 'CLO', 'Tranches', 'Futures', 'Cash', 'FX', 'Cleared', name='asset_class') +ACTION = ENUM('NEW', 'UPDATE', 'CANCEL', name='action') def myticket(ctx): return "{0}.{1}".format(ctx.current_parameters['dealid'], @@ -49,14 +50,16 @@ class BondDeal(db.Model): __tablename__ = 'bonds' id = db.Column('id', db.Integer, primary_key=True) dealid = db.Column(db.String(28)) + lastupdate = db.Column(db.DateTime, server_default=db.func.now(), onupdate=db.func.now()) + action = db.Column(ACTION) folder = db.Column(BOND_STRAT, nullable=False) - custodian = db.Column(db.String(12), nullable=False) - cashaccount = db.Column(db.String(10), nullable=False) + custodian = db.Column(db.String(12), default='BAC', nullable=False) + cashaccount = db.Column(db.String(10), default='V0NSCLMAMB', nullable=False) counterparty = db.Column(db.String, db.ForeignKey("counterparties.code"), info={'choices': [(None, None)]}) trade_date = db.Column(db.Date, nullable = False, default = datetime.date.today) settle_date = db.Column(db.Date, nullable = False, default = - lambda : datetime.date.today()+datetime.timedelta(3)) + lambda : datetime.date.today() + datetime.timedelta(3)) cusip = db.Column(db.String(9), info={'validators': Length(9,9)}) isin = db.Column(db.String(12), info={'validator': Length(12, 12)}) description = db.Column(db.String(32)) |