/*******************************************************************************

 * Copyright (c) 1998, 2008 Oracle. All rights reserved.

 * This program and the accompanying materials are made available under the 

 * terms of the Eclipse Public License v1.0 and Eclipse Distribution License v. 1.0 

 * which accompanies this distribution. 

 * The Eclipse Public License is available at http://www.eclipse.org/legal/epl-v10.html

 * and the Eclipse Distribution License is available at 

 * http://www.eclipse.org/org/documents/edl-v10.php.

 *

 * Contributors:

 *     Oracle - initial API and implementation from Oracle TopLink

 ******************************************************************************/  

package org.eclipse.persistence.testing.tests.jpa.structconverter;

import javax.persistence.EntityManager;

import junit.extensions.TestSetup;

import junit.framework.Test;

import junit.framework.TestSuite;

import oracle.spatial.geometry.JGeometry;

import org.eclipse.persistence.platform.database.converters.StructConverter;

import org.eclipse.persistence.testing.framework.junit.JUnitTestCase;

import org.eclipse.persistence.testing.models.jpa.structconverter.SimpleSpatial;

import org.eclipse.persistence.testing.models.jpa.structconverter.SimpleXMLSpatial;

import org.eclipse.persistence.testing.models.jpa.structconverter.JGeometryTableCreator;

import org.eclipse.persistence.testing.models.jpa.structconverter.DummyStructConverterType;

/**

 * TestSuite to ensure Annotation-based struct converters get properly added to the project

 * 

 * This test suite ensures the project is properly set-up and does a sanity test using one of the

 * converters.  Other tests are handled by the StructConverter tests suites in the TestBrowser.

 * @author tware

 *

 */

public class StructConverterServerTestSuite extends JUnitTestCase {

    public static final String STRUCT_CONVERTER_PU = "structConverter";

    public StructConverterServerTestSuite(){

    }

    public StructConverterServerTestSuite(String name){

        super(name);

    }

    public static Test suite() {

        TestSuite suite = new TestSuite();

        suite.setName("Struct Converter Test Suite");

        suite.addTest(new StructConverterServerTestSuite("testSetup"));

        suite.addTest(new StructConverterServerTestSuite("testPlatform"));

        suite.addTest(new StructConverterServerTestSuite("testSimpleSpatialWrite"));

        return suite;

    }

    public void testSetup() {

        clearCache();

        new JGeometryTableCreator().replaceTables(JUnitTestCase.getServerSession(STRUCT_CONVERTER_PU));

    }

    /**

     * Ensure the DatabasePlatform is setup with the proper StructConverters

     */

    public void testPlatform(){

            EntityManager em = createEntityManager(STRUCT_CONVERTER_PU);

            try{

                // trigger deploy

                em.find(SimpleSpatial.class, new Long(1));

            } catch (Exception e){};

            StructConverter converter = getServerSession(STRUCT_CONVERTER_PU).getPlatform().getTypeConverters().get(JGeometry.class);

            assertNotNull("Platform does not have correct JGeometryConverter.", converter);

            assertTrue("JGeometery struct converter is wrong type.", converter.getClass().getName().indexOf("JGeometryConverter") >= 0);

            converter = getServerSession(STRUCT_CONVERTER_PU).getPlatform().getTypeConverters().get(DummyStructConverterType.class);

            assertNotNull("Platform does not have correct DummyStructConverter.", converter);

            assertTrue("JGeometery struct converter is wrong type.", converter.getClass().getName().indexOf("DummyStructConverter") >= 0);

    }

    /**

     * Sanity test to ensure a read and a write with a Converter specified by 

     * annotations work properly

     */

    public void testSimpleSpatialWrite(){

            EntityManager em = createEntityManager(STRUCT_CONVERTER_PU);

            beginTransaction(em);

            SimpleSpatial simpleSpatial = new SimpleSpatial(1000, pointCluster1());

            em.persist(simpleSpatial);

            em.flush();

            em.clear();

            simpleSpatial = em.find(SimpleSpatial.class, new Long(1000));

            assertNotNull("JGeometry was not properly read in.", simpleSpatial.getJGeometry());

            rollbackTransaction(em);

    }

    /**

     * mdsys.sdo_geometry(5,

     *                   NULL, null,

     *                   mdsys.sdo_elem_info_array(1,1,3),

     *                   mdsys.sdo_ordinate_array(1.1, 1.1, 2.2, 2.2, 3.3, 4.4)));

     */

    public JGeometry pointCluster1() {

        Object[] points = 

            new Object[] { new double[] { 1.1, 1.1 }, new double[] { 2.2,                                                                      2.2 }, 

                           new double[] { 3.3, 4.4 } };

        return JGeometry.createMultiPoint(points, 2, 0);

    }

}

            <pathelement path="${oracle.extensions.depend.dir}/${oracle.spatial.lib}"/>

    <target name="server-test-struct-converter" if="is.oracle">

        <echo message="Creating MY_GEOMETRY datatype for spatial tests: ${db.url}..."/>

        <sql driver="${db.driver}"

            url="${db.url}"

            userid="${db.user}"

            password="${db.pwd}"

            onerror="continue"

            >

            <classpath>

                <pathelement location="${jdbc.driver.jar}"/>

            </classpath>

CREATE OR REPLACE TYPE MY_GEOMETRY AS OBJECT (id NUMBER, geom MDSYS.SDO_GEOMETRY);

        </sql>

        <antcall target="server-run-all" inheritRefs="true">

            <param name="PERSISTENCE_UNIT_NAME" value="structConverter"/>

            <param name="MODEL_DIR" value="org/eclipse/persistence/testing/models/jpa/structconverter"/>

            <param name="MODEL_NAME" value="eclipselink-structconverter-model"/>

            <param name="TEST_DIR" value="org/eclipse/persistence/testing/tests/jpa/structconverter"/>

            <param name="TEST_NAME" value="eclipselink-structconverter-model"/>

            <param name="EAR_NAME" value="eclipselink-structconverter-model"/>

            <param name="TEST_SUITE" value="org.eclipse.persistence.testing.tests.jpa.structconverter.StructConverterServerTestSuite"/>

            <param name="eclipselink.jpa.test.dir" value="./../../foundation/eclipselink.extension.oracle.test"/>

        </antcall>

    </target>

        <copy file="${oracle.extensions.depend.dir}/${oracle.spatial.lib}" todir="${weblogic.domain}/lib"/>