package gov.bsp.lcmis.internal.domain;

import static org.hamcrest.CoreMatchers.notNullValue;
import static org.junit.Assert.*;

import java.math.BigDecimal;
import java.sql.Connection;
import java.sql.SQLException;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.List;
import java.util.Locale;

import javax.naming.NamingException;
import javax.sql.DataSource;

import org.junit.BeforeClass;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.BeansException;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.ApplicationContext;
import org.springframework.context.ApplicationContextAware;
import org.springframework.jdbc.datasource.AbstractDataSource;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
import org.springframework.mock.jndi.SimpleNamingContextBuilder;
import org.springframework.test.context.ActiveProfiles;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import org.springframework.test.context.web.WebAppConfiguration;

import gov.bsp.lcmis.internal.fsm.exception.FSMBusinessException;
import gov.bsp.lcmis.internal.fsm.manager.ApprovedPostedTransactionsManager;
import gov.bsp.lcmis.internal.fsm.service.RetrieveApprovedPostedTransactionsService;
import gov.bsp.lcmis.internal.lmm.domain.BidMemoComponentPmcImpl;
import gov.bsp.lcmis.internal.report.domain.RvcReport;
import gov.bsp.lcmis.internal.report.manager.RvcManagerTest;
import gov.bsp.lcmis.internal.report.service.GenerateRvcReportService;

@RunWith(SpringJUnit4ClassRunner.class)
@WebAppConfiguration
@ContextConfiguration(value="file:src/main/webapp/WEB-INF/dispatcher-servlet.xml")
public class MTestClass  {

	private static Logger log = LoggerFactory.getLogger(MTestClass.class);

	@Autowired
	private RetrieveApprovedPostedTransactionsService manager;

	/**
	 * SET THE DATABASE CREDS and URL
	 */
	private static String url = "jdbc:db2://localhost:50000/bspdb2";

	private static String username = "db2admin";

	private static String password = "password123";

	/**
	 * Note to Architect : please setup an environment dependent datasource
	 * to remove the need for commenting and uncommenting the @Test method.
	 */
	@BeforeClass
	public static void setupClass() {
		//create the datasource
		DriverManagerDataSource datasource = new DriverManagerDataSource(url, username, password);
		datasource.setDriverClassName("com.ibm.db2.jcc.DB2Driver");

		//bind to a jndi string
		SimpleNamingContextBuilder builder = new SimpleNamingContextBuilder();
		builder.bind("lcmisbsp", datasource);
		try {
			builder.activate();
		} catch (IllegalStateException | NamingException e) {
			log.error("Error setting up test class, ", e);
		}
	}

	/**
	 * The @Test annotation
	 * Uncomment when running, comment when Committing.
	 *
	 * @throws FSMBusinessException
	 * @throws ParseException
	 */
	@Test
	public void test() throws FSMBusinessException, ParseException {
		assertThat(manager, notNullValue());

		List<TransactionPageObject> test = manager.retrieveApprovedPostedTransactions("fsm.maker");
		System.out.println(test.size());

		for (TransactionPageObject t : test) {
			System.out.println(t.getMaker());
			System.out.println(t.getBankName());
		}
		assertNotNull(test);


	}



}