org.ojbc.intermediaries.sn.dao.RapbackDAOImplTest.java Source code

Introduction

Here is the source code for org.ojbc.intermediaries.sn.dao.RapbackDAOImplTest.java

Source

/*
 * Unless explicitly acquired and licensed from Licensor under another license, the contents of
 * this file are subject to the Reciprocal Public License ("RPL") Version 1.5, or subsequent
 * versions as allowed by the RPL, and You may not copy or use this file in either source code
 * or executable form, except in compliance with the terms and conditions of the RPL
 *
 * All software distributed under the RPL is provided strictly on an "AS IS" basis, WITHOUT
 * WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, AND LICENSOR HEREBY DISCLAIMS ALL SUCH
 * WARRANTIES, INCLUDING WITHOUT LIMITATION, ANY WARRANTIES OF MERCHANTABILITY, FITNESS FOR A
 * PARTICULAR PURPOSE, QUIET ENJOYMENT, OR NON-INFRINGEMENT. See the RPL for specific language
 * governing rights and limitations under the RPL.
 *
 * http://opensource.org/licenses/RPL-1.5
 *
 * Copyright 2012-2015 Open Justice Broker Consortium
 */
package org.ojbc.intermediaries.sn.dao;

import static org.junit.Assert.assertEquals;
import static org.junit.Assert.assertNotNull;
import static org.junit.Assert.assertNull;
import static org.junit.Assert.assertTrue;

import java.sql.Connection;
import java.sql.ResultSet;
import java.util.List;

import javax.annotation.Resource;
import javax.sql.DataSource;

import junit.framework.Assert;

import org.apache.commons.lang.BooleanUtils;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.joda.time.DateTime;
import org.junit.Before;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.ojbc.intermediaries.sn.dao.rapback.FbiRapbackDao;
import org.ojbc.intermediaries.sn.dao.rapback.FbiRapbackSubscription;
import org.ojbc.intermediaries.sn.dao.rapback.ResultSender;
import org.ojbc.intermediaries.sn.dao.rapback.SubsequentResults;
import org.ojbc.util.helper.ZipUtils;
import org.springframework.test.annotation.DirtiesContext;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = { "classpath:META-INF/spring/test-application-context.xml",
        "classpath:META-INF/spring/h2-mock-database-application-context.xml",
        "classpath:META-INF/spring/h2-mock-database-context-rapback-datastore.xml", })
@DirtiesContext
public class RapbackDAOImplTest {
    private final Log log = LogFactory.getLog(this.getClass());

    @Resource
    private FbiRapbackDao rapbackDao;

    @Resource
    private DataSource dataSource;

    @Before
    public void setUp() throws Exception {
        assertNotNull(rapbackDao);
    }

    @Test
    @DirtiesContext
    public void testGetStateSubscriptions() {

        List<Subscription> stateSubList = rapbackDao.getStateSubscriptions("1234", "CI");

        Assert.assertNotNull(stateSubList);

        Assert.assertFalse(stateSubList.isEmpty());
    }

    @Test
    @DirtiesContext
    public void testGetFbiUcnIdFromSubIdAndReasonCode() {

        String personFbiUcnId = rapbackDao.getFbiUcnIdFromSubIdAndReasonCode("62727", "CI");

        Assert.assertEquals("1234", personFbiUcnId);
    }

    @Test
    @DirtiesContext
    public void testCountStateSubscriptions() {

        int stateSubCount = rapbackDao.countStateSubscriptions("1234", "CI");

        Assert.assertEquals(1, stateSubCount);
    }

    @Test
    @DirtiesContext
    public void testGetFbiSubscription() throws Exception {

        FbiRapbackSubscription fbiSubscription = rapbackDao.getFbiRapbackSubscription("CI", "123456789");

        String fbiSubId = fbiSubscription.getFbiSubscriptionId();
        Assert.assertEquals("fbiSubscriptionId", fbiSubId);

        String format = fbiSubscription.getRapbackActivityNotificationFormat();
        Assert.assertEquals("2", format);

        String category = fbiSubscription.getRapbackCategory();
        Assert.assertEquals("CI", category);

        boolean optOutInState = fbiSubscription.getRapbackOptOutInState();
        Assert.assertEquals(false, optOutInState);

        DateTime expDate = fbiSubscription.getRapbackExpirationDate();
        String sExpDate = expDate.toString("yyyy-MM-dd");
        Assert.assertEquals("2015-12-19", sExpDate);

        DateTime startDate = fbiSubscription.getRapbackStartDate();
        String sStartDate = startDate.toString("yyyy-MM-dd");
        Assert.assertEquals("2014-10-19", sStartDate);

        String term = fbiSubscription.getSubscriptionTerm();
        Assert.assertEquals("5", term);

        String ucn = fbiSubscription.getUcn();
        Assert.assertEquals("123456789", ucn);
    }

    @Test
    @DirtiesContext
    public void testSaveSubsequentResults() throws Exception {

        SubsequentResults subsequentResults = new SubsequentResults();
        subsequentResults.setUcn("9222201");
        subsequentResults.setRapSheet("rapsheet".getBytes());
        subsequentResults.setResultsSender(ResultSender.FBI);

        Integer pkId = rapbackDao.saveSubsequentResults(subsequentResults);
        assertNotNull(pkId);
        assertEquals(3, pkId.intValue());

        Connection conn = dataSource.getConnection();
        ResultSet rs = conn.createStatement()
                .executeQuery("select * from SUBSEQUENT_RESULTS where SUBSEQUENT_RESULT_ID = 3");
        assertTrue(rs.next());
        assertEquals("9222201", rs.getString("ucn"));

        String rapsheetContent = new String(ZipUtils.unzip(rs.getBytes("RAP_SHEET")));
        log.info("Rap sheet content: " + rapsheetContent);
        assertEquals("rapsheet", rapsheetContent);
    }

    @Test
    @DirtiesContext
    public void testGetFbiIds() throws Exception {
        List<String> fbiIds = rapbackDao.getFbiIds("A123459");
        assertEquals(1, fbiIds.size());
        assertEquals("9222201", fbiIds.get(0));

        List<String> fbiSubscriptionIdsEmpty = rapbackDao.getFbiIds("9222202");
        assertTrue(fbiSubscriptionIdsEmpty.isEmpty());
    }

    @Test
    @DirtiesContext
    public void testGetFbiSubscriptionQualification() throws Exception {
        Boolean fbiSubscriptionQualificationByTransactionNumber = rapbackDao
                .getfbiSubscriptionQualification("000001820140729014008339993");
        assertEquals(Boolean.TRUE, fbiSubscriptionQualificationByTransactionNumber);

        Boolean fbiSubscriptionQualificationBySubscriptionId = rapbackDao.getfbiSubscriptionQualification(62723);
        assertEquals(Boolean.TRUE, fbiSubscriptionQualificationBySubscriptionId);

        Boolean fbiSubscriptionQualification = rapbackDao.getfbiSubscriptionQualification(99999);
        log.info("fbiSubscriptionQualification:" + BooleanUtils.isTrue(fbiSubscriptionQualification));
        assertNull(fbiSubscriptionQualification);
    }
}