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