SelectQuery query = ... query.addConditions( ( CAR.COLOR.eq("blue") .or ( CAR.MODEL.eq("Genesis") ) ) .or ( CAR.MANUFACTOR.eq("ford") .and ( CAR.COLOR.eq("blue") ) ) )
private void filterByTags(SelectQuery<Record> query, Set<String> tags) { if (tags == null || tags.isEmpty()) { return; } String[] as = tags.toArray(new String[0]); query.addConditions(PgUtils.contains(PROCESS_QUEUE.PROCESS_TAGS, as)); }
@Override public final SelectImpl where(Condition conditions) { conditionStep = ConditionStep.WHERE; getQuery().addConditions(conditions); return this; }
@Override public final SelectImpl where(Condition... conditions) { conditionStep = ConditionStep.WHERE; getQuery().addConditions(conditions); return this; }
@Override public final SelectImpl where(Collection<? extends Condition> conditions) { conditionStep = ConditionStep.WHERE; getQuery().addConditions(conditions); return this; }
@Override public final SelectImpl where(Collection<? extends Condition> conditions) { conditionStep = ConditionStep.WHERE; getQuery().addConditions(conditions); return this; }
@Override public final SelectImpl where(Condition... conditions) { conditionStep = ConditionStep.WHERE; getQuery().addConditions(conditions); return this; }
private void filterByMetaFilters(SelectQuery<Record> query, Map<String, String> filters) { if (filters == null || filters.isEmpty()) { return; } for (Map.Entry<String, String> e : filters.entrySet()) { query.addConditions(jsonText(PROCESS_QUEUE.META, e.getKey()).contains(e.getValue())); } }
protected void addConditions(SchemaFactory schemaFactory, SelectQuery<?> query, String type, Table<?> table, Map<Object, Object> criteria) { org.jooq.Condition condition = JooqUtils.toConditions(getMetaDataManager(), type, criteria); if (condition != null) { query.addConditions(condition); } }
public List<ProcessEntry> get(List<PartialProcessKey> processKeys) { try (DSLContext tx = DSL.using(cfg)) { List<UUID> instanceIds = processKeys.stream() .map(PartialProcessKey::getInstanceId) .collect(Collectors.toList()); SelectQuery<Record> query = buildSelect(tx, DEFAULT_INCLUDES); query.addConditions(PROCESS_QUEUE.INSTANCE_ID.in(instanceIds)); return query.fetch(this::toEntry); } }
@Override public final SelectImpl or(Condition condition) { switch (conditionStep) { case WHERE: getQuery().addConditions(Operator.OR, condition); break; case CONNECT_BY: throw new IllegalStateException("Cannot connect conditions for the CONNECT BY clause using the OR operator"); case HAVING: getQuery().addHaving(Operator.OR, condition); break; case ON: joinConditions.addConditions(Operator.OR, condition); break; } return this; }
@Override public final SelectImpl or(Condition condition) { switch (conditionStep) { case WHERE: getQuery().addConditions(Operator.OR, condition); break; case CONNECT_BY: throw new IllegalStateException("Cannot connect conditions for the CONNECT BY clause using the OR operator"); case HAVING: getQuery().addHaving(Operator.OR, condition); break; case ON: joinConditions.addConditions(Operator.OR, condition); break; } return this; }
private ProcessEntry get(DSLContext tx, PartialProcessKey key, Set<ProcessDataInclude> includes) { SelectQuery<Record> query = buildSelect(tx, includes); query.addConditions(PROCESS_QUEUE.INSTANCE_ID.eq(key.getInstanceId())); return query.fetchOne(this::toEntry); }
select.addConditions(Usage.TIME_FIELD.between(inline(new Timestamp(time_from)), inline(new Timestamp(time_to)))); select.addConditions(onlySelectTheseMetrics(metrics));
public List<ProcessEntry> list(UUID parentInstanceId, Set<String> tags) { try (DSLContext tx = DSL.using(cfg)) { SelectQuery<Record> query = buildSelect(tx, DEFAULT_INCLUDES); query.addConditions(PROCESS_QUEUE.PARENT_INSTANCE_ID.eq(parentInstanceId)); filterByTags(query, tags); query.addOrderBy(PROCESS_QUEUE.CREATED_AT.desc()); return query.fetch(this::toEntry); } }
@Override public final SelectImpl and(Condition condition) { switch (conditionStep) { case WHERE: getQuery().addConditions(condition); break; case CONNECT_BY: getQuery().addConnectBy(condition); break; case HAVING: getQuery().addHaving(condition); break; case ON: joinConditions.addConditions(condition); break; } return this; }
@Override public final SelectImpl and(Condition condition) { switch (conditionStep) { case WHERE: getQuery().addConditions(condition); break; case CONNECT_BY: getQuery().addConnectBy(condition); break; case HAVING: getQuery().addHaving(condition); break; case ON: joinConditions.addConditions(condition); break; } return this; }
select.addConditions(BillRun.ID_FIELD.eq(inline(id))); selectBills.addConditions(Bill.RUN_FIELD.eq(inline(id))); List<Bill> bills = db.fetchUsingSelectStatement(selectBills, Bill.class);
query.addFrom(ACCOUNT); query.addJoin(PROJECT_MEMBER, PROJECT_MEMBER.PROJECT_ID.equal(ACCOUNT.ID)); query.addConditions(allMembers); query.setDistinct(true); projects.addAll(query.fetchInto(ACCOUNT));
@Override public List<? extends ProjectMember> getProjectMembersByIdentity(long projectId, Set<Identity> identities) { Condition allMembers = DSL.falseCondition(); for (Identity identity : identities) { allMembers = allMembers.or(PROJECT_MEMBER.EXTERNAL_ID.eq(identity.getExternalId()) .and(PROJECT_MEMBER.EXTERNAL_ID_TYPE.eq(identity.getExternalIdType())) .and(PROJECT_MEMBER.REMOVED.isNull()) .and(PROJECT_MEMBER.STATE.eq(CommonStatesConstants.ACTIVE)) .and(PROJECT_MEMBER.PROJECT_ID.eq(projectId))); } SelectQuery<Record> query = create().selectQuery(); query.addFrom(PROJECT_MEMBER); query.addConditions(allMembers); query.setDistinct(true); return query.fetchInto(PROJECT_MEMBER); }