def getAllOpenTrades(self): conn = self.connection() cur = conn.cursor() cur.execute("SELECT * FROM trades where close_date is NULL") cur.close() conn.close() output = [] for r in cur: trade = BotTrade(self.parent, 0, 0 if r[3] is None else float(r[3]), 0 if r[1] is None else float(r[1]), 0, 0, float(r[6]), 0, 1) trade.externalId = r[0] output.append(trade) return output
import sys sys.path.append("Connections") sys.path.append("Models") from mysql_database import BotFunctions from bottrade import BotTrade from datetime import datetime import mysql_database hey = mysql_database.BotFunctions() trade = BotTrade(1, datetime.now(), 5, 645, 2, 0.1, 10, 20) trade.externalId = hey.createTrade(trade) trade.close(datetime.now(), 700, 'reason') hey.closeTrade(trade) print(hey.getTradeById(trade.externalId))