public PageResult<Article> page(PageResult<Article> page, Integer status, Optional<String> catalogId, String ...keywords) { CArticle table = C_ARTICLE; List<Condition> cons = new ArrayList<>(); cons.add(table.STATUS.eq(Article.STATUS_PUBLISH)); catalogId.ifPresent(cid -> { if ("-1".equals(cid)) { cons.add(table.CATALOG_ID.isNull().or(table.CATALOG_ID.eq(""))); } else if (!"0".equals(cid)) { cons.add(table.CATALOG_ID.eq(cid)); } }); List<Condition> kwCons = new ArrayList<>(); Arrays.asList(keywords).forEach(k -> { if (k.trim().length() > 0) { String kwLike = "%" + k + "%"; kwCons.add(table.TITLE.like(kwLike)); kwCons.add(table.CONTENT.like(kwLike)); kwCons.add(table.TAG_NAMES.like(kwLike)); } }); cons.add(kwCons.stream().reduce((a, b) -> a.or(b)).orElse(DSL.trueCondition())); return searchPageByCondition(page, cons.stream()); }
@Override public List<? extends Agent> findAgentsToRemove() { if (startTime == null) { startTime = System.currentTimeMillis(); } if ((System.currentTimeMillis() - startTime) <= (HostDao.HOST_REMOVE_START_DELAY.get() * 1000)) { return Collections.emptyList(); } List<? extends Agent> agents = create().select(AGENT.fields()) .from(AGENT) .leftOuterJoin(HOST) .on(HOST.AGENT_ID.eq(AGENT.ID)) .where(HOST.ID.isNull().or(HOST.REMOVED.isNotNull()) .and(AGENT.STATE.eq(AgentConstants.STATE_DISCONNECTED))) .fetchInto(AgentRecord.class); // This is purging old pre-1.2 agent delegates List<? extends Agent> oldAgents = create().select(AGENT.fields()) .from(AGENT) .where(AGENT.REMOVED.isNull().and(AGENT.URI.like("delegate%"))) .fetchInto(AgentRecord.class); List<Agent> result = new ArrayList<>(agents); result.addAll(oldAgents); return result; } }
@Override public String getPublicCA() { Record1<String> r = create().select(CERTIFICATE.CERT_CHAIN) .from(CERTIFICATE) .join(ACCOUNT) .on(ACCOUNT.ID.eq(CERTIFICATE.ACCOUNT_ID)) .where(CERTIFICATE.STATE.eq(CommonStatesConstants.ACTIVE) .and(ACCOUNT.UUID.like("system-ha-%"))) .fetchAny(); return r == null ? null : r.value1(); }
@Override public boolean isSchedulerServiceEnabled(Long accountId) { return create() .select(SERVICE.ID) .from(SERVICE) .where(SERVICE.ACCOUNT_ID.equal(accountId) .and(SERVICE.SYSTEM.isTrue()) .and(SERVICE.REMOVED.isNull()) .and(SERVICE.STATE.notIn(INACTIVE_STATES)) .and(SERVICE.DATA.like("%io.rancher.container.agent_service.scheduling%"))).fetch().size() > 0; } }
.from(COLUMNS) .where( Columns.COLUMN_TYPE.like("ENUM(%)%").and( Columns.TABLE_SCHEMA.in(getInputSchemata()))) .orderBy(
.from(COLUMNS) .where( Columns.COLUMN_TYPE.like("enum(%)").and(