def insert_trade_history(session, request_nonce, amount, order_id):
session.add(
LiquidEmaTradeHistory(
order_request_nonce=request_nonce,
amount=amount,
status="request",
open_order_id=order_id,
created_at=datetime.now().strftime("%Y-%m-%d %H:%M:%S"),
updated_at=datetime.now().strftime("%Y-%m-%d %H:%M:%S")))
session.commit()
def signin(datas):
try:
session.query(Users).filter_by(user_name=datas['user_name']).one()
except:
session.add(
Users(user_name=datas['user_name'],
user_password=datas['user_password'],
created_at=datetime.datetime.now()))
session.commit()
return 1
return 0
if my_trade["info"]["order_id"] == trade_history.close_order_id:
close_time = my_trade["info"]["created_at"]
close_rate = my_trade["info"]["rate"]
close_price = my_trade["info"]["funds"]["jpy"]
# データ整形
sharping_open_time = open_time.split(".")[0].replace("T", " ")
sharping_close_time = close_time.split(".")[0].replace("T", " ")
profit = float(close_price) + float(open_price)
print(close_price)
print(open_price)
# update
trade_history.status = "agregated"
trade_history.open_time = datetime.strptime(sharping_open_time, "%Y-%m-%d %H:%M:%S")
trade_history.open_rate = open_rate
trade_history.close_time =datetime.strptime(sharping_close_time, "%Y-%m-%d %H:%M:%S")
trade_history.close_rate = close_rate
trade_history.profit = profit
trade_history.updated_at = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
session.commit()
# キャッチして例外をログに記録
except Exception as e:
logger.exception(e)
sys.exit(1)
logger.info("=== aggregate_batch finish ===")
def update_status(session, trade_history, position_status):
trade_history.status = position_status
trade_history.updated_at = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
session.commit()
def update_status_close(session, trade_history, order_id):
trade_history.status = "close"
trade_history.close_order_id = order_id
trade_history.updated_at = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
session.commit()
def update_status_open(session, trade_history, position_status, assumed_rate):
trade_history.status = position_status
trade_history.open_assumed_rate = assumed_rate
trade_history.updated_at = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
session.commit()
