当前位置: 首页>>代码示例>>Java>>正文


Java SelectQuery.fetchInto方法代码示例

本文整理汇总了Java中org.jooq.SelectQuery.fetchInto方法的典型用法代码示例。如果您正苦于以下问题:Java SelectQuery.fetchInto方法的具体用法?Java SelectQuery.fetchInto怎么用?Java SelectQuery.fetchInto使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在org.jooq.SelectQuery的用法示例。


在下文中一共展示了SelectQuery.fetchInto方法的4个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。

示例1: getProjectMembersByIdentity

import org.jooq.SelectQuery; //导入方法依赖的package包/类
@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);
}
 
开发者ID:rancher,项目名称:cattle,代码行数:17,代码来源:AuthDaoImpl.java

示例2: getListByRelationshipMap

import org.jooq.SelectQuery; //导入方法依赖的package包/类
@SuppressWarnings("unchecked")
@Override
protected <T> List<T> getListByRelationshipMap(Object obj, MapRelationship rel) {
    Class<UpdatableRecord<?>> typeClass = JooqUtils.getRecordClass(schemaFactory, rel.getObjectType());

    String mappingType = schemaFactory.getSchemaName(rel.getMappingType());
    String fromType = schemaFactory.getSchemaName(rel.getObjectType());

    TableField<?, Object> fieldFrom = JooqUtils.getTableField(getMetaDataManager(), fromType, ObjectMetaDataManager.ID_FIELD);
    TableField<?, Object> mappingTo = JooqUtils.getTableField(getMetaDataManager(), mappingType, rel.getOtherRelationship().getPropertyName());
    TableField<?, Object> mappingOther = JooqUtils.getTableField(getMetaDataManager(), mappingType, rel.getPropertyName());
    TableField<?, Object> mappingRemoved = JooqUtils.getTableField(getMetaDataManager(), mappingType, ObjectMetaDataManager.REMOVED_FIELD);

    Table<?> table = JooqUtils.getTable(schemaFactory, typeClass);
    Table<?> mapTable = JooqUtils.getTable(schemaFactory, rel.getMappingType());

    SelectQuery<?> query = create().selectQuery();
    query.addFrom(table);
    query.addSelect(table.fields());
    query.addJoin(mapTable, fieldFrom.eq(mappingTo)
            .and(mappingRemoved == null ? DSL.trueCondition() : mappingRemoved.isNull())
            .and(mappingOther.eq(ObjectUtils.getId(obj))));

    return (List<T>)query.fetchInto(typeClass);
}
 
开发者ID:cloudnautique,项目名称:cloud-cattle,代码行数:26,代码来源:JooqObjectManager.java

示例3: listInternal

import org.jooq.SelectQuery; //导入方法依赖的package包/类
protected Object listInternal(SchemaFactory schemaFactory, String type, Map<Object, Object> criteria, ListOptions options,
        Map<Table<?>,Condition> joins) {
    Class<?> clz = getClass(schemaFactory, type, criteria, true);
    if ( clz == null ) {
        return null;
    }

    /* Use core schema, parent may not be authorized */
    type = getObjectManager().getSchemaFactory().getSchemaName(clz);
    Table<?> table = JooqUtils.getTableFromRecordClass(clz);
    Sort sort = options == null ? null : options.getSort();
    Pagination pagination = options == null ? null : options.getPagination();
    Include include = options ==null ? null : options.getInclude();

    if ( table == null )
        return null;

    SelectQuery<?> query = create().selectQuery();
    MultiTableMapper mapper = addTables(schemaFactory, query, type, table, criteria, include, pagination, joins);
    addJoins(query, joins);
    addConditions(schemaFactory, query, type, table, criteria);
    addSort(schemaFactory, type, sort, query);
    addLimit(schemaFactory, type, pagination, query);

    List<?> result = mapper == null ? query.fetch() : query.fetchInto(mapper);

    processPaginationResult(result, pagination, mapper);

    return result;
}
 
开发者ID:cloudnautique,项目名称:cloud-cattle,代码行数:31,代码来源:AbstractJooqResourceManager.java

示例4: listInternal

import org.jooq.SelectQuery; //导入方法依赖的package包/类
protected Object listInternal(SchemaFactory schemaFactory, String type, Map<Object, Object> criteria, ListOptions options,
        Map<Table<?>,Condition> joins) {
    Class<?> clz = getClass(schemaFactory, type, criteria, true);
    if ( clz == null ) {
        return null;
    }

    type = schemaFactory.getSchemaName(clz);
    Table<?> table = JooqUtils.getTableFromRecordClass(clz);
    Sort sort = options == null ? null : options.getSort();
    Pagination pagination = options == null ? null : options.getPagination();
    Include include = options ==null ? null : options.getInclude();

    if ( table == null )
        return null;

    SelectQuery<?> query = create().selectQuery();
    MultiTableMapper mapper = addTables(schemaFactory, query, type, table, criteria, include, pagination, joins);
    addJoins(query, joins);
    addConditions(schemaFactory, query, type, table, criteria);
    addSort(schemaFactory, type, sort, query);
    addLimit(schemaFactory, type, pagination, query);

    List<?> result = mapper == null ? query.fetch() : query.fetchInto(mapper);

    processPaginationResult(result, pagination, mapper);

    return result;
}
 
开发者ID:ibuildthecloud,项目名称:dstack,代码行数:30,代码来源:AbstractJooqResourceManager.java


注:本文中的org.jooq.SelectQuery.fetchInto方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。