//$Id: SubselectTest.java 10976 2006-12-12 23:22:26Z steve.ebersole@jboss.com $
package org.hibernate.test.subselect;
import java.util.Iterator;
import java.util.List;
import junit.framework.Test;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.junit.functional.FunctionalTestCase;
import org.hibernate.junit.functional.FunctionalTestClassTestSuite;
/**
* @author Gavin King
*/
public class SubselectTest extends FunctionalTestCase {
public SubselectTest(String str) {
super(str);
}
public String[] getMappings() {
return new String[] { "subselect/Beings.hbm.xml" };
}
public static Test suite() {
return new FunctionalTestClassTestSuite( SubselectTest.class );
}
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 beings = s.createQuery("from Being").list();
for ( Iterator iter = beings.iterator(); iter.hasNext(); ) {
Being b = (Being) iter.next();
assertNotNull( b.getLocation() );
assertNotNull( b.getIdentity() );
assertNotNull( b.getSpecies() );
}
s.clear();
getSessions().evict(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();
}
}
|