/*
* Hibernate, Relational Persistence for Idiomatic Java
*
* Copyright (c) 2006-2011, Red Hat Inc. or third-party contributors as
* indicated by the @author tags or express copyright attribution
* statements applied by the authors. All third-party contributions are
* distributed under license by Red Hat Inc.
*
* 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.hibernate.test.subselect;
import java.util.List;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.criterion.Restrictions;
import org.junit.Test;
import org.hibernate.testing.junit4.BaseCoreFunctionalTestCase;
import static org.junit.Assert.assertEquals;
import static org.junit.Assert.assertNotNull;
import static org.junit.Assert.assertTrue;
/**
* @author Gavin King
*/
public class SubselectTest extends BaseCoreFunctionalTestCase {
public String[] getMappings() {
return new String[] { "subselect/Beings.hbm.xml" };
}
@Test
@SuppressWarnings( {"unchecked"})
public void testEntitySubselect() {
Session s = openSession();
Transaction t = s.beginTransaction();
Human gavin = new Human();
gavin.setName( "gavin" );
gavin.setSex( 'M' );
gavin.setAddress( "Melbourne, Australia" );
Alien x23y4 = new Alien();
x23y4.setIdentity( "x23y4$$hu%3" );
x23y4.setPlanet( "Mars" );
x23y4.setSpecies( "martian" );
s.save(gavin);
s.save(x23y4);
s.flush();
List<Being> beings = ( List<Being>) s.createQuery("from Being").list();
for ( Being being : beings ) {
assertNotNull( being.getLocation() );
assertNotNull( being.getIdentity() );
assertNotNull( being.getSpecies() );
}
s.clear();
sessionFactory().getCache().evictEntityRegion( Being.class );
Being gav = (Being) s.get(Being.class, gavin.getId());
assertEquals( gav.getLocation(), gavin.getAddress() );
assertEquals( gav.getSpecies(), "human" );
assertEquals( gav.getIdentity(), gavin.getName() );
s.clear();
//test the <synchronized> tag:
gavin = (Human) s.get(Human.class, gavin.getId());
gavin.setAddress( "Atlanta, GA" );
gav = (Being) s.createQuery("from Being b where b.location like '%GA%'").uniqueResult();
assertEquals( gav.getLocation(), gavin.getAddress() );
s.delete(gavin);
s.delete(x23y4);
assertTrue( s.createQuery("from Being").list().isEmpty() );
t.commit();
s.close();
}
@Test
public void testCustomColumnReadAndWrite() {
Session s = openSession();
Transaction t = s.beginTransaction();
final double HUMAN_INCHES = 73;
final double ALIEN_INCHES = 931;
final double HUMAN_CENTIMETERS = HUMAN_INCHES * 2.54d;
final double ALIEN_CENTIMETERS = ALIEN_INCHES * 2.54d;
Human gavin = new Human();
gavin.setName( "gavin" );
gavin.setSex( 'M' );
gavin.setAddress( "Melbourne, Australia" );
gavin.setHeightInches( HUMAN_INCHES );
Alien x23y4 = new Alien();
x23y4.setIdentity( "x23y4$$hu%3" );
x23y4.setPlanet( "Mars" );
x23y4.setSpecies( "martian" );
x23y4.setHeightInches( ALIEN_INCHES );
s.save(gavin);
s.save(x23y4);
s.flush();
// Test value conversion during insert
Double humanHeightViaSql = (Double)s.createSQLQuery("select height_centimeters from humans").uniqueResult();
assertEquals(HUMAN_CENTIMETERS, humanHeightViaSql, 0.01d);
Double alienHeightViaSql = (Double)s.createSQLQuery("select height_centimeters from aliens").uniqueResult();
assertEquals(ALIEN_CENTIMETERS, alienHeightViaSql, 0.01d);
s.clear();
// Test projection
Double heightViaHql = (Double)s.createQuery("select heightInches from Being b where b.identity = 'gavin'").uniqueResult();
assertEquals(HUMAN_INCHES, heightViaHql, 0.01d);
// Test restriction and entity load via criteria
Being b = (Being)s.createCriteria(Being.class)
.add(Restrictions.between("heightInches", HUMAN_INCHES - 0.01d, HUMAN_INCHES + 0.01d))
.uniqueResult();
assertEquals(HUMAN_INCHES, b.getHeightInches(), 0.01d);
// Test predicate and entity load via HQL
b = (Being)s.createQuery("from Being b where b.heightInches between ? and ?")
.setDouble(0, ALIEN_INCHES - 0.01d)
.setDouble(1, ALIEN_INCHES + 0.01d)
.uniqueResult();
assertEquals(ALIEN_INCHES, b.getHeightInches(), 0.01d);
s.delete(gavin);
s.delete(x23y4);
t.commit();
s.close();
}
}