FieldSetSqlParameterSourceProviderTest.java

package fr.acxio.tools.agia.item.database;

/*
 * Copyright 2014 Acxio
 * 
 * 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.
 */

import static org.junit.Assert.*;

import org.junit.Test;
import org.springframework.batch.item.file.transform.DefaultFieldSet;
import org.springframework.batch.item.file.transform.FieldSet;
import org.springframework.jdbc.core.SqlParameterValue;
import org.springframework.jdbc.core.namedparam.SqlParameterSource;

public class FieldSetSqlParameterSourceProviderTest {

    @Test
    public void test() {
        FieldSetSqlParameterSourceProvider aProvider = new FieldSetSqlParameterSourceProvider();
        FieldSet aFieldSet = new DefaultFieldSet(new String[]{"Facture", "2222.22", "2014-08-01T12:00:00.000"}, new String[]{"TypeDoc", "Montant", "Date"});
        SqlParameterSource aResult = aProvider.createSqlParameterSource(aFieldSet);
        assertNotNull(aResult);
        assertEquals("Facture", aResult.getValue("rec0_TypeDoc"));
        assertEquals("2222.22", aResult.getValue("rec0_Montant"));
        assertEquals("2014-08-01T12:00:00.000", aResult.getValue("rec0_Date"));
        assertFalse(aResult.hasValue("rec1_TypeDoc"));
    }
    
    @Test
    public void testEmpty() {
        FieldSetSqlParameterSourceProvider aProvider = new FieldSetSqlParameterSourceProvider();
        FieldSet aFieldSet = new DefaultFieldSet(new String[]{}, new String[]{});
        SqlParameterSource aResult = aProvider.createSqlParameterSource(aFieldSet);
        assertNotNull(aResult);
        assertFalse(aResult.hasValue("rec0_TypeDoc"));
    }

    @Test
    public void testNull() {
        FieldSetSqlParameterSourceProvider aProvider = new FieldSetSqlParameterSourceProvider();
        SqlParameterSource aResult = aProvider.createSqlParameterSource(null);
        assertNotNull(aResult);
        assertFalse(aResult.hasValue("rec0_TypeDoc"));
    }
    
    @Test
    public void testNoName() {
        FieldSetSqlParameterSourceProvider aProvider = new FieldSetSqlParameterSourceProvider();
        FieldSet aFieldSet = new DefaultFieldSet(new String[]{"Facture", "2222.22", "2014-08-01T12:00:00.000"});
        SqlParameterSource aResult = aProvider.createSqlParameterSource(aFieldSet);
        assertNotNull(aResult);
        assertEquals("Facture", aResult.getValue("rec0_ucol0"));
        assertEquals("2222.22", aResult.getValue("rec0_ucol1"));
        assertEquals("2014-08-01T12:00:00.000", aResult.getValue("rec0_ucol2"));
        assertFalse(aResult.hasValue("rec1_ucol0"));
    }
    
    @Test
    public void testNoNameNewPrefix() {
        FieldSetSqlParameterSourceProvider aProvider = new FieldSetSqlParameterSourceProvider();
        aProvider.setFieldsetNamePrefix("field");
        aProvider.setUnnamedColumnPrefix("column");
        FieldSet aFieldSet = new DefaultFieldSet(new String[]{"Facture", "2222.22", "2014-08-01T12:00:00.000"});
        SqlParameterSource aResult = aProvider.createSqlParameterSource(aFieldSet);
        assertNotNull(aResult);
        assertEquals("Facture", aResult.getValue("field0_column0"));
        assertEquals("2222.22", aResult.getValue("field0_column1"));
        assertEquals("2014-08-01T12:00:00.000", aResult.getValue("field0_column2"));
        assertFalse(aResult.hasValue("field1_column0"));
    }

    @Test
    public void testEmptyNames() {
        FieldSetSqlParameterSourceProvider aProvider = new FieldSetSqlParameterSourceProvider();
        FieldSet aFieldSet = new DefaultFieldSet(new String[]{"Facture", "2222.22", "2014-08-01T12:00:00.000"}, new String[]{"", "", ""});
        SqlParameterSource aResult = aProvider.createSqlParameterSource(aFieldSet);
        assertNotNull(aResult);
        assertEquals("Facture", aResult.getValue("rec0_ucol0"));
        assertEquals("2222.22", aResult.getValue("rec0_ucol1"));
        assertEquals("2014-08-01T12:00:00.000", aResult.getValue("rec0_ucol2"));
        assertFalse(aResult.hasValue("rec1_ucol0"));
    }

    @Test
    public void testNullNames() {
        FieldSetSqlParameterSourceProvider aProvider = new FieldSetSqlParameterSourceProvider();
        FieldSet aFieldSet = new DefaultFieldSet(new String[]{"Facture", "2222.22", "2014-08-01T12:00:00.000"}, new String[]{null, null, null});
        SqlParameterSource aResult = aProvider.createSqlParameterSource(aFieldSet);
        assertNotNull(aResult);
        assertEquals("Facture", aResult.getValue("rec0_ucol0"));
        assertEquals("2222.22", aResult.getValue("rec0_ucol1"));
        assertEquals("2014-08-01T12:00:00.000", aResult.getValue("rec0_ucol2"));
        assertFalse(aResult.hasValue("rec1_ucol0"));
    }
}