Package org.hibernate.classic

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

418
419
420
421
422
423
424
425
426
427
428
    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
420
421
422
423
424
425
426
427
428
429
430
    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
424
425
426
427
428
429
430
431
432
433
434
    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
431
432
433
434
435
436
437
438
439
440
441
    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
439
440
441
442
443
444
445
446
447
448
449
    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
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
62
63
64
65
66
67
68
69
            throw new NullPointerException("EntityManager is null - needs to be injected.");
        }

        Session session = (Session) entityManager.getDelegate();

        return ((Long) session.createFilter(collection, "select count(*)").list().get(0)).longValue();
    }
}
View Full Code Here
466
467
468
469
470
471
472
473
474
475
476
    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
352
353
354
355
356
357
358
359
360
361
362
    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
383
384
385
386
387
388
389
390
391
392
393
    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
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.