def insert_obj(self, order):
sql = ('INSERT INTO Orders VALUES '
'({0},"{1}",{2},{3},{4},{5},'
'{6},{7},{8},{9})').format(order.id, order.date,
order.brokerOrderId,
order.instr.id, order.quantity,
order.get_avg_price(),
order.commission, order.type,
order.action, order.tradeId)
order.id = tmdb.db_modify(self.dbconn, sql)
LOGGER.info("Inserted %s to Orders", order)
def insert_obj(self, order):
sql = ("INSERT INTO Orders VALUES " '({0},"{1}",{2},{3},{4},{5},' "{6},{7},{8},{9})").format(
order.id,
order.date,
order.brokerOrderId,
order.instr.id,
order.quantity,
order.get_avg_price(),
order.commission,
order.type,
order.action,
order.tradeId,
)
order.id = tmdb.db_modify(self.dbconn, sql)
LOGGER.info("Inserted %s to Orders", order)
def close_trade(self, id_):
sql = ("UPDATE Trades set statusTypeId = {0} " "WHERE id = {1}").format(mappings.CLOSED_TRADE_ID, id_)
ins = tmdb.db_modify(self.dbconn, sql)
LOGGER.info("Closed tradeId=%s", id_)
return ins
def insert_obj(self, trade):
sql = ("INSERT INTO Trades VALUES " '({0},"{1}",{2},{3})').format(
trade.id, trade.name, trade.type, trade.status
)
trade.id = tmdb.db_modify(self.dbconn, sql)
LOGGER.info("Inserted %s to Trades", trade)
def insert_obj(self, instr):
sql = ("INSERT INTO Instruments VALUES " '({0},"{1}","{2}",{3})').format(
instr.id, instr.name, instr.sym, instr.type
)
instr.id = tmdb.db_modify(self.dbconn, sql)
LOGGER.info("Inserted %s to Instruments", instr)
def close_trade(self, id_):
sql = ('UPDATE Trades set statusTypeId = {0} '
'WHERE id = {1}').format(mappings.CLOSED_TRADE_ID, id_)
ins = tmdb.db_modify(self.dbconn, sql)
LOGGER.info("Closed tradeId=%s", id_)
return ins
def insert_obj(self, trade):
sql = ('INSERT INTO Trades VALUES '
'({0},"{1}",{2},{3})').format(trade.id, trade.name, trade.type,
trade.status)
trade.id = tmdb.db_modify(self.dbconn, sql)
LOGGER.info("Inserted %s to Trades", trade)
def insert_obj(self, instr):
sql = ('INSERT INTO Instruments VALUES '
'({0},"{1}","{2}",{3})').format(instr.id, instr.name, instr.sym,
instr.type)
instr.id = tmdb.db_modify(self.dbconn, sql)
LOGGER.info("Inserted %s to Instruments", instr)
