package gov.bsp.lcmis.internal.test;

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

import java.io.IOException;
import java.math.BigDecimal;
import java.sql.Connection;
import java.sql.SQLException;

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 com.fasterxml.jackson.core.JsonParseException;
import com.fasterxml.jackson.databind.JsonMappingException;
import com.fasterxml.jackson.databind.ObjectMapper;

import gov.bsp.lcmis.internal.lmm.domain.BidMemoComponentPmcImpl;
import gov.bsp.lcmis.internal.lmm.domain.Dacion;
import gov.bsp.lcmis.internal.lmm.service.SaveUnencumberedMortgageCreditService;

/**
 * This class tests if the context that is setup by dispatcher-servlet.xml is complete and will run.
 * Completeness includes :
 * 	(1) that all bean definitions have corresponding classes in the classpath.
 *
 * Note that the datasource set up here cannot be used to query the database in other junit tests.
 * A little tweaking is needed.
 *
 * @author enrique.feleo
 *
 */
@RunWith(SpringJUnit4ClassRunner.class)
@WebAppConfiguration
@ContextConfiguration(value="file:src/main/webapp/WEB-INF/dispatcher-servlet.xml")
@ActiveProfiles("test")
public class ApplicationContextsTest{



	@Autowired
	private SaveUnencumberedMortgageCreditService saveUnencumberedMortgageCreditService;

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

	    private static String url = "jdbc:db2://localhost:50000/bspdb2";

	    private static String username = "db2admin";

	    private static String password = "password123";


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


	@Test
	public void test() {
//	    BidMemoComponentPmcImpl bidMemoComponent= (BidMemoComponentPmcImpl) context.getBean("bidMemoComponent");
//	    bidMemoComponent.setBidPrice(new BigDecimal("3999"));
//	    BigDecimal courtsCommission = bidMemoComponent.getCourtsCommisssion();
//		assertThat(courtsCommission, notNullValue());
	    String json = "{\"dacionId\":0,\"transactionNumber\":\"2017000004\",\"dacionType\":\"UNENMC\",\"dacionValue\":123,\"transactionDate\":null,\"osloanValue\":0,\"pnOsBalance\":0,\"totalRemAmount\":0,\"bankName\":null,\"eubName\":null,\"udoaNumber\":\"123\",\"pnNumber\":null,\"collaterals\":null,\"rems\":[{\"remName\":null,\"amount\":\"123\",\"titles\":[{\"collateralId\":0,\"collateralNumber\":null,\"registeredOwner\":\"123\",\"borrowerName\":null,\"fairMarketValue\":null,\"percentageWeightDistribution\":null,\"bestUseOftheProperty\":null,\"location\":\"123\",\"area\":123,\"unitMeasurement\":\"sqm\",\"collateralValue\":0,\"remAmount\":0,\"collateralType\":\"TCT\",\"registryOfDeed\":null,\"registryOfDeedId\":0,\"registryOfDeeds\":null,\"appraisalDate\":null,\"taxDeclaration\":[{\"taxDeclarationId\":0,\"taxDeclarationNumber\":\"123\",\"taxDeclarationType\":\"LAND\",\"propertyClassification\":\"123\",\"amount\":123,\"appraisalDate\":1505145600000,\"refCollateralId\":0,\"refAppraiserId\":0,\"appraiserName\":\"123\",\"appraisalReportType\":null},{\"taxDeclarationId\":0,\"taxDeclarationNumber\":\"123\",\"taxDeclarationType\":\"IMPROVEMENT\",\"propertyClassification\":\"123\",\"amount\":123,\"appraisalDate\":1504627200000,\"refCollateralId\":0,\"refAppraiserId\":0,\"appraiserName\":\"123\",\"appraisalReportType\":null}],\"insurance\":{\"insuranceId\":0,\"policyNumber\":\"123\",\"insuranceCompanyName\":\"123\",\"orNumber\":\"123\",\"expiryDate\":1504540800000,\"insuredAmount\":123,\"refCollateralId\":0}}]}],\"promissoryNote\":{\"promissoryNoteId\":0,\"promissoryNoteNumber\":\"123\",\"balance\":{\"balanceId\":0,\"refId\":0,\"totalOutstandingBalance\":123,\"balanceType\":null,\"others\":0,\"accrued_interest_receivable\":0,\"liquidated_damages\":0,\"interest_income\":0,\"outstanding_principal\":0,\"cwt\":0,\"miscellaneous_income_others\":0,\"miscellaneous_income_liquidating_dividends\":0},\"dateGranted\":null,\"maturityDate\":null,\"interestRate\":123,\"amountGranted\":123,\"penaltyRate\":123,\"borrowerId\":0,\"bankId\":1,\"balanceId\":0},\"loan\":null,\"tin\":\"123\",\"address\":null,\"remarks\":{\"remarksId\":0,\"remarksGroup\":null,\"remarksGroupRefId\":0,\"remarksContent\":\"123\",\"createdBy\":\"lmm.maker\",\"createdDate\":0},\"registryOfDeed\":null,\"collateralId\":0,\"pnId\":0,\"dacionTransactionId\":0}";
	    ObjectMapper mapper = new ObjectMapper();

	    try {
            Dacion dacion = mapper.readValue(json, Dacion.class);
            saveUnencumberedMortgageCreditService.saveUnencumberedMortgageCreditService(dacion);
        } catch (JsonParseException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (JsonMappingException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
	}


}