本文整理汇总了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);
}
示例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);
}
示例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;
}
示例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;
}