private SelectJoinStep<Record12<UUID, UUID, String, UUID, String, UUID, String, String, String[], String, String, String>> selectTriggers(DSLContext tx) { Organizations o = ORGANIZATIONS.as("o"); Projects p = PROJECTS.as("p"); Repositories r = REPOSITORIES.as("r"); return tx.select( TRIGGERS.TRIGGER_ID, o.ORG_ID, o.ORG_NAME, TRIGGERS.PROJECT_ID, p.PROJECT_NAME, TRIGGERS.REPO_ID, r.REPO_NAME, TRIGGERS.EVENT_SOURCE, TRIGGERS.ACTIVE_PROFILES, TRIGGERS.ARGUMENTS.cast(String.class), TRIGGERS.CONDITIONS.cast(String.class), TRIGGERS.TRIGGER_CFG.cast(String.class)) .from(TRIGGERS) .leftJoin(p).on(p.PROJECT_ID.eq(TRIGGERS.PROJECT_ID)) .leftJoin(o).on(o.ORG_ID.eq(p.ORG_ID)) .leftJoin(r).on(r.REPO_ID.eq(TRIGGERS.REPO_ID)); }
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; }
.on(bt.TYPNAMESPACE.eq(oid(nbt)))) .on(t.TYPTYPE.eq(inline("d")).and(t.TYPBASETYPE.eq(oid(bt)))) .leftJoin(co .join(nco) .on(co.COLLNAMESPACE.eq(oid(nco)))) nco.NSPNAME.ne(inline("pg_catalog")).or(co.COLLNAME.ne(inline("default"))) )) .leftJoin(PG_DESCRIPTION) .on(PG_DESCRIPTION.OBJOID.eq(oid(c))) .and(PG_DESCRIPTION.OBJSUBID.eq(a.ATTNUM.coerce(PG_DESCRIPTION.OBJSUBID)))