def amend_trade_with_trade(self, id_, trade):
if check_trade(trade, self.trade_class):
if self.select_trade_from_id(id_) is None:
raise ValueError("Cannot amend trade %d because it doesn't exist" % id_)
columns_sql_with_trade_values = {column: getattr(trade, str(column))
for column in self.__get_columns_sql()
if str(column) != "id_"}
update_req = self.__table.update().where(self.__table.c.id_ == id_)
update_req.values(columns_sql_with_trade_values).execute()
def amend_trade_with_trade(self, id_, trade):
if check_trade(trade, self.trade_class):
if self.select_trade_from_id(id_) is None:
raise ValueError(
"Cannot amend trade %d because it doesn't exist" % id_)
columns_sql_with_trade_values = {
column: getattr(trade, str(column))
for column in self.__get_columns_sql() if str(column) != "id_"
}
update_req = self.__table.update().where(self.__table.c.id_ == id_)
update_req.values(columns_sql_with_trade_values).execute()
def add_trade(self, trade):
if check_trade(trade, self.trade_class):
self.__table.insert().execute(**trade.get_variables_dict_no_id())
def add_trade(self, trade):
if check_trade(trade, self.trade_class):
self.__table.insert().execute(**trade.get_variables_dict_no_id())
