Package org.hibernate.classic

Examples of org.hibernate.classic.Session.createFilter()

425
426
427
428
429
430
431
432
433
434
435
    assertTrue( s.createFilter( master.getDetails(), "select this.master" ).list().size()==2 );
    assertTrue( s.filter( master.getMoreDetails(), "" ).size()==0 );
    assertTrue( s.filter( master.getIncoming(), "" ).size()==0 );

    Query f = s.createFilter( master.getDetails(), "select max(this.i) where this.i < :top and this.i>=:bottom" );
    f.setInteger("top", 100);
    f.setInteger("bottom", 0);
    assertEquals( f.iterate().next(), new Integer(12) );
    f.setInteger("top", 2);
    assertEquals( f.iterate().next(), new Integer(0) );
View Full Code Here
432
433
434
435
436
437
438
439
440
441
442
    f.setInteger("bottom", 0);
    assertEquals( f.iterate().next(), new Integer(12) );
    f.setInteger("top", 2);
    assertEquals( f.iterate().next(), new Integer(0) );

    f = s.createFilter( master.getDetails(), "select max(this.i) where this.i not in (:list)" );
    Collection coll = new ArrayList();
    coll.add( new Integer(-666) );
    coll.add( new Integer(22) );
    coll.add( new Integer(0) );
    f.setParameterList("list", coll);
View Full Code Here
440
441
442
443
444
445
446
447
448
449
450
    coll.add( new Integer(22) );
    coll.add( new Integer(0) );
    f.setParameterList("list", coll);
    assertEquals( f.iterate().next(), new Integer(12) );

    f = s.createFilter( master.getDetails(), "select max(this.i) where this.i not in (:list) and this.master.name = :listy2" );
    f.setParameterList("list", coll);
    f.setParameter( "listy2", master.getName() );
    assertEquals( f.iterate().next(), new Integer(12) );

    iter = master.getDetails().iterator();
View Full Code Here
358
359
360
361
362
363
364
365
366
367
368
    assertTrue( s.createCriteria(Part.class).list().size()==1 ); //there is a where condition on Part mapping
    assertTrue( s.createCriteria(Part.class).add( Restrictions.eq( "id", p1.getId() ) ).list().size()==1 );
    assertTrue( s.createQuery("from Part").list().size()==1 );
    assertTrue( s.createQuery("from Baz baz join baz.parts").list().size()==2 );
    baz = (Baz) s.createCriteria(Baz.class).uniqueResult();
    assertTrue( s.createFilter( baz.getParts(), "" ).list().size()==2 );
    //assertTrue( baz.getParts().size()==1 );
    s.delete( s.get( Part.class, p1.getId() ));
    s.delete( s.get( Part.class, p2.getId() ));
    s.delete(baz);
    t.commit();
View Full Code Here
389
390
391
392
393
394
395
396
397
398
399
    assertTrue( s.createCriteria(Part.class).list().size()==1 ); //there is a where condition on Part mapping
    assertTrue( s.createCriteria(Part.class).add( Restrictions.eq( "id", p1.getId() ) ).list().size()==1 );
    assertTrue( s.createQuery("from Part").list().size()==1 );
    assertTrue( s.createQuery("from Baz baz join baz.moreParts").list().size()==2 );
    baz = (Baz) s.createCriteria(Baz.class).uniqueResult();
    assertTrue( s.createFilter( baz.getMoreParts(), "" ).list().size()==2 );
    //assertTrue( baz.getParts().size()==1 );
    s.delete( s.get( Part.class, p1.getId() ));
    s.delete( s.get( Part.class, p2.getId() ));
    s.delete(baz);
    t.commit();
View Full Code Here
395
396
397
398
399
400
401
402
403
404
405
    Detail dd = (Detail) s.load(Detail.class, did);
    master = dd.getMaster();
    assertTrue( "detail-master", master.getDetails().contains(dd) );
    assertTrue( s.filter( master.getDetails(), "order by this.i desc").size()==2 );
    assertTrue( s.filter( master.getDetails(), "select this where this.id > -1").size()==2 );
    Query q = s.createFilter( master.getDetails(), "where this.id > :id" );
    q.setInteger("id", -1);
    assertTrue( q.list().size()==2 );
    q = s.createFilter( master.getDetails(), "where this.id > :id1 and this.id < :id2" );
    q.setInteger("id1", -1);
    q.setInteger("id2", 99999999);
View Full Code Here
398
399
400
401
402
403
404
405
406
407
408
    assertTrue( s.filter( master.getDetails(), "order by this.i desc").size()==2 );
    assertTrue( s.filter( master.getDetails(), "select this where this.id > -1").size()==2 );
    Query q = s.createFilter( master.getDetails(), "where this.id > :id" );
    q.setInteger("id", -1);
    assertTrue( q.list().size()==2 );
    q = s.createFilter( master.getDetails(), "where this.id > :id1 and this.id < :id2" );
    q.setInteger("id1", -1);
    q.setInteger("id2", 99999999);
    assertTrue( q.list().size()==2 );
    q.setInteger("id2", -1);
    assertTrue( q.list().size()==0 );
View Full Code Here
404
405
406
407
408
409
410
411
412
413
414
    q.setInteger("id1", -1);
    q.setInteger("id2", 99999999);
    assertTrue( q.list().size()==2 );
    q.setInteger("id2", -1);
    assertTrue( q.list().size()==0 );
    q = s.createFilter( master.getDetails(), "where this.id in (:ids)" );
    list = new ArrayList();
    list.add(did);
    list.add( new Long(-1) );
    q.setParameterList("ids", list);
    assertTrue( q.list().size()==1 );
View Full Code Here
416
417
418
419
420
421
422
423
424
425
426
    assertTrue( s.filter( master.getDetails(), "where this.id > -1").size()==2 );
    assertTrue( s.filter( master.getDetails(), "select this.master where this.id > -1").size()==2 );
    assertTrue( s.filter( master.getDetails(), "select m from Master m where this.id > -1 and this.master=m").size()==2 );
    assertTrue( s.filter( master.getIncoming(), "where this.id > -1 and this.name is not null").size()==0 );

    assertTrue( s.createFilter( master.getDetails(), "select max(this.i)" ).iterate().next() instanceof Integer );
    assertTrue( s.createFilter( master.getDetails(), "select max(this.i) group by this.id" ).iterate().next() instanceof Integer );
    assertTrue( s.createFilter( master.getDetails(), "select count(*)" ).iterate().next() instanceof Long );

    assertTrue( s.createFilter( master.getDetails(), "select this.master" ).list().size()==2 );
    assertTrue( s.filter( master.getMoreDetails(), "" ).size()==0 );
View Full Code Here
417
418
419
420
421
422
423
424
425
426
427
    assertTrue( s.filter( master.getDetails(), "select this.master where this.id > -1").size()==2 );
    assertTrue( s.filter( master.getDetails(), "select m from Master m where this.id > -1 and this.master=m").size()==2 );
    assertTrue( s.filter( master.getIncoming(), "where this.id > -1 and this.name is not null").size()==0 );

    assertTrue( s.createFilter( master.getDetails(), "select max(this.i)" ).iterate().next() instanceof Integer );
    assertTrue( s.createFilter( master.getDetails(), "select max(this.i) group by this.id" ).iterate().next() instanceof Integer );
    assertTrue( s.createFilter( master.getDetails(), "select count(*)" ).iterate().next() instanceof Long );

    assertTrue( s.createFilter( master.getDetails(), "select this.master" ).list().size()==2 );
    assertTrue( s.filter( master.getMoreDetails(), "" ).size()==0 );
    assertTrue( s.filter( master.getIncoming(), "" ).size()==0 );
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.