def QA_SU_save_deal(dealist, client=DATABASE): """存储order_handler的deal_status Arguments: dealist {[dataframe]} -- [description] Keyword Arguments: client {[type]} -- [description] (default: {DATABASE}) """ if isinstance(dealist, pd.DataFrame): collection = client.deal collection.create_index( [('account_cookie', ASCENDING), ('trade_id', ASCENDING)], unique=True ) try: dealist = QA_util_to_json_from_pandas(dealist.reset_index()) collection.insert_many(dealist, ordered=False) except Exception as e: pass
def QA_SU_save_order(orderlist, client=DATABASE): """存储order_handler的order_status Arguments: orderlist {[dataframe]} -- [description] Keyword Arguments: client {[type]} -- [description] (default: {DATABASE}) """ orderlist = QA_util_to_json_from_pandas(orderlist.reset_index()) collection = client.order collection.create_index([('account_cookie', ASCENDING), ('realorder_id', ASCENDING)], unique=True) try: for item in orderlist: #item['date']= QA_util_get_order_day() collection.update_one( { 'account_cookie': item.get('account_cookie'), 'realorder_id': item.get('realorder_id') }, {'$set': item}, upsert=True) except Exception as e: print(e) pass
def QA_SU_save_deal(dealist, client=DATABASE): """存储order_handler的deal_status Arguments: dealist {[dataframe]} -- [description] Keyword Arguments: client {[type]} -- [description] (default: {DATABASE}) """ if isinstance(dealist,pd.DataFrame): dealist = QA_util_to_json_from_pandas(dealist.reset_index()) collection = client.deal collection.create_index( [('account_cookie', ASCENDING), ('trade_id', ASCENDING)], unique=True) try: collection.insert_many(dealist,ordered=False) except Exception as e: pass
def QA_SU_save_order(orderlist, client=DATABASE): """存储order_handler的order_status Arguments: orderlist {[dataframe]} -- [description] Keyword Arguments: client {[type]} -- [description] (default: {DATABASE}) """ if isinstance(orderlist, pd.DataFrame): collection = client.order collection.create_index( [('account_cookie', ASCENDING), ('realorder_id', ASCENDING)], unique=True ) try: orderlist = QA_util_to_json_from_pandas(orderlist.reset_index()) for item in orderlist: if item: #item['date']= QA_util_get_order_day() collection.update_one( { 'account_cookie': item.get('account_cookie'), 'realorder_id': item.get('realorder_id') }, {'$set': item}, upsert=True ) except Exception as e: print(e) pass