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();
    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

    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

        .size() == 1
      );
    }
    assertTrue( s.contains(cd) );
    if ( !(getDialect() instanceof MySQLDialect) && !(getDialect() instanceof HSQLDialect) )  {
      s.filter( c.getBag(), "where 0 in elements(this.bag)" );
      s.filter( c.getBag(), "where 0 in elements(this.lazyBag)" );
    }
    s.find("select count(comp.name) from ContainerX c join c.components comp");
    s.delete(cd);
    s.delete(c);

View Full Code Here

      );
    }
    assertTrue( s.contains(cd) );
    if ( !(getDialect() instanceof MySQLDialect) && !(getDialect() instanceof HSQLDialect) )  {
      s.filter( c.getBag(), "where 0 in elements(this.bag)" );
      s.filter( c.getBag(), "where 0 in elements(this.lazyBag)" );
    }
    s.find("select count(comp.name) from ContainerX c join c.components comp");
    s.delete(cd);
    s.delete(c);
    s.delete(s1);

View Full Code Here

      assertTrue( ( (Object[]) iter.next() )[1] instanceof Fum );
    }
    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() );

View Full Code Here

    }
    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'");

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 = 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

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.