/*
 * Copyright (c) 2014, Oracle and/or its affiliates. All rights reserved.
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
 *
 * This code is free software; you can redistribute it and/or modify it
 * under the terms of the GNU General Public License version 2 only, as
 * published by the Free Software Foundation.
 *
 * This code 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
 * version 2 for more details (a copy is included in the LICENSE file that
 * accompanied this code).
 *
 * You should have received a copy of the GNU General Public License version
 * 2 along with this work; if not, write to the Free Software Foundation,
 * Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA.
 *
 * Please contact Oracle, 500 Oracle Parkway, Redwood Shores, CA 94065 USA
 * or visit www.oracle.com if you need additional information or have any
 * questions.
 */
package test.rowset.serial;

import java.net.URL;
import java.sql.Array;
import java.sql.Blob;
import java.sql.Clob;
import java.sql.Ref;
import java.sql.SQLException;
import java.sql.Struct;
import java.util.Arrays;
import java.util.HashMap;
import java.util.Map;
import java.util.Vector;
import javax.sql.rowset.serial.SQLInputImpl;
import javax.sql.rowset.serial.SQLOutputImpl;
import javax.sql.rowset.serial.SerialArray;
import javax.sql.rowset.serial.SerialBlob;
import javax.sql.rowset.serial.SerialClob;
import javax.sql.rowset.serial.SerialDatalink;
import javax.sql.rowset.serial.SerialRef;
import javax.sql.rowset.serial.SerialStruct;
import static org.testng.Assert.*;
import org.testng.annotations.BeforeMethod;
import org.testng.annotations.Test;
import util.BaseTest;
import util.StubArray;
import util.StubBlob;
import util.StubClob;
import util.StubRef;
import util.StubStruct;
import util.SuperHero;
import util.TestSQLDataImpl;

public class SQLOutputImplTests extends BaseTest {

    // Copy of the array of data type values
    private Object[] typeValues;
    private TestSQLDataImpl impl;
    private Map<String, Class<?>> map = new HashMap<>();
    private Vector results;
    private final String sqlType = "SUPERHERO";
    private SuperHero hero;
    private SQLOutputImpl outImpl;

    @BeforeMethod
    @Override
    public void setUpMethod() throws Exception {
        results = new Vector();
        impl = new TestSQLDataImpl("TestSQLData");
        typeValues = Arrays.copyOf(TestSQLDataImpl.attributes,
                TestSQLDataImpl.attributes.length);
        hero = new SuperHero(sqlType, "Bruce", "Wayne", 1939, "Batman");
        outImpl = new SQLOutputImpl(results, map);
    }

    /*
     * Validate that a SQLException is thrown if the attribute value is
     * null
     */
    @Test(expectedExceptions = SQLException.class)
    public void test() throws Exception {
        SQLOutputImpl x = new SQLOutputImpl(null, map);
    }

    /*
     * Validate that a SQLException is thrown if the map value is
     * null
     */
    @Test(expectedExceptions = SQLException.class)
    public void test02() throws Exception {
        SQLOutputImpl x = new SQLOutputImpl(results, null);
    }

    /*
     * Read in the various datatypes via readSQL (which will exercise the
     * various readXXX methods and validate that results are as expected
     */
    @Test()
    public void test03() throws Exception {
        impl.readSQL(new SQLInputImpl(typeValues, map), "misc");
        impl.writeSQL(outImpl);
        assertTrue(Arrays.equals(results.toArray(), typeValues));
        // Null out a field and make sure the arrays do not match
        typeValues[2] = null;
        assertFalse(Arrays.equals(results.toArray(), typeValues));
    }

    /*
     * Validate a Array can be written and returned
     */
    @Test(enabled = true)
    public void test04() throws Exception {
        Object[] coffees = new Object[]{"Espresso", "Colombian", "French Roast",
            "Cappuccino"};
        Array a = new StubArray("VARCHAR", coffees);
        outImpl.writeArray(a);
        SerialArray sa = (SerialArray) results.get(0);
        assertTrue(Arrays.equals(coffees, (Object[]) sa.getArray()));
        assertTrue(a.getBaseTypeName().equals(sa.getBaseTypeName()));
    }

    /*
     * Validate a Blob can be written and returned
     */
    @Test(enabled = true)
    public void test05() throws Exception {
        Blob b = new StubBlob();
        outImpl.writeBlob(b);
        SerialBlob sb = (SerialBlob) results.get(0);
        assertTrue(Arrays.equals(
                b.getBytes(1, (int) b.length()),
                sb.getBytes(1, (int) sb.length())));
    }

    /*
     * Validate a Clob can be written and returned
     */
    @Test(enabled = true)
    public void test06() throws Exception {
        Clob c = new StubClob();
        outImpl.writeClob(c);
        SerialClob sc = (SerialClob) results.get(0);
        assertTrue(c.getSubString(1,
                (int) c.length()).equals(sc.getSubString(1, (int) sc.length())));
    }

    /*
     * Validate a Ref can be written and returned
     */
    @Test(enabled = true)
    public void test07() throws Exception {
        Ref ref = new StubRef(sqlType, hero);
        outImpl.writeRef(ref);
        SerialRef sr = (SerialRef) results.get(0);
        assertTrue(hero.equals(sr.getObject()));
    }

    /*
     * Validate a Struct can be written and returned
     */
    @Test(enabled = true)
    public void test08() throws Exception {
        Object[] attributes = new Object[]{"Bruce", "Wayne", 1939,
            "Batman"};
        Struct s = new StubStruct(sqlType, attributes);
        outImpl.writeStruct(s);
        SerialStruct ss = (SerialStruct) results.get(0);
        assertTrue(Arrays.equals(attributes, (Object[]) ss.getAttributes()));
        assertTrue(sqlType.equals(ss.getSQLTypeName()));
    }

    /*
     * Validate a DataLink can be written and returned
     */
    @Test(enabled = true)
    public void test09() throws Exception {
        URL u = new URL("http://www.oracle.com/");
        outImpl.writeURL(u);
        SerialDatalink sdl = (SerialDatalink) results.get(0);
        URL u2 = sdl.getDatalink();
        assertTrue(u2.equals(u));
        assertTrue(u2.sameFile(u));
    }

    /*
     * Validate an Object implementing SQLData can be written and returned
     */
    @Test(enabled = true)
    public void test10() throws Exception {
        Object[] attributes = new Object[]{"Bruce", "Wayne", 1939,
            "Batman"};
        outImpl.writeObject(hero);
        SerialStruct ss = (SerialStruct) results.get(0);
        assertTrue(Arrays.equals(attributes, (Object[]) ss.getAttributes()));
        assertTrue(sqlType.equals(ss.getSQLTypeName()));
    }
}