def cleanOlderData(): session.query(NseCashDaily).filter( NseCashDaily.trade_date < (todaysDate - timedelta(days=365))).delete() session.commit()
def cleanupOldFnOData(): session.query(NseStockOptionDaily).filter( NseStockOptionDaily.expiry_date < todaysDate).delete() session.commit()
high=stock_ohlc_data["High"][ind], low=stock_ohlc_data["Low"][ind], close=stock_ohlc_data["Close"][ind], volume=stock_ohlc_data["Volume"][ind].item(), vwap=stock_ohlc_data["VWAP"][ind], trades=stock_ohlc_data["Trades"][ind].item(), deliverable_volume=stock_ohlc_data[ "Deliverable Volume"][ind].item(), percentage_delivery=stock_ohlc_data["%Deliverble"] [ind]) # print(nseDaily) session.add(nseDaily) print("END: Inserted into DB......") except Exception as ex: print("ERROR: while Create NSEDAILY Object:") print(ex) try: session.commit() session.query(StockList).filter( StockList.stock_code == stock.stock_code).update( {StockList.cash_updated: todaysDate}, synchronize_session=False) session.commit() except Exception as ex: print("ERROR: while Commiting Last Session Data......") print(ex) #print("To download NSE all Stock Data from:" + str(fromDate) + " to :" + str(toDate)) #print("took %s seconds " % (time.time() - start_time))
def cleanupOldFnOData(): session.query(NseIndicesOptionDaily.expiry_date < trade_date).delete() session.commit()