ASTParserLoadingTestpublic class ASTParserLoadingTest extends org.hibernate.junit.functional.FunctionalTestCase | Tests the integration of the new AST parser into the loading of query results using
the Hibernate persisters and loaders.
Also used to test the syntax of the resulting sql against the underlying
database, specifically for functionality not supported by the classic
parser. |
| Fields Summary |
|---|
| private static final Log | log | | private List | createdAnimalIds | | private static final QueryPreparer | DEFAULT_PREPARER |
| Constructors Summary |
|---|
public ASTParserLoadingTest(String name)
super( name );
|
| Methods Summary |
|---|
| private void | assertResultSize(java.lang.String hql, int size)
Session session = openSession();
Transaction txn = session.beginTransaction();
assertEquals( size, session.createQuery(hql).list().size() );
txn.commit();
session.close();
| | private void | checkCounts(java.lang.String hql, int expected, java.lang.String testCondition)
Session s = openSession();
s.beginTransaction();
int count = determineCount( s.createQuery( hql ).list().iterator() );
assertEquals( "list() [" + testCondition + "]", expected, count );
count = determineCount( s.createQuery( hql ).iterate() );
assertEquals( "iterate() [" + testCondition + "]", expected, count );
s.getTransaction().commit();
s.close();
| | public void | configure(org.hibernate.cfg.Configuration cfg)
super.configure( cfg );
cfg.setProperty( Environment.USE_QUERY_CACHE, "true" );
cfg.setProperty( Environment.GENERATE_STATISTICS, "true" );
cfg.setProperty( Environment.QUERY_TRANSLATOR, ASTQueryTranslatorFactory.class.getName() );
| | private void | createTestBaseData()
Session session = openSession();
Transaction txn = session.beginTransaction();
Mammal m1 = new Mammal();
m1.setBodyWeight( 11f );
m1.setDescription( "Mammal #1" );
session.save( m1 );
Mammal m2 = new Mammal();
m2.setBodyWeight( 9f );
m2.setDescription( "Mammal #2" );
m2.setMother( m1 );
session.save( m2 );
txn.commit();
session.close();
createdAnimalIds.add( m1.getId() );
createdAnimalIds.add( m2.getId() );
| | private void | destroyTestBaseData()
Session session = openSession();
Transaction txn = session.beginTransaction();
for ( int i = 0; i < createdAnimalIds.size(); i++ ) {
Animal animal = ( Animal ) session.load( Animal.class, ( Long ) createdAnimalIds.get( i ) );
session.delete( animal );
}
txn.commit();
session.close();
| | private int | determineCount(java.util.Iterator iterator)
int count = 0;
while( iterator.hasNext() ) {
count++;
iterator.next();
}
return count;
| | private Human | genSimpleHuman(java.lang.String fName, java.lang.String lName)
Human h = new Human();
h.setName( new Name( fName, 'X", lName ) );
return h;
| | public java.lang.String[] | getMappings()
return new String[] {
"hql/Animal.hbm.xml",
"hql/FooBarCopy.hbm.xml",
"hql/SimpleEntityWithAssociation.hbm.xml",
"hql/CrazyIdFieldNames.hbm.xml",
"batchfetch/ProductLine.hbm.xml",
"cid/Customer.hbm.xml",
"cid/Order.hbm.xml",
"cid/LineItem.hbm.xml",
"cid/Product.hbm.xml",
"any/Properties.hbm.xml",
"legacy/Commento.hbm.xml",
"legacy/Marelo.hbm.xml"
};
| | private org.hibernate.Query | getSelectNewQuery(org.hibernate.Session session)
return session.createQuery( "select new Animal(an.description, an.bodyWeight) from Animal an" );
| | public static junit.framework.Test | suite()
return new FunctionalTestClassTestSuite( ASTParserLoadingTest.class );
| | public void | testAggregation()
Session s = openSession();
Transaction t = s.beginTransaction();
Human h = new Human();
h.setBodyWeight( (float) 74.0 );
h.setHeight(120.5);
h.setDescription("Me");
h.setName( new Name("Gavin", 'A", "King") );
h.setNickName("Oney");
s.persist(h);
Double sum = (Double) s.createQuery("select sum(h.bodyWeight) from Human h").uniqueResult();
Double avg = (Double) s.createQuery("select avg(h.height) from Human h").uniqueResult();
assertEquals(sum.floatValue(), 74.0, 0.01);
assertEquals(avg.doubleValue(), 120.5, 0.01);
Long id = (Long) s.createQuery("select max(a.id) from Animal a").uniqueResult();
s.delete(h);
t.commit();
s.close();
| | public void | testAliases()
Session s = openSession();
Transaction t = s.beginTransaction();
Animal a = new Animal();
a.setBodyWeight(12.4f);
a.setDescription("an animal");
s.persist(a);
String[] aliases1 = s.createQuery("select a.bodyWeight as abw, a.description from Animal a").getReturnAliases();
assertEquals(aliases1[0], "abw");
assertEquals(aliases1[1], "1");
String[] aliases2 = s.createQuery("select count(*), avg(a.bodyWeight) as avg from Animal a").getReturnAliases();
assertEquals(aliases2[0], "0");
assertEquals(aliases2[1], "avg");
s.delete(a);
t.commit();
s.close();
| | public void | testAnyMappingReference()
Session s = openSession();
s.beginTransaction();
PropertyValue redValue = new StringPropertyValue( "red" );
PropertyValue lonliestNumberValue = new IntegerPropertyValue( 1 );
Long id;
PropertySet ps = new PropertySet( "my properties" );
ps.setSomeSpecificProperty( redValue );
ps.getGeneralProperties().put( "the lonliest number", lonliestNumberValue );
ps.getGeneralProperties().put( "i like", new StringPropertyValue( "pina coladas" ) );
ps.getGeneralProperties().put( "i also like", new StringPropertyValue( "getting caught in the rain" ) );
s.save( ps );
s.getTransaction().commit();
id = ps.getId();
s.clear();
s.beginTransaction();
// TODO : setEntity() currently will not work here, but that would be *very* nice
// does not work because the corresponding EntityType is then used as the "bind type" rather
// than the "discovered" AnyType...
s.createQuery( "from PropertySet p where p.someSpecificProperty = :ssp" ).setParameter( "ssp", redValue ).list();
s.createQuery( "from PropertySet p where p.someSpecificProperty.id is not null" ).list();
s.createQuery( "from PropertySet p join p.generalProperties gp where gp.id is not null" ).list();
s.delete( s.load( PropertySet.class, id ) );
s.getTransaction().commit();
s.close();
| | public void | testArithmetic()
Session s = openSession();
Transaction t = s.beginTransaction();
Zoo zoo = new Zoo();
zoo.setName("Melbourne Zoo");
s.persist(zoo);
s.createQuery("select 2*2*2*2*(2*2) from Zoo").uniqueResult();
s.createQuery("select 2 / (1+1) from Zoo").uniqueResult();
int result0 = ( (Integer) s.createQuery("select 2 - (1+1) from Zoo").uniqueResult() ).intValue();
int result1 = ( (Integer) s.createQuery("select 2 - 1 + 1 from Zoo").uniqueResult() ).intValue();
int result2 = ( (Integer) s.createQuery("select 2 * (1-1) from Zoo").uniqueResult() ).intValue();
int result3 = ( (Integer) s.createQuery("select 4 / (2 * 2) from Zoo").uniqueResult() ).intValue();
int result4 = ( (Integer) s.createQuery("select 4 / 2 * 2 from Zoo").uniqueResult() ).intValue();
int result5 = ( (Integer) s.createQuery("select 2 * (2/2) from Zoo").uniqueResult() ).intValue();
int result6 = ( (Integer) s.createQuery("select 2 * (2/2+1) from Zoo").uniqueResult() ).intValue();
assertEquals(result0, 0);
assertEquals(result1, 2);
assertEquals(result2, 0);
assertEquals(result3, 1);
assertEquals(result4, 4);
assertEquals(result5, 2);
assertEquals(result6, 4);
s.delete(zoo);
t.commit();
s.close();
| | public void | testCast()
if ( ( getDialect() instanceof MySQLDialect ) || ( getDialect() instanceof DB2Dialect ) ) {
return;
}
Session session = openSession();
Transaction txn = session.beginTransaction();
session.createQuery("from Human h where h.nickName like 'G%'").list();
session.createQuery("from Animal a where cast(a.bodyWeight as string) like '1.%'").list();
session.createQuery("from Animal a where cast(a.bodyWeight as integer) = 1").list();
txn.commit();
session.close();
| | public void | testCastInSelect()
Session s = openSession();
Transaction t = s.beginTransaction();
Animal a = new Animal();
a.setBodyWeight(12.4f);
a.setDescription("an animal");
s.persist(a);
Integer bw = (Integer) s.createQuery("select cast(bodyWeight as integer) from Animal").uniqueResult();
bw = (Integer) s.createQuery("select cast(a.bodyWeight as integer) from Animal a").uniqueResult();
bw.toString();
s.delete(a);
t.commit();
s.close();
| | public void | testCoalesce()
Session session = openSession();
Transaction txn = session.beginTransaction();
session.createQuery("from Human h where coalesce(h.nickName, h.name.first, h.name.last) = 'max'").list();
session.createQuery("select nullif(nickName, '1e1') from Human").list();
txn.commit();
session.close();
| | public void | testCollectionFetchWithDistinctionAndLimit()
// create some test data...
Session s = openSession();
Transaction t = s.beginTransaction();
int parentCount = 30;
for ( int i = 0; i < parentCount; i++ ) {
Animal child1 = new Animal();
child1.setDescription( "collection fetch distinction (child1 - parent" + i + ")" );
s.persist( child1 );
Animal child2 = new Animal();
child2.setDescription( "collection fetch distinction (child2 - parent " + i + ")" );
s.persist( child2 );
Animal parent = new Animal();
parent.setDescription( "collection fetch distinction (parent" + i + ")" );
parent.setSerialNumber( "123-" + i );
parent.addOffspring( child1 );
parent.addOffspring( child2 );
s.persist( parent );
}
t.commit();
s.close();
s = openSession();
t = s.beginTransaction();
// Test simple distinction
List results;
results = s.createQuery( "select distinct p from Animal p inner join fetch p.offspring" ).list();
assertEquals( "duplicate list() returns", 30, results.size() );
// Test first/max
results = s.createQuery( "select p from Animal p inner join fetch p.offspring order by p.id" )
.setFirstResult( 5 )
.setMaxResults( 20 )
.list();
assertEquals( "duplicate returns", 20, results.size() );
Animal firstReturn = ( Animal ) results.get( 0 );
assertEquals( "firstResult not applied correctly", "123-5", firstReturn.getSerialNumber() );
t.commit();
s.close();
s = openSession();
t = s.beginTransaction();
s.createQuery( "delete Animal where mother is not null" ).executeUpdate();
s.createQuery( "delete Animal" ).executeUpdate();
t.commit();
s.close();
| | public void | testCollectionFetching()
createTestBaseData();
Session session = openSession();
List results = session.createQuery( "from Animal an join fetch an.offspring" ).list();
assertEquals( "Incorrect result size", 1, results.size() );
assertTrue( "Incorrect result return type", results.get( 0 ) instanceof Animal );
Collection os = ( ( Animal ) results.get( 0 ) ).getOffspring();
assertTrue( "fetch uninitialized", os != null && Hibernate.isInitialized( os ) && os.size() == 1 );
results = session.createQuery( "select an from Animal an join fetch an.offspring" ).list();
assertEquals( "Incorrect result size", 1, results.size() );
assertTrue( "Incorrect result return type", results.get( 0 ) instanceof Animal );
os = ( ( Animal ) results.get( 0 ) ).getOffspring();
assertTrue( "fetch uninitialized", os != null && Hibernate.isInitialized( os ) && os.size() == 1 );
session.close();
destroyTestBaseData();
| | public void | testCollectionJoinsInSubselect()
// HHH-1248 : initially FromElementFactory treated any explicit join
// as an implied join so that theta-style joins would always be used.
// This was because correlated subqueries cannot use ANSI-style joins
// for the correlation. However, this special treatment was not limited
// to only correlated subqueries; it was applied to any subqueries ->
// which in-and-of-itself is not necessarily bad. But somewhere later
// the choices made there caused joins to be dropped.
Session s = openSession();
String qryString =
"select a.id, a.description" +
" from Animal a" +
" left join a.offspring" +
" where a in (" +
" select a1 from Animal a1" +
" left join a1.offspring o" +
" where a1.id=1" +
")";
s.createQuery( qryString ).list();
qryString =
"select h.id, h.description" +
" from Human h" +
" left join h.friends" +
" where h in (" +
" select h1" +
" from Human h1" +
" left join h1.friends f" +
" where h1.id=1" +
")";
s.createQuery( qryString ).list();
qryString =
"select h.id, h.description" +
" from Human h" +
" left join h.friends f" +
" where f in (" +
" select h1" +
" from Human h1" +
" left join h1.friends f1" +
" where h = f1" +
")";
s.createQuery( qryString ).list();
s.close();
| | public void | testComponentOrderBy()
Session s = openSession();
Transaction t = s.beginTransaction();
Long id1 = ( Long ) s.save( genSimpleHuman( "John", "Jacob" ) );
Long id2 = ( Long ) s.save( genSimpleHuman( "Jingleheimer", "Schmidt" ) );
s.flush();
// the component is defined with the firstName column first...
List results = s.createQuery( "from Human as h order by h.name" ).list();
assertEquals( "Incorrect return count", 2, results.size() );
Human h1 = ( Human ) results.get( 0 );
Human h2 = ( Human ) results.get( 1 );
assertEquals( "Incorrect ordering", id2, h1.getId() );
assertEquals( "Incorrect ordering", id1, h2.getId() );
s.delete( h1 );
s.delete( h2 );
t.commit();
s.close();
| | public void | testComponentParameterBinding()
// HHH-1774 : parameters are bound incorrectly with component parameters...
Session s = openSession();
s.beginTransaction();
Order.Id oId = new Order.Id( "1234", 1 );
// control
s.createQuery("from Order o where o.customer.name =:name and o.id = :id")
.setParameter( "name", "oracle" )
.setParameter( "id", oId )
.list();
// this is the form that caused problems in the original case...
s.createQuery("from Order o where o.id = :id and o.customer.name =:name ")
.setParameter( "id", oId )
.setParameter( "name", "oracle" )
.list();
s.getTransaction().commit();
s.close();
| | public void | testComponentQueries()
Session s = openSession();
s.beginTransaction();
Type[] types = s.createQuery( "select h.name from Human h" ).getReturnTypes();
assertEquals( 1, types.length );
assertTrue( types[0] instanceof ComponentType );
// Test the ability to perform comparisions between component values
s.createQuery( "from Human h where h.name = h.name" ).list();
s.createQuery( "from Human h where h.name = :name" ).setParameter( "name", new Name() ).list();
s.createQuery( "from Human where name = :name" ).setParameter( "name", new Name() ).list();
s.createQuery( "from Human h where :name = h.name" ).setParameter( "name", new Name() ).list();
s.createQuery( "from Human h where :name <> h.name" ).setParameter( "name", new Name() ).list();
// Test the ability to perform comparisions between a component and an explicit row-value
s.createQuery( "from Human h where h.name = ('John', 'X', 'Doe')" ).list();
s.createQuery( "from Human h where ('John', 'X', 'Doe') = h.name" ).list();
s.createQuery( "from Human h where ('John', 'X', 'Doe') <> h.name" ).list();
s.createQuery( "from Human h where ('John', 'X', 'Doe') >= h.name" ).list();
s.createQuery( "from Human h order by h.name" ).list();
s.getTransaction().commit();
s.close();
| | public void | testConcatenation()Copied from {@link HQLTest#testConcatenation}
// simple syntax checking...
Session s = openSession();
s.beginTransaction();
s.createQuery( "from Human h where h.nickName = '1' || 'ov' || 'tha' || 'few'" ).list();
s.getTransaction().commit();
s.close();
| | public void | testCrazyIdFieldNames()
MoreCrazyIdFieldNameStuffEntity top = new MoreCrazyIdFieldNameStuffEntity( "top" );
HeresAnotherCrazyIdFieldName next = new HeresAnotherCrazyIdFieldName( "next" );
top.setHeresAnotherCrazyIdFieldName( next );
MoreCrazyIdFieldNameStuffEntity other = new MoreCrazyIdFieldNameStuffEntity( "other" );
Session s = openSession();
s.beginTransaction();
s.save( next );
s.save( top );
s.save( other );
s.flush();
List results = s.createQuery( "select e.heresAnotherCrazyIdFieldName from MoreCrazyIdFieldNameStuffEntity e where e.heresAnotherCrazyIdFieldName is not null" ).list();
assertEquals( 1, results.size() );
Object result = results.get( 0 );
assertClassAssignability( HeresAnotherCrazyIdFieldName.class, result.getClass() );
assertSame( next, result );
results = s.createQuery( "select e.heresAnotherCrazyIdFieldName.heresAnotherCrazyIdFieldName from MoreCrazyIdFieldNameStuffEntity e where e.heresAnotherCrazyIdFieldName is not null" ).list();
assertEquals( 1, results.size() );
result = results.get( 0 );
assertClassAssignability( Long.class, result.getClass() );
assertEquals( next.getHeresAnotherCrazyIdFieldName(), result );
results = s.createQuery( "select e.heresAnotherCrazyIdFieldName from MoreCrazyIdFieldNameStuffEntity e" ).list();
assertEquals( 1, results.size() );
Iterator itr = s.createQuery( "select e.heresAnotherCrazyIdFieldName from MoreCrazyIdFieldNameStuffEntity e" ).iterate();
assertTrue( itr.hasNext() ); itr.next(); assertFalse( itr.hasNext() );
s.delete( top );
s.delete( next );
s.getTransaction().commit();
s.close();
| | public void | testDecimalLiterals()
// note: simply performing syntax checking in the db
Session s = openSession();
s.beginTransaction();
s.createQuery( "from Animal where bodyWeight > 100.0e-10" ).list();
s.createQuery( "from Animal where bodyWeight > 100.0E-10" ).list();
s.createQuery( "from Animal where bodyWeight > 100.001f" ).list();
s.createQuery( "from Animal where bodyWeight > 100.001F" ).list();
s.createQuery( "from Animal where bodyWeight > 100.001d" ).list();
s.createQuery( "from Animal where bodyWeight > 100.001D" ).list();
s.createQuery( "from Animal where bodyWeight > .001f" ).list();
s.createQuery( "from Animal where bodyWeight > 100e-10" ).list();
s.createQuery( "from Animal where bodyWeight > .01E-10" ).list();
s.createQuery( "from Animal where bodyWeight > 1e-38" ).list();
s.getTransaction().commit();
s.close();
| | public void | testDynamicInstantiationQueries()
createTestBaseData();
Session session = openSession();
List results = session.createQuery( "select new Animal(an.description, an.bodyWeight) from Animal an" ).list();
assertEquals( "Incorrect result size", 2, results.size() );
assertClassAssignability( results.get( 0 ).getClass(), Animal.class );
Iterator iter = session.createQuery( "select new Animal(an.description, an.bodyWeight) from Animal an" ).iterate();
assertTrue( "Incorrect result size", iter.hasNext() );
assertTrue( "Incorrect return type", iter.next() instanceof Animal );
results = session.createQuery( "select new list(an.description, an.bodyWeight) from Animal an" ).list();
assertEquals( "Incorrect result size", 2, results.size() );
assertTrue( "Incorrect return type", results.get( 0 ) instanceof List );
assertEquals( "Incorrect return type", ( (List) results.get( 0 ) ).size(), 2 );
results = session.createQuery( "select new list(an.description, an.bodyWeight) from Animal an" ).list();
assertEquals( "Incorrect result size", 2, results.size() );
assertTrue( "Incorrect return type", results.get( 0 ) instanceof List );
assertEquals( "Incorrect return type", ( (List) results.get( 0 ) ).size(), 2 );
iter = session.createQuery( "select new list(an.description, an.bodyWeight) from Animal an" ).iterate();
assertTrue( "Incorrect result size", iter.hasNext() );
Object obj = iter.next();
assertTrue( "Incorrect return type", obj instanceof List );
assertEquals( "Incorrect return type", ( (List) obj ).size(), 2 );
iter = ((org.hibernate.classic.Session)session).iterate( "select new list(an.description, an.bodyWeight) from Animal an" );
assertTrue( "Incorrect result size", iter.hasNext() );
obj = iter.next();
assertTrue( "Incorrect return type", obj instanceof List );
assertEquals( "Incorrect return type", ( (List) obj ).size(), 2 );
results = session.createQuery( "select new map(an.description, an.bodyWeight) from Animal an" ).list();
assertEquals( "Incorrect result size", 2, results.size() );
assertTrue( "Incorrect return type", results.get( 0 ) instanceof Map );
assertEquals( "Incorrect return type", ( (Map) results.get( 0 ) ).size(), 2 );
assertTrue( ( (Map) results.get( 0 ) ).containsKey("0") );
assertTrue( ( (Map) results.get( 0 ) ).containsKey("1") );
results = session.createQuery( "select new map(an.description as descr, an.bodyWeight as bw) from Animal an" ).list();
assertEquals( "Incorrect result size", 2, results.size() );
assertTrue( "Incorrect return type", results.get( 0 ) instanceof Map );
assertEquals( "Incorrect return type", ( (Map) results.get( 0 ) ).size(), 2 );
assertTrue( ( (Map) results.get( 0 ) ).containsKey("descr") );
assertTrue( ( (Map) results.get( 0 ) ).containsKey("bw") );
iter = session.createQuery( "select new map(an.description, an.bodyWeight) from Animal an" ).iterate();
assertTrue( "Incorrect result size", iter.hasNext() );
obj = iter.next();
assertTrue( "Incorrect return type", obj instanceof Map );
assertEquals( "Incorrect return type", ( (Map) obj ).size(), 2 );
ScrollableResults sr = session.createQuery( "select new map(an.description, an.bodyWeight) from Animal an" ).scroll();
assertTrue( "Incorrect result size", sr.next() );
obj = sr.get(0);
assertTrue( "Incorrect return type", obj instanceof Map );
assertEquals( "Incorrect return type", ( (Map) obj ).size(), 2 );
sr.close();
sr = session.createQuery( "select new Animal(an.description, an.bodyWeight) from Animal an" ).scroll();
assertTrue( "Incorrect result size", sr.next() );
assertTrue( "Incorrect return type", sr.get(0) instanceof Animal );
sr.close();
// caching...
QueryStatistics stats = getSessions().getStatistics().getQueryStatistics( "select new Animal(an.description, an.bodyWeight) from Animal an" );
results = session.createQuery( "select new Animal(an.description, an.bodyWeight) from Animal an" )
.setCacheable( true )
.list();
assertEquals( "incorrect result size", 2, results.size() );
assertClassAssignability( Animal.class, results.get( 0 ).getClass() );
long initCacheHits = stats.getCacheHitCount();
results = session.createQuery( "select new Animal(an.description, an.bodyWeight) from Animal an" )
.setCacheable( true )
.list();
assertEquals( "dynamic intantiation query not served from cache", initCacheHits + 1, stats.getCacheHitCount() );
assertEquals( "incorrect result size", 2, results.size() );
assertClassAssignability( Animal.class, results.get( 0 ).getClass() );
session.close();
destroyTestBaseData();
| | public void | testEJBQLFunctions()
Session session = openSession();
String hql = "from Animal a where a.description = concat('1', concat('2','3'), '4'||'5')||'0'";
session.createQuery(hql).list();
hql = "from Animal a where substring(a.description, 1, 3) = 'cat'";
session.createQuery(hql).list();
hql = "select substring(a.description, 1, 3) from Animal a";
session.createQuery(hql).list();
hql = "from Animal a where lower(a.description) = 'cat'";
session.createQuery(hql).list();
hql = "select lower(a.description) from Animal a";
session.createQuery(hql).list();
hql = "from Animal a where upper(a.description) = 'CAT'";
session.createQuery(hql).list();
hql = "select upper(a.description) from Animal a";
session.createQuery(hql).list();
hql = "from Animal a where length(a.description) = 5";
session.createQuery(hql).list();
hql = "select length(a.description) from Animal a";
session.createQuery(hql).list();
//note: postgres and db2 don't have a 3-arg form, it gets transformed to 2-args
hql = "from Animal a where locate('abc', a.description, 2) = 2";
session.createQuery(hql).list();
hql = "from Animal a where locate('abc', a.description) = 2";
session.createQuery(hql).list();
hql = "select locate('cat', a.description, 2) from Animal a";
session.createQuery(hql).list();
if ( !( getDialect() instanceof DB2Dialect ) ) {
hql = "from Animal a where trim(trailing '_' from a.description) = 'cat'";
session.createQuery(hql).list();
hql = "select trim(trailing '_' from a.description) from Animal a";
session.createQuery(hql).list();
hql = "from Animal a where trim(leading '_' from a.description) = 'cat'";
session.createQuery(hql).list();
hql = "from Animal a where trim(both from a.description) = 'cat'";
session.createQuery(hql).list();
}
if ( !(getDialect() instanceof HSQLDialect) ) { //HSQL doesn't like trim() without specification
hql = "from Animal a where trim(a.description) = 'cat'";
session.createQuery(hql).list();
}
hql = "from Animal a where abs(a.bodyWeight) = sqrt(a.bodyWeight)";
session.createQuery(hql).list();
hql = "from Animal a where mod(16, 4) = 4";
session.createQuery(hql).list();
hql = "from Animal a where bit_length(a.bodyWeight) = 24";
session.createQuery(hql).list();
hql = "select bit_length(a.bodyWeight) from Animal a";
session.createQuery(hql).list();
/*hql = "select object(a) from Animal a where CURRENT_DATE = :p1 or CURRENT_TIME = :p2 or CURRENT_TIMESTAMP = :p3";
session.createQuery(hql).list();*/
// todo the following is not supported
//hql = "select CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP from Animal a";
//parse(hql, true);
//System.out.println("sql: " + toSql(hql));
hql = "from Animal a where a.description like '%a%'";
session.createQuery(hql).list();
hql = "from Animal a where a.description not like '%a%'";
session.createQuery(hql).list();
hql = "from Animal a where a.description like 'x%ax%' escape 'x'";
session.createQuery(hql).list();
session.close();
| | public void | testEntityFetching()
createTestBaseData();
Session session = openSession();
List results = session.createQuery( "from Animal an join fetch an.mother" ).list();
assertEquals( "Incorrect result size", 1, results.size() );
assertTrue( "Incorrect result return type", results.get( 0 ) instanceof Animal );
Animal mother = ( ( Animal ) results.get( 0 ) ).getMother();
assertTrue( "fetch uninitialized", mother != null && Hibernate.isInitialized( mother ) );
results = session.createQuery( "select an from Animal an join fetch an.mother" ).list();
assertEquals( "Incorrect result size", 1, results.size() );
assertTrue( "Incorrect result return type", results.get( 0 ) instanceof Animal );
mother = ( ( Animal ) results.get( 0 ) ).getMother();
assertTrue( "fetch uninitialized", mother != null && Hibernate.isInitialized( mother ) );
session.close();
destroyTestBaseData();
| | public void | testEntityPropertySelect()
createTestBaseData();
Session session = openSession();
List results = session.createQuery( "select a.mother from Animal as a" ).list();
// assertEquals("Incorrect result size", 2, results.size());
assertTrue( "Incorrect result return type", results.get( 0 ) instanceof Animal );
session.close();
destroyTestBaseData();
| | public void | testExpressionWithParamInFunction()Copied from {@link HQLTest#testExpressionWithParamInFunction}
Session s = openSession();
s.beginTransaction();
s.createQuery( "from Animal a where abs(a.bodyWeight-:param) < 2.0" ).setLong( "param", 1 ).list();
s.createQuery( "from Animal a where abs(:param - a.bodyWeight) < 2.0" ).setLong( "param", 1 ).list();
if ( ! ( getDialect() instanceof HSQLDialect ) ) {
// HSQLDB does not like the abs(? - ?) syntax...
s.createQuery( "from Animal where abs(:x - :y) < 2.0" ).setLong( "x", 1 ).setLong( "y", 1 ).list();
}
s.createQuery( "from Animal where lower(upper(:foo)) like 'f%'" ).setString( "foo", "foo" ).list();
s.createQuery( "from Animal a where abs(abs(a.bodyWeight - 1.0 + :param) * abs(length('ffobar')-3)) = 3.0" ).setLong( "param", 1 ).list();
s.createQuery( "from Animal where lower(upper('foo') || upper(:bar)) like 'f%'" ).setString( "bar", "xyz" ).list();
if ( ! ( getDialect() instanceof PostgreSQLDialect || getDialect() instanceof MySQLDialect ) ) {
s.createQuery( "from Animal where abs(cast(1 as float) - cast(:param as float)) = 1.0" ).setLong( "param", 1 ).list();
}
s.getTransaction().commit();
s.close();
| | public void | testExtract()
Session session = openSession();
Transaction txn = session.beginTransaction();
session.createQuery("select second(current_timestamp()), minute(current_timestamp()), hour(current_timestamp()) from Mammal m").list();
session.createQuery("select day(m.birthdate), month(m.birthdate), year(m.birthdate) from Mammal m").list();
if ( !(getDialect() instanceof DB2Dialect) ) { //no ANSI extract
session.createQuery("select extract(second from current_timestamp()), extract(minute from current_timestamp()), extract(hour from current_timestamp()) from Mammal m").list();
session.createQuery("select extract(day from m.birthdate), extract(month from m.birthdate), extract(year from m.birthdate) from Mammal m").list();
}
txn.commit();
session.close();
| | public void | testFetchInSubqueryFails()
Session s = openSession();
try {
s.createQuery( "from Animal a where a.mother in (select m from Animal a1 inner join a1.mother as m join fetch m.mother)" ).list();
fail( "fetch join allowed in subquery" );
}
catch( QueryException expected ) {
// expected behavior
}
s.close();
| | public void | testFromOnly()
createTestBaseData();
Session session = openSession();
List results = session.createQuery( "from Animal" ).list();
assertEquals( "Incorrect result size", 2, results.size() );
assertTrue( "Incorrect result return type", results.get( 0 ) instanceof Animal );
session.close();
destroyTestBaseData();
| | public void | testIllegalMixedTransformerQueries()
Session session = openSession();
try {
getSelectNewQuery( session ).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list();
fail("'select new' together with a resulttransformer should result in error!");
} catch(QueryException he) {
assertTrue(he.getMessage().indexOf("ResultTransformer")==0);
}
try {
getSelectNewQuery( session ).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).iterate();
fail("'select new' together with a resulttransformer should result in error!");
} catch(HibernateException he) {
assertTrue(he.getMessage().indexOf("ResultTransformer")==0);
}
try {
getSelectNewQuery( session ).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).scroll();
fail("'select new' together with a resulttransformer should result in error!");
} catch(HibernateException he) {
assertTrue(he.getMessage().indexOf("ResultTransformer")==0);
}
session.close();
| | public void | testImplicitJoin()
Session session = openSession();
Transaction t = session.beginTransaction();
Animal a = new Animal();
a.setBodyWeight(0.5f);
a.setBodyWeight(1.5f);
Animal b = new Animal();
Animal mother = new Animal();
mother.setBodyWeight(10.0f);
mother.addOffspring(a);
mother.addOffspring(b);
session.persist(a);
session.persist(b);
session.persist(mother);
List list = session.createQuery("from Animal a where a.mother.bodyWeight < 2.0 or a.mother.bodyWeight > 9.0").list();
assertEquals( list.size(), 2 );
list = session.createQuery("from Animal a where a.mother.bodyWeight > 2.0 and a.mother.bodyWeight > 9.0").list();
assertEquals( list.size(), 2 );
session.delete(b);
session.delete(a);
session.delete(mother);
t.commit();
session.close();
| | public void | testImplicitJoinsInDifferentClauses()
// HHH-2257 :
// both the classic and ast translators output the same syntactically valid sql
// for all of these cases; the issue is that shallow (iterate) and
// non-shallow (list/scroll) queries return different results because the
// shallow skips the inner join which "weeds out" results from the non-shallow queries.
// The results were initially different depending upon the clause(s) in which the
// implicit join occurred
Session s = openSession();
s.beginTransaction();
SimpleEntityWithAssociation owner = new SimpleEntityWithAssociation( "owner" );
SimpleAssociatedEntity e1 = new SimpleAssociatedEntity( "thing one", owner );
SimpleAssociatedEntity e2 = new SimpleAssociatedEntity( "thing two" );
s.save( e1 );
s.save( e2 );
s.save( owner );
s.getTransaction().commit();
s.close();
checkCounts( "select e.owner from SimpleAssociatedEntity e", 1, "implicit-join in select clause" );
checkCounts( "select e.id, e.owner from SimpleAssociatedEntity e", 1, "implicit-join in select clause" );
// resolved to a "id short cut" when part of the order by clause -> no inner join = no weeding out...
checkCounts( "from SimpleAssociatedEntity e order by e.owner", 2, "implicit-join in order-by clause" );
// resolved to a "id short cut" when part of the group by clause -> no inner join = no weeding out...
checkCounts( "select e.owner.id, count(*) from SimpleAssociatedEntity e group by e.owner", 2, "implicit-join in select and group-by clauses" );
s = openSession();
s.beginTransaction();
s.delete( e1 );
s.delete( e2 );
s.delete( owner );
s.getTransaction().commit();
s.close();
| | public void | testImplicitPolymorphism()
Session s = openSession();
Transaction t = s.beginTransaction();
Product product = new Product();
product.setDescription( "My Product" );
product.setNumberAvailable( 10 );
product.setPrice( new BigDecimal( 123 ) );
product.setProductId( "4321" );
s.save( product );
List list = s.createQuery("from java.lang.Comparable").list();
assertEquals( list.size(), 0 );
list = s.createQuery("from java.lang.Object").list();
assertEquals( list.size(), 1 );
s.delete(product);
list = s.createQuery("from java.lang.Object").list();
assertEquals( list.size(), 0 );
t.commit();
s.close();
| | public void | testImplicitSelectEntityAssociationInShallowQuery()
// HHH-2257 :
// both the classic and ast translators output the same syntactically valid sql.
// the issue is that shallow and non-shallow queries return different
// results because the shallow skips the inner join which "weeds out" results
// from the non-shallow queries...
Session s = openSession();
s.beginTransaction();
SimpleEntityWithAssociation owner = new SimpleEntityWithAssociation( "owner" );
SimpleAssociatedEntity e1 = new SimpleAssociatedEntity( "thing one", owner );
SimpleAssociatedEntity e2 = new SimpleAssociatedEntity( "thing two" );
s.save( e1 );
s.save( e2 );
s.save( owner );
s.getTransaction().commit();
s.close();
s = openSession();
s.beginTransaction();
int count = determineCount( s.createQuery( "select e.id, e.owner from SimpleAssociatedEntity e" ).list().iterator() );
assertEquals( 1, count ); // thing two would be removed from the result due to the inner join
count = determineCount( s.createQuery( "select e.id, e.owner from SimpleAssociatedEntity e" ).iterate() );
assertEquals( 1, count );
s.getTransaction().commit();
s.close();
s = openSession();
s.beginTransaction();
s.delete( e1 );
s.delete( e2 );
s.delete( owner );
s.getTransaction().commit();
s.close();
| | public void | testIndexParams()
Session s = openSession();
Transaction t = s.beginTransaction();
s.createQuery("from Zoo zoo where zoo.mammals[:name] = :id")
.setParameter("name", "Walrus")
.setParameter("id", new Long(123))
.list();
s.createQuery("from Zoo zoo where zoo.mammals[:name].bodyWeight > :w")
.setParameter("name", "Walrus")
.setParameter("w", new Float(123.32))
.list();
s.createQuery("from Zoo zoo where zoo.animals[:sn].mother.bodyWeight < :mw")
.setParameter("sn", "ant-123")
.setParameter("mw", new Float(23.32))
.list();
/*s.createQuery("from Zoo zoo where zoo.animals[:sn].description like :desc and zoo.animals[:sn].bodyWeight > :wmin and zoo.animals[:sn].bodyWeight < :wmax")
.setParameter("sn", "ant-123")
.setParameter("desc", "%big%")
.setParameter("wmin", new Float(123.32))
.setParameter("wmax", new Float(167.89))
.list();*/
/*s.createQuery("from Human where addresses[:type].city = :city and addresses[:type].country = :country")
.setParameter("type", "home")
.setParameter("city", "Melbourne")
.setParameter("country", "Australia")
.list();*/
t.commit();
s.close();
| | public void | testInitProxy()
Session s = openSession();
Transaction t = s.beginTransaction();
Mammal plat = new Mammal();
plat.setBodyWeight( 11f );
plat.setDescription( "Platypus" );
s.persist( plat );
s.flush();
s.clear();
plat = (Mammal) s.load(Mammal.class, plat.getId() );
assertFalse( Hibernate.isInitialized(plat) );
Object plat2 = s.createQuery("from Animal a").uniqueResult();
assertSame(plat, plat2);
assertTrue( Hibernate.isInitialized(plat) );
s.delete(plat);
t.commit();
s.close();
| | public void | testIntegerLiterals()
// note: simply performing syntax checking in the db
Session s = openSession();
s.beginTransaction();
s.createQuery( "from Foo where long = 1" ).list();
s.createQuery( "from Foo where long = " + Integer.MIN_VALUE ).list();
s.createQuery( "from Foo where long = " + Integer.MAX_VALUE ).list();
s.createQuery( "from Foo where long = 1L" ).list();
s.createQuery( "from Foo where long = " + (Long.MIN_VALUE + 1) + "L" ).list();
s.createQuery( "from Foo where long = " + Long.MAX_VALUE + "L" ).list();
s.createQuery( "from Foo where integer = " + (Long.MIN_VALUE + 1) ).list();
// currently fails due to HHH-1387
// s.createQuery( "from Foo where long = " + Long.MIN_VALUE ).list();
s.getTransaction().commit();
s.close();
| | public void | testInvalidCollectionDereferencesFail()
Session s = openSession();
s.beginTransaction();
// control group...
s.createQuery( "from Animal a join a.offspring o where o.description = 'xyz'" ).list();
s.createQuery( "from Animal a join a.offspring o where o.father.description = 'xyz'" ).list();
s.createQuery( "from Animal a join a.offspring o order by o.description" ).list();
s.createQuery( "from Animal a join a.offspring o order by o.father.description" ).list();
try {
s.createQuery( "from Animal a where a.offspring.description = 'xyz'" ).list();
fail( "illegal collection dereference semantic did not cause failure" );
}
catch( QueryException qe ) {
log.trace( "expected failure...", qe );
}
try {
s.createQuery( "from Animal a where a.offspring.father.description = 'xyz'" ).list();
fail( "illegal collection dereference semantic did not cause failure" );
}
catch( QueryException qe ) {
log.trace( "expected failure...", qe );
}
try {
s.createQuery( "from Animal a order by a.offspring.description" ).list();
fail( "illegal collection dereference semantic did not cause failure" );
}
catch( QueryException qe ) {
log.trace( "expected failure...", qe );
}
try {
s.createQuery( "from Animal a order by a.offspring.father.description" ).list();
fail( "illegal collection dereference semantic did not cause failure" );
}
catch( QueryException qe ) {
log.trace( "expected failure...", qe );
}
s.getTransaction().commit();
s.close();
| | public void | testInvalidFetchSemantics()
Session s = openSession();
s.beginTransaction();
try {
s.createQuery( "select mother from Human a left join fetch a.mother mother" ).list();
fail( "invalid fetch semantic allowed!" );
}
catch( QueryException e ) {
}
try {
s.createQuery( "select mother from Human a left join fetch a.mother mother" ).list();
fail( "invalid fetch semantic allowed!" );
}
catch( QueryException e ) {
}
s.getTransaction().commit();
s.close();
| | public void | testJPAPositionalParameterList()
Session s = openSession();
s.beginTransaction();
ArrayList params = new ArrayList();
params.add( "Doe" );
params.add( "Public" );
s.createQuery( "from Human where name.last in (?1)" )
.setParameterList( "1", params )
.list();
s.getTransaction().commit();
s.close();
| | public void | testJdkEnumStyleEnumConstant()
Session s = openSession();
s.beginTransaction();
s.createQuery( "from Zoo z where z.classification = org.hibernate.test.hql.Classification.LAME" ).list();
s.getTransaction().commit();
s.close();
| | public void | testJoinFetchCollectionOfValues()
// note: simply performing syntax checking in the db
Session s = openSession();
s.beginTransaction();
s.createQuery( "select h from Human as h join fetch h.nickNames" ).list();
s.getTransaction().commit();
s.close();
| | public void | testManyToManyFilter()
Session session = openSession();
Transaction txn = session.beginTransaction();
Human human = new Human();
human.setName( new Name( "Steve", 'L", "Ebersole" ) );
session.save( human );
Human friend = new Human();
friend.setName( new Name( "John", 'Q", "Doe" ) );
friend.setBodyWeight( 11.0f );
session.save( friend );
human.setFriends( new ArrayList() );
friend.setFriends( new ArrayList() );
human.getFriends().add( friend );
friend.getFriends().add( human );
session.flush();
assertEquals( session.createFilter( human.getFriends(), "" ).list().size(), 1 );
assertEquals( session.createFilter( human.getFriends(), "where this.bodyWeight > ?" ).setFloat( 0, 10f ).list().size(), 1 );
assertEquals( session.createFilter( human.getFriends(), "where this.bodyWeight < ?" ).setFloat( 0, 10f ).list().size(), 0 );
session.delete(human);
session.delete(friend);
txn.commit();
session.close();
| | public void | testMultipleBagFetchesFail()
Session s = openSession();
s.beginTransaction();
try {
s.createQuery( "from Human h join fetch h.friends f join fetch f.friends fof" ).list();
fail( "failure expected" );
}
catch( HibernateException e ) {
assertTrue( "unexpected failure reason : " + e, e.getMessage().indexOf( "multiple bags" ) > 0 );
}
s.getTransaction().commit();
s.close();
| | public void | testNakedComponentPropertyRef()
// note: simply performing syntax and column/table resolution checking in the db
Session s = openSession();
s.beginTransaction();
s.createQuery( "from Human where name.first = 'Gavin'" ).list();
s.createQuery( "select name from Human" ).list();
s.createQuery( "select upper(h.name.first) from Human as h" ).list();
s.createQuery( "select upper(name.first) from Human" ).list();
s.getTransaction().commit();
s.close();
| | public void | testNakedEntityAssociationReference()
// note: simply performing syntax and column/table resolution checking in the db
Session s = openSession();
s.beginTransaction();
s.createQuery( "from Animal where mother = :mother" ).setParameter( "mother", null ).list();
s.getTransaction().commit();
s.close();
| | public void | testNakedImplicitJoins()
// note: simply performing syntax and column/table resolution checking in the db
Session s = openSession();
s.beginTransaction();
s.createQuery( "from Animal where mother.father.id = 1" ).list();
s.getTransaction().commit();
s.close();
| | public void | testNakedMapIndex()
// note: simply performing syntax and column/table resolution checking in the db
Session s = openSession();
s.beginTransaction();
s.createQuery( "from Zoo where mammals['dog'].description like '%black%'" ).list();
s.getTransaction().commit();
s.close();
| | public void | testNakedPropertyRef()
// note: simply performing syntax and column/table resolution checking in the db
Session s = openSession();
s.beginTransaction();
s.createQuery( "from Animal where bodyWeight = bodyWeight" ).list();
s.createQuery( "select bodyWeight from Animal" ).list();
s.createQuery( "select max(bodyWeight) from Animal" ).list();
s.getTransaction().commit();
s.close();
| | public void | testNestedCollectionFetch()
Session s = openSession();
Transaction t = s.beginTransaction();
s.createQuery("from Animal a left join fetch a.offspring o left join fetch o.offspring where a.mother.id = 1 order by a.description").list();
s.createQuery("from Zoo z left join fetch z.animals a left join fetch a.offspring where z.name ='MZ' order by a.description").list();
s.createQuery("from Human h left join fetch h.pets a left join fetch a.offspring where h.name.first ='Gavin' order by a.description").list();
t.commit();
s.close();
| | public void | testNestedComponentIsNull()
// (1) From MapTest originally...
// (2) Was then moved into HQLTest...
// (3) However, a bug fix to EntityType#getIdentifierOrUniqueKeyType (HHH-2138)
// caused the classic parser to suddenly start throwing exceptions on
// this query, apparently relying on the buggy behavior somehow; thus
// moved here to at least get some syntax checking...
//
// fyi... found and fixed the problem in the classic parser; still
// leaving here for syntax checking
new SyntaxChecker( "from Commento c where c.marelo.commento.mcompr is null" ).checkAll();
| | public void | testOneToManyFilter()
Session session = openSession();
Transaction txn = session.beginTransaction();
Product product = new Product();
product.setDescription( "My Product" );
product.setNumberAvailable( 10 );
product.setPrice( new BigDecimal( 123 ) );
product.setProductId( "4321" );
session.save( product );
Customer customer = new Customer();
customer.setCustomerId( "123456789" );
customer.setName( "My customer" );
customer.setAddress( "somewhere" );
session.save( customer );
Order order = customer.generateNewOrder( new BigDecimal( 1234 ) );
session.save( order );
LineItem li = order.generateLineItem( product, 5 );
session.save( li );
session.flush();
assertEquals( session.createFilter( customer.getOrders(), "" ).list().size(), 1 );
assertEquals( session.createFilter( order.getLineItems(), "" ).list().size(), 1 );
assertEquals( session.createFilter( order.getLineItems(), "where this.quantity > :quantity" ).setInteger( "quantity", 5 ).list().size(), 0 );
session.delete(li);
session.delete(order);
session.delete(product);
session.delete(customer);
txn.commit();
session.close();
| | public void | testOrdinalParameters()
Session s = openSession();
Transaction t = s.beginTransaction();
s.createQuery( "from Animal a where a.description = ? and a.bodyWeight = ?" )
.setString( 0, "something" )
.setFloat( 1, 123f )
.list();
s.createQuery( "from Animal a where a.bodyWeight in (?, ?)" )
.setFloat( 0, 999f )
.setFloat( 1, 123f )
.list();
t.commit();
s.close();
| | public void | testParameterMixing()
Session s = openSession();
Transaction t = s.beginTransaction();
s.createQuery( "from Animal a where a.description = ? and a.bodyWeight = ? or a.bodyWeight = :bw" )
.setString( 0, "something" )
.setFloat( 1, 12345f )
.setFloat( "bw", 123f )
.list();
t.commit();
s.close();
| | public void | testParameterTypeMismatchFailureExpected()
Session s = openSession();
s.beginTransaction();
Query query = s.createQuery( "from Animal a where a.description = :nonstring" )
.setParameter( "nonstring", new Integer(1) );
try {
query.list();
fail( "query execution should have failed" );
}
catch( TypeMismatchException tme ) {
// expected behavior
}
s.getTransaction().commit();
s.close();
| | public void | testProjectionQueries()
createTestBaseData();
Session session = openSession();
List results = session.createQuery( "select an.mother.id, max(an.bodyWeight) from Animal an group by an.mother.id" ).list();
// mysql returns nulls in this group by
assertEquals( "Incorrect result size", 2, results.size() );
assertTrue( "Incorrect return type", results.get( 0 ) instanceof Object[] );
assertEquals( "Incorrect return dimensions", 2, ( ( Object[] ) results.get( 0 ) ).length );
session.close();
destroyTestBaseData();
| | public void | testQueryMetadataRetrievalWithFetching()
// HHH-1464 : there was a problem due to the fact they we polled
// the shallow version of the query plan to get the metadata.
Session s = openSession();
Query query = s.createQuery( "from Animal a inner join fetch a.mother" );
assertEquals( 1, query.getReturnTypes().length );
assertNull( query.getReturnAliases() );
s.close();
| | public void | testResultTransformerEntityQueries()
createTestBaseData();
String query = "select an as an from Animal an order by bodyWeight desc";
Session session = openSession();
List results = session.createQuery( query )
.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list();
assertEquals( "Incorrect result size", results.size(), 2 );
assertTrue( "Incorrect return type", results.get(0) instanceof Map );
Map map = ((Map) results.get(0));
assertEquals(1, map.size());
Animal firstAnimal = (Animal) map.get("an");
map = ((Map) results.get(1));
Animal secondAnimal = (Animal) map.get("an");
assertEquals("Mammal #1", firstAnimal.getDescription());
assertEquals("Mammal #2", secondAnimal.getDescription());
assertTrue(session.contains(firstAnimal));
assertSame(firstAnimal, session.get(Animal.class,firstAnimal.getId()));
session.close();
session = openSession();
Iterator iter = session.createQuery( query )
.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).iterate();
assertTrue( "Incorrect result size", iter.hasNext() );
map = (Map) iter.next();
firstAnimal = (Animal) map.get("an");
assertEquals("Mammal #1", firstAnimal.getDescription());
assertTrue( "Incorrect result size", iter.hasNext() );
session.close();
session = openSession();
ScrollableResults sr = session.createQuery( query )
.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).scroll();
assertTrue( "Incorrect result size", sr.next() );
assertTrue( "Incorrect return type", sr.get(0) instanceof Map );
assertFalse(session.contains(sr.get(0)));
sr.close();
session.close();
destroyTestBaseData();
| | public void | testResultTransformerScalarQueries()
createTestBaseData();
String query = "select an.description as description, an.bodyWeight as bodyWeight from Animal an order by bodyWeight desc";
Session session = openSession();
List results = session.createQuery( query )
.setResultTransformer(Transformers.aliasToBean(Animal.class)).list();
assertEquals( "Incorrect result size", results.size(), 2 );
assertTrue( "Incorrect return type", results.get(0) instanceof Animal );
Animal firstAnimal = (Animal) results.get(0);
Animal secondAnimal = (Animal) results.get(1);
assertEquals("Mammal #1", firstAnimal.getDescription());
assertEquals("Mammal #2", secondAnimal.getDescription());
assertFalse(session.contains(firstAnimal));
session.close();
session = openSession();
Iterator iter = session.createQuery( query )
.setResultTransformer(Transformers.aliasToBean(Animal.class)).iterate();
assertTrue( "Incorrect result size", iter.hasNext() );
assertTrue( "Incorrect return type", iter.next() instanceof Animal );
session.close();
session = openSession();
ScrollableResults sr = session.createQuery( query )
.setResultTransformer(Transformers.aliasToBean(Animal.class)).scroll();
assertTrue( "Incorrect result size", sr.next() );
assertTrue( "Incorrect return type", sr.get(0) instanceof Animal );
assertFalse(session.contains(sr.get(0)));
sr.close();
session.close();
session = openSession();
results = session.createQuery( "select a from Animal a, Animal b order by a.id" )
.setResultTransformer(new DistinctRootEntityResultTransformer())
.list();
assertEquals( "Incorrect result size", 2, results.size());
assertTrue( "Incorrect return type", results.get(0) instanceof Animal );
firstAnimal = (Animal) results.get(0);
secondAnimal = (Animal) results.get(1);
assertEquals("Mammal #1", firstAnimal.getDescription());
assertEquals("Mammal #2", secondAnimal.getDescription());
session.close();
destroyTestBaseData();
| | public void | testSelectClauseCase()
Session s = openSession();
Transaction t = s.beginTransaction();
Human h = new Human();
h.setBodyWeight( (float) 74.0 );
h.setHeight(120.5);
h.setDescription("Me");
h.setName( new Name("Gavin", 'A", "King") );
h.setNickName("Oney");
s.persist(h);
String name = (String) s.createQuery("select case nickName when 'Oney' then 'gavin' when 'Turin' then 'christian' else nickName end from Human").uniqueResult();
assertEquals(name, "gavin");
String result = (String) s.createQuery("select case when bodyWeight > 100 then 'fat' else 'skinny' end from Human").uniqueResult();
assertEquals(result, "skinny");
s.delete(h);
t.commit();
s.close();
| | public void | testSelectClauseImplicitJoin()
Session s = openSession();
Transaction t = s.beginTransaction();
Zoo zoo = new Zoo();
zoo.setName("The Zoo");
zoo.setMammals( new HashMap() );
zoo.setAnimals( new HashMap() );
Mammal plat = new Mammal();
plat.setBodyWeight( 11f );
plat.setDescription( "Platypus" );
plat.setZoo(zoo);
plat.setSerialNumber("plat123");
zoo.getMammals().put("Platypus", plat);
zoo.getAnimals().put("plat123", plat);
s.persist( plat );
s.persist(zoo);
s.flush();
s.clear();
Query q = s.createQuery("select distinct a.zoo from Animal a where a.zoo is not null");
Type type = q.getReturnTypes()[0];
assertTrue( type instanceof ManyToOneType );
assertEquals( ( (ManyToOneType) type ).getAssociatedEntityName(), "org.hibernate.test.hql.Zoo" );
zoo = (Zoo) q.list().get(0);
assertEquals( zoo.getMammals().size(), 1 );
assertEquals( zoo.getAnimals().size(), 1 );
s.clear();
s.delete(plat);
s.delete(zoo);
t.commit();
s.close();
| | public void | testSelectClauseImplicitJoinWithIterate()
Session s = openSession();
Transaction t = s.beginTransaction();
Zoo zoo = new Zoo();
zoo.setName("The Zoo");
zoo.setMammals( new HashMap() );
zoo.setAnimals( new HashMap() );
Mammal plat = new Mammal();
plat.setBodyWeight( 11f );
plat.setDescription( "Platypus" );
plat.setZoo(zoo);
plat.setSerialNumber("plat123");
zoo.getMammals().put("Platypus", plat);
zoo.getAnimals().put("plat123", plat);
s.persist( plat );
s.persist(zoo);
s.flush();
s.clear();
Query q = s.createQuery("select distinct a.zoo from Animal a where a.zoo is not null");
Type type = q.getReturnTypes()[0];
assertTrue( type instanceof ManyToOneType );
assertEquals( ( (ManyToOneType) type ).getAssociatedEntityName(), "org.hibernate.test.hql.Zoo" );
zoo = (Zoo) q
.iterate().next();
assertEquals( zoo.getMammals().size(), 1 );
assertEquals( zoo.getAnimals().size(), 1 );
s.clear();
s.delete(plat);
s.delete(zoo);
t.commit();
s.close();
| | public void | testSelectClauseSubselect()
Session s = openSession();
Transaction t = s.beginTransaction();
Zoo zoo = new Zoo();
zoo.setName("Melbourne Zoo");
zoo.setMammals( new HashMap() );
zoo.setAnimals( new HashMap() );
Mammal plat = new Mammal();
plat.setBodyWeight( 11f );
plat.setDescription( "Platypus" );
plat.setZoo(zoo);
plat.setSerialNumber("plat123");
zoo.getMammals().put("Platypus", plat);
zoo.getAnimals().put("plat123", plat);
s.persist( plat );
s.persist(zoo);
s.createQuery("select (select max(z.id) from a.zoo z) from Animal a").list();
s.createQuery("select (select max(z.id) from a.zoo z where z.name=:name) from Animal a")
.setParameter("name", "Melbourne Zoo").list();
s.delete(plat);
s.delete(zoo);
t.commit();
s.close();
| | public void | testSelectExpressions()
createTestBaseData();
Session session = openSession();
Transaction txn = session.beginTransaction();
Human h = new Human();
h.setName( new Name("Gavin", 'A", "King") );
h.setNickName("Oney");
h.setBodyWeight(1.0f);
session.persist(h);
List results = session.createQuery("select 'found', lower(h.name.first) from Human h where lower(h.name.first) = 'gavin'").list();
results = session.createQuery("select 'found', lower(h.name.first) from Human h where concat(h.name.first, ' ', h.name.initial, ' ', h.name.last) = 'Gavin A King'").list();
results = session.createQuery("select 'found', lower(h.name.first) from Human h where h.name.first||' '||h.name.initial||' '||h.name.last = 'Gavin A King'").list();
results = session.createQuery("select a.bodyWeight + m.bodyWeight from Animal a join a.mother m").list();
results = session.createQuery("select 2.0 * (a.bodyWeight + m.bodyWeight) from Animal a join a.mother m").list();
results = session.createQuery("select sum(a.bodyWeight + m.bodyWeight) from Animal a join a.mother m").list();
results = session.createQuery("select sum(a.mother.bodyWeight * 2.0) from Animal a").list();
results = session.createQuery("select concat(h.name.first, ' ', h.name.initial, ' ', h.name.last) from Human h").list();
results = session.createQuery("select h.name.first||' '||h.name.initial||' '||h.name.last from Human h").list();
results = session.createQuery("select nickName from Human").list();
results = session.createQuery("select lower(nickName) from Human").list();
results = session.createQuery("select abs(bodyWeight*-1) from Human").list();
results = session.createQuery("select upper(h.name.first||' ('||h.nickName||')') from Human h").list();
results = session.createQuery("select abs(a.bodyWeight-:param) from Animal a").setParameter("param", new Float(2.0)).list();
results = session.createQuery("select abs(:param - a.bodyWeight) from Animal a").setParameter("param", new Float(2.0)).list();
results = session.createQuery("select lower(upper('foo')) from Animal").list();
results = session.createQuery("select lower(upper('foo') || upper('bar')) from Animal").list();
results = session.createQuery("select sum(abs(bodyWeight - 1.0) * abs(length('ffobar')-3)) from Animal").list();
session.delete(h);
txn.commit();
session.close();
destroyTestBaseData();
| | public void | testSimpleSelect()
createTestBaseData();
Session session = openSession();
List results = session.createQuery( "select a from Animal as a" ).list();
assertEquals( "Incorrect result size", 2, results.size() );
assertTrue( "Incorrect result return type", results.get( 0 ) instanceof Animal );
session.close();
destroyTestBaseData();
| | public void | testSimpleSelectWithLimitAndOffset()
if ( ! ( getDialect().supportsLimit() && getDialect().supportsLimitOffset() ) ) {
reportSkip( "dialect does not support offset and limit combo", "limit and offset combination" );
return;
}
// just checking correctness of param binding code...
Session session = openSession();
session.createQuery( "from Animal" )
.setFirstResult( 2 )
.setMaxResults( 1 )
.list();
session.close();
| | public void | testSpecialClassPropertyReference()
// this is a long standing bug in Hibernate when applied to joined-subclasses;
// see HHH-939 for details and history
new SyntaxChecker( "from Zoo zoo where zoo.class = PettingZoo" ).checkAll();
new SyntaxChecker( "select a.description from Animal a where a.class = Mammal" ).checkAll();
new SyntaxChecker( "select a.class from Animal a" ).checkAll();
new SyntaxChecker( "from DomesticAnimal an where an.class = Dog" ).checkAll();
new SyntaxChecker( "from Animal an where an.class = Dog" ).checkAll();
| | public void | testSpecialClassPropertyReferenceFQN()
// tests relating to HHH-2376
new SyntaxChecker( "from Zoo zoo where zoo.class = org.hibernate.test.hql.PettingZoo" ).checkAll();
new SyntaxChecker( "select a.description from Animal a where a.class = org.hibernate.test.hql.Mammal" ).checkAll();
new SyntaxChecker( "from DomesticAnimal an where an.class = org.hibernate.test.hql.Dog" ).checkAll();
new SyntaxChecker( "from Animal an where an.class = org.hibernate.test.hql.Dog" ).checkAll();
| | public void | testStandardFunctions()
Session session = openSession();
Transaction t = session.beginTransaction();
Product p = new Product();
p.setDescription("a product");
p.setPrice( new BigDecimal(1.0) );
p.setProductId("abc123");
session.persist(p);
Object[] result = (Object[]) session
.createQuery("select current_time(), current_date(), current_timestamp() from Product")
.uniqueResult();
assertTrue( result[0] instanceof Time );
assertTrue( result[1] instanceof Date );
assertTrue( result[2] instanceof Timestamp );
assertNotNull( result[0] );
assertNotNull( result[1] );
assertNotNull( result[2] );
session.delete(p);
t.commit();
session.close();
| | public void | testStr()
Session session = openSession();
Transaction txn = session.beginTransaction();
Animal an = new Animal();
an.setBodyWeight(123.45f);
session.persist(an);
String str = (String) session.createQuery("select str(an.bodyWeight) from Animal an where str(an.bodyWeight) like '123%' or str(an.bodyWeight) like '1.23%'").uniqueResult();
if ( getDialect() instanceof DB2Dialect ) {
assertTrue( str.startsWith("1.234") );
}
else if ( getDialect() instanceof SQLServerDialect ) {
// no assertion as SQLServer always returns nulls here; even trying directly against the
// database, it seems to have problems with str() in the where clause...
}
else {
assertTrue( str.startsWith("123.4") );
}
if ( ! ( getDialect() instanceof SybaseDialect ) ) {
// In TransactSQL (the variant spoken by Sybase and SQLServer), the str() function
// is explicitly intended for numeric values only...
String dateStr1 = (String) session.createQuery("select str(current_date) from Animal").uniqueResult();
String dateStr2 = (String) session.createQuery("select str(year(current_date))||'-'||str(month(current_date))||'-'||str(day(current_date)) from Animal").uniqueResult();
System.out.println(dateStr1 + '=" + dateStr2);
if ( ! ( getDialect() instanceof Oracle9Dialect || getDialect() instanceof Oracle8iDialect ) ) { //Oracle renders the name of the month :(
String[] dp1 = StringHelper.split("-", dateStr1);
String[] dp2 = StringHelper.split("-", dateStr2);
for (int i=0; i<3; i++) {
if ( dp1[i].startsWith( "0" ) ) {
dp1[i] = dp1[i].substring( 1 );
}
assertEquals( dp1[i], dp2[i] );
}
}
}
session.delete(an);
txn.commit();
session.close();
| | public void | testSubclassOrSuperclassPropertyReferenceInJoinedSubclass()
// this is a long standing bug in Hibernate; see HHH-1631 for details and history
//
// (1) pregnant is defined as a property of the class (Mammal) itself
// (2) description is defined as a property of the superclass (Animal)
// (3) name is defined as a property of a particular subclass (Human)
new SyntaxChecker( "from Zoo z join z.mammals as m where m.name.first = 'John'" ).checkIterate();
new SyntaxChecker( "from Zoo z join z.mammals as m where m.pregnant = false" ).checkAll();
new SyntaxChecker( "select m.pregnant from Zoo z join z.mammals as m where m.pregnant = false" ).checkAll();
new SyntaxChecker( "from Zoo z join z.mammals as m where m.description = 'tabby'" ).checkAll();
new SyntaxChecker( "select m.description from Zoo z join z.mammals as m where m.description = 'tabby'" ).checkAll();
new SyntaxChecker( "from Zoo z join z.mammals as m where m.name.first = 'John'" ).checkAll();
new SyntaxChecker( "select m.name from Zoo z join z.mammals as m where m.name.first = 'John'" ).checkAll();
new SyntaxChecker( "select m.pregnant from Zoo z join z.mammals as m" ).checkAll();
new SyntaxChecker( "select m.description from Zoo z join z.mammals as m" ).checkAll();
new SyntaxChecker( "select m.name from Zoo z join z.mammals as m" ).checkAll();
new SyntaxChecker( "from DomesticAnimal da join da.owner as o where o.nickName = 'Gavin'" ).checkAll();
new SyntaxChecker( "select da.father from DomesticAnimal da join da.owner as o where o.nickName = 'Gavin'" ).checkAll();
| | public void | testSubselectBetween()
if ( supportsSubselectOnLeftSideIn() ) {
assertResultSize( "from Animal x where (select max(a.bodyWeight) from Animal a) in (1,2,3)", 0 );
assertResultSize( "from Animal x where (select max(a.bodyWeight) from Animal a) between 0 and 100", 0 );
assertResultSize( "from Animal x where (select max(a.description) from Animal a) like 'big%'", 0 );
assertResultSize( "from Animal x where (select max(a.bodyWeight) from Animal a) is not null", 0 );
}
assertResultSize( "from Animal x where exists (select max(a.bodyWeight) from Animal a)", 0 );
| | public void | testSuperclassPropertyReferenceAfterCollectionIndexedAccess()
// note: simply performing syntax checking in the db
// test for HHH-429
Session s = openSession();
s.beginTransaction();
Mammal tiger = new Mammal();
tiger.setDescription( "Tiger" );
s.persist( tiger );
Mammal mother = new Mammal();
mother.setDescription( "Tiger's mother" );
mother.setBodyWeight( 4.0f );
mother.addOffspring( tiger );
s.persist( mother );
Zoo zoo = new Zoo();
zoo.setName( "Austin Zoo" );
zoo.setMammals( new HashMap() );
zoo.getMammals().put( "tiger", tiger );
s.persist( zoo );
s.getTransaction().commit();
s.close();
s = openSession();
s.beginTransaction();
List results = s.createQuery( "from Zoo zoo where zoo.mammals['tiger'].mother.bodyWeight > 3.0f" ).list();
assertEquals( 1, results.size() );
s.getTransaction().commit();
s.close();
s = openSession();
s.beginTransaction();
s.delete( tiger );
s.delete( mother );
s.delete( zoo );
s.getTransaction().commit();
s.close();
| | public void | testWhere()
createTestBaseData();
Session session = openSession();
List results = null;
results = session.createQuery( "from Animal an where an.bodyWeight > 10" ).list();
assertEquals( "Incorrect result size", 1, results.size() );
results = session.createQuery( "from Animal an where not an.bodyWeight > 10" ).list();
assertEquals( "Incorrect result size", 1, results.size() );
results = session.createQuery( "from Animal an where an.bodyWeight between 0 and 10" ).list();
assertEquals( "Incorrect result size", 1, results.size() );
results = session.createQuery( "from Animal an where an.bodyWeight not between 0 and 10" ).list();
assertEquals( "Incorrect result size", 1, results.size() );
results = session.createQuery( "from Animal an where sqrt(an.bodyWeight)/2 > 10" ).list();
assertEquals( "Incorrect result size", 0, results.size() );
results = session.createQuery( "from Animal an where (an.bodyWeight > 10 and an.bodyWeight < 100) or an.bodyWeight is null" ).list();
assertEquals( "Incorrect result size", 1, results.size() );
session.close();
destroyTestBaseData();
|
|
