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

org.hibernate.classic.Session.filter()
Apply a filter to a persistent collection. A filter is a Hibernate query that may refer to this, the collection element. Filters allow efficient access to very large lazy collections. (Executing the filter does not initialize the collection.) @deprecated use {@link #createFilter(Object,String)}. {@link Query#list} @param collection a persistent collection to filter @param filter a filter query string @return Collection the resulting collection @throws HibernateException

    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.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" );

View Full Code Here

    t = s.beginTransaction();
    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);

View Full Code Here

    list.add(did);
    list.add( new Long(-1) );
    q.setParameterList("ids", list);
    assertTrue( q.list().size()==1 );
    assertTrue( q.iterate().hasNext() );
    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 );

View Full Code Here

    list.add( new Long(-1) );
    q.setParameterList("ids", list);
    assertTrue( q.list().size()==1 );
    assertTrue( q.iterate().hasNext() );
    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 );

View Full Code Here

    q.setParameterList("ids", list);
    assertTrue( q.list().size()==1 );
    assertTrue( q.iterate().hasNext() );
    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 );

View Full Code Here

    assertTrue( q.list().size()==1 );
    assertTrue( q.iterate().hasNext() );
    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 );

View Full Code Here

    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);
    f.setInteger("bottom", 0);

View Full Code Here

    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);
    f.setInteger("bottom", 0);
    assertEquals( f.iterate().next(), new Integer(12) );

View Full Code Here

    master1.addIncoming(master2);
    master2.addOutgoing(master1);
    master1.addIncoming(master3);
    master3.addOutgoing(master1);
    Serializable m1id = s.getIdentifier(master1);
    assertTrue( s.filter( master1.getIncoming(), "where this.id > 0 and this.name is not null").size()==2 );
    s.flush();
    s.connection().commit();
    s.close();


    s = openSession();

View Full Code Here

    s.save(baz);
    Glarch g = new Glarch();
    Serializable gid = s.save(g);


    if ( !(getDialect() instanceof MySQLDialect) && !(getDialect() instanceof HSQLDialect) /*&& !(dialect instanceof MckoiDialect)*/ && !(getDialect() instanceof SAPDBDialect) && !(getDialect() instanceof PointbaseDialect) && !(getDialect() instanceof TimesTenDialect) ) {
      s.filter( baz.getFooArray(), "where size(this.bytes) > 0");
      s.filter( baz.getFooArray(), "where 0 in elements(this.bytes)");
    }
    s.flush();
    s.connection().commit();
    s.close();

View Full Code Here

0 1 2 3 4 5 6

TOP

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.