package com.activequant.utils;

import java.io.FileInputStream;
import java.util.Map;

import org.apache.log4j.Logger;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.activequant.domainmodel.Instrument;
import com.activequant.domainmodel.exceptions.DaoException;
import com.activequant.interfaces.dao.IDaoFactory;
import com.activequant.interfaces.dao.IInstrumentDao;
import com.activequant.interfaces.utils.IEventListener;

/**
 * Imports one CSV file that contains instrument reference data, one instrument per row,
 * with multiple columns.
 * 
 * The file must have a header and must be comma separated.
 * 
 * Each instrument must have at least: 
 * - CLASSNAME (this corresponds to the type)
 * - SHORTNAME
 * - NAME
 * - DESCRIPTION
 * - plus some class specific parameters, such as tick value, tick size. 
 * 
 * @author ustaudinger
 * 
 */
public class ImportInstrumentsCSV {

	private final ApplicationContext appContext;
	private final IDaoFactory idf;
	private final IInstrumentDao idao;
	private Logger log = Logger.getLogger(this.getClass());

	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));

	}

	/**
	 * @param args
	 */
	public static void main(String[] args) throws Exception {
		String fileName = args[0];
		String springFile = args[1];
		System.out.println("Importing from " + fileName
				+ ". Using spring configuration " + springFile);
		new ImportInstrumentsCSV(fileName, springFile);

	}

}