Package org.hibernate.classic

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

480
481
482
483
484
485
486
487
488
489
490
    master1.addIncoming(master2);
    master2.addOutgoing(master1);
    master1.addIncoming(master3);
    master3.addOutgoing(master1);
    Serializable m1id = s.getIdentifier(master1);
    assertTrue( s.createFilter( master1.getIncoming(), "where this.id > 0 and this.name is not null" ).list().size()==2 );
    s.flush();
    s.connection().commit();
    s.close();

    s = openSession();
View Full Code Here
398
399
400
401
402
403
404
405
406
407
408
    s = openSession();
    t = s.beginTransaction();
    Detail dd = (Detail) s.load(Detail.class, did);
    master = dd.getMaster();
    assertTrue( "detail-master", master.getDetails().contains(dd) );
    assertTrue( s.createFilter( master.getDetails(), "order by this.i desc" ).list().size()==2 );
    assertTrue( s.createFilter( master.getDetails(), "select this where this.id > -1" ).list().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" );
View Full Code Here
399
400
401
402
403
404
405
406
407
408
409
    t = s.beginTransaction();
    Detail dd = (Detail) s.load(Detail.class, did);
    master = dd.getMaster();
    assertTrue( "detail-master", master.getDetails().contains(dd) );
    assertTrue( s.createFilter( master.getDetails(), "order by this.i desc" ).list().size()==2 );
    assertTrue( s.createFilter( master.getDetails(), "select this where this.id > -1" ).list().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);
View Full Code Here
400
401
402
403
404
405
406
407
408
409
410
    Detail dd = (Detail) s.load(Detail.class, did);
    master = dd.getMaster();
    assertTrue( "detail-master", master.getDetails().contains(dd) );
    assertTrue( s.createFilter( master.getDetails(), "order by this.i desc" ).list().size()==2 );
    assertTrue( s.createFilter( master.getDetails(), "select this where this.id > -1" ).list().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
403
404
405
406
407
408
409
410
411
412
413
    assertTrue( s.createFilter( master.getDetails(), "order by this.i desc" ).list().size()==2 );
    assertTrue( s.createFilter( master.getDetails(), "select this where this.id > -1" ).list().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
409
410
411
412
413
414
415
416
417
418
419
    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
    list.add(did);
    list.add( new Long(-1) );
    q.setParameterList("ids", list);
    assertTrue( q.list().size()==1 );
    assertTrue( q.iterate().hasNext() );
    assertTrue( s.createFilter( master.getDetails(), "where this.id > -1" ).list().size()==2 );
    assertTrue( s.createFilter( master.getDetails(), "select this.master where this.id > -1" ).list().size()==2 );
    assertTrue(
        s.createFilter( master.getDetails(), "select m from Master m where this.id > -1 and this.master=m" )
            .list()
            .size()==2 );
View Full Code Here
417
418
419
420
421
422
423
424
425
426
427
    list.add( new Long(-1) );
    q.setParameterList("ids", list);
    assertTrue( q.list().size()==1 );
    assertTrue( q.iterate().hasNext() );
    assertTrue( s.createFilter( master.getDetails(), "where this.id > -1" ).list().size()==2 );
    assertTrue( s.createFilter( master.getDetails(), "select this.master where this.id > -1" ).list().size()==2 );
    assertTrue(
        s.createFilter( master.getDetails(), "select m from Master m where this.id > -1 and this.master=m" )
            .list()
            .size()==2 );
    assertTrue( s.createFilter( master.getIncoming(), "where this.id > -1 and this.name is not null" ).list().size()==0 );
View Full Code Here
419
420
421
422
423
424
425
426
427
428
429
    assertTrue( q.list().size()==1 );
    assertTrue( q.iterate().hasNext() );
    assertTrue( s.createFilter( master.getDetails(), "where this.id > -1" ).list().size()==2 );
    assertTrue( s.createFilter( master.getDetails(), "select this.master where this.id > -1" ).list().size()==2 );
    assertTrue(
        s.createFilter( master.getDetails(), "select m from Master m where this.id > -1 and this.master=m" )
            .list()
            .size()==2 );
    assertTrue( s.createFilter( master.getIncoming(), "where this.id > -1 and this.name is not null" ).list().size()==0 );

    assertTrue( s.createFilter( master.getDetails(), "select max(this.i)" ).iterate().next() instanceof Integer );
View Full Code Here
422
423
424
425
426
427
428
429
430
431
432
    assertTrue( s.createFilter( master.getDetails(), "select this.master where this.id > -1" ).list().size()==2 );
    assertTrue(
        s.createFilter( master.getDetails(), "select m from Master m where this.id > -1 and this.master=m" )
            .list()
            .size()==2 );
    assertTrue( s.createFilter( master.getIncoming(), "where this.id > -1 and this.name is not null" ).list().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 );

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.