@Override public TSContainer getTimeSeries(final String streamId, final String key, final TimeStamp startTimeStamp) throws Exception { final List<TimeStamp> timeStamps = new ArrayList<TimeStamp>(); final List<Double> values = new ArrayList<Double>(); // import the soybeans example and treat it like a performance curve. new CsvMapReader().read(new IEventListener<Map<String, String>>() { @Override public void eventFired(Map<String, String> event) { try { String date = event.get("DATE"); String value = event.get(key); TimeStamp ts = new TimeStamp(sdf.parse(date)); if (ts.isAfter(startTimeStamp)) { timeStamps.add(ts); values.add(Double.parseDouble(value)); } } catch (ParseException e) { e.printStackTrace(); } } }, new FileInputStream(fileName)); return new TSContainer(timeStamps.toArray(new TimeStamp[] {}), values.toArray(new Double[] {})); }
final CsvMapReader cmr = new CsvMapReader(); cmr.setHeader(new String[] { "TIMESTAMP", "TYPE", "PRICE", "QUANTITY", "IND"}); cmr.read(new IEventListener<Map<String, String>>() {
@Override public TSContainer getTimeSeries(String streamId, final String key, final TimeStamp startTimeStamp, final TimeStamp stopTimeStamp) throws Exception { final List<TimeStamp> timeStamps = new ArrayList<TimeStamp>(); final List<Double> values = new ArrayList<Double>(); // import the soybeans example and treat it like a performance curve. new CsvMapReader().read(new IEventListener<Map<String, String>>() { @Override public void eventFired(Map<String, String> event) { try { String date = event.get("DATE"); String value = event.get(key); TimeStamp ts = new TimeStamp(sdf.parse(date)); if (ts.isAfter(startTimeStamp) && ts.isBefore(stopTimeStamp)) { timeStamps.add(ts); values.add(Double.parseDouble(value)); } } catch (ParseException e) { e.printStackTrace(); } } }, new FileInputStream(fileName)); return new TSContainer(timeStamps.toArray(new TimeStamp[] {}), values.toArray(new Double[] {})); }
public ImportTradeableInstrumentsCSV(String fileName, String springInitFile) throws Exception { appContext = new ClassPathXmlApplicationContext(springInitFile); idf = (IDaoFactory) appContext.getBean("ibatisDao"); tdiDao = idf.tradeableDao(); final InstanceFromMapInstantiator<TradeableInstrument> i = new InstanceFromMapInstantiator<TradeableInstrument>(); final CsvMapReader cmr = new CsvMapReader(); cmr.read(new IEventListener<Map<String, String>>() { @Override public void eventFired(Map<String, String> event) { TradeableInstrument instr = i.loadStringString(event); // try { tdiDao.update(instr); log.info("Updated or created instrument: " + instr.getId()); } catch (DaoException e) { System.err.println("Error while importing " + event); e.printStackTrace(); } } }, new FileInputStream(fileName)); }
public ImportMarketDataInstrumentsCSV(String fileName, String springInitFile) throws Exception { appContext = new ClassPathXmlApplicationContext(springInitFile); idf = (IDaoFactory) appContext.getBean("ibatisDao"); mdiDao = idf.mdiDao(); final InstanceFromMapInstantiator<MarketDataInstrument> i = new InstanceFromMapInstantiator<MarketDataInstrument>(); final CsvMapReader cmr = new CsvMapReader(); cmr.read(new IEventListener<Map<String, String>>() { @Override public void eventFired(Map<String, String> event) { MarketDataInstrument instr = i.loadStringString(event); // try { mdiDao.update(instr); log.info("Updated or created instrument: " + instr.getId()); } catch (DaoException e) { System.err.println("Error while importing " + event); e.printStackTrace(); } } }, new FileInputStream(fileName)); }
public ImportInstrumentsCSV(String fileName, String springInitFile) throws Exception { appContext = new ClassPathXmlApplicationContext(springInitFile); idf = (IDaoFactory) appContext.getBean("ibatisDao"); idao = idf.instrumentDao(); final InstanceFromMapInstantiator<Instrument> i = new InstanceFromMapInstantiator<Instrument>(); final CsvMapReader cmr = new CsvMapReader(); cmr.read(new IEventListener<Map<String, String>>() { @Override public void eventFired(Map<String, String> event) { Instrument instr = i.loadStringString(event); // try { idao.update(instr); log.info("Created or updated instrument" + instr.getId()); } catch (DaoException e) { log.warn("Error while importing " + event, e); e.printStackTrace(); } } }, new FileInputStream(fileName)); }
final CsvMapReader cmr = new CsvMapReader(); cmr.read(new IEventListener<Map<String, String>>() {
public void testReader() throws Exception{ rowCount = 0; String data = "A,B,C,D\n1,2,3,4\n2,3,4,5"; new CsvMapReader().read(new IEventListener<Map<String,String>>() { @Override public void eventFired(Map<String, String> event) { rowCount++; if(rowCount == 1){ assertEquals("1", event.get("A")); assertEquals("4", event.get("D")); } else if(rowCount == 2){ assertEquals("2", event.get("A")); assertEquals("5", event.get("D")); } } }, new ByteArrayInputStream(data.getBytes())); assertEquals(2, rowCount); }
public void testReader() throws Exception{ rowCount = 0; String data = "A,B,C,D\n1,2,3,4\n2,3,4,5"; new CsvMapReader().read(new IEventListener<Map<String,String>>() { @Override public void eventFired(Map<String, String> event) { rowCount++; if(rowCount == 1){ assertEquals("1", event.get("A")); assertEquals("4", event.get("D")); } else if(rowCount == 2){ assertEquals("2", event.get("A")); assertEquals("5", event.get("D")); } } }, new ByteArrayInputStream(data.getBytes())); assertEquals(2, rowCount); }
final CsvMapReader cmr = new CsvMapReader(); cmr.read(new IEventListener<Map<String, String>>() {
final CsvMapReader cmr = new CsvMapReader(); cmr.read(new IEventListener<Map<String, String>>() {
final CsvMapReader cmr = new CsvMapReader(); cmr.read(new IEventListener<Map<String, String>>() {
sdf.setTimeZone(TimeZone.getTimeZone("UTC")); final CsvMapReader cmr = new CsvMapReader(); cmr.read(el, new FileInputStream("./src/test/resources/sampledata/Q62_60_2000.csv"));