org.mifos.dmt.excel.columnValidator.ColumnStructureTest.java Source code

Introduction

Here is the source code for org.mifos.dmt.excel.columnValidator.ColumnStructureTest.java

Source

/*
 * Copyright (c) 2011-2015 SunGard Global Services, Bangalore
 * All rights reserved.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or
 * implied. See the License for the specific language governing
 * permissions and limitations under the License.
 *
 * See also http://www.apache.org/licenses/LICENSE-2.0.html for an
 * explanation of the license and how it is applied.
 */

package org.mifos.dmt.excel.columnValidator;

import java.io.IOException;
import java.io.InputStream;

import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
import org.junit.Assert;
import org.mifos.dmt.configuration.DMTConfig;
import org.mifos.dmt.util.DMTException;
import org.testng.annotations.Test;

public class ColumnStructureTest {

    ColumnStructure columnStructure;
    String baseTemplate;
    Workbook workbook;
    Workbook baseworkbook;
    boolean sheetPass;

    @SuppressWarnings("static-access")
    @Test
    public void processSheetStructureTrue() throws InvalidFormatException, IOException, DMTException {
        sheetPass = false;
        baseTemplate = DMTConfig.DMT_CONFIG_DIR + "\\DMTMigrationTemplateBase.xlsx";
        InputStream inp = this.getClass().getResourceAsStream("MigrationTemplatePassTest.xlsx");
        workbook = WorkbookFactory.create(inp);
        columnStructure = new ColumnStructure(workbook, baseTemplate);
        columnStructure.processSheetStructure();
        sheetPass = columnStructure.sheetPass;
        Assert.assertTrue(sheetPass);

    }

    @SuppressWarnings("static-access")
    @Test
    public void processSheetStructureFalse() throws InvalidFormatException, IOException {
        sheetPass = true;
        baseTemplate = DMTConfig.DMT_CONFIG_DIR + "\\DMTMigrationTemplateBase.xlsx";
        InputStream inp = this.getClass().getResourceAsStream("MigrationTemplateFailTest.xlsx");
        workbook = WorkbookFactory.create(inp);
        columnStructure = new ColumnStructure(workbook, baseTemplate);
        try {
            columnStructure.processSheetStructure();
        } catch (DMTException e) {
            sheetPass = columnStructure.sheetPass;
        } finally {
            Assert.assertFalse(sheetPass);

        }

    }
}