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