Examples of enableFilter()

Examples of org.hibernate.Session.enableFilter()

279
280
281
282
283
284
285
286
287
288
289
        .list();

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

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

    orders = session.createCriteria(Order.class)
        .add(Subqueries.exists(lineItemSubquery))
        .add(Restrictions.eq("buyer", "gavin"))
        .list();
View Full Code Here

Examples of org.hibernate.Session.enableFilter()

300
301
302
303
304
305
306
307
308
309
310
    //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    TestData testData = new TestData();
    testData.prepare();

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

    List departments = session.createQuery("select d from Department as d where d.id in (select s.department from Salesperson s where s.name = ?)").setString(0, "steve").list();

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

Examples of org.hibernate.Session.enableFilter()

306
307
308
309
310
311
312
313
314
315
316
    List departments = session.createQuery("select d from Department as d where d.id in (select s.department from Salesperson s where s.name = ?)").setString(0, "steve").list();

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

    session.enableFilter("region").setParameter("region", "Foobar");
    departments = session.createQuery("select d from Department as d where d.id in (select s.department from Salesperson s where s.name = ?)").setString(0, "steve").list();

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

    session.enableFilter("region").setParameter("region", "APAC");
View Full Code Here

Examples of org.hibernate.Session.enableFilter()

311
312
313
314
315
316
317
318
319
320
321
    session.enableFilter("region").setParameter("region", "Foobar");
    departments = session.createQuery("select d from Department as d where d.id in (select s.department from Salesperson s where s.name = ?)").setString(0, "steve").list();

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

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

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

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

Examples of org.hibernate.Session.enableFilter()

318
319
320
321
322
323
324
325
326
327
328
    List orders = session.createQuery("select o from Order as o where exists (select li.id from LineItem li, Product as p where p.id = li.product and li.quantity >= ? and p.name = ?) and o.buyer = ?")
        .setLong(0, 1L).setString(1, "Acme Hair Gel").setString(2, "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 = ?")
        .setLong(0, 1L).setString(1, "Acme Hair Gel").setString(2, "gavin").list();
View Full Code Here

Examples of org.hibernate.Session.enableFilter()

319
320
321
322
323
324
325
326
327
328
329
        .setLong(0, 1L).setString(1, "Acme Hair Gel").setString(2, "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 = ?")
        .setLong(0, 1L).setString(1, "Acme Hair Gel").setString(2, "gavin").list();

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

Examples of org.hibernate.Session.enableFilter()

326
327
328
329
330
331
332
333
334
335
336
    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 = ?")
        .setLong(0, 1L).setString(1, "Acme Hair Gel").setString(2, "gavin").list();

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

    session.enableFilter("region").setParameter("region", "APAC");
    session.enableFilter("effectiveDate").setParameter("asOfDate", testData.fourMonthsAgo.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 = ?")
        .setLong(0, 1L).setString(1, "Acme Hair Gel").setString(2, "gavin").list();
View Full Code Here

Examples of org.hibernate.Session.enableFilter()

327
328
329
330
331
332
333
334
335
336
337
        .setLong(0, 1L).setString(1, "Acme Hair Gel").setString(2, "gavin").list();

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

    session.enableFilter("region").setParameter("region", "APAC");
    session.enableFilter("effectiveDate").setParameter("asOfDate", testData.fourMonthsAgo.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 = ?")
        .setLong(0, 1L).setString(1, "Acme Hair Gel").setString(2, "gavin").list();

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

Examples of org.hibernate.Session.enableFilter()

334
335
336
337
338
339
340
341
342
343
344
    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 = ?")
        .setLong(0, 1L).setString(1, "Acme Hair Gel").setString(2, "gavin").list();

    assertEquals("Incorrect orders count", 0, 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 >= :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();
View Full Code Here

Examples of org.hibernate.Session.enableFilter()

335
336
337
338
339
340
341
342
343
344
345
        .setLong(0, 1L).setString(1, "Acme Hair Gel").setString(2, "gavin").list();

    assertEquals("Incorrect orders count", 0, 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 >= :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());
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.