org.jooq.TableField.ge()方法的使用及代码示例

x33g5p2x  于2022-01-29 转载在 其他  
字(2.7k)|赞(0)|评价(0)|浏览(186)

本文整理了Java中org.jooq.TableField.ge()方法的一些代码示例,展示了TableField.ge()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。TableField.ge()方法的具体详情如下:
包路径:org.jooq.TableField
类名称:TableField
方法名:ge

TableField.ge介绍

暂无

代码示例

代码示例来源:origin: k55k32/cms-admin-end

private Stream<Condition> getCondition(Long start, Long end) {
  return Stream.of(C_PAGE_VIEW.CREATE_TIME.ge(new Timestamp(start)), C_PAGE_VIEW.CREATE_TIME.le(new Timestamp(end)));
}

代码示例来源:origin: rancher/cattle

return field.gt(condition.getValue());
case GTE:
  return field.ge(condition.getValue());
case IN:
  List<Object> values = condition.getValues();

代码示例来源:origin: com.walmartlabs.concord.server/concord-server

public List<ProcessEventEntry> list(ProcessKey processKey, Timestamp geTimestamp, String eventType, Map<String, Object> dataFilter, int limit) {
  try (DSLContext tx = DSL.using(cfg)) {
    SelectConditionStep<Record4<UUID, String, Timestamp, String>> q = tx
        .select(PROCESS_EVENTS.EVENT_ID,
            PROCESS_EVENTS.EVENT_TYPE,
            PROCESS_EVENTS.EVENT_DATE,
            PROCESS_EVENTS.EVENT_DATA.cast(String.class))
        .from(PROCESS_EVENTS)
        .where(PROCESS_EVENTS.INSTANCE_ID.eq(processKey.getInstanceId())
            .and(PROCESS_EVENTS.INSTANCE_CREATED_AT.eq(processKey.getCreatedAt())));
    if (geTimestamp != null) {
      q.and(PROCESS_EVENTS.EVENT_DATE.ge(geTimestamp));
    }
    if (eventType != null) {
      q.and(PROCESS_EVENTS.EVENT_TYPE.eq(eventType));
    }
    if (dataFilter != null) {
      dataFilter.forEach((k, v) -> {
        q.and(field("{0}->>{1}", Object.class, PROCESS_EVENTS.EVENT_DATA, inline(k)).eq(v));
      });
    }
    if (limit > 0) {
      q.limit(limit);
    }
    return q.orderBy(PROCESS_EVENTS.EVENT_DATE)
        .fetch(EventDao::toEntry);
  }
}

代码示例来源:origin: k55k32/cms-admin-end

public ArticleDetail getDetail(String id) {
  CArticle article = C_ARTICLE.as("a");
  CArticle before = C_ARTICLE.as("b");
  CArticle next = C_ARTICLE.as("n");
  CArticle inner = C_ARTICLE.as("i");
  ArticleDetail a = dao.execute(e -> {
    return e.select(Fields.all(article.fields(),
      before.ID.as("beforeId"),
      before.TITLE.as("beforeTitle"),
      next.ID.as("nextId"),
      next.TITLE.as("nextTitle")
      )).from(article)
      .leftJoin(before).on(before.ID.eq(e.select(inner.ID).from(inner).where(article.CREATE_TIME.ge(inner.CREATE_TIME)).and(inner.ID.ne(article.ID).and(inner.STATUS.eq(Article.STATUS_PUBLISH))).orderBy(inner.CREATE_TIME.desc()).limit(0, 1)))
      .leftJoin(next).on((next.ID.eq(e.select(inner.ID).from(inner).where(article.CREATE_TIME.le(inner.CREATE_TIME)).and(inner.ID.ne(article.ID).and(inner.STATUS.eq(Article.STATUS_PUBLISH))).orderBy(inner.CREATE_TIME).limit(0, 1))))
      .where(article.ID.eq(id))
      .fetchOne(r -> {
        return dao.mapperEntityEx(r, ArticleDetail.class);
      });
  });
  List<Tag> tags = articleTagService.findTags(a.getId());
  a.setTags(tags);
  return a;
}

相关文章