/*******************************************************************************
* Gisgraphy Project
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
*
* This library 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 library; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA
*
* Copyright 2008 Gisgraphy project
*
* David Masclet <davidmasclet@gisgraphy.com>
******************************************************************************/
package com.gisgraphy.hibernate.criterion;
import java.util.ArrayList;
import java.util.List;
import javax.persistence.PersistenceException;
import static org.junit.Assert.*;
import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Projection;
import org.hibernate.transform.Transformers;
import org.junit.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.orm.hibernate3.HibernateCallback;
import com.gisgraphy.domain.geoloc.entity.OpenStreetMap;
import com.gisgraphy.domain.repository.IOpenStreetMapDao;
import com.gisgraphy.domain.valueobject.SRID;
import com.gisgraphy.fulltext.AbstractIntegrationHttpSolrTestCase;
import com.gisgraphy.helper.GeolocHelper;
import com.gisgraphy.helper.StringHelper;
import com.gisgraphy.hibernate.projection.ProjectionBean;
import com.gisgraphy.hibernate.projection._OpenstreetmapDTO;
import com.gisgraphy.street.StreetType;
import com.gisgraphy.test._DaoHelper;
import com.vividsolutions.jts.geom.LineString;
public class IntersectsRestrictionTest extends AbstractIntegrationHttpSolrTestCase{
private _DaoHelper testDao;
private IOpenStreetMapDao openStreetMapDao;
private OpenStreetMap createAndSaveStreet(){
//we create a multilineString a little bit closest than the first one
OpenStreetMap street = new OpenStreetMap();
LineString shape2 = GeolocHelper.createLineString("LINESTRING (6.9416088 50.9154239,6.9410001 50.9154734)");
shape2.setSRID(SRID.WGS84_SRID.getSRID());
street.setShape(shape2);
street.setGid(2L);
//Simulate middle point
street.setLocation(GeolocHelper.createPoint(6.94130445F , 50.91544865F));
street.setOneWay(false);
street.setStreetType(StreetType.FOOTWAY);
street.setOpenstreetmapId(1234L);
street.setName("John Kenedy");
StringHelper.updateOpenStreetMapEntityForIndexation(street);
openStreetMapDao.save(street);
assertNotNull(openStreetMapDao.get(street.getId()));
return street;
}
@SuppressWarnings("unchecked")
@Test
public void testPartialWordRestriction() {
OpenStreetMap streetOSM = createAndSaveStreet();
HibernateCallback hibernateCallbackSuccess = new HibernateCallback() {
public Object doInHibernate(Session session)
throws PersistenceException {
Criteria testCriteria = session.createCriteria(OpenStreetMap.class);
List<String> fieldList = new ArrayList<String>();
fieldList.add("name");
fieldList.add("gid");
Projection projection = ProjectionBean.fieldList(fieldList, true);
testCriteria.setProjection(projection).add(
new IntersectsRestriction(OpenStreetMap.SHAPE_COLUMN_NAME, GeolocHelper.createPolygonBox(6.94130445F , 50.91544865F, 10000)))
.setResultTransformer(
Transformers.aliasToBean(_OpenstreetmapDTO.class));
List<_OpenstreetmapDTO> results = testCriteria.list();
return results;
}
};
List<_OpenstreetmapDTO> streets = (List<_OpenstreetmapDTO>) testDao
.testCallback(hibernateCallbackSuccess);
assertEquals(
"According to the intersects restriction, it should have a result ",
1, streets.size());
assertEquals(
"According to the intersects restriction, the result is incorrect",
streetOSM.getGid(), streets.get(0).getGid());
HibernateCallback hibernateCallbackFail = new HibernateCallback() {
public Object doInHibernate(Session session)
throws PersistenceException {
Criteria testCriteria = session.createCriteria(OpenStreetMap.class);
List<String> fieldList = new ArrayList<String>();
fieldList.add("name");
fieldList.add("gid");
Projection projection = ProjectionBean.fieldList(fieldList, true);
testCriteria.setProjection(projection).add(
new IntersectsRestriction(OpenStreetMap.SHAPE_COLUMN_NAME, GeolocHelper.createPolygonBox(7.94130445F , 51.91544865F, 10000)))
.setResultTransformer(
Transformers.aliasToBean(_OpenstreetmapDTO.class));
List<_OpenstreetmapDTO> results = testCriteria.list();
return results;
}
};
streets = (List<_OpenstreetmapDTO>) testDao
.testCallback(hibernateCallbackFail);
assertEquals(
"According to the intersects restriction, it should have no result ",
0, streets.size());
}
@Autowired
public void setOpenStreetMapDao(IOpenStreetMapDao openStreetMapDao) {
this.openStreetMapDao = openStreetMapDao;
}
@Autowired
public void setTestDao(_DaoHelper testDao) {
this.testDao = testDao;
}
}