| /* |
| * Copyright (c) 1998, 2020 Oracle and/or its affiliates. All rights reserved. |
| * |
| * This program and the accompanying materials are made available under the |
| * terms of the Eclipse Public License v. 2.0 which is available at |
| * http://www.eclipse.org/legal/epl-2.0, |
| * or the Eclipse Distribution License v. 1.0 which is available at |
| * http://www.eclipse.org/org/documents/edl-v10.php. |
| * |
| * SPDX-License-Identifier: EPL-2.0 OR BSD-3-Clause |
| */ |
| |
| // Contributors: |
| // Oracle - initial API and implementation from Oracle TopLink |
| package org.eclipse.persistence.testing.tests.spatial.jgeometry.wrapped; |
| |
| import java.util.List; |
| |
| import org.eclipse.persistence.expressions.ExpressionBuilder; |
| import org.eclipse.persistence.queries.ReportQuery; |
| import org.eclipse.persistence.sessions.DatabaseSession; |
| import org.eclipse.persistence.sessions.UnitOfWork; |
| import org.eclipse.persistence.testing.models.spatial.jgeometry.wrapped.WrappedJGeometryTableCreator; |
| import org.eclipse.persistence.testing.models.spatial.jgeometry.wrapped.WrappedSpatial; |
| import org.eclipse.persistence.testing.tests.spatial.jgeometry.SampleGeometries; |
| import org.eclipse.persistence.testing.tests.spatial.jgeometry.SimpleSpatialTestCase; |
| import org.eclipse.persistence.tools.schemaframework.TableCreator; |
| |
| public class WrappedSpatialTestCase extends SimpleSpatialTestCase { |
| |
| public WrappedSpatialTestCase(String name){ |
| super(name); |
| } |
| |
| public static void repopulate(DatabaseSession session, boolean replaceTables) throws Exception { |
| if (replaceTables){ |
| replaceTables(session); |
| } |
| UnitOfWork uow = session.acquireUnitOfWork(); |
| |
| List existing = uow.readAllObjects(WrappedSpatial.class); |
| uow.deleteAllObjects(existing); |
| uow.commit(); |
| |
| session.getIdentityMapAccessor().initializeIdentityMaps(); |
| |
| SampleGeometries samples = new SampleGeometries(DEFAULT_SRID); |
| |
| uow = session.acquireUnitOfWork(); |
| uow.registerAllObjects(samples.wrappedPopulation()); |
| uow.commit(); |
| |
| assertEquals(samples.wrappedPopulation().size(), countWrappedSpatial(session)); |
| session.getIdentityMapAccessor().initializeIdentityMaps(); |
| } |
| |
| public static void replaceTables(DatabaseSession session){ |
| |
| session.executeNonSelectingSQL("DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'WRAPPED_SPATIAL'"); |
| |
| TableCreator tableCreator = new WrappedJGeometryTableCreator(); |
| tableCreator.replaceTables(session); |
| |
| session.executeNonSelectingSQL("INSERT INTO USER_SDO_GEOM_METADATA(TABLE_NAME, COLUMN_NAME, DIMINFO) VALUES('WRAPPED_SPATIAL', 'GEOMETRY.GEOM'," + |
| " mdsys.sdo_dim_array(mdsys.sdo_dim_element('X', -100, 100, 0.005), mdsys.sdo_dim_element('Y', -100, 100, 0.005)))"); |
| session.executeNonSelectingSQL("delete from WRAPPED_SPATIAL where gid between 1000 and 1013"); |
| session.executeNonSelectingSQL("CREATE INDEX wrapped_test_index on WRAPPED_SPATIAL(geometry.geom) indextype is mdsys.spatial_index"); |
| session.executeNonSelectingSQL("commit"); |
| } |
| |
| public static int countWrappedSpatial(DatabaseSession session) { |
| ReportQuery rq = |
| new ReportQuery(WrappedSpatial.class, new ExpressionBuilder()); |
| rq.addCount(); |
| rq.setShouldReturnSingleValue(true); |
| |
| return ((Number)session.executeQuery(rq)).intValue(); |
| } |
| } |