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())