/**
 * DataCleaner (community edition)
 * Copyright (C) 2014 Neopost - Customer Information Management
 *
 * This copyrighted material is made available to anyone wishing to use, modify,
 * copy, or redistribute it subject to the terms and conditions of the GNU
 * Lesser General Public License, as published by the Free Software Foundation.
 *
 * This program 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 Lesser General Public License
 * for more details.
 *
 * You should have received a copy of the GNU Lesser General Public License
 * along with this distribution; if not, write to:
 * Free Software Foundation, Inc.
 * 51 Franklin Street, Fifth Floor
 * Boston, MA  02110-1301  USA
 */
package org.datacleaner.metamodel.datahub.utils;

import static org.hamcrest.Matchers.containsInAnyOrder;
import static org.hamcrest.Matchers.is;
import static org.junit.Assert.assertThat;

import java.io.IOException;
import java.util.Arrays;
import java.util.Collections;
import java.util.List;

import org.junit.Test;

import com.fasterxml.jackson.core.JsonParseException;
import com.fasterxml.jackson.databind.JsonMappingException;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.fasterxml.jackson.databind.type.CollectionType;
import com.fasterxml.jackson.databind.type.TypeFactory;

public class JsonUpdateQueryBuilderTest {

    private static final String QUERY1 =
            "UPDATE tablename SET column1 = value1, column2 = value2 WHERE column3 = value3";
    private static final String QUERY2 = "INSERT INTO tablename VALUES (value1, value2, value3)";

    private static final ObjectMapper mapper = new ObjectMapper();

    @Test
    public void shouldConvertQueriesToJson() throws IOException {
        final List<String> queries = Arrays.asList(new String[] { QUERY1, QUERY2 });
        final String jsonString = JsonUpdateQueryBuilder.buildJsonArray(queries);
        final List<String> jsonArrayValues = jsonArrayToList(jsonString);
        assertThat(jsonArrayValues, containsInAnyOrder(QUERY1, QUERY2));
    }

    @Test
    public void shouldConvertEmptyList() throws IOException {
        final List<String> emptyList = Collections.emptyList();
        final String jsonString = JsonUpdateQueryBuilder.buildJsonArray(emptyList);
        final List<String> jsonArrayValues = jsonArrayToList(jsonString);
        assertThat(jsonArrayValues.isEmpty(), is(true));
    }

    @Test
    public void shouldHandleNullValue() {
        final String jsonString = JsonUpdateQueryBuilder.buildJsonArray(null);
        assertThat(jsonString, is("null"));
    }

    private List<String> jsonArrayToList(final String jsonString)
            throws IOException, JsonParseException, JsonMappingException {
        final CollectionType stringListCollectionType =
                TypeFactory.defaultInstance().constructCollectionType(List.class, String.class);
        return mapper.readValue(jsonString, stringListCollectionType);
    }

}