Java TableField.in方法代碼示例

import org.jooq.TableField; //導入方法依賴的package包/類
@Override
protected void addAccountAuthorization(String type, Map<Object, Object> criteria, Policy policy) {
    super.addAccountAuthorization(type, criteria, policy);

    if ( ! policy.isOption(Policy.AUTHORIZED_FOR_ALL_ACCOUNTS) ) {
        TableField<?, Object> accountField = JooqUtils.getTableField(getMetaDataManager(), type, ObjectMetaDataManager.ACCOUNT_FIELD);
        TableField<?, Object> publicField = JooqUtils.getTableField(getMetaDataManager(), type, ObjectMetaDataManager.PUBLIC_FIELD);
        Object accountValue = criteria.get(ObjectMetaDataManager.ACCOUNT_FIELD);

        if ( accountField == null || publicField == null || accountValue == null ) {
            return;
        }

        criteria.remove(ObjectMetaDataManager.ACCOUNT_FIELD);
        Condition accountCondition = null;
        if ( accountValue instanceof io.github.ibuildthecloud.gdapi.condition.Condition ) {
            accountCondition = accountField.in(((io.github.ibuildthecloud.gdapi.condition.Condition)accountValue).getValues());
        } else {
            accountCondition = accountField.eq(accountValue);
        }

        criteria.put(Condition.class, publicField.isTrue().or(accountCondition));
    }
}
 

import org.jooq.TableField; //導入方法依賴的package包/類
private void addMask(SelectQuery<Record> selectQuery, UUID classifier,
                     UUID classification, TableField<?, UUID> field,
                     ExistentialDomain domain) {
    if (classifier.equals(WellKnownRelationship.ANY.id())) {
        if (log.isTraceEnabled()) {
            log.trace("Match ANY {}", field.getName());
        }
        return;
    }
    Condition condition;
    if (classifier.equals(WellKnownRelationship.SAME.id())) {
        condition = field.eq(classification);
        if (log.isTraceEnabled()) {
            log.trace("Match SAME {}", field.getName());
        }
    } else {
        condition = field.in(inferenceSubQuery(classifier, classification));
        if (log.isTraceEnabled()) {
            log.trace("Match on inferrred {}", field.getName());
        }
    }
    condition = condition.or(field.equal(getAnyId(domain)))
                         .or(field.equal(getSameId(domain)))
                         .or(field.equal(getNotApplicable(domain)));
    selectQuery.addConditions(condition);
}
 

import org.jooq.TableField; //導入方法依賴的package包/類
protected static org.jooq.Condition toCondition(TableField<?, Object> field, Condition value) {
    Condition condition = value;
    switch (condition.getConditionType()) {
    case EQ:
        return field.eq(condition.getValue());
    case GT:
        return field.gt(condition.getValue());
    case GTE:
        return field.ge(condition.getValue());
    case IN:
        List<Object> values = condition.getValues();
        if ( values.size() == 1 ) {
            return field.eq(values.get(0));
        } else {
            return field.in(condition.getValues());
        }
    case LIKE:
        return field.like(condition.getValue().toString());
    case LT:
        return field.lt(condition.getValue());
    case LTE:
        return field.le(condition.getValue());
    case NE:
        return field.ne(condition.getValue());
    case NOTLIKE:
        return field.notLike(condition.getValue().toString());
    case NOTNULL:
        return field.isNotNull();
    case NULL:
        return field.isNull();
    case PREFIX:
        return field.like(condition.getValue() + "%");
    case OR:
        return toCondition(field, condition.getLeft()).or(toCondition(field, condition.getRight()));
    default:
        throw new IllegalArgumentException("Invalid condition type [" + condition.getConditionType() + "]");
    }
}
 

import org.jooq.TableField; //導入方法依賴的package包/類
protected static org.jooq.Condition toCondition(TableField<?, Object> field, Condition value) {
    Condition condition = value;
    switch (condition.getConditionType()) {
    case EQ:
        return field.eq(condition.getValue());
    case GT:
        return field.gt(condition.getValue());
    case GTE:
        return field.ge(condition.getValue());
    case IN:
        List<Object> values = condition.getValues();
        if (values.size() == 1) {
            return field.eq(values.get(0));
        } else {
            return field.in(condition.getValues());
        }
    case NOTIN:
        List<Object> vals = condition.getValues();
        if (vals.size() == 1) {
            return field.ne(vals.get(0));
        } else {
            return field.notIn(condition.getValues());
        }
    case LIKE:
        return field.like(condition.getValue().toString());
    case LT:
        return field.lt(condition.getValue());
    case LTE:
        return field.le(condition.getValue());
    case NE:
        return field.ne(condition.getValue());
    case NOTLIKE:
        return field.notLike(condition.getValue().toString());
    case NOTNULL:
        return field.isNotNull();
    case NULL:
        return field.isNull();
    case PREFIX:
        return field.like(condition.getValue() + "%");
    case OR:
        return toCondition(field, condition.getLeft()).or(toCondition(field, condition.getRight()));
    default:
        throw new IllegalArgumentException("Invalid condition type [" + condition.getConditionType() + "]");
    }
}