本文整理汇总了Java中com.querydsl.sql.SQLQuery.where方法的典型用法代码示例。如果您正苦于以下问题:Java SQLQuery.where方法的具体用法?Java SQLQuery.where怎么用?Java SQLQuery.where使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类com.querydsl.sql.SQLQuery
的用法示例。
在下文中一共展示了SQLQuery.where方法的4个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: fetchProperties
import com.querydsl.sql.SQLQuery; //导入方法依赖的package包/类
protected Map<Revision, List<Tuple>> fetchProperties(boolean optimized, BooleanExpression predicate) {
SQLQuery<?> qry = options.queryFactory
.from(options.property)
.where(predicate);
if (optimized) {
qry.innerJoin(options.version).on(
options.version.revision.eq(options.property.revision),
options.version.status.goe(ACTIVE));
qry.where(options.property.status.goe(ACTIVE));
} else {
qry.innerJoin(options.version).on(options.version.revision.eq(options.property.revision));
qry.where(options.property.status.loe(ACTIVE));
}
return qry.transform(properties);
}
示例2: fetchVersionsAndParents
import com.querydsl.sql.SQLQuery; //导入方法依赖的package包/类
protected List<Group> fetchVersionsAndParents(boolean optimized, BooleanExpression predicate, OrderSpecifier<?> orderBy) {
SQLQuery<?> qry = options.queryFactory
.from(options.version)
.where(predicate)
.orderBy(orderBy);
if (optimized) {
qry.leftJoin(options.parent).on(options.parent.revision.eq(options.version.revision), options.parent.status.goe(ACTIVE));
qry.where(options.version.status.goe(ACTIVE));
} else {
qry.leftJoin(options.parent).on(options.parent.revision.eq(options.version.revision), options.parent.status.loe(ACTIVE));
qry.where(options.version.status.loe(ACTIVE));
}
return qry.transform(versionAndParents);
}
示例3: versionsAndParentsSince
import com.querydsl.sql.SQLQuery; //导入方法依赖的package包/类
protected List<Group> versionsAndParentsSince(Id docId, Revision since) {
SQLQuery<?> qry = options.queryFactory.from(options.sinceVersion);
// Left join version version on version.ordinal > since.ordinal and version.doc_id = since.doc_id
qry.leftJoin(options.version).on(
options.version.ordinal.gt(options.sinceVersion.ordinal),
predicate(EQ, options.version.docId, options.sinceVersion.docId));
// Left join parents
qry.leftJoin(options.parent).on(options.parent.revision.eq(options.version.revision));
qry.where(options.sinceVersion.revision.eq(since),
// Return "since" row even if there is no newer versions
versionsOf(docId).or(predicate(IS_NULL, options.version.docId)));
qry.orderBy(options.version.ordinal.asc());
return verifyVersionsAndParentsSince(qry.transform(groupBy(options.version.revision).list(versionAndParentsSince)), since);
}
示例4: versionsAndParentsSince
import com.querydsl.sql.SQLQuery; //导入方法依赖的package包/类
protected List<Group> versionsAndParentsSince(Id docId, Revision since) {
SQLQuery<?> qry = options.queryFactory.from(options.sinceVersion);
// Left join version version on version.ordinal > since.ordinal and version.doc_id = since.doc_id
qry.leftJoin(options.version).on(
options.version.localOrdinal.gt(options.sinceVersion.localOrdinal),
predicate(EQ, options.version.docId, options.sinceVersion.docId));
// Left join parents
qry.leftJoin(options.parent).on(options.parent.revision.eq(options.version.revision));
qry.where(options.sinceVersion.revision.eq(since),
versionsOf(docId).or(predicate(IS_NULL, options.version.docId)));
qry.orderBy(options.version.localOrdinal.asc());
return verifyVersionsAndParentsSince(qry.transform(versionAndParentsSince), since);
}