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.

    session.enableFilter( "regionlist" ).setParameterList( "regions", new String[] { "APAC" } );
    result = session.createQuery( queryString ).setParameter( 0, "steve" ).list();
    assertEquals( 1, result.size() );


    // ... then a silly one...
    session.enableFilter( "regionlist" ).setParameterList( "regions", new String[] { "gamma quadrant" } );
    result = session.createQuery( queryString ).setParameter( 0, "steve" ).list();
    assertEquals( 0, result.size() );


    session.getTransaction().commit();
    session.close();

View Full Code Here

    // first a control-group query
    List result = session.createQuery( queryString ).setParameter( "salesPersonName", "steve" ).list();
    assertEquals( 2, result.size() );


    // now lets enable filters on Order...
    session.enableFilter( "fulfilledOrders" ).setParameter( "asOfDate", testData.lastMonth.getTime() );
    result = session.createQuery( queryString ).setParameter( "salesPersonName", "steve" ).list();
    assertEquals( 1, result.size() );


    // now, lets additionally enable filter on Salesperson.  First a valid one...
    session.enableFilter( "regionlist" ).setParameterList( "regions", new String[] { "APAC" } );

View Full Code Here

    session.enableFilter( "fulfilledOrders" ).setParameter( "asOfDate", testData.lastMonth.getTime() );
    result = session.createQuery( queryString ).setParameter( "salesPersonName", "steve" ).list();
    assertEquals( 1, result.size() );


    // now, lets additionally enable filter on Salesperson.  First a valid one...
    session.enableFilter( "regionlist" ).setParameterList( "regions", new String[] { "APAC" } );
    result = session.createQuery( queryString ).setParameter( "salesPersonName", "steve" ).list();
    assertEquals( 1, result.size() );


    // ... then a silly one...
    session.enableFilter( "regionlist" ).setParameterList( "regions", new String[] { "gamma quadrant" } );

View Full Code Here

    session.enableFilter( "regionlist" ).setParameterList( "regions", new String[] { "APAC" } );
    result = session.createQuery( queryString ).setParameter( "salesPersonName", "steve" ).list();
    assertEquals( 1, result.size() );


    // ... then a silly one...
    session.enableFilter( "regionlist" ).setParameterList( "regions", new String[] { "gamma quadrant" } );
    result = session.createQuery( queryString ).setParameter( "salesPersonName", "steve" ).list();
    assertEquals( 0, result.size() );


    session.getTransaction().commit();
    session.close();

View Full Code Here

    session.getTransaction().commit();
    session.close();


    session = openSession();
    session.beginTransaction();
    session.enableFilter( "region" ).setParameter( "region", "NA" );
    int count = session.createQuery( "delete from Salesperson" ).executeUpdate();
    assertEquals( 1, count );
    session.delete( sp2 );
    session.getTransaction().commit();
    session.close();

View Full Code Here

    session.getTransaction().commit();
    session.close();


    session = openSession();
    session.beginTransaction();
    session.enableFilter( "region" ).setParameter( "region", "NA" );
    int count = session.createQuery( "delete from Salesperson" ).executeUpdate();
    assertEquals( 1, count );
    session.delete( sp2 );
    session.getTransaction().commit();
    session.close();

View Full Code Here

    //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    TestData testData = new TestData();
    testData.prepare();


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


    Salesperson salesperson = ( Salesperson ) session.get( Salesperson.class, testData.steveId );
    assertNotNull( salesperson );
    assertEquals( "Incorrect order count", 1, salesperson.getOrders().size() );

View Full Code Here

    //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    TestData testData = new TestData();
    testData.prepare();


    Session session = openSession();
    session.enableFilter( "seniorSalespersons" )
            .setParameter( "asOfDate", testData.lastMonth.getTime() );


    Department department = ( Department ) session.load( Department.class, testData.deptId );
    Set salespersons = department.getSalespersons();
    assertEquals( "Incorrect salesperson count", 1, salespersons.size() );

View Full Code Here

    //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    TestData testData = new TestData();
    testData.prepare();


    Session session = openSession();
    session.enableFilter( "regionlist" )
            .setParameterList( "regions", new String[]{"LA", "APAC"} );


    List salespersons = session.createQuery( "from Salesperson" ).list();
    assertEquals( "Incorrect salesperson count", 1, salespersons.size() );

View Full Code Here

  public void testManyToManyFilterOnCriteria() {
    TestData testData = new TestData();
    testData.prepare();


    Session session = openSession();
    session.enableFilter( "effectiveDate" ).setParameter( "asOfDate", new Date() );


    Product prod = ( Product ) session.createCriteria( Product.class )
            .setResultTransformer( new DistinctRootEntityResultTransformer() )
            .add( Restrictions.eq( "id", testData.prod1Id ) )
            .uniqueResult();

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.