Package org.hibernate.classic

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

359
360
361
362
363
364
365
366
367
368
369
    assertTrue( s.createCriteria(Part.class).list().size()==1 ); //there is a where condition on Part mapping
    assertTrue( s.createCriteria(Part.class).add( Expression.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
390
391
392
393
394
395
396
397
398
399
400
    assertTrue( s.createCriteria(Part.class).list().size()==1 ); //there is a where condition on Part mapping
    assertTrue( s.createCriteria(Part.class).add( Expression.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
467
468
469
470
471
472
473
474
475
476
477
    assertTrue( "iterate on composite key", j==8 );

    fum = (Fum) s.load( Fum.class, fum.getId() );
    s.filter( fum.getQuxArray(), "where this.foo is null" );
    s.filter( fum.getQuxArray(), "where this.foo.id = ?", "fooid", Hibernate.STRING );
    Query f = s.createFilter( fum.getQuxArray(), "where this.foo.id = :fooId" );
    f.setString("fooId", "abc");
    assertFalse( f.iterate().hasNext() );

    iter = s.iterate("from Fum fum where not fum.fum='FRIEND'");
    int i = 0;
View Full Code Here
396
397
398
399
400
401
402
403
404
405
406
    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
399
400
401
402
403
404
405
406
407
408
409
    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
405
406
407
408
409
410
411
412
413
414
415
    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
417
418
419
420
421
422
423
424
425
426
427
    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
418
419
420
421
422
423
424
425
426
427
428
    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
419
420
421
422
423
424
425
426
427
428
429
    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
421
422
423
424
425
426
427
428
429
430
431
    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 );

    Query f = s.createFilter( master.getDetails(), "select max(this.i) where this.i < :top and this.i>=:bottom" );
    f.setInteger("top", 100);
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.