Examples of enableFilter()

Examples of org.hibernate.Session.enableFilter()

342
343
344
345
346
347
348
349
350
351
352
    orders = session.createQuery("select o from Order as o where exists (select li.id from LineItem li where li.quantity >= :quantity and li.product in (select p.id from Product p where p.name = :name)) and o.buyer = :buyer")
        .setLong("quantity", 1L).setString("name", "Acme Hair Gel").setString("buyer", "gavin").list();

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

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

    orders = session.createQuery("select o from Order as o where exists (select li.id from LineItem li where li.quantity >= ? and li.product in (select p.id from Product p where p.name = ?)) and o.buyer = :buyer")
        .setLong(0, 1L).setString(1, "Acme Hair Gel").setString("buyer", "gavin").list();
View Full Code Here

Examples of org.hibernate.Session.enableFilter()

343
344
345
346
347
348
349
350
351
352
353
        .setLong("quantity", 1L).setString("name", "Acme Hair Gel").setString("buyer", "gavin").list();

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

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

    orders = session.createQuery("select o from Order as o where exists (select li.id from LineItem li where li.quantity >= ? and li.product in (select p.id from Product p where p.name = ?)) and o.buyer = :buyer")
        .setLong(0, 1L).setString(1, "Acme Hair Gel").setString("buyer", "gavin").list();

    assertEquals("Incorrect orders count", 1, orders.size());
View Full Code Here

Examples of org.hibernate.Session.enableFilter()

368
369
370
371
372
373
374
375
376
377
378
    // first a control-group query
    List result = session.createQuery( queryString ).setParameter( 0, "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( 0, "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

Examples of org.hibernate.Session.enableFilter()

373
374
375
376
377
378
379
380
381
382
383
    session.enableFilter( "fulfilledOrders" ).setParameter( "asOfDate", testData.lastMonth.getTime() );
    result = session.createQuery( queryString ).setParameter( 0, "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( 0, "steve" ).list();
    assertEquals( 1, result.size() );

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

Examples of org.hibernate.Session.enableFilter()

378
379
380
381
382
383
384
385
386
387
388
    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

Examples of org.hibernate.Session.enableFilter()

402
403
404
405
406
407
408
409
410
411
412
    // 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

Examples of org.hibernate.Session.enableFilter()

407
408
409
410
411
412
413
414
415
416
417
    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

Examples of org.hibernate.Session.enableFilter()

412
413
414
415
416
417
418
419
420
421
422
    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

Examples of org.hibernate.Session.enableFilter()

438
439
440
441
442
443
444
445
446
447
448
    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

Examples of org.hibernate.Session.enableFilter()

462
463
464
465
466
467
468
469
470
471
472
    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
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.