SQLALCHEMY的MODE
class FutureTradeBlanceHis(Base):
"""Marex余額變更歷史記錄"""
tablename = "T_FutureTrade_Blance_History"
table_args = (
(ForeignKeyConstraint(['blanceid', 'contractid'],
['T_FutureTrade_Blance.pid','T_FutureTrade_Blance.contractid'])
),
) #多外鍵范例
pid = Column(Integer, primary_key=True)
blanceid = Column(Integer)#,
chagedate = Column(Date) # 更新時間
marketid = Column(String(50)) # 市場代碼
contractid = Column(String(50)) # 合約號
direction = Column(String(50)) # 多空方向
buyblance = Column(Float) # 買入余額
sellblance = Column(Float) # 賣出余額
totalblance = Column(Float) # 總余額
多外鍵的MODE設(shè)置
class FutureTradeBlance(Base):
tablename = "T_FutureTrade_Blance"
table_args = ((PrimaryKeyConstraint('pid', 'contractid')),) #建立多主鍵的方式
pid = Column(Integer)
sourceid = Column(String(50)) #系統(tǒng)代碼
marketid = Column(String(50)) # 市場代碼
contractid = Column(String(50)) # 合約號
createdate = Column(Date) #創(chuàng)建時間
updatedate = Column(Date) #更新時間
direction = Column(String(50)) # 多空方向
buyblance = Column(Float) # 買入余額
sellblance = Column(Float) # 賣出余額
totalblance = Column(Float) # 總余額
多主鍵的模型類建立
