Package org.hibernate

Examples of org.hibernate.Session.enableFilter()

227
228
229
230
231
232
233
234
235
236
237
    //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    TestData testData = new TestData();
    testData.prepare();

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

    DetachedCriteria salespersonSubquery = DetachedCriteria.forClass(Salesperson.class)
        .add(Restrictions.eq("name", "steve"))
        .setProjection(Property.forName("department"));
View Full Code Here
238
239
240
241
242
243
244
245
246
247
248
    Criteria departmentsQuery = session.createCriteria(Department.class).add(Subqueries.propertyIn("id", salespersonSubquery));
    List departments = departmentsQuery.list();

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

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

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

    session.enableFilter("region").setParameter("region", "APAC");
View Full Code Here
243
244
245
246
247
248
249
250
251
252
253
    session.enableFilter("region").setParameter("region", "Foobar");
    departments = departmentsQuery.list();

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

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

    DetachedCriteria lineItemSubquery = DetachedCriteria.forClass(LineItem.class)
        .add(Restrictions.ge("quantity", new Long(1)))
        .createCriteria("product")
        .add(Restrictions.eq("name", "Acme Hair Gel"))
View Full Code Here
258
259
260
261
262
263
264
265
266
267
268
        .add(Restrictions.eq("buyer", "gavin"))
        .list();

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

    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
259
260
261
262
263
264
265
266
267
268
269
        .list();

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

    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
278
279
280
281
282
283
284
285
286
287
288
        .add(Restrictions.eq("buyer", "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.createCriteria(Order.class)
        .add(Subqueries.exists(lineItemSubquery))
        .add(Restrictions.eq("buyer", "gavin"))
View Full Code Here
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
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
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
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
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.