@Override public <T extends Comparable<?>> Path<T> createDatePath(Class<T> type, PathMetadata<?> metadata) { return new DatePath<T>(type, metadata); }
@Test public void DateOperations2() { // catalog.effectiveDate.second(); // catalog.effectiveDate.minute(); // catalog.effectiveDate.hour(); catalog.effectiveDate.dayOfMonth(); catalog.effectiveDate.month(); catalog.effectiveDate.year(); }
Matcher isNullMatcher = isNullOperator.matcher(searchStr); if (isNullMatcher.matches()) { return dateExpression.isNull(); Matcher isNotNullMatcher = isNotNullOperator.matcher(searchStr); if (isNotNullMatcher.matches()) { return dateExpression.isNotNull(); searchCal.setTime(dateToFilter); return dateExpression.eq(conversionService.convert(searchCal, fieldType)); return dateExpression.year().eq(Integer.parseInt(value)); return dateExpression.month().eq(Integer.parseInt(value)); return dateExpression.dayOfMonth().eq(Integer.parseInt(value)); dateToCal.setTime(dateTo); return dateExpression.between( conversionService.convert(dateFromCal, fieldType), conversionService.convert(dateToCal, fieldType));
Calendar searchCal = Calendar.getInstance(); searchCal.setTime(searchDate); expression = dateExpression.eq((fieldType.cast(searchCal))); searchCal.setTime(searchDate); expression = dateExpression .dayOfMonth() .eq(searchCal.get(Calendar.DAY_OF_MONTH)) .and(dateExpression.month().eq( searchCal.get(Calendar.MONTH) + 1)) .and(dateExpression.year().eq( searchCal.get(Calendar.YEAR))); searchCal.setTime(searchDate); expression = dateExpression .dayOfMonth() .eq(searchCal.get(Calendar.DAY_OF_MONTH)) .and(dateExpression.month().eq( searchCal.get(Calendar.MONTH) + 1)); monthEndCal.set(Calendar.MILLISECOND, 999); expression = dateExpression.between( fieldType.cast(monthStartCal), fieldType.cast(monthEndCal)); expression = dateExpression.stringValue().like( "%".concat(searchStr).concat("%"));
@Test public void DayOfMonth() { assertToString("day(date)", new DatePath<Date>(Date.class, "date").dayOfMonth()); }
@Test public void DocoExamples912() throws Exception { query().from(ord, cust) .join(ord.lineItems, item).join(item.product, product) .from(catalog).join(catalog.prices, price).where( ord.paid.not().and(ord.customer.eq(cust)).and( price.product.eq(product)).and( catalog.effectiveDate.gt(DateExpression.currentDate())).and( catalog.effectiveDate.gtAny( sub().from(catalog).where( catalog.effectiveDate.lt(DateExpression.currentDate())) .list(catalog.effectiveDate)))) .groupBy(ord).having(price.amount.sum().gt(0l)) .orderBy(price.amount.sum().desc()) .select(ord.id, price.amount.sum(), item.count()); Customer c1 = new Customer(); Catalog c2 = new Catalog(); query().from(ord) .join(ord.lineItems, item).join(item.product, product) .from(catalog).join(catalog.prices, price).where( ord.paid.not().and(ord.customer.eq(c1)).and( price.product.eq(product)).and(catalog.eq(c2))) .groupBy(ord).having(price.amount.sum().gt(0l)) .orderBy(price.amount.sum().desc()) .select(ord.id, price.amount.sum(), item.count()); }
@Test @ExcludeIn(ORACLE) public void DocoExamples97() throws Exception { query().from(foo, bar).where(foo.startDate.eq(bar.date)).select(foo).parse(); }
Matcher isNullMatcher = isNullOperator.matcher(searchStr); if (isNullMatcher.matches()) { return dateExpression.isNull(); Matcher isNotNullMatcher = isNotNullOperator.matcher(searchStr); if (isNotNullMatcher.matches()) { return dateExpression.isNotNull(); searchCal.setTime(dateToFilter); return dateExpression.eq(conversionService.convert(searchCal, fieldType)); return dateExpression.year().eq(Integer.parseInt(value)); return dateExpression.month().eq(Integer.parseInt(value)); return dateExpression.dayOfMonth().eq(Integer.parseInt(value)); dateToCal.setTime(dateTo); return dateExpression.between( conversionService.convert(dateFromCal, fieldType), conversionService.convert(dateToCal, fieldType));
Calendar searchCal = Calendar.getInstance(); searchCal.setTime(searchDate); expression = dateExpression.eq((fieldType.cast(searchCal))); searchCal.setTime(searchDate); expression = dateExpression .dayOfMonth() .eq(searchCal.get(Calendar.DAY_OF_MONTH)) .and(dateExpression.month().eq( searchCal.get(Calendar.MONTH) + 1)) .and(dateExpression.year().eq( searchCal.get(Calendar.YEAR))); searchCal.setTime(searchDate); expression = dateExpression .dayOfMonth() .eq(searchCal.get(Calendar.DAY_OF_MONTH)) .and(dateExpression.month().eq( searchCal.get(Calendar.MONTH) + 1)); monthEndCal.set(Calendar.MILLISECOND, 999); expression = dateExpression.between( fieldType.cast(monthStartCal), fieldType.cast(monthEndCal)); expression = dateExpression.stringValue().like( "%".concat(searchStr).concat("%"));
assertEquals(literals.date2, session.from($(l)).where($(l.getDate2()).eq(literals.date2)).uniqueResult($(l.getDate2()))); assertEquals(literals.dateTime.getMillis(), session.from($(l)).where($(l.getDateTime()).eq(literals.dateTime)).uniqueResult($(l.getDateTime())).getMillis()); assertEquals(literals.localDate, session.from($(l)).where($(l.getLocalDate()).eq(literals.localDate)).uniqueResult($(l.getLocalDate()))); assertEquals(1, session.from($(l)).where($(l.getDate2()).eq(literals.date2)).count()); assertEquals(1, session.from($(l)).where($(l.getDateTime()).eq(literals.dateTime)).count()); assertEquals(1, session.from($(l)).where($(l.getLocalDate()).eq(literals.localDate)).count());
/** * Create a new Path expression * * @param type * @param parent * @param property * @return */ public static <T extends Comparable<?>> DatePath<T> datePath(Class<T> type, Path<?> parent, String property) { return new DatePath<T>(type, PathMetadataFactory.forProperty(parent, property)); }
/** * Create a new Path expression * * @param type * @param variable * @return */ public static <T extends Comparable<?>> DatePath<T> datePath(Class<T> type, String variable) { return new DatePath<T>(type, PathMetadataFactory.forVariable(variable)); }
/** * Create a new Date path * * @param <A> * @param property * @param type * @return */ @SuppressWarnings("unchecked") protected <A extends Comparable> DatePath<A> createDate(String property, Class<? super A> type) { return add(new DatePath<A>((Class) type, forProperty(property))); }