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

    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

    assertTrue( s.find("select elements(sm.children) from SubMulti as sm").size()==2 );
    assertTrue( s.find("select distinct sm from SubMulti as sm join sm.children as s where s.amount>-1 and s.name is null").size()==1 );
    sm = (SubMulti) s.load(SubMulti.class, id);
    assertTrue( sm.getChildren().size()==2 );
    assertEquals(
      s.filter( sm.getMoreChildren(), "select count(*) where this.amount>-1 and this.name is null" ).iterator().next(),
      new Long(2)
    );
    assertEquals( "FOO", sm.getDerived() );
    assertSame(
      s.iterate("select distinct s from SubMulti s where s.moreChildren[1].amount < 1.0").next(),

View Full Code Here

    s = openSession();
    baz = (Baz) s.load( Baz.class, baz.getCode() );
    assertTrue( baz.getFooArray().length==1 );
    assertTrue( s.find("from Baz baz join baz.fooArray foo").size()==1 );
    assertTrue( s.find("from Foo foo").size()==2 );
    assertTrue( s.filter( baz.getFooArray(), "" ).size()==1 );
    //assertTrue( s.delete("from java.lang.Object o")==9 );
    s.delete("from Foo foo");
    String bazid = baz.getCode();
    s.delete(baz);
    int rows=s.connection().createStatement().executeUpdate(

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.