/** * Create an expression representing the current time instant as a DateTimeExpression instance * * @return current timestamp */ public static DateTimeExpression<Date> currentTimestamp() { return DateTimeExpression.currentTimestamp(); }
public Collection<Predicate> dateTime(DateTimeExpression<java.util.Date> expr, DateTimeExpression<java.util.Date> other) { HashSet<Predicate> rv = new HashSet<Predicate>(); rv.addAll(comparable(expr, other)); rv.add(expr.milliSecond().eq(other.milliSecond())); rv.add(expr.second().eq(other.second())); rv.add(expr.minute().eq(other.minute())); rv.add(expr.hour().eq(other.hour())); rv.add(expr.dayOfMonth().eq(other.dayOfMonth())); if (!target.equals(Target.DERBY) && !module.equals(Module.JDO) && !target.equals(Target.ORACLE) && (!target.equals(Target.POSTGRESQL) || !module.equals(Module.JPA))) { rv.add(expr.dayOfWeek().eq(other.dayOfWeek())); rv.add(expr.dayOfYear().eq(other.dayOfYear())); if (!target.equals(Target.SQLSERVER) && !target.equals(Target.MYSQL) && !target.equals(Target.CUBRID) && !target.equals(Target.POSTGRESQL) && !target.equals(Target.HSQLDB)) { rv.add(expr.week().eq(other.week())); } } rv.add(expr.month().eq(other.month())); rv.add(expr.year().eq(other.year())); rv.add(expr.yearMonth().eq(other.yearMonth())); return ImmutableList.copyOf(rv); }
@SuppressWarnings("unchecked") public <A extends Comparable> Collection<Expression<?>> dateTime(DateTimeExpression<A> expr, DateTimeExpression<A> other, A knownValue) { HashSet<Expression<?>> rv = new HashSet<Expression<?>>(); rv.add(expr.dayOfMonth()); rv.add(expr.month()); rv.add(expr.year()); rv.add(expr.yearMonth()); rv.add(expr.hour()); rv.add(expr.minute()); rv.add(expr.second()); if (module != Module.COLLECTIONS && module != Module.RDFBEAN) { rv.add(expr.min()); rv.add(expr.max()); } return ImmutableList.copyOf(rv); }
@SuppressWarnings("unchecked") public <A extends Comparable> Collection<Predicate> dateTime(DateTimeExpression<A> expr, DateTimeExpression<A> other, A knownValue) { List<Predicate> rv = new ArrayList<Predicate>(); rv.addAll(comparable(expr, other, knownValue)); rv.addAll(dateOrTime(expr, other, knownValue)); rv.add(expr.dayOfMonth().eq(1)); rv.add(expr.dayOfMonth().eq(other.dayOfMonth())); rv.add(expr.month().eq(1)); rv.add(expr.month().eq(other.month())); rv.add(expr.year().eq(2000)); rv.add(expr.year().eq(other.year())); rv.add(expr.yearMonth().eq(other.yearMonth())); if (module.equals(Module.SQL) || module.equals(Module.COLLECTIONS)) { if (target != Target.DERBY) { rv.add(expr.yearWeek().eq(other.yearWeek())); } } rv.add(expr.hour().eq(1)); rv.add(expr.hour().eq(other.hour())); rv.add(expr.minute().eq(1)); rv.add(expr.minute().eq(other.minute())); rv.add(expr.second().eq(1)); rv.add(expr.second().eq(other.second())); return ImmutableList.copyOf(rv); }
@Override public List<? extends JpaNifiFeedProcessorStats> findFeedProcessorStatisticsByProcessorId(String feedName, DateTime start, DateTime end) { QJpaNifiFeedProcessorStats stats = QJpaNifiFeedProcessorStats.jpaNifiFeedProcessorStats; QJpaOpsManagerFeed feed = QJpaOpsManagerFeed.jpaOpsManagerFeed; JPAQuery query = factory.select( Projections.bean(JpaNifiFeedProcessorStats.class, stats.feedName, stats.processorId, stats.processorName, stats.bytesIn.sum().as("bytesIn"), stats.bytesOut.sum().as("bytesOut"), stats.duration.sum().as("duration"), stats.jobsStarted.sum().as("jobsStarted"), stats.jobsFinished.sum().as("jobsFinished"), stats.jobDuration.sum().as("jobDuration"), stats.flowFilesStarted.sum().as("flowFilesStarted"), stats.flowFilesFinished.sum().as("flowFilesFinished"), stats.totalCount.sum().as("totalCount"), stats.maxEventTime.max().as("maxEventTime"), stats.minEventTime.min().as("minEventTime"), stats.jobsFailed.sum().as("jobsFailed"), stats.failedCount.sum().as("failedCount"), stats.count().as("resultSetCount")) ) .from(stats) .innerJoin(feed).on(feed.name.eq(stats.feedName)) .where(stats.feedName.eq(feedName) .and(FeedAclIndexQueryAugmentor.generateExistsExpression(feed.id, accessController.isEntityAccessControlled())) .and(stats.minEventTime.goe(start) .and(stats.maxEventTime.loe(end)))) .groupBy(stats.feedName, stats.processorId, stats.processorName) .orderBy(stats.processorName.asc()); return (List<JpaNifiFeedProcessorStats>) query.fetch(); }
/** * Get the minimum value of this expression (aggregation) * * @return min(this) */ public DateTimeExpression<T> min() { if (min == null) { min = Expressions.dateTimeOperation(getType(), Ops.AggOps.MIN_AGG, mixin); } return min; }
@Test public void currentDate2() { assertToString("current_date", DateTimeExpression.currentDate()); }
rn.orderBy(Expressions.currentTimestamp().asc());
@Override public List<? extends JpaNifiFeedProcessorStats> findFeedProcessorStatisticsByProcessorName(String feedName, DateTime start, DateTime end) { QJpaNifiFeedProcessorStats stats = QJpaNifiFeedProcessorStats.jpaNifiFeedProcessorStats; QJpaOpsManagerFeed feed = QJpaOpsManagerFeed.jpaOpsManagerFeed; JPAQuery query = factory.select( Projections.bean(JpaNifiFeedProcessorStats.class, stats.feedName, stats.processorName, stats.bytesIn.sum().as("bytesIn"), stats.bytesOut.sum().as("bytesOut"), stats.duration.sum().as("duration"), stats.jobsStarted.sum().as("jobsStarted"), stats.jobsFinished.sum().as("jobsFinished"), stats.jobDuration.sum().as("jobDuration"), stats.flowFilesStarted.sum().as("flowFilesStarted"), stats.flowFilesFinished.sum().as("flowFilesFinished"), stats.totalCount.sum().as("totalCount"), stats.maxEventTime.max().as("maxEventTime"), stats.minEventTime.min().as("minEventTime"), stats.jobsFailed.sum().as("jobsFailed"), stats.failedCount.sum().as("failedCount"), stats.count().as("resultSetCount")) ) .from(stats) .innerJoin(feed).on(feed.name.eq(stats.feedName)) .where(stats.feedName.eq(feedName) .and(FeedAclIndexQueryAugmentor.generateExistsExpression(feed.id, accessController.isEntityAccessControlled())) .and(stats.minEventTime.goe(start) .and(stats.maxEventTime.loe(end)))) .groupBy(stats.feedName, stats.processorName) .orderBy(stats.processorName.asc()); return (List<JpaNifiFeedProcessorStats>) query.fetch(); }
/** * Get the maximum value of this expression (aggregation) * * @return max(this) */ public DateTimeExpression<T> max() { if (max == null) { max = Expressions.dateTimeOperation(getType(), Ops.AggOps.MAX_AGG, mixin); } return max; }
@Test public void test() { Calendar cal = Calendar.getInstance(); cal.set(Calendar.DAY_OF_MONTH, 1); cal.set(Calendar.MONTH, 0); cal.set(Calendar.YEAR, 2000); cal.set(Calendar.HOUR_OF_DAY, 13); cal.set(Calendar.MINUTE, 30); cal.set(Calendar.SECOND, 12); cal.set(Calendar.MILLISECOND, 3); DateTimeExpression<Date> date = DateTimeConstant.create(cal.getTime()); assertEquals("1", date.dayOfMonth().toString()); assertEquals("1", date.month().toString()); assertEquals("2000", date.year().toString()); assertEquals("7", date.dayOfWeek().toString()); assertEquals("1", date.dayOfYear().toString()); assertEquals("13", date.hour().toString()); assertEquals("30", date.minute().toString()); assertEquals("12", date.second().toString()); assertEquals("3", date.milliSecond().toString()); }
.then($.currentFormVersion.inclusionDate) .otherwise($.currentFormDraftVersionEntity.inclusionDate) .as("creationDate")) .addCase($case -> $case .when($.formType.abbreviation.isNull())
@Override public DateTimeExpression<T> as(Path<T> alias) { return Expressions.dateTimeOperation(getType(), Ops.ALIAS, mixin, alias); }
/** * Create an expression representing the current time instant as a DateTimeExpression instance * * @return current timestamp */ public static DateTimeExpression<Date> currentTimestamp() { return DateTimeExpression.currentTimestamp(); }
.then($.currentFormVersion.inclusionDate) .otherwise($.currentFormDraftVersionEntity.inclusionDate) .as("creationDate")) .addCase($case -> $case .when($.formType.abbreviation.isNull())
/** * Get the maximum value of this expression (aggregation) * * @return max(this) */ public DateTimeExpression<T> max() { if (max == null) { max = Expressions.dateTimeOperation(getType(), Ops.AggOps.MAX_AGG, mixin); } return max; }
@Test public void currentTimestamp() { assertToString("current_timestamp", DateTimeExpression.currentTimestamp()); }
.then($.currentFormVersion.inclusionDate) .otherwise($.currentFormDraftVersionEntity.inclusionDate) .as(CREATION_DATE)) .addCaseToSelect($case -> $case .when($.formType.abbreviation.isNull())