Package org.hibernate.classic

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

424
425
426
427
428
429
430
431
432
433
434
        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 );

    assertTrue( s.createFilter( master.getDetails(), "select this.master" ).list().size()==2 );
    assertTrue( s.createFilter( master.getMoreDetails(), "" ).list().size()==0 );
View Full Code Here
425
426
427
428
429
430
431
432
433
434
435
            .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 );

    assertTrue( s.createFilter( master.getDetails(), "select this.master" ).list().size()==2 );
    assertTrue( s.createFilter( master.getMoreDetails(), "" ).list().size()==0 );
    assertTrue( s.createFilter( master.getIncoming(), "" ).list().size()==0 );
View Full Code Here
426
427
428
429
430
431
432
433
434
435
436
            .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 );

    assertTrue( s.createFilter( master.getDetails(), "select this.master" ).list().size()==2 );
    assertTrue( s.createFilter( master.getMoreDetails(), "" ).list().size()==0 );
    assertTrue( s.createFilter( master.getIncoming(), "" ).list().size()==0 );

View Full Code Here
428
429
430
431
432
433
434
435
436
437
438
    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.createFilter( master.getMoreDetails(), "" ).list().size()==0 );
    assertTrue( s.createFilter( master.getIncoming(), "" ).list().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
429
430
431
432
433
434
435
436
437
438
439
    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.createFilter( master.getMoreDetails(), "" ).list().size()==0 );
    assertTrue( s.createFilter( master.getIncoming(), "" ).list().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);
View Full Code Here
430
431
432
433
434
435
436
437
438
439
440
    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.createFilter( master.getMoreDetails(), "" ).list().size()==0 );
    assertTrue( s.createFilter( master.getIncoming(), "" ).list().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) );
View Full Code Here
432
433
434
435
436
437
438
439
440
441
442
    assertTrue( s.createFilter( master.getDetails(), "select this.master" ).list().size()==2 );
    assertTrue( s.createFilter( master.getMoreDetails(), "" ).list().size()==0 );
    assertTrue( s.createFilter( master.getIncoming(), "" ).list().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
439
440
441
442
443
444
445
446
447
448
449
    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
447
448
449
450
451
452
453
454
455
456
457
    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
136
137
138
139
140
141
142
143
144
145
146
            "select distinct sm from SubMulti as sm join sm.children as s where s.amount>-1 and s.name is null"
        ).list().size()==1 );
    sm = (SubMulti) s.load(SubMulti.class, id);
    assertTrue( sm.getChildren().size()==2 );
    assertEquals(
      s.createFilter( sm.getMoreChildren(), "select count(*) where this.amount>-1 and this.name is null" ).list().get(0),
      new Long(2)
    );
    assertEquals( "FOO", sm.getDerived() );
    assertSame(
        s.createQuery( "select distinct s from SubMulti s where s.moreChildren[1].amount < 1.0" ).iterate().next(),
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.