@Test public void testNegativeLowerBound() { DynamicQuery dynamicQuery = ClassNameLocalServiceUtil.dynamicQuery(); dynamicQuery.addOrder(OrderFactoryUtil.asc("classNameId")); dynamicQuery.setLimit(-50, _allClassNames.size()); Assert.assertEquals( _allClassNames, ClassNameLocalServiceUtil.<ClassName>dynamicQuery(dynamicQuery)); }
@Test public void testUpperBound() { DynamicQuery dynamicQuery = ClassNameLocalServiceUtil.dynamicQuery(); dynamicQuery.addOrder(OrderFactoryUtil.asc("classNameId")); dynamicQuery.setLimit(QueryUtil.ALL_POS, 10); Assert.assertEquals( _allClassNames.subList(0, 10), ClassNameLocalServiceUtil.<ClassName>dynamicQuery(dynamicQuery)); }
@Test public void testSingleResult() { DynamicQuery dynamicQuery = ClassNameLocalServiceUtil.dynamicQuery(); dynamicQuery.addOrder(OrderFactoryUtil.asc("classNameId")); dynamicQuery.setLimit(10, 11); List<ClassName> dynamicQueryClassNames = ClassNameLocalServiceUtil.dynamicQuery(dynamicQuery); Assert.assertEquals(1, dynamicQueryClassNames.size()); Assert.assertEquals(_allClassNames.get(10), dynamicQueryClassNames.get(0)); }
@Test public void testNoLimit() { DynamicQuery dynamicQuery = ClassNameLocalServiceUtil.dynamicQuery(); dynamicQuery.addOrder(OrderFactoryUtil.asc("classNameId")); List<ClassName> classNames = ClassNameLocalServiceUtil.dynamicQuery(dynamicQuery); for (ClassName className : _allClassNames) { if (!classNames.contains(className)) { Assert.fail("Class names do not contain " + className); } } }
public int populateMessages( List<Message> messages, long folderId, String keywords, int pageNumber, int messagesPerPage, String orderByField, String orderByType) throws SystemException { DynamicQuery countDynamicQuery = DynamicQueryFactoryUtil.forClass(Message.class, getClassLoader()); countDynamicQuery.add(RestrictionsFactoryUtil.eq("folderId", folderId)); DynamicQuery messageDynamicQuery = DynamicQueryFactoryUtil.forClass(Message.class, getClassLoader()); messageDynamicQuery.add(RestrictionsFactoryUtil.eq("folderId", folderId)); if (Validator.isNotNull(keywords)) { String value = "%" + keywords + "%"; Disjunction disjunction = RestrictionsFactoryUtil.disjunction(); disjunction.add(RestrictionsFactoryUtil.ilike("subject", value)); disjunction.add(RestrictionsFactoryUtil.ilike("body", value)); countDynamicQuery.add(disjunction); messageDynamicQuery.add(disjunction); } if (orderByType.equals("desc")) { messageDynamicQuery.addOrder(OrderFactoryUtil.desc(orderByField)); } else { messageDynamicQuery.addOrder(OrderFactoryUtil.asc(orderByField)); } int start = messagesPerPage * (pageNumber - 1); int end = messagesPerPage * pageNumber; messages.addAll(messagePersistence.findWithDynamicQuery(messageDynamicQuery, start, end)); return (int) dynamicQueryCount(countDynamicQuery); }
@SuppressWarnings("unchecked") public List<Asset> getAssets(String pattern, boolean ticker) { List<Asset> results = new ArrayList<Asset>(); DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(AssetImpl.class); dynamicQuery.add( RestrictionsFactoryUtil.like( ticker ? "security_ticker" : "id_isin", StringPool.PERCENT + pattern + StringPool.PERCENT)); dynamicQuery.addOrder(OrderFactoryUtil.asc(ticker ? "security_ticker" : "id_isin")); try { results = assetLocalService.dynamicQuery(dynamicQuery); } catch (SystemException e) { e.printStackTrace(); } return results; }
public static List<CalEvent> getEventFromDateRange( ThemeDisplay themeDisplay, Date startDate, Date endDate) { List<CalEvent> lstEvents = null; DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(CalEvent.class); dynamicQuery.add(PropertyFactoryUtil.forName("groupId").eq(themeDisplay.getScopeGroupId())); Criterion criterion = null; criterion = RestrictionsFactoryUtil.between("startDate", startDate, endDate); Order defaultOrder = OrderFactoryUtil.asc("startDate"); dynamicQuery.add(criterion); dynamicQuery.addOrder(defaultOrder); try { lstEvents = CalEventLocalServiceUtil.dynamicQuery(dynamicQuery); } catch (SystemException e) { _log.error(e); } return lstEvents; }
public Message getRemoteMessage(long folderId, boolean oldest) throws PortalException, SystemException { DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(Message.class, getClassLoader()); dynamicQuery.add(RestrictionsFactoryUtil.eq("folderId", folderId)); dynamicQuery.add(RestrictionsFactoryUtil.gt("remoteMessageId", new Long(0))); if (oldest) { dynamicQuery.addOrder(OrderFactoryUtil.asc("remoteMessageId")); } else { dynamicQuery.addOrder(OrderFactoryUtil.desc("remoteMessageId")); } List<Message> messages = messagePersistence.findWithDynamicQuery(dynamicQuery, 0, 1); if (messages.isEmpty()) { throw new NoSuchMessageException(); } return messages.get(0); }