def convertDataHistoryToJSON(ticker, dataSeriesID=None): global file_format if dataSeriesID is None: dataSeriesID = EM_DBHelp.retrieve_DataSeriesID( db_conn, db_curs, dataTicker=ticker, insertIfNot=False) dataSeries = EM_DBHelp.getCompleteDataHistory_DataHistoryTable( db_conn, db_curs, dataSeriesID) if file_format[0] == 'rs': convertValue = lambda (dt, vl): {'x': dt, 'y': float(vl)} elif file_format[0] == 'd3': convertValue = lambda (dt, vl): {'date': dtConvert_EpochtoY_M_D(dt), 'value': float(vl)} else: raise Exception('File Format Type not recognized for date/value JSON') return map(convertValue, dataSeries)
def getDataHistory(self, dataType='float'): dataSeries = EM_DBHelp.getCompleteDataHistory_DataHistoryTable(self.db_conn, self.db_curs, self.dataSeriesID) dt = np.dtype('int,'+dataType) # Format is, e.g. 'int,int' or 'int,float' dataSeries = np.array(dataSeries, dtype=dt) dataSeries.dtype.names = ['dates','values'] return dataSeries