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
