com.github.jferard.pgloaderutils.sniffer.csd.CSDSchemaValidatorTest.java Source code

Introduction

Here is the source code for com.github.jferard.pgloaderutils.sniffer.csd.CSDSchemaValidatorTest.java

Source

/*
 * Some utilities for loading csv data into a PosgtreSQL database:
 * detect file encoding, CSV format and populate database
 *
 *     Copyright (C) 2016, 2018 J. Frard <https://github.com/jferard>
 *
 * This file is part of pgLoader Utils.
 *
 * pgLoader Utils is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * pgLoader Utils is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */

package com.github.jferard.pgloaderutils.sniffer.csd;

import org.apache.commons.csv.CSVFormat;
import org.apache.commons.csv.CSVParser;
import org.apache.commons.csv.CSVRecord;
import org.easymock.EasyMock;
import org.junit.Assert;
import org.junit.Before;
import org.junit.Test;
import org.powermock.api.easymock.PowerMock;

import java.io.StringReader;
import java.util.logging.Logger;

/**
 * Created by jferard on 07/04/17.
 */
public class CSDSchemaValidatorTest {
    private CSDSchemaValidator<CSDFieldPattern> validator;
    private Logger logger;
    private CSDValidatorHelper<CSDFieldPattern> vh;
    private CSDSchema<CSDFieldPattern> s;

    @Before
    public void setUp() {
        this.logger = PowerMock.createNiceMock(Logger.class);
        this.vh = PowerMock.createMock(CSDValidatorHelper.class);
        this.s = PowerMock.createMock(CSDSchema.class);

        this.validator = new CSDSchemaValidator<CSDFieldPattern>(this.logger, this.vh);
    }

    @Test
    public void sniffNoLine() throws Exception {
        CSVParser p = CSVFormat.RFC4180.parse(new StringReader(""));

        PowerMock.replayAll();
        CSDValidationResult<CSDFieldPattern> r = this.validator.validate(this.s, p);
        Assert.assertEquals(1, r.errorCount());
        Assert.assertEquals("CSDValidationError of type NO_AVAILABLE_LINE: No available line. (line 0)",
                r.iterator().next().toString());
        PowerMock.verifyAll();
    }

    @Test
    public void sniffBadHeader1() throws Exception {
        CSVParser p = CSVFormat.RFC4180.parse(new StringReader("a,b,c\n1,2,3\n4,5,6"));

        EasyMock.expect(this.vh.validateHeader(EasyMock.isA(CSDValidationResult.class), EasyMock.eq(this.s),
                EasyMock.isA(CSVRecord.class))).andReturn(10);
        EasyMock.expect(this.vh.validateRecord(EasyMock.isA(CSDValidationResult.class), EasyMock.eq(this.s),
                EasyMock.isA(CSVRecord.class), EasyMock.eq(1))).andReturn(100);
        EasyMock.expect(this.vh.validateRecord(EasyMock.isA(CSDValidationResult.class), EasyMock.eq(this.s),
                EasyMock.isA(CSVRecord.class), EasyMock.eq(2))).andReturn(1000);
        EasyMock.expect(this.s.hasOptionalHeader()).andReturn(false);

        PowerMock.replayAll();
        CSDValidationResult<CSDFieldPattern> r = this.validator.validate(this.s, p);
        Assert.assertEquals(0, r.errorCount());
        PowerMock.verifyAll();
    }

    @Test
    public void sniffBadHeader2() throws Exception {
        CSVParser p = CSVFormat.RFC4180.parse(new StringReader("a,b,c\n1,2,3\n4,5,6"));

        EasyMock.expect(this.vh.validateHeader(EasyMock.isA(CSDValidationResult.class), EasyMock.eq(this.s),
                EasyMock.isA(CSVRecord.class))).andReturn(-1);
        EasyMock.expect(this.vh.validateRecord(EasyMock.isA(CSDValidationResult.class), EasyMock.eq(this.s),
                EasyMock.isA(CSVRecord.class), EasyMock.eq(1))).andReturn(0);
        EasyMock.expect(this.vh.validateRecord(EasyMock.isA(CSDValidationResult.class), EasyMock.eq(this.s),
                EasyMock.isA(CSVRecord.class), EasyMock.eq(2))).andReturn(0);

        PowerMock.replayAll();
        CSDValidationResult<CSDFieldPattern> r = this.validator.validate(this.s, p);
        Assert.assertEquals(0, r.errorCount());
        PowerMock.verifyAll();
    }

    @Test
    public void sniffGoodHeader() throws Exception {
        CSVParser p = CSVFormat.RFC4180.parse(new StringReader("a,b,c\n1,2,3\n4,5,6"));

        EasyMock.expect(this.vh.validateHeader(EasyMock.isA(CSDValidationResult.class), EasyMock.eq(this.s),
                EasyMock.isA(CSVRecord.class))).andReturn(0);
        EasyMock.expect(this.vh.validateRecord(EasyMock.isA(CSDValidationResult.class), EasyMock.eq(this.s),
                EasyMock.isA(CSVRecord.class), EasyMock.eq(1))).andReturn(0);
        EasyMock.expect(this.vh.validateRecord(EasyMock.isA(CSDValidationResult.class), EasyMock.eq(this.s),
                EasyMock.isA(CSVRecord.class), EasyMock.eq(2))).andReturn(0);

        PowerMock.replayAll();
        CSDValidationResult<CSDFieldPattern> r = this.validator.validate(this.s, p);
        Assert.assertEquals(0, r.errorCount());
        Assert.assertTrue(r.isOk());
        PowerMock.verifyAll();
    }
}