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

    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

        .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

      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

        .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

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.