Examples of org.hibernate.Session.enableFilter()

org.hibernate.Session.enableFilter()
Enable the named filter for this current session. @param filterName The name of the filter to be enabled. @return The Filter instance representing the enabled fiter.

    log.info( "Starting HQL filter with custom SQL get/set tests" );
    TestData testData = new TestData();
    testData.prepare();


    Session session = openSession();
    session.enableFilter( "heavyProducts" ).setParameter("weightKilograms", 4d);
    log.info( "HQL against Product..." );
    List results = session.createQuery( "from Product").list();
    assertEquals( 1, results.size() );


    session.close();

View Full Code Here

    log.info( "Starting Criteria-query filter tests" );
    TestData testData = new TestData();
    testData.prepare();


    Session session = openSession();
    session.enableFilter( "region" ).setParameter( "region", "APAC" );


    session.enableFilter( "fulfilledOrders" )
            .setParameter( "asOfDate", testData.lastMonth.getTime() );


    session.enableFilter( "effectiveDate" )

View Full Code Here

    testData.prepare();


    Session session = openSession();
    session.enableFilter( "region" ).setParameter( "region", "APAC" );


    session.enableFilter( "fulfilledOrders" )
            .setParameter( "asOfDate", testData.lastMonth.getTime() );


    session.enableFilter( "effectiveDate" )
            .setParameter( "asOfDate", testData.lastMonth.getTime() );

View Full Code Here

    session.enableFilter( "region" ).setParameter( "region", "APAC" );


    session.enableFilter( "fulfilledOrders" )
            .setParameter( "asOfDate", testData.lastMonth.getTime() );


    session.enableFilter( "effectiveDate" )
            .setParameter( "asOfDate", testData.lastMonth.getTime() );


    log.info( "Criteria query against Salesperson..." );
    List salespersons = session.createCriteria( Salesperson.class )
            .setFetchMode( "orders", FetchMode.JOIN )

View Full Code Here

    DetachedCriteria subquery = DetachedCriteria.forClass( Salesperson.class )
        .setProjection( Property.forName( "name" ) );


    Session session = openSession();
    session.beginTransaction();
    session.enableFilter( "fulfilledOrders" ).setParameter( "asOfDate", testData.lastMonth.getTime() );
    session.enableFilter( "regionlist" ).setParameterList( "regions", new String[] { "APAC" } );


    List result = session.createCriteria( Order.class )
        .add( Subqueries.in( "steve", subquery ) )
        .list();

View Full Code Here

        .setProjection( Property.forName( "name" ) );


    Session session = openSession();
    session.beginTransaction();
    session.enableFilter( "fulfilledOrders" ).setParameter( "asOfDate", testData.lastMonth.getTime() );
    session.enableFilter( "regionlist" ).setParameterList( "regions", new String[] { "APAC" } );


    List result = session.createCriteria( Order.class )
        .add( Subqueries.in( "steve", subquery ) )
        .list();
    assertEquals( 1, result.size() );

View Full Code Here

    log.info("Starting Criteria-subquery filter tests");
    TestData testData = new TestData();
    testData.prepare();


    Session session = openSession();
    session.enableFilter("region").setParameter("region", "APAC");


    log.info("Criteria query against Department with a subquery on Salesperson in the APAC reqion...");
    DetachedCriteria salespersonSubquery = DetachedCriteria.forClass(Salesperson.class)
        .add(Restrictions.eq("name", "steve"))
        .setProjection(Property.forName("department"));

View Full Code Here


    assertEquals("Incorrect department count", 1, departments.size());


    log.info("Criteria query against Department with a subquery on Salesperson in the FooBar reqion...");


    session.enableFilter("region").setParameter("region", "Foobar");
    departments = departmentsQuery.list();


    assertEquals("Incorrect department count", 0, departments.size());


    log.info("Criteria query against Order with a subquery for line items with a subquery on product and sold by a given sales person...");

View Full Code Here

    departments = departmentsQuery.list();


    assertEquals("Incorrect department count", 0, departments.size());


    log.info("Criteria query against Order with a subquery for line items with a subquery on product and sold by a given sales person...");
    session.enableFilter("region").setParameter("region", "APAC");


    DetachedCriteria lineItemSubquery = DetachedCriteria.forClass(LineItem.class)
        .add( Restrictions.ge( "quantity", 1L ) )
        .createCriteria( "product" )
        .add( Restrictions.eq( "name", "Acme Hair Gel" ) )

View Full Code Here

        .list();


    assertEquals("Incorrect orders count", 1, orders.size());


    log.info("query against Order with a subquery for line items with a subquery line items where the product name is Acme Hair Gel and the quantity is greater than 1 in a given region and the product is effective as of last month");
    session.enableFilter("region").setParameter("region", "APAC");
    session.enableFilter("effectiveDate").setParameter("asOfDate", testData.lastMonth.getTime());


    DetachedCriteria productSubquery = DetachedCriteria.forClass(Product.class)
        .add(Restrictions.eq("name", "Acme Hair Gel"))
        .setProjection(Property.forName("id"));

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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.